SELECT
a.id,
a.proimg,
a.projectname,
a.datecreated AS date,
a.studyCount AS courseCount,
(SELECT count(1) FROM b WHERE b.proid= a.id) AS materialCount
FROM a
LEFT JOIN c ON c.id = a.projectsource
WHERE 1 = 1
AND a.id NOT IN ('uuceacgkqjlcg5rdlg7zla','uz6eacgkzpnizkuk-ysalw','vsqcacgkpzposa5myqrmxg')
ORDER BY
studyCount DESC,
materialCount DESC,
DATE ASC
uj5u.com熱心網友回復：
以文本方式貼出(不要貼圖!)explain select ....
及
show index from
以供分析
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/96625.html
標籤：MySQL
上一篇：求助：OLE IDispatch例外代碼0出自Excel無法設定種類Range的NumberFormatLocal屬性
下一篇：mysql中文為啥查不出來