时间:2019-11-05 14:33:19
SELECT
a.id,
a.school_id,
a.branch_id,
a.branch_class_no,
GROUP_CONCAT( DISTINCT a.id ) AS class_ids,注意这里
b.id frist_lesson_id,
b.classin_file_id,
b.start_time
FROM
wjy_school_class a
RIGHT JOIN (select * from wjy_school_class_lesson where start_time > 1550160000 AND start_time < 1561910400 AND `status` = 3 and classin_file_name like "%NCE1%" ORDER BY start_time asc ) b ON a.id = b.class_id
WHERE
a.branch_class_no <> ''
AND a.school_id = 54
GROUP BY
a.school_id,
a.branch_id,
a.branch_class_no
一脸蒙逼。。。