SELECT classdata.name1, classdata.name2, MAX(class.year * 10 + (class.term - 1) * 5) FROM classdata, class WHERE classdata.id = class.classdata_id AND class.year = 2011 AND class.term = 1 GROUP BY class.classdata_id
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