Untitled

SELECT 
    GROUP_CONCAT(CONCAT('s', serialnumber)) SerialsToCheck,
    GROUP_CONCAT(Product) Products,
    Bin,
    Location,
    PreviousLocation,
    Lastscandate
FROM
    inventoryitem
WHERE
    previouslocation = 'PA RT in-trnst'
        AND location LIKE '7-%'
        AND location NOT LIKE '7-Q%'
        AND location NOT LIKE '7-R%'
        AND location NOT LIKE '7-S%'
        AND location NOT LIKE '7-T%'
        AND qtyonhand = 1
GROUP BY bin
ORDER BY location ASC