Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE '%'
        AND (location LIKE '7-UL%'
        OR location LIKE '7-L%')
        AND lastscandate >= '2022-01-01 00:00:00'
        AND lastscandate <= '2024-06-30 23:59:59'
        AND qtyonhand = 1
GROUP BY location ASC