Article viewed by category report throws Query Size limitation error
SummaryArticle viewed by category report throws Query Size limitation error
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