Untitled

SELECT 
    concat('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    previousbin,
    previouslocation,
    SUBSTRING_INDEX(SUBSTRING_INDEX(locationhistory, ']', 1),
            ',',
            - 1) user,
            lastscandate
FROM
    inventoryitem
WHERE
    location = 'pa returns'
        AND qtyonhand = 1
        AND date(lastscandate) <= '2024-01-01'