Error Line #95
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY t.name_1 ORDER BY st.name ASC, sd.name ASC,' at line 6

SELECT st.type_id, st.name AS type_name, sd.division_id, sd.name AS division_name, n.name_id AS team_id, n.name AS team_name FROM name AS n LEFT JOIN sport_type AS st ON st.type_id = n.type LEFT JOIN sport_division AS sd ON sd.division_id = n.division LEFT JOIN ticket AS t ON t.name_1 = n.name_id WHERE n.category = '2' AND n.type IS NOT NULL AND n.division IS NOT NULL AND t.venue IN () GROUP BY t.name_1 ORDER BY st.name ASC, sd.name ASC, n.name ASC