Untitled

SELECT 
    CONCAT('$', FORMAT(ROUND(cost), 'c')) roundedcost,
    CONCAT('s', serialnumber) serial,
    product,
    location,
    removedate,
    SUBSTRING_INDEX(notes, ']', 1) notes
FROM
    inventoryitem
WHERE
    product LIKE 'EFCR%'
        AND location = 'cant find:pending'
        AND qtyonhand = 0
        AND notes LIKE '%Manual Decrement%'
        AND DATE(removedate) >= '2023-01-01'
ORDER BY removedate ASC