SELECT
Anderson, d,
Amy polumbo roimg,
Amy polumbo rojectname,
A. d. atecreated AS the date,
A.s tudyCount AS courseCount,
(SELECT count (1) the FROM b WHERE p. roid=Anderson, d) AS materialCount
FROM a
LEFT the JOIN c ON c.i d=Amy polumbo rojectsource
WHERE 1=1
AND Anderson, d NOT IN (' uuceacgkqjlcg5rdlg7zla ', 'uz6eacgkzpnizkuk - ysalw', 'vsqcacgkpzposa5myqrmxg')
The ORDER BY
StudyCount DESC,
MaterialCount DESC,
The DATE the ASC

CodePudding user response:

With text posted ( don't map!
) the explain the select...
And
show index from

For analysis