Untitled

mail@pastecode.io avatar
unknown
mysql
6 months ago
272 B
3
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    shard.inventoryitemupdate
WHERE
    location = 'Pulls'
    AND previouslocation <> 'Pulls'
    AND date(lastscandate) = '2023-10-04'
    and qtyonhand = 1