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 = '1145' AND ia1.ixe_composition IN (441,529,564) GROUP BY i.ixe ORDER BY ia1.value ASC LIMIT 0, 50

Xorroxin Irratia

X-011a

  • Record: X-011a
  • Piece: A03
  • Time: 00:23:35 - 00:28:00
  • Themes: war
  • Summary: Memories of the war years. Manuel: They used to go to the farmhouse next door to spend the night. The two men spent the night at the doorway on guard with their pitchforks and suchlike.They were often scared but they never went hungry. As they were at the farmhouse there was always something to eat. Felipe was born in Sundilla in 1932 and he was four years old when the war began. They cut down trees and used them to block the road. He suffered hard times but no real hunger.