历史最长的SQL语句
时间：2021-07-01 10:21:17
帮助过：2人阅读
ml.`name`
as lessonName,ml.category,ml.deleted,ml.teacherName,
ml.id,ml.liveId,ml.selected,mlc.channelId,p.viewNums,count(
*)
as totalNum
from mlk_live_channel
AS ml
LEFT JOIN mlk_lesson_channel
AS mlc
ON mlc.lessonId
= ml.id
LEFT JOIN mlk_live_channel
AS mcl
ON mcl.id
= mlc.channelId
LEFT JOIN
(SELECT mpr.liveId,mpr.memberId,
COUNT(mpr.liveId)
as viewNums
FROM mlk_payment_record
AS mpr
WHERE mpr.payType
= 3 AND mpr.notify
= 1 GROUP BY mpr.liveId)
AS p
ON p.liveId
= mcl.liveId
WHERE ml.deleted
= 0 AND ml.category
= 1
GROUP BY ml.id
ORDER BY ml.create_time
历史最长的SQL语句
标签：
