Untitled
unknown
plain_text
a year ago
494 B
3
Indexable
SELECT DISTINCT i.id_status, COUNT(*) FROM picking_container pc LEFT JOIN picking_job pj USING (id_picking_job) LEFT JOIN item i USING (order_nr) WHERE box_barcode in ( 'PF11015965283A', 'PF16082714966A', 'PF17784466627A', 'PF13825368357A', 'PEC9199371031A', 'PF14398362086A', 'PF11553752248A', 'PF19474567785A', 'PF13796867586A', 'PEC3855895798A', 'PF11020650541A', 'PF12723372744A', 'PF12205951826A', 'PF13644521567A', 'PF15141228608A', 'PF11130472898A') GROUP BY 1
Editor is loading...
Leave a Comment