However I do the same with PR_PROMOCIONOFI
using a group by it goes

SORT GROUP BY
INDEX RANGE SCAN PR_PROMOCIONOFI_PK

tricky!