Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `wp_postmeta`(post_id, meta_key, meta_value)
- SELECT DISTINCT p.`ID`, `tt`.`meta_key`, `tt`.`meta_value`
- FROM `wp_posts` p
- INNER JOIN `wp_postmeta` pm on pm.`post_id` = p.`ID`
- LEFT JOIN (
- select distinct p.`ID` as ID
- from `wp_posts` p
- inner join `wp_postmeta` pm on pm.`post_id` = p.`ID`
- where p.`post_type` = 'product'
- and `pm`.`meta_key` in (
- '_wc_measurement_price_calculator_min_price',
- '_wc_price_calculator',
- '_wc_price_calculator_pricing_rules'
- )
- ) as t on t.`ID` = p.`ID`
- CROSS JOIN (
- select `pm`.`meta_key`,
- `pm`.`meta_value`
- from `wp_posts` p
- inner join `wp_postmeta` pm on pm.`post_id` = p.`ID`
- where p.`post_type` = 'product'
- and p.`ID` = 7632 //ID образца //
- and `pm`.`meta_key` in (
- '_wc_measurement_price_calculator_min_price',
- '_wc_price_calculator',
- '_wc_price_calculator_pricing_rules'
- )
- ) as tt
- WHERE p.`post_type` = 'product'
- AND t.`ID` IS NULL
- AND pm.`meta_key` = '_product_attributes'
- AND pm.`meta_value` like '%pa_vid-prodazhi%'
- AND pm.`meta_value` like '%м2%'
Advertisement
Add Comment
Please, Sign In to add comment