Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO item_daily_data (added, in_stock, in_stock_count, price_current, price_original, sale_tag, delta, region_id, spider_item_id)
- SELECT spider_items.added, spider_items.in_stock, spider_items.in_stock_count, prices.current, prices.original, prices.sale_tag, prices.delta, NULL, spider_items_main.id FROM spider_items
- LEFT JOIN prices ON spider_items.id = prices.spider_item_id
- LEFT JOIN spider_items_main ON spider_items."RPC" = spider_items_main."RPC" AND spider_items.spider_id = spider_items_main.spider_id
- WHERE spider_items.added >= '2018-01-01';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement