Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate,
    SUBSTRING_INDEX(locationhistory, ']', 2) LocHis
FROM
    inventoryitem
WHERE
    location = 'gift pack pending'
    AND product in ('AIKA-WU168',
'PTHO-WU96',
'OSER-WU45',
'KOSA-WU81',
'RPCO-WU132',
'DRBR-WU106',
'KOPR-WU97',
'ABEV-WU282',
'CTIL-WU235',
'ORIB-WU235',
'SRIL-WU59',
'BCOS-WU501',
'TUXR-WU38',
'SUMR-WU38',
'OLAP-WU18',
'ILIR-WU240',
'SOOR-WU120',
'EJAY-WA53',
'BSME-WA45',
'VERB-WU48',
'VERB-WU48',
'LASR-WU43',
'LORO-WU2',
'111R-WU42',
'AIKA-WU83',
'PTHO-WU76',
'OSER-WU37',
'RPCO-WU34',
'DRBR-WU35',
'KOPR-WU21',
'CTIL-WU113',
'ORIB-WU133',
'SRIL-WU6',
'BCOS-WU65',
'BCOS-WU65',
'TUXR-WU7',
'SUMR-WU1',
'ILIR-WU124',
'SOOR-WU31',
'EJAY-WA53',
'VERB-WU9',
'BSME-WA5',
'ABAD-WU7',
'LASR-WU22',
'LORO-WU2',
'111R-WU42')
        AND qtyonhand = 1
        AND product NOT LIKE 'btys%'
        order by lastscandate asc
        limit 400