UPDATE tmp_sales_august t JOIN iceleads.merchant m ON t.merchant_name=m.name SET t.merchant_id=m.id;

UPDATE tmp_sales_august t JOIN iceleads_stat.cold_stat_leads_detail l ON t.lead_id=l.lead_id
 SET t.affiliate_id=l.affiliate_id, t.core_product_repository_id=l.core_product_repository_id, t.session_key=l.session_key, t.cid=l.cid;

UPDATE tmp_sales_august t JOIN iceleads.affiliate a ON t.affiliate_id=a.id SET t.affiliate_name=a.name;

UPDATE tmp_sales_august t JOIN iceleads.merchant_country m ON t.merchant_id=m.merchant_id
 SET t.ref_country_id=m.ref_country_id;

UPDATE tmp_sales_august SET pixel_string=CONCAT('http://iceleads.com/iceleads_rest/merch/',merchant_id,'/direct',';mpn=',(REPLACE(REPLACE(mpn,'/','%2F'),' ','%20')),';ean=',ean,';pr=',price,';cur=',currency,';qty=',qty,';vendor_name=',vendor_name,';prod_name=',(REPLACE(REPLACE(description,'/','%2F'),' ','%20')));

UPDATE tmp_sales_august t JOIN iceleads.core_product_alternative ca ON t.mpn=ca.mpn_alternative AND t.core_product_repository_id=ca.core_product_repository_id
JOIN iceleads.core_product_repository cr ON ca.core_product_repository_id=cr.id
SET t.category_id=cr.category_id;

UPDATE tmp_sales_august t JOIN iceleads.vendor v ON v.name=t.vendor_name SET t.vendor_id=v.id;

UPDATE tmp_sales_august t JOIN iceleads_stat.cold_stat_leads_detail l ON t.lead_id=l.lead_id
SET t.user_agent_value=l.user_agent_value, t.remote_ip=l.remote_ip;