Untitled

 avatar
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...