SQL怖い＞＜
SELECT sikepuri.*, teacher.name AS teacher_name, classdata.name1 AS classdata_name1, classdata.name2 AS classdata_name2, COUNT(DISTINCT teacher.id) AS teacher_count, COUNT(DISTINCT classdata.id) AS classdata_count FROM sikepuri_link LEFT JOIN teacher ON sikepuri_link.teacher_id = teacher.id, sikepuri, classdata WHERE sikepuri_link.sikepuri_id = sikepuri.id AND sikepuri_link.classdata_id = classdata.id AND classdata.id = :classdata_id
