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