Untitled

 avatar
unknown
mysql
3 years ago
809 B
3
Indexable
SELECT     CONCAT('s', serialnumber) AS serial,    product,    size,    location,    bin,    previouslocation,    lastscandate,    removedate,    TIMESTAMPDIFF(DAY,        removedate,        lastscandate) AS found_interval,    SUBSTRING_INDEX(SUBSTRING_INDEX(notes, ':', 1), '[', - 1) AS reasonFROM    inventoryitem j2WHERE    location LIKE '7-%'        AND location NOT LIKE '7-T%'        AND location NOT LIKE '7-800%'        AND location NOT LIKE '7-R%'        AND location NOT LIKE '7-S%'        AND location NOT LIKE '7-Q%'        AND location NOT LIKE '7-444_-%'        AND lastscandate >= (CURRENT_DATE - INTERVAL 1 DAY)        AND lastscandate > removedate        AND qtyonhand = 0HAVING reason IN ('OOS on' , 'Manual decrement on ')
Editor is loading...