Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '15604) ORDER BY es.value1 DESC' at line 8
SELECT es.*, p.profile_url, p.fname, p.lname, p.high_school, p.class, p.pri_position, p.hs_st, ps.name as college_school_name, p.school_id as school_id, pc.school_id as college_school_id, c.name as college_school_name2 FROM player_event_stats es INNER JOIN players p ON p.id = es.player_id INNER JOIN `event` e on es.event_id = e.id LEFT JOIN schools ps on ps.id = p.school_id AND (p.current_commitment_date < e.start_date OR p.`current_commitment_date` IS NULL) AND e.`juco_event` = 1 LEFT JOIN `player_commitment` pc on es.player_id = pc.player_id AND pc.commitment_date < e.start_date AND e.`juco_event` = 1 LEFT JOIN `schools` c on c.id = pc.school_id WHERE es.visible = 1 AND es.value1 != 0.0000 AND stat_id=78 AND es.event_id IN (15604) ORDER BY es.value1 DESC