Top Players - Season

SELECT l.rank, l.user_id, p.name, p.team_id, p.team_name_short, p.frozen, TO_CHAR(p.price/1000000, '99.99') || 'M', l.value, p.full_name, p.pos_1_abbrev FROM leaders l, player_research p WHERE l.user_id = p.player_id AND l.query_id = 21 AND l.value > 0 AND p.timeframe_name = 'season' AND (p.team_old_id = 0 OR p.multiple_row = 0) ORDER BY l.rank ASC 25

Rk	Player	Team	Price	TSNP
	(&FIELD_10&)		1 &FIELD_7& &FIELD_7&		Top Players will be available when the season begins.

Top Players - Last 2 Weeks

SELECT l.rank, l.user_id, p.name, p.team_id, p.team_name_short, p.frozen, TO_CHAR(p.price/1000000, '99.99') || 'M', l.value, p.full_name, p.pos_1_abbrev FROM leaders l, player_research p WHERE l.user_id = p.player_id AND l.query_id = 23 AND l.value > 0 AND p.timeframe_name = 'season' AND (p.team_old_id = 0 OR p.multiple_row = 0) ORDER BY l.rank ASC 25

Rk	Player	Team	Price	TSNP
	(&FIELD_10&)		1 &FIELD_7& &FIELD_7&		Top Players will be available when the season begins.

Top Players - Last Week

SELECT l.rank, l.user_id, p.name, p.team_id, p.team_name_short, p.frozen, TO_CHAR(p.price/1000000, '99.99') || 'M', l.value, p.full_name, p.pos_1_abbrev FROM leaders l, player_research p WHERE l.user_id = p.player_id AND l.query_id = 22 AND l.value > 0 AND p.timeframe_name = 'season' AND (p.team_old_id = 0 OR p.multiple_row = 0) ORDER BY l.rank ASC 25

Rk	Player	Team	Price	TSNP
	(&FIELD_10&)		1 &FIELD_7& &FIELD_7&		Top Players will be available when the season begins.

Top Players - Last 4 Weeks

SELECT l.rank, l.user_id, p.name, p.team_id, p.team_name_short, p.frozen, TO_CHAR(p.price/1000000, '99.99') || 'M', l.value, p.full_name, p.pos_1_abbrev FROM leaders l, player_research p WHERE l.user_id = p.player_id AND l.query_id = 24 AND l.value > 0 AND p.timeframe_name = 'season' AND (p.team_old_id = 0 OR p.multiple_row = 0) ORDER BY l.rank ASC 25

Rk	Player	Team	Price	TSNP
	(&FIELD_10&)		1 &FIELD_7& &FIELD_7&
Top Players will be available when the season begins.