Re: Help me to optimize my sql query

[Rick James]

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

Without knowing what the indexes are, I can't say what is happening.
However, filtering on one table, then ordering on another necessarily requires collecting stuff from both tables before being able to optimize much.

Mixing DISTINCT and GROUP BY is usually a mistake. What is the purpose of each?

Do you need "LEFT" JOIN? Will the 'right' table be missing rows? If not, use "JOIN".