Untitled
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