Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    location,
    previouslocation,
    lastscandate,
    username
FROM
    shard.inventoryitemupdate
WHERE
    location = 'Mending'
        AND DATE(lastscandate) >= '2023-09-22'
        AND DATE(lastscandate) < '2023-09-29'
        AND username IN ('cecilia lira' , 'maria bermudez',
        'karen rojas',
        'Patricia Vidales',
        'marisol gonzalez',
        'Susana Alvarez Orozco',
        'guadalupe lopez',
        'johanna morales',
        'yoana berenice collazo',
        'yolitzyn alexandra garcia',
        'Xiclaly Esperanza Vallejo',
        'jennifer blanco Aguilera',
        'Jonatan Lopez')
GROUP BY serialnumber
ORDER BY lastscandate ASC
LIMIT 1000000000000