| Line 16... |
Line 16... |
| 16 |
" SUM(tl.selling_price) AS Total" +
|
16 |
" SUM(tl.selling_price) AS Total" +
|
| 17 |
" from warehouse.inventoryItem ii" +
|
17 |
" from warehouse.inventoryItem ii" +
|
| 18 |
" join warehouse.scanNew s on s.inventoryItemId = ii.id" +
|
18 |
" join warehouse.scanNew s on s.inventoryItemId = ii.id" +
|
| 19 |
" join catalog.item i on i.id = ii.itemId" +
|
19 |
" join catalog.item i on i.id = ii.itemId" +
|
| 20 |
" join catalog.tag_listing tl on tl.item_id = i.id" +
|
20 |
" join catalog.tag_listing tl on tl.item_id = i.id" +
|
| 21 |
" join catalog.catagoriesd_catalog cc on cc.catalog_id = i.catalog_item_id and cc.end_date is null" +
|
21 |
" left join catalog.catagoriesd_catalog cc on cc.catalog_id = i.catalog_item_id and cc.end_date is null" +
|
| 22 |
" join (warehouse.inventoryItem ii2 join warehouse.purchase p on p.id = ii2.purchaseId" +
|
22 |
" join (warehouse.inventoryItem ii2 join warehouse.purchase p on p.id = ii2.purchaseId" +
|
| 23 |
" join warehouse.purchaseorder po on po.id = p.purchaseOrder_id" +
|
23 |
" join warehouse.purchaseorder po on po.id = p.purchaseOrder_id" +
|
| 24 |
" join warehouse.invoice inv on (p.invoice_id = inv.id and po.supplierId = inv.supplierId and" +
|
24 |
" join warehouse.invoice inv on (p.invoice_id = inv.id and po.supplierId = inv.supplierId and" +
|
| 25 |
" po.warehouseId = ii2.physicalWarehouseId)" +
|
25 |
" po.warehouseId = ii2.physicalWarehouseId)" +
|
| 26 |
" join warehouse.supplier su on su.id = inv.supplierId and su.internal = 0)" +
|
26 |
" join warehouse.supplier su on su.id = inv.supplierId and su.internal = 0)" +
|