Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate,
    SUBSTRING_INDEX(locationhistory, ']', 1) LastTouch
FROM
    inventoryitem
WHERE
    location IN ('TruckToWarehouse' , 'TruckToWarehouse2')
        AND qtyonhand = 1
ORDER BY lastscandate ASC