Untitled

  
    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