Article viewed by category report throws Query Size limitation error

Summary

Article viewed by category report throws Query Size limitation error

Content

We have a report to show Articles viewed by category, this report shows sum of Number of Page Hits (sum(ans_stats.hits)/count(distinct categories.id)) for articles. This report was working fine previously but throws query size limitation error now. I understand this is because size of data was less previously and now the report query is not able to run because of query size limitation.

I have tried the following options but no success till now...

Restructured the table links between okcs_answers,ans_stats,removing Categories and okcs_content_category  table from the query