mp_query_log.sql

BEFORE: SELECT name, slug, type, count(post_id) as count FROM wp_mp_terms t LEFT JOIN wp_mp_term_relationships r ON t.term_id = r.term_id WHERE t.type = 'product_category' GROUP BY t.term_id ORDER BY name ASC LIMIT 50
AFTER: SELECT name, slug, type, count(post_id) as count FROM wp_terms t LEFT JOIN wp_terms r ON t.term_id = r.term_id WHERE t.type = 'product_category' GROUP BY t.term_id ORDER BY name ASC LIMIT 50

BEFORE: DELETE p.*, r.* FROM wp_mp_products p LEFT JOIN wp_mp_term_relationships r ON p.id = r.post_id WHERE p.site_id = 1 AND p.blog_id = 3 AND p.post_id = 12
AFTER: DELETE p.*, r.* FROM wp_mp_products p LEFT JOIN wp_terms r ON p.id = r.post_id WHERE p.site_id = 1 AND p.blog_id = 3 AND p.post_id = 12

BEFORE: DELETE p.*, r.* FROM wp_mp_products p LEFT JOIN wp_mp_term_relationships r ON p.id = r.post_id WHERE p.site_id = 1 AND p.blog_id = 3 AND p.post_id = 12
AFTER: DELETE p.*, r.* FROM wp_mp_products p LEFT JOIN wp_terms r ON p.id = r.post_id WHERE p.site_id = 1 AND p.blog_id = 3 AND p.post_id = 12

BEFORE: SELECT * FROM wp_mp_terms WHERE slug IN ('music-computer-hardware')
AFTER: SELECT * FROM wp_terms WHERE slug IN ('music-computer-hardware')

BEFORE: INSERT INTO `wp_mp_term_relationships` (`term_id`,`post_id`) VALUES (122,5)
AFTER: INSERT INTO `wp_terms` (`term_id`,`post_id`) VALUES (122,5)

BEFORE: SELECT name, slug, type, count(post_id) as count FROM wp_mp_terms t LEFT JOIN wp_mp_term_relationships r ON t.term_id = r.term_id WHERE t.type = 'product_category' GROUP BY t.term_id ORDER BY name ASC LIMIT 50
AFTER: SELECT name, slug, type, count(post_id) as count FROM wp_terms t LEFT JOIN wp_terms r ON t.term_id = r.term_id WHERE t.type = 'product_category' GROUP BY t.term_id ORDER BY name ASC LIMIT 50

BEFORE: SELECT * FROM wp_mp_terms WHERE slug IN ('packaging','billing-forms')
AFTER: SELECT * FROM wp_terms WHERE slug IN ('packaging','billing-forms')

BEFORE: SELECT * FROM wp_mp_term_relationships r INNER JOIN wp_mp_terms t ON r.term_id = t.term_id WHERE r.post_id = 2
AFTER: SELECT * FROM wp_terms r INNER JOIN wp_terms t ON r.term_id = t.term_id WHERE r.post_id = 2

BEFORE: INSERT INTO `wp_mp_term_relationships` (`term_id`,`post_id`) VALUES (80,2)
AFTER: INSERT INTO `wp_terms` (`term_id`,`post_id`) VALUES (80,2)

BEFORE: INSERT INTO `wp_mp_term_relationships` (`term_id`,`post_id`) VALUES (81,2)
AFTER: INSERT INTO `wp_terms` (`term_id`,`post_id`) VALUES (81,2)

BEFORE: DELETE FROM wp_mp_term_relationships WHERE post_id = 2 AND term_id NOT IN ('80','81')
AFTER: DELETE FROM wp_terms WHERE post_id = 2 AND term_id NOT IN ('80','81')