Mysql_ each city online product Day order data 20161130

#sealreport010 ' tb010_02d ' Cities online product Day order data

#sealreport010 ' tb010_02d ' Cities online product Day order dataSELECTD.id,a. The city, a. Online date, c. Commodity classification level, c. Classification of commodities class two, category three, commodity classification, product id,c. Product Name, B. Total quantity of items, order Amount from (    SELECTCity, date (online date) asonline date, Product ID from' a010_dynamic_ products 'WHEREOnline date>='2016-08-04'  andOnline date<current_date    GROUP  byCity, date (online date), Product ID) asa Left JOIN (    SELECTCity, date (order date) asOrder date, Product ID,SUM(Total quantity of items) asTotal quantity of the product,SUMAmount asOrder Amount from' A003_order 'WHEREOrder Date>='2016-08-04'  andOrder Date<current_date  andAmount>0     GROUP  byCity, date (order date), Product ID) asB onA. City=B. Cities andA. Product ID=B. Product ID andA. Online date=B. Order Date Left JOIN' A002_ Products ' asC onA. Product ID=c. Product ID Left JOIN' A000_city ' asD onA. City=D. City

Mysql_ each city online product Day order data 20161130