Untitled

SELECT 
    serialnumber, product, size, bin, location, lastscandate
FROM
    inventoryitem
WHERE
    product IN ('ANIN-WS125' , 'ANIN-WK134', 'LCDE-WD373', 'ANIN-WS109')
        AND qtyonhand = 1
        order by location asc