Untitled
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