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

Satrustegi

SM-009

  • Record: SM-009
  • Piece: A06
  • Time: 00:36:10 - 00:37:00
  • Themes: America , jobs:
  • Summary: When they were working as shepherds in America, they used to be in carts.