Untitled

SELECT 
    CONCAT('s', serialnumber) AS Serial,
    Product,
    Size,
    Bin,
    Location,
    PreviousLocation AS PrevLoc,
    Lastscandate,
    Username AS User
FROM
    shard.inventoryitemupdate
WHERE
    previouslocation LIKE 'Consolidation Discrepancy%'
        AND location NOT LIKE '7-L666A-1a'
        AND (location LIKE '7-UL%'
        OR location LIKE '7-L%')
        AND (username LIKE 'Laura Ayala 8041'
        OR username LIKE 'Josefina Quezada 6014')
        AND lastscandate >= '2024-09-01 00:00:00'
        AND lastscandate <= '2024-09-30 23:59:59'
        AND qtyonhand = 1
ORDER BY lastscandate DESC