Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    inventoryId,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    serialnumber IN ('193336814' , '193336823',
        '230938201',
        '230938196',
        '220351092',
        '220351140',
        '220351143',
        '240500326',
        '240500311',
        '221856678',
        '221856612',
        '221856639',
        '221856693',
        '241978481',
        '241978511',
        '220351233',
        '220351236',
        '240500196',
        '240939546',
        '240500281',
        '241978361',
        '241978366',
        '230883581',
        '230883551',
        '230883461')