Untitled

SELECT 
    r.reasoncode,
    i.createdate AS removedate,
    CONCAT('s', s.serialnumber) serial,
    s.product,
    size,
    location,
    SUBSTRING(SUBSTRING_INDEX(SUBSTRING_INDEX(s.notes, ',', 1),
                'by',
                - 1),
        2,
        50) user,
    SUBSTRING_INDEX(s.notes, ']', 1) notes
FROM
    (SELECT 
        serialnumber, createdate, productcode, inventoryupdateid
    FROM
        inventoryupdate_extend
    WHERE
        DATE(createdate) = CURDATE()) i
        JOIN
    inventoryitem s ON s.serialnumber = i.serialnumber
        AND s.notes LIKE '[Manual decrement%'
        AND DATE(removedate) = CURDATE()
        JOIN
    inventoryupdate r ON r.id = i.inventoryupdateid
ORDER BY removedate DESC;