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