Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    location,
    previouslocation,
    internalRANum
FROM
    inventoryitem
WHERE
    product IN ('MILL-WS513')
    and location = 'UNSELLABLE RA Location'
    #AND previouslocation = 'RA Inventory Pending'
        AND qtyonhand = 0