Untitled

unknown
mysql
a month ago
615 B
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    location LIKE '7-%'
        AND (previouslocation = 'PA Returns'
        OR previouslocation = 'Happy Returns'
        OR previouslocation = 'Repack'
        OR previouslocation = 'Returns'
        OR previouslocation LIKE '7-T%')
        AND (product LIKE '%-_S%'
        OR product LIKE '%-_D%'
        OR product LIKE '%-_X%'
        OR product LIKE '%-_Z%'
        OR product LIKE '%-_D%'
        OR product LIKE '%-wu%')
        AND qtyonhand = 1