Færdiggjort

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 [url removed, login to view] 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 [url removed, login to view] 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 = [url removed, login to view] 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 [url removed, login to view] = [url removed, login to view]

INNER JOIN (SELECT [url removed, login to view] 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 = [url removed, login to view] 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 [url removed, login to view] = [url removed, login to view]

INNER JOIN (SELECT [url removed, login to view] 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 = [url removed, login to view] 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 [url removed, login to view] = [url removed, login to view]

INNER JOIN (SELECT [url removed, login to view] 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 = [url removed, login to view] 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 [url removed, login to view] = [url removed, login to view]

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.

Færdigheder: MySQL, WordPress

Se mere: slow mysql queries wordpress, wordpress plugin custom mysql tables, wordpress custom tags page, 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 Mere

€25 EUR in 10 dage
(0 bedømmelser)
0.0

19 freelancers are bidding on average €64 for this 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
(142 bedømmelser)
7.0
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 ([url removed, login to view];idtf Mere

€100 EUR på 1 dag
(104 bedømmelser)
6.2
yogeshssanwal

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

€23 EUR på 1 dag
(84 bedømmelser)
5.7
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 Mere

€34 EUR på 1 dag
(42 bedømmelser)
5.5
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 Mere

€250 EUR in 0 dage
(13 bedømmelser)
3.8
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 Mere

€29 EUR in 3 dage
(17 bedømmelser)
3.4
BeautiCG

Hi,dear. I am a senior software developer. I have just checked your project report, I am able to perform this task with my developer team. I am looking forward to your proposal...

€23 EUR på 1 dag
(6 bedømmelser)
3.1
€70 EUR på 1 dag
(1 bedømmelse)
2.6
kudosta

Hello Greetings from Sweety, Thanks for give us a chance for submit [url removed, login to view] 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 Mere

€66 EUR på 1 dag
(1 bedømmelse)
2.2
€50 EUR på 1 dag
(1 bedømmelse)
2.1
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 Mere

€34 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 Mere

€100 EUR in 3 dage
(3 bedømmelser)
2.1
WPtrend

*******Sakaype: alipetarian9090 ****** For Quick communication******** Hy there! I hope you are fine. Do not waste your time with new freelancers. Instead engage the expert and get your problems solved. Mere

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

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mere

€25 EUR in 6 dage
(0 bedømmelser)
0.0
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 Mere

€55 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. Mere

€34 EUR på 1 dag
(0 bedømmelser)
0.0
€84 EUR in 10 dage
(0 bedømmelser)
0.0
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 Mere

€20 EUR på 1 dag
(0 bedømmelser)
0.0
intmir

A proposal has not yet been provided

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