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

Satrustegi

SC-011b

  • Record: SC-011b
  • Piece: A01
  • Time: 00:00:00 - 00:04:43
  • Themes: America , jobs:
  • Summary: He went as a shepherd in 1957. In the beginning it was tough; he especially missed the Sunday afternoon fiestas they used to have. He started with a flock of three thousand five hundred sheep. He was at it for three and a half years with two different bosses. His contract began in 1956. He had to spend three years there.The Basque speakers used to meet up quite often. There were eighteen or twenty thousand sheep in those lands and all the shepherds were Basque speakers.The second boss paid him more. He took tax out of the salary.