Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    location,
    previousbin,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    location = 'cant find:pending'
        AND previouslocation IN ('7-A27F-3b',
'7-A45D-0a',
'7-A45G-3b',
'7-A45H-1b',
'7-A59A-1a',
'7-A60G-5a',
'7-B13F-2a',
'7-B14E-0a',
'7-B14L-3b',
'7-B14N-4a',
'7-B27I-2a',
'7-B27I-3a',
'7-B27J-3c',
'7-B27J-4c',
'7-B27K-2c',
'7-B27M-3a',
'7-B28I-0b',
'7-B28J-1a',
'7-B28J-3a',
'7-B28M-2a',
'7-B33A-2c',
'7-B33I-1b',
'7-B33K-3a',
'7-B33M-0a',
'7-B33M-2c',
'7-B33M-3c',
'7-B34A-4c',
'7-B34B-0a',
'7-B34C-0a',
'7-B34C-0b',
'7-B34M-1c',
'7-B34M-4a',
'7-B34N-5a',
'7-B37B-5b',
'7-B38M-1c',
'7-B41B-0b',
'7-B41E-3a',
'7-B42B-0b',
'7-B42B-4a',
'7-B42E-3a',
'7-B42J-1a',
'7-B49B-3c',
'7-B49E-2a',
'7-B49I-1b',
'7-B49I-5c',
'7-B49K-2b',
'7-B50B-5c',
'7-B50F-4c',
'7-B50K-0a',
'7-B50K-1c',
'7-C1B-0a',
'7-C1G-4a',
'7-C2E-5c',
'7-C2H-3b',
'7-C2H-4b',
'7-C2J-5c',
'7-C2U-4b',
'7-C3P-2b',
'7-C3Q-1b',
'7-C3T-3c',
'7-C9L-3a',
'7-C9M-3c',
'7-C10J-0c',
'7-C11A-0a',
'7-C11A-5b',
'7-C11J-2a',
'7-C12B-2c',
'7-C12H-4a',
'7-C13P-2a',
'7-C14X-5b',
'7-C17G-2a',
'7-C18A-0a',
'7-C18E-5b',
'7-C18I-4b',
'7-C20I-4a',
'7-C22A-3b',
'7-C23C-5b',
'7-C23G-4a',
'7-C23R-0c',
'7-C23R-1c',
'7-C23R-5a',
'7-C23S-0b',
'7-C23T-3a',
'7-C23V-0b',
'7-C24B-5a',
'7-C24E-5b',
'7-C24J-2b',
'7-C24J-4c',
'7-C24K-5c',
'7-C24T-2b',
'7-C24X-4c',
'7-C24Z-0a',
'7-C24Z-4b',
'7-C25Z-2c',
'7-C33B-5b',
'7-C33E-4b',
'7-C33F-2b',
'7-C33F-4a',
'7-C33F-5b',
'7-C33M-2b',
'7-C34A-4a',
'7-C34H-4c',
'7-C38Z-1b',
'7-C40A-3a',
'7-C40B-0b',
'7-C47C-4a',
'7-C47R-4c',
'7-C47Z-3c',
'7-C49H-0c',
'7-C49H-2b',
'7-C49I-4c',
'7-C49K-3b',
'7-C49S-3a',
'7-C49U-2a',
'7-C50H-4c',
'7-C50I-3a',
'7-C50J-0b',
'7-C50X-4d',
'7-C51I-4a',
'7-C51M-2a',
'7-C52E-5a',
'7-C52F-3b',
'7-C55C-4c',
'7-C55D-0b',
'7-C55K-2c',
'7-C55L-1a',
'7-UA9B-1b',
'7-UA9B-1c',
'7-UA9E-4b',
'7-UA10E-0a',
'7-UA10E-2b',
'7-UA10H-1b',
'7-UA10I-1a',
'7-UA18A-2a',
'7-UA21A-0b',
'7-UA21A-0c',
'7-UA21A-3a',
'7-UA21B-0c',
'7-UA21B-3a',
'7-UA21B-4a',
'7-UA21B-5a',
'7-UA21D-5a',
'7-UA21E-4b',
'7-UA21F-0c',
'7-UA21F-1a',
'7-UA21F-1c',
'7-UA21F-5a',
'7-UA21G-4b',
'7-UA21H-1c',
'7-UA21H-5a',
'7-UA22E-3a',
'7-UA22E-4a',
'7-UA22I-3c',
'7-UA28G-1a',
'7-UA28G-1b',
'7-UA28I-2b',
'7-UA31A-0a',
'7-UA31A-0c',
'7-UA31A-2c',
'7-UA31A-4c',
'7-UA31B-2a',
'7-UA31F-0b',
'7-UA31G-2a',
'7-UA32A-3b',
'7-UA32B-5a',
'7-UA32D-3c',
'7-UA32F-0a',
'7-UA32H-3b',
'7-UA35I-4a',
'7-UA39E-4b',
'7-UA39G-3b',
'7-UA40G-0c',
'7-UA40G-1b',
'7-UA40H-0b',
'7-UA40I-4a',
'7-UA40I-4b',
'7-UA51B-2c',
'7-UA51D-2c',
'7-UA51E-1a',
'7-UA51E-4c',
'7-UA51H-4c',
'7-UA51H-5b',
'7-UA52I-3c',
'7-UA56B-2c',
'7-UA57G-3b',
'7-UA59G-2b',
'7-UA60E-2c',
'7-UA61A-1c',
'7-UA61E-2a',
'7-UA63A-1c',
'7-UB3L-1a',
'7-UB9E-2a',
'7-UB22M-5c',
'7-UB34H-3a',
'7-UB35A-5a',
'7-UB35B-4a',
'7-UB35C-2b',
'7-UB35E-2a',
'7-UB35E-3a',
'7-UB35F-4a',
'7-UB35G-0a',
'7-UB35G-1b',
'7-UB35G-4a',
'7-UB35H-1b',
'7-UB35J-4b',
'7-UB36F-2b',
'7-UB47E-5c',
'7-UB47K-3c',
'7-UB47M-5b',
'7-UB48M-0c',
'7-UB55E-5b',
'7-UB55I-5b',
'7-UB55L-0a',
'7-UB56B-2c',
'7-UB56D-5c',
'7-UB56K-5c',
'7-UB57A-1c',
'7-UB57A-3c',
'7-UB57C-0c',
'7-UB57C-4a',
'7-UB57D-4a',
'7-UB58A-3a',
'7-UB58N-2b',
'7-UC15A-2b',
'7-UC15B-2b',
'7-UC15B-3a',
'7-UC15K-2b',
'7-UC16B-5a',
'7-UC16C-2a',
'7-UC20W-1c',
'7-UC26W-2a',
'7-UC28N-4a',
'7-UC32Z-3b',
'7-UC33C-5b',
'7-UC33D-3a',
'7-UC33G-4b',
'7-UC34A-1b',
'7-UC34A-5c',
'7-UC34B-4c',
'7-UC34D-5b',
'7-UC34L-2c',
'7-UC41R-2a',
'7-UC41S-4c',
'7-UC41Y-1c',
'7-UC51Z-1c',
'7-UC53F-1a',
'7-UC58O-1c',
'7-UC69L-2c',
'7-UC70J-3c',
'7-VA5F-4c',
'7-VA12H-4a',
'7-VB38L-4c',
'7-VB66F-1b',
'7-VC5K-1b',
'7-VC6I-3b',
'7-VC13S-0b',
'7-VC13S-0c',
'7-VC14N-2a',
'7-VC14N-2b',
'7-VC28E-1b',
'7-VC29I-0c',
'7-VC29J-3b',
'7-VC30F-1a',
'7-VC30F-1c',
'7-VC30S-0a',
'7-VC39F-0c',
'7-VC39O-0c',
'7-VC40C-3a',
'7-VC40C-3b',
'7-VC40G-1a',
'7-VC40Y-1a',
'7-VC40Z-2a',
'7-VC40Z-2b',
'7-VC41M-0b',
'7-VC42B-1a',
'7-VC43E-0b',
'7-VC44I-2c',
'7-VC44K-1a',
'7-VC45R-0c',
'7-VC46K-1c',
'7-VC46N-0b',
'7-VC48E-3b',
'7-VC49C-0b',
'7-VC49W-0c',
'7-VC50P-2a',
'7-VC56N-4a',
'7-VC57R-3c')
        AND qtyonhand = 1
        AND DATE(lastscandate) <= '2025-01-27'
ORDER BY lastscandate DESC