Completed

10 custom MySQL queries with WordPress meta tags (for statistical purposes)

I have 10 different queries (rougly) that I want to do, and I need someone that is great doing manual queries to do those for me.

I am using the plugin wpDataTable so that I can have graphics and tables for my customer.

Here is one example of a query that should be working but it's not:

SELECT [login to view URL] AS roll_ID,

posts_roll.post_title AS roll_post_title,

roll_meta_roll_brand_tbl.meta_value AS roll_meta_roll_brand,

log_meta_log_length_tbl.meta_value AS log_meta_log_length,

log_meta_log_order_tbl.meta_value AS log_meta_log_order,

log_meta_log_roll_tbl.meta_value AS log_meta_log_roll

FROM wp_vpel_devposts AS posts_roll

INNER JOIN (SELECT [login to view URL] as id, meta_value, meta_key FROM wp_vpel_devpostmeta AS roll_meta_roll_brand_tbl_postmeta INNER JOIN wp_vpel_devposts AS roll_meta_roll_brand_tbl_posts ON roll_meta_roll_brand_tbl_postmeta.post_id = [login to view URL] AND roll_meta_roll_brand_tbl_posts.post_type = 'roll') AS roll_meta_roll_brand_tbl

ON roll_meta_roll_brand_tbl.meta_key = 'roll_brand' AND [login to view URL] = [login to view URL]

INNER JOIN (SELECT [login to view URL] as id, meta_value, meta_key FROM wp_vpel_devpostmeta AS log_meta_log_length_tbl_postmeta INNER JOIN wp_vpel_devposts AS log_meta_log_length_tbl_posts ON log_meta_log_length_tbl_postmeta.post_id = [login to view URL] AND log_meta_log_length_tbl_posts.post_type = 'log') AS log_meta_log_length_tbl

ON log_meta_log_length_tbl.meta_key = 'log_length' AND [login to view URL] = [login to view URL]

INNER JOIN (SELECT [login to view URL] as id, meta_value, meta_key FROM wp_vpel_devpostmeta AS log_meta_log_order_tbl_postmeta INNER JOIN wp_vpel_devposts AS log_meta_log_order_tbl_posts ON log_meta_log_order_tbl_postmeta.post_id = [login to view URL] AND log_meta_log_order_tbl_posts.post_type = 'log') AS log_meta_log_order_tbl

ON log_meta_log_order_tbl.meta_key = 'log_order' AND [login to view URL] = [login to view URL]

INNER JOIN (SELECT [login to view URL] as id, meta_value, meta_key FROM wp_vpel_devpostmeta AS log_meta_log_roll_tbl_postmeta INNER JOIN wp_vpel_devposts AS log_meta_log_roll_tbl_posts ON log_meta_log_roll_tbl_postmeta.post_id = [login to view URL] AND log_meta_log_roll_tbl_posts.post_type = 'log') AS log_meta_log_roll_tbl

ON log_meta_log_roll_tbl.meta_key = 'log_roll' AND [login to view URL] = [login to view URL]

WHERE 1=1

AND posts_roll.post_type = 'roll'

I want to do things like, having in one table, different metas being shown and joined together, etc.

Evner: MySQL, WordPress

Se mere: slow mysql queries wordpress, wordpress plugin custom mysql tables, wordpress custom tags page, mysql, wordpress, wordpress custom title tags, wordpress custom fields tags, wordpress custom xml feed tags, wordpress custom form mysql database, wordpress plugin mysql custom tables, wordpress custom sql queries, wordpress custom queries, wordpress custom fields will display post, wordpress custom xml, building xml files mysql queries, wordpress custom sql category, wordpress custom query sort field

Om arbejdsgiveren:
( 11 bedømmelser ) Leiria, Portugal

Projekt ID: #13304289

Tildelt til:

ilatech

Hi, I'm a french software engineer, and I new to this website. I just create my compagny, and I develop software for compagnies. I worked for 10 years as a software developer. For my first project on this site, I Flere

€25 EUR in 10 dage
(2 bedømmelser)
0.7

17 freelancere byder i gennemsnit €67 på dette job

Risalat1

Ready to work with you on this project, could you please send me some more details so we will estimate it accordingly .....

€161 EUR in 2 dage
(186 bedømmelser)
7.3
instaservpvtltd

Hi, We're expert in fixing SQL queries Top 2% IN WORDPRESS AND PREFERRED GOLD BADGE WINNER BY THE FREELANCER.COM. We are a PREMIER GOOGLE PARTNER STATUS FREELANCER ([login to view URL];idtf Flere

€100 EUR på 1 dag
(109 bedømmelser)
6.4
yogeshssanwal

I am Yogesh sanwal, 5+ years experienced inwebsite and e-commerce development using PHP/MySQL. Take a look to my last work: [login to view URL] [login to view URL] [login to view URL] http://ww Flere

€23 EUR på 1 dag
(138 bedømmelser)
6.4
itsoftwarelab

Hi, We are an experienced and dynamic team of designers/ programmers, expertise in php, wordpress, Html,xHTML, javascript, jQuery (average years of experience of 10 years) and we work independently, efficiently, and Flere

€34 EUR på 1 dag
(48 bedømmelser)
5.6
imagicaworld

Hi Client.. Greetings!!! I have read your project description you are looking for someone who can develop and design a responsive website in WordPress and I am much experienced in this. I can start work right aw Flere

€55 EUR på 1 dag
(27 bedømmelser)
5.4
dezines99

Hi, Expert here,ready to start immediately. I will always available to discuss project specs.I have reviewed all your requirements and can deliver exactly what you are looking for, 100% guaranteed. I am confident to Flere

€250 EUR in 0 dage
(17 bedømmelser)
4.3
akrontechnohub

Hi There! I read your requirement,you are Looking for web development . We have good professional development team with 5+ years experience for WordPress Development. I hope we are perfect for your requirement Flere

€34 EUR på 1 dag
(11 bedømmelser)
4.2
davedcb

Olá, Estou interessado no seu projecto. Sou um programador com experiência em MySQL. Podia me indicar o resultado que pretende alcançar com a query apresentada e um exemplo dos dados presentes nessa tabela, de forma Flere

€29 EUR in 3 dage
(18 bedømmelser)
3.5
€70 EUR på 1 dag
(2 bedømmelser)
2.6
kudosta

Hello Greetings from Sweety, Thanks for give us a chance for submit [login to view URL] want to fix MySQL queries with WordPress . We have done 270+ project on upwork but on freelance not have profile strong till yet but we Flere

€66 EUR på 1 dag
(1 bedømmelse)
2.2
umesh655

Hello, I am writing in response to your job posted. I enjoy working with creative team and have the ability to communicate with managers and colleagues. There I was responsible for graphics and web designing, slicin Flere

€100 EUR in 3 dage
(4 bedømmelser)
2.4
dedycatedinc

I have successfully delivered many projects in many different company and clients. I have a strong Programming and Management skills and always updates myself with Research and Development of new technologies to streng Flere

€20 EUR på 1 dag
(0 bedømmelser)
0.0
€84 EUR in 10 dage
(0 bedømmelser)
0.0
intmir

A proposal has not yet been provided

€27 EUR på 1 dag
(0 bedømmelser)
0.0
singlaneha2512

Dear Hiring Manager, I’m interested in the position you recently posted. I have been a professional web developer and designer for 9+ years. During my last 7 years i worked as a senior web developer and team leader. Flere

€34 EUR på 1 dag
(0 bedømmelser)
0.0
€34 EUR in 2 dage
(0 bedømmelser)
0.0