| Line 32... |
Line 32... |
| 32 |
" LEFT JOIN (" +
|
32 |
" LEFT JOIN (" +
|
| 33 |
" SELECT o.fofo_id, ci.catalog_item_id, SUM(oi.quantity) AS last2daysSale" +
|
33 |
" SELECT o.fofo_id, ci.catalog_item_id, SUM(oi.quantity) AS last2daysSale" +
|
| 34 |
" FROM fofo.fofo_order o" +
|
34 |
" FROM fofo.fofo_order o" +
|
| 35 |
" JOIN fofo.fofo_order_item oi ON o.id = oi.order_id" +
|
35 |
" JOIN fofo.fofo_order_item oi ON o.id = oi.order_id" +
|
| 36 |
" JOIN catalog.item ci ON oi.item_id = ci.id" +
|
36 |
" JOIN catalog.item ci ON oi.item_id = ci.id" +
|
| - |
|
37 |
" WHERE o.fofo_id = :fofoId" +
|
| 37 |
" WHERE DATE(o.create_timestamp) BETWEEN (CURDATE() - INTERVAL 2 DAY) AND CURDATE()" +
|
38 |
" AND o.create_timestamp >= CURDATE() - INTERVAL 2 DAY" +
|
| 38 |
" GROUP BY o.fofo_id, ci.catalog_item_id" +
|
39 |
" GROUP BY o.fofo_id, ci.catalog_item_id" +
|
| 39 |
") sale1 ON sale1.catalog_item_id = os.catalog_id AND os.fofo_id = sale1.fofo_id" +
|
40 |
") sale1 ON sale1.catalog_item_id = os.catalog_id AND os.fofo_id = sale1.fofo_id" +
|
| 40 |
" JOIN catalog.catalog c ON c.id = cc.catalog_id" +
|
41 |
" JOIN catalog.catalog c ON c.id = cc.catalog_id" +
|
| 41 |
" WHERE cc.end_date IS NULL AND cc.status = 'HID'" +
|
42 |
" WHERE cc.end_date IS NULL AND cc.status = 'HID'" +
|
| 42 |
"GROUP BY cc.catalog_id",
|
43 |
"GROUP BY cc.catalog_id",
|