SELECT items.item_id FROM items LEFT JOIN mapping ON (items.item_id = mapping.item_id) EXCEPT SELECT items.item_id FROM items LEFT JOIN mapping ON (items.item_id = mapping.item_id) WHERE mapping.container_id = 1