SELECT i.id, i.level, t.item_name, t.item_desciption
  FROM items i, translations t
  WHERE i.id = t.item_id
  AND i.level = 3
  GROUP BY i.id
  ORDER BY t.name;