Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO prices (price, product_id)
- SELECT
- product_price, commn_id
- FROM products_temp as prod
- WHERE NOT EXISTS
- (SELECT *
- FROM prices od
- WHERE prod.commn_id = od.product_id)
- OR prod.product_price !=
- ( SELECT price
- FROM prices as p
- WHERE p.product_id = prod.commn_id
- order by p.end
- desc LIMIT 1 )
- OR prod.product_price !=
- ( SELECT price
- FROM prices as p
- WHERE p.product_id = prod.commn_id
- order by p.end
- desc LIMIT 1 )
Add Comment
Please, Sign In to add comment