I'm having an issue with a view, when I make a query it brings CPU to 100% and it keeps loading.
The view is:
channel_data_60 table contains about 1,200,000 records:
and this is the source table:
and a screenshot of the EXPLAIN:
I read around and it seems UNION makes this kind of issues but I made a test without it and the query keeps loading forever.
Any help? Is the EXPLAIN result showing something useful?