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 '),4) AND ((b.POSITION_ID = 2) OR (e.POSITION_ID = 2)) AND (b.START_DT <= c.END_D' at line 1
SELECT a.RANKER_ID as rankerid, MAX(UPDATE_DATE) as LastUpdate, MIN(UPDATE_DATE) as FirstUpdate FROM rankings a INNER JOIN rankings_rankers d ON d.RANKER_ID = a.RANKER_ID INNER JOIN player_position_term b ON a.PLAYER_ID = b.PLAYER_ID LEFT JOIN player_position_group ON b.POSITION_ID = player_position_group.POSITION_ID LEFT JOIN player_position e ON player_position_group.PARENT_POSITION_ID = e.POSITION_ID INNER JOIN stats_schedule_segment c ON a.SEGMENT_ID = c.SEGMENT_ID WHERE a.RANK IS NOT NULL AND (a.SEGMENT_ID = 1) AND a.RANKER_TYPE IN(),4) AND ((b.POSITION_ID = 2) OR (e.POSITION_ID = 2)) AND (b.START_DT <= c.END_DT) AND ((b.END_DT >= c.END_DT) OR (b.END_DT Is Null)) GROUP BY a.RANKER_ID ORDER BY d.ZORDER ASC
