SELECT ixe, ixe_type, status FROM ixe i, ixe_attribute ia LEFT JOIN ixe_attribute ia1 ON ia.id = ia1.id WHERE i.ixe = ia.id AND i.ixe_type IN (73) AND i.status IN (1) AND ia1.ixe_composition IN (443) GROUP BY i.ixe ORDER BY ia1.value ASC SELECT ixe, ixe_type, status , ia1.value FROM ixe i, ixe_attribute ia LEFT JOIN ixe_attribute ia1 ON ia.id = ia1.id WHERE i.ixe = ia.id AND i.ixe_type IN (72,78,79) AND i.status IN (1) AND ia.ixe_composition IN (475, 547, 582) AND ia.value = '1091' AND ia1.ixe_composition IN (441,529,564) GROUP BY i.ixe ORDER BY ia1.value ASC LIMIT 0, 50

Irulegi Irratia

II-147b

  • Record: II-147b
  • Piece: A04
  • Time: 00:07:08 - 00:10:12
  • Themes: improvised verse
  • Summary: In Uztaritze there was a versolari (traditional singer) but he was not among the best.(08:35") Verses.