Untitled

mail@pastecode.io avatar
unknown
mysql
a year ago
316 B
4
Indexable
Never
SELECT 
    concat('s', serialnumber) serials,
    product,
    size,
    location,
    previousbin,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    location = 'cant find:pending'
    AND previouslocation like '7-%'
        AND qtyonhand = 1
        order by previouslocation, previousbin asc