Untitled

mail@pastecode.io avatar
unknown
mysql
13 days ago
3.4 kB
9
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    location,
    previousbin,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    location = 'cant find:pending'
        AND previouslocation IN ('7-LA1A-5c' , '7-LA1A-4f',
        '7-LA1B-3c',
        '7-LA1B-4c',
        '7-LA1B-4b',
        '7-LA1E-2d',
        '7-LA1E-2e',
        '7-LA1E-5a',
        '7-LA1E-5b',
        '7-LA15C-1f',
        '7-LA15C-1e',
        '7-LA37A-3c',
        '7-LA36B-1b',
        '7-LA37D-2a',
        '7-LA36E-2c',
        '7-LA37E-2d',
        '7-LA37E-3a',
        '7-LA37F-1d',
        '7-LA37F-3d',
        '7-LA37F-1a',
        '7-LA37F-3c',
        '7-LA36F-1b',
        '7-LA36F-1a',
        '7-LA36G-2a',
        '7-LA36G-1d',
        '7-LA37G-3c',
        '7-LA38E-3a',
        '7-LA39B-1a',
        '7-LB42J-1d',
        '7-LB25B-1f',
        '7-LB25B-4f',
        '7-LB25C-3g',
        '7-LB25C-3b',
        '7-LB25D-2a',
        '7-LB25D-3b',
        '7-LB25D-1a',
        '7-LB24E-1e',
        '7-LB1D-4f',
        '7-LB1D-4e',
        '7-LB1D-1f',
        '7-LB1D-1c',
        '7-LB1D-3f',
        '7-LB1D-5g',
        '7-ULA1C-4g',
        '7-ULA1C-4e',
        '7-ULA1C-2f',
        '7-ULA1D-2c',
        '7-ULA1E-2a',
        '7-ULA1E-3f',
        '7-ULA1E-2f',
        '7-ULA1F-3g',
        '7-ULB25A-8b',
        '7-ULB25A-6c',
        '7-ULB24B-6b',
        '7-ULB24B-8f',
        '7-ULB24B-6g',
        '7-ULB25C-8b',
        '7-ULB25C-5e',
        '7-ULB25C-5e',
        '7-ULB24C-8d',
        '7-ULB24C-6a',
        '7-ULB24D-2g',
        '7-ULB25E-7g',
        '7-ULB25E-8g',
        '7-ULB24E-7f',
        '7-ULB22E-7a',
        '7-ULB23D-6b',
        '7-ULB23C-8c',
        '7-ULB22C-6b',
        '7-ULB22C-7g',
        '7-ULB22C-7d',
        '7-ULB22C-6a',
        '7-ULB22B-6e',
        '7-ULB22B-7e',
        '7-ULB22B-6f',
        '7-ULB22B-7c',
        '7-ULB23B-6e',
        '7-ULB23A-7c',
        '7-ULB23A-7c',
        '7-ULB22A-8g',
        '7-ULB22A-4b',
        '7-ULB22A-7f',
        '7-ULB22A-5f',
        '7-ULB21A-6g',
        '7-ULB21A-7e',
        '7-ULB21A-7c',
        '7-ULB20A-4c',
        '7-ULB20B-4a',
        '7-ULB21B-4b',
        '7-ULB21C-5f',
        '7-ULB21C-5e',
        '7-ULB20C-4a',
        '7-ULB20C-4e',
        '7-ULB20D-4e',
        '7-ULB21D-6a',
        '7-ULB21E-6b',
        '7-ULB17D-4c',
        '7-ULB15C-4a',
        '7-ULB10D-4e',
        '7-ULB1D-2e',
        '7-ULB1D-2e',
        '7-ULA36G-4a',
        '7-ULA36G-3c',
        '7-ULA36G-4b',
        '7-ULA36G-4d',
        '7-ULA37F-7a',
        '7-ULA37F-1b',
        '7-ULA36E-6d',
        '7-ULA36E-5c',
        '7-ULA36E-6a',
        '7-ULA36E-1b',
        '7-ULA36E-1d',
        '7-ULA36E-1a',
        '7-ULA36E-6b',
        '7-ULA37E-5a',
        '7-ULA37E-1d',
        '7-ULA37E-2a',
        '7-ULA37E-3c',
        '7-ULA37E-6b',
        '7-ULA36D-7b',
        '7-ULA36D-4d',
        '7-ULA36C-7c',
        '7-ULA37C-2c',
        '7-ULA36B-4b',
        '7-ULA36B-7b',
        '7-ULA36B-3b',
        '7-ULA37B-3d',
        '7-ULA37B-7c',
        '7-ULA37B-3d',
        '7-ULA37B-7d',
        '7-ULA37B-2d',
        '7-ULA37B-1b',
        '7-ULA36A-3c',
        '7-ULA37A-7c',
        '7-ULA37A-2b',
        '7-ULA38A-7c',
        '7-ULA38C-2b',
        '7-ULA39C-7b')
        AND qtyonhand = 1
        AND date(lastscandate) >= '2024-05-30'
Leave a Comment