Untitled
unknown
mysql
2 years ago
307 B
6
Indexable
SELECT CONCAT('s', serialnumber) serial, product, size, bin, location, lastscandate FROM inventoryitem WHERE location = 'gift pack pending' AND date(lastscandate) >= '2023-01-01' AND PONum not like '%-GIFT' AND qtyonhand = 1 order by lastscandate asc
Editor is loading...