Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location
FROM
    inventoryitem
WHERE
    product LIKE 'rayb%' AND qtyonhand = 1
        AND sellAsDefective = 1
        order by location asc