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

Patziku Perurena

PP-001