Untitled

mail@pastecode.io avatarunknown
mysql
a month ago
494 B
3
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    (location LIKE '7-A%'
        OR location LIKE '7-B%'
        OR location LIKE '7-C%'
        OR location LIKE '7-U%'
        OR location LIKE '7-V%'
        OR location LIKE '7-D%'
        OR location LIKE '7-E%'
        OR location LIKE '7-Z%')
        AND defective = 1
        AND sellasdefective = 0
        AND Qtyonhand = 1
ORDER BY location ASC