Home / Fantasy Tools/ Forecasts / Dynasty Fantasy Football Rankings

Dynasty Fantasy Football Rankings

Please login to customize analysis according to your leagues.

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 '),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(a.PPR_UPDATE_DATE) as LastUpdate, MIN(a.PPR_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.PPR_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