SELECT query FROM sql WHERE size = ‘BIG’
This is a big query.
SELECT CONCAT(students.firstname, students.lastname) AS name, students.grade, students.id, CONVERT(GROUP_CONCAT(DISTINCT classes.name ORDER BY classes.type) USING latin1) as classnames, CONVERT(GROUP_CONCAT(DISTINCT classes.id ORDER BY classes.type) USING latin1) as ids
FROM students, classes
WHERE (students.grade = classes.grade OR classes.type = 'ele')
AND (CASE WHEN students.spec_mat IS NULL THEN TRUE ELSE (CASE WHEN classes.type = 'mat' THEN students.spec_mat = classes.id ELSE TRUE END) END)
AND (CASE WHEN students.spec_sci IS NULL THEN TRUE ELSE (CASE WHEN classes.type = 'sci' THEN students.spec_sci = classes.id ELSE TRUE END) END)
AND (CASE WHEN ((students.spec_ele IS NULL) AND (students.spec_ele2 IS NULL)) THEN classes.type != 'ele' ELSE (CASE WHEN classes.type = 'ele' THEN (classes.id IN (students.spec_ele, students.spec_ele2)) ELSE TRUE END) END)
AND (CASE WHEN students.spec_lang IS NULL THEN classes.type != 'lang' ELSE (CASE WHEN classes.type = 'lang' THEN students.spec_lang = classes.id ELSE TRUE END) END)
AND (SELECT grades.id FROM grades WHERE grades.student = students.id AND grades.class = classes.id LIMIT 1) IS NULL
GROUP BY name
ORDER BY students.grade, students.lastname, students.firstname
‘Nuff said. It is, however, worth several hundred dollars when combined with the other code I wrote. Cool.
Wowzas kid, what are you working on?
Uck… thats one huge query.
And a hard one.
It’s a grade tracker thing for my old high school, Orange boy.
Amazingly… I can understand that.