il problema era questo:

codice:
ORDER BY cnt_counter DESC
-->
ORDER BY sum_cnt DESC