Prozaik

plitk

Nov 6th, 2017
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. INSERT INTO `wp_postmeta`(post_id, meta_key, meta_value)
  2.  
  3. SELECT DISTINCT p.`ID`, `tt`.`meta_key`, `tt`.`meta_value`
  4. FROM `wp_posts` p
  5. INNER JOIN `wp_postmeta` pm on pm.`post_id` = p.`ID`
  6. LEFT JOIN (
  7. select distinct p.`ID` as ID
  8. from `wp_posts` p
  9. inner join `wp_postmeta` pm on pm.`post_id` = p.`ID`
  10. where p.`post_type` = 'product'
  11. and `pm`.`meta_key` in (
  12. '_wc_measurement_price_calculator_min_price',
  13. '_wc_price_calculator',
  14. '_wc_price_calculator_pricing_rules'
  15. )
  16.  
  17. ) as t on t.`ID` = p.`ID`
  18.  
  19. CROSS JOIN (
  20. select `pm`.`meta_key`,
  21. `pm`.`meta_value`
  22. from `wp_posts` p
  23. inner join `wp_postmeta` pm on pm.`post_id` = p.`ID`
  24. where p.`post_type` = 'product'
  25. and p.`ID` = 7632 //ID образца //
  26. and `pm`.`meta_key` in (
  27. '_wc_measurement_price_calculator_min_price',
  28. '_wc_price_calculator',
  29. '_wc_price_calculator_pricing_rules'
  30. )
  31.  
  32. ) as tt
  33. WHERE p.`post_type` = 'product'
  34. AND t.`ID` IS NULL
  35. AND pm.`meta_key` = '_product_attributes'
  36. AND pm.`meta_value` like '%pa_vid-prodazhi%'
  37. AND pm.`meta_value` like '%м2%'
Advertisement
Add Comment
Please, Sign In to add comment