子查询都是对本身结果的整理 请大神赐教
SELECT
nl.real_name,
nt.id,nt.user_id,nt.schedule_id,nt.level_id,nt.task_id,nt.task_begin_time,nt.task_end_time,nt.teacher_name,nt.task_name, (
SELECT
count(distinct nl.real_name)
FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
) Namenumber,
(select count(nt.id) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" ) taskNm,
(select count(nt.status) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" and nt.status=3 ) finishNm,
(select count(nt.status) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" and nt.status!=3 ) unfinishNm
FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
SELECT
nl.real_name,
nt.id,nt.user_id,nt.schedule_id,nt.level_id,nt.task_id,nt.task_begin_time,nt.task_end_time,nt.teacher_name,nt.task_name, (
SELECT
count(distinct nl.real_name)
FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
) Namenumber,
(select count(nt.id) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" ) taskNm,
(select count(nt.status) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" and nt.status=3 ) finishNm,
(select count(nt.status) FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04" and nt.status!=3 ) unfinishNm
FROM
ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE
ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
nt.id ,
nt.user_id ,
nt.schedule_id ,
nt.level_id ,
nt.task_id ,
nt.task_begin_time ,
nt.task_end_time ,
nt.teacher_name ,
nt.task_name ,
( SELECT COUNT(DISTINCT nl.real_name)
FROM ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
) Namenumber ,
( SELECT COUNT(nt.id)
FROM ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
) taskNm ,
( SELECT COUNT(nt.status)
FROM ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
AND nt.status = 3
) finishNm ,
( SELECT COUNT(nt.status)
FROM ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"
AND nt.status != 3
) unfinishNm
FROM ns_schedule_task nt
LEFT JOIN ns_user_login nl ON nt.user_id = nl.user_id
LEFT JOIN ns_user_student ns ON ns.user_id = nl.user_id
LEFT JOIN ns_schedule_level nsl ON nsl.id = nt.level_id
WHERE ns.teacher_id = 746
AND nsl.level_plan_date = "2016-07-04"