| Line 42... |
Line 42... |
| 42 |
" AND fs.active = 1" +
|
42 |
" AND fs.active = 1" +
|
| 43 |
" and fs.internal = false" +
|
43 |
" and fs.internal = false" +
|
| 44 |
" AND p.escalation_type = 'L1') a" +
|
44 |
" AND p.escalation_type = 'L1') a" +
|
| 45 |
" LEFT JOIN (SELECT o.customer_id, tl.selling_price, cc.status from transaction.order o" +
|
45 |
" LEFT JOIN (SELECT o.customer_id, tl.selling_price, cc.status from transaction.order o" +
|
| 46 |
" JOIN transaction.lineitem li ON li.order_id = o.id AND li.brand NOT IN ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
46 |
" JOIN transaction.lineitem li ON li.order_id = o.id AND li.brand NOT IN ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
| 47 |
" JOIN catalog.item ci ON ci.id = li.item_id" +
|
47 |
" JOIN catalog.item ci ON ci.id = li.item_id AND ci.category = 10006" +
|
| 48 |
" JOIN catalog.tag_listing tl ON tl.item_id = ci.id" +
|
48 |
" JOIN catalog.tag_listing tl ON tl.item_id = ci.id" +
|
| 49 |
" LEFT JOIN catalog.catagoriesd_catalog cc ON cc.catalog_id = ci.catalog_item_id" +
|
49 |
" LEFT JOIN catalog.catagoriesd_catalog cc ON cc.catalog_id = ci.catalog_item_id" +
|
| 50 |
" AND (cc.start_date <= o.created_timestamp AND (cc.end_date IS NULL OR cc.end_date > o.created_timestamp))" +
|
50 |
" AND (cc.start_date <= o.created_timestamp AND (cc.end_date IS NULL OR cc.end_date > o.created_timestamp))" +
|
| 51 |
" JOIN warehouse.scanNew s ON s.orderId = o.id" +
|
51 |
" JOIN warehouse.scanNew s ON s.orderId = o.id" +
|
| 52 |
" JOIN warehouse.inventoryItem ii ON ii.id = s.inventoryItemId" +
|
52 |
" JOIN warehouse.inventoryItem ii ON ii.id = s.inventoryItemId" +
|