Query failed: Unknown column 'undefined' in 'where clause'
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 LEFT JOIN players p ON p.id = es.player_id LEFT JOIN `event` e on es.event_id = e.id LEFT JOIN mage_player_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 `mage_player_schools` c on c.id = pc.school_id WHERE es.visible = 1 AND es.value1 != 0.0000 AND stat_id=6 AND es.event_id IN (undefined) ORDER BY es.value1 DESC