10 custom MySQL queries with WordPress meta tags (for statistical purposes)
€8-30 EUR
Paid on delivery
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.
Project ID: #13304289
About the project
15 freelancers are bidding on average €72 for this job
Ready to work with you on this project, could you please send me some more details so we will estimate it accordingly .....
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 More