-- Removing common weapon elements
DELETE
FROM
    item_attributes
WHERE
    itemId IN
    (
        SELECT
            object_id
        FROM
            items
        WHERE
            item_id IN
            (
                SELECT
                    item_id
                FROM
                    weapon
                WHERE
                    name LIKE "Common Item%"
            )
    )
;
-- Removing common armor elements
DELETE
FROM
    item_attributes
WHERE
    itemId IN
    (
        SELECT
            object_id
        FROM
            items
        WHERE
            item_id IN
            (
                SELECT
                    item_id
                FROM
                    armor
                WHERE
                    name LIKE "Common Item%"
            )
    )
;