Untitled

mail@pastecode.io avatar
unknown
mysql
16 days ago
304 B
2
Indexable
Never
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
Leave a Comment