group by and order by sql

Rhythmyx Technical Discussion
1

Hi there,

i have the following query which doesnt bring back any error but the ordering is not actually working:

SELECT FIELD_OPTION_CHILDTABLE.OPTION_TRANSLATION FROM FIELD_OPTION_CHILDTABLE WHERE FIELD_OPTION_CHILDTABLE.CONTENTID in (select TOP 50 PHRASE_TO_APPEAR_ON_LABEL from CT_PRODUCT_DATA1_LABEL_PHRASES Join contentstatus On CT_PRODUCT_DATA1_LABEL_PHRASES.contentid = contentstatus.contentid where CT_PRODUCT_DATA1_LABEL_PHRASES.revisionid = contentstatus.currentrevision and CT_PRODUCT_DATA1_LABEL_PHRASES.contentid = '278381' GROUP BY PHRASE_TO_APPEAR_ON_LABEL ORDER BY MAX(SORTRANK) ASC) and OPTION_LANGUAGE = 'GB' and OPTION_TRANSLATION not like '%*%'

Would anyone have any ideas?

Thanks in advance