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
