SELECT i.* FROM items AS i 
  LEFT JOIN mapping AS m ON (m.item_id = i.item_id AND m.container_id=1) 
WHERE m.container_id IS NULL