Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate,
    ponum
FROM
    inventoryitem
WHERE
    product IN ('MDNF-UA9' , 'MDNF-UA5',
        'MDNF-UA7',
        'MDNF-UA6',
        '111F-UU65',
        '111F-UU66',
        'MZSN-UU3',
        'TEFF-WU6',
        'SOUF-UU9',
        'ORIB-WU13',
        'MSIX-UU9',
        'SRYF-WU12',
        '199F-WU1',
        'CZIF-UU7')
        AND qtyonhand = 1
        AND location = 'gift pack pending'
ORDER BY product ASC