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.

MySQL Wordpress

ID Projek: #13304289

Tentang projek