The problem with the widget's sorting of top rated stuff is that the meta_value field is longtext. So, it doesn't properly sort numbers, specifically on the _kksr_casts field. My change is to cast those fields as UNSIGNED, in turn treating them as numbers and sorting properly.
kamalkhan
commented
7 years ago
The problem with the widget's sorting of top rated stuff is that the meta_value field is longtext. So, it doesn't properly sort numbers, specifically on the _kksr_casts field. My change is to cast those fields as UNSIGNED, in turn treating them as numbers and sorting properly.