Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product IN ('LCDE-WD373' , 'ANIN-WK134', 'ANIN-WS125', 'ANIN-WK109')
        AND qtyonhand = 1
ORDER BY product , size , location ASC