Untitled

SELECT 
    COUNT(serialnumber) serials,
    product,
    size,
    bin,
    location,
    lastscandate,
    SUBSTRING_INDEX(locationhistory, ']', 1) LocHis,
    ponum
FROM
    inventoryitem
WHERE
    location = 'gift pack pending'
        AND qtyonhand = 1
        group by product
ORDER BY lastscandate ASC