Advertisement
Guest User

Untitled

a guest
Feb 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO item_daily_data (added, in_stock, in_stock_count, price_current, price_original, sale_tag, delta, region_id, spider_item_id)
  2. 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
  3. LEFT JOIN prices ON spider_items.id = prices.spider_item_id
  4. LEFT JOIN spider_items_main ON spider_items."RPC" = spider_items_main."RPC" AND spider_items.spider_id = spider_items_main.spider_id
  5. WHERE spider_items.added >= '2018-01-01';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement