SQL Query:
SELECT 'Clothing' AS item_type, item_name, size, color FROM Clothes WHERE clothing_id NOT IN (SELECT item_id FROM CostumeItem WHERE item_type='Clothing') UNION ALL ...

Items not currently assigned to any costume: 0 item(s) available.
TypeItem NameSubtypeSizeColorConditionShop
All items are currently assigned to costumes.