New answers tagged


ORDER BY y0_ DESC does not make sense when you have GROUP BY this_.CELL , HOUR(this_.DATE). ORDER BY HOUR(this_.DATE) DESC makes more sense; change to that. I suspect the optimizer will then 'correctly' pick the CELL index. Another problem... It is not 'proper' to select several non-aggregate values but GROUP BY only a subset of them. Which NODE and ...

Top 50 recent answers are included