Untitled

mail@pastecode.io avatar
unknown
mysql
21 days ago
288 B
6
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    previousbin,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE 'bot_-%' AND qtyonhand = 1
        AND location like '7-E30__-%'
        order by location asc
Leave a Comment