Untitled

SELECT 
    CONCAT(serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE 'EFCR%' AND qtyonhand = 1
        AND location LIKE '7-%'
        order by location asc