Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    group_concat(product) products,
    size,
    bin,
    location
FROM
    inventoryitem
WHERE
    (product LIKE 'ZHIR%'
        OR product LIKE 'ZIMM%'
        OR product LIKE 'BROR%')
        AND qtyonhand = 1
        and location like '7-%'
        AND orderhistory = ''
        group by location
order by location asc
limit 50