rendered paste body<IXLSNACK NAME="insert_file"><PARAM NAME="PATH">/football/fullseason/ultimate/splitters/top_page.txt</PARAM></IXLSNACK>
<p class="line"> </p>
<div id="headerSection">
<span class="pageTitle">Top Performers</span>
<p class="dottedLine"> </p>
Top players for the week and season.
<br /><br />
<span class="b">More Resources</span><br />
» <a href="player_bargains.html">Top Bargains</a>
</div>
<br />
<p class="line"> </p>
<div class="left">
<h3>Top Players - Season</h3>
<table class="infotable w50">
<tr>
<th class="tright">Rk</td>
<th class="tleft">Player</th>
<th class="tleft">Team</th>
<th class="tright">Price</th>
<th class="tright">TSNP</th>
</tr>
<IXLSNACK NAME="sql_call">
<PARAM NAME="QUERY">
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
</PARAM>
<PARAM NAME="MAX_ROWS">25</PARAM>
<PARAM NAME="FIELD_2_INV"></PARAM>
<PARAM NAME="FIELD_4_INV"></PARAM>
<PARAM NAME="FIELD_7_INV"></PARAM>
<PARAM NAME="FIELD_9_INV"></PARAM>
<PARAM NAME="FIELD_10_INV"></PARAM>
<PARAM NAME="ALTERNATING_ROWS"></PARAM>
<PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM>
<PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM>
<PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM>
<PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM>
<PARAM NAME="FIELD_1_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_1_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_3_PREFIX"><td class="tright"><a href="player.html?player_id=&FIELD_2&"></PARAM>
<PARAM NAME="FIELD_3_SUFFIX"></a> (&FIELD_10&)</td></PARAM>
<PARAM NAME="FIELD_5_PREFIX"><td class="tright"><a href="team_page.html?team_id=&FIELD_4&"></PARAM>
<PARAM NAME="FIELD_5_SUFFIX"></a></td></PARAM>
<PARAM NAME="FIELD_6_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_6_IF">1</PARAM>
<PARAM NAME="FIELD_6_THEN"><i>&FIELD_7&</i></PARAM>
<PARAM NAME="FIELD_6_ELSE"><a href="xact_buy.html?add_player_id=&FIELD_2&" class="altlink" onClick="if(!confirm('Are you sure you want to buy &FIELD_9& for &FIELD_7&?')) return false;">&FIELD_7&</a></PARAM>
<PARAM NAME="FIELD_6_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_8_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_8_SUFFIX"></td></PARAM>
<PARAM NAME="MISSING"><td colspan="5">Top Players will be available when the season begins.</td></PARAM>
</IXLSNACK>
</td>
</tr>
</table>
<br />
<h3>Top Players - Last 2 Weeks</h3>
<table class="infotable w50">
<tr>
<th class="tright">Rk</td>
<th class="tleft">Player</th>
<th class="tleft">Team</th>
<th class="tright">Price</th>
<th class="tright">TSNP</th>
</tr>
<IXLSNACK NAME="sql_call">
<PARAM NAME="QUERY">
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
</PARAM>
<PARAM NAME="MAX_ROWS">25</PARAM>
<PARAM NAME="FIELD_2_INV"></PARAM>
<PARAM NAME="FIELD_4_INV"></PARAM>
<PARAM NAME="FIELD_7_INV"></PARAM>
<PARAM NAME="FIELD_9_INV"></PARAM>
<PARAM NAME="FIELD_10_INV"></PARAM>
<PARAM NAME="ALTERNATING_ROWS"></PARAM>
<PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM>
<PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM>
<PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM>
<PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM>
<PARAM NAME="FIELD_1_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_1_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_3_PREFIX"><td class="tright"><a href="player.html?player_id=&FIELD_2&"></PARAM>
<PARAM NAME="FIELD_3_SUFFIX"></a> (&FIELD_10&)</td></PARAM>
<PARAM NAME="FIELD_5_PREFIX"><td class="tright"><a href="team_page.html?team_id=&FIELD_4&"></PARAM>
<PARAM NAME="FIELD_5_SUFFIX"></a></td></PARAM>
<PARAM NAME="FIELD_6_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_6_IF">1</PARAM>
<PARAM NAME="FIELD_6_THEN"><i>&FIELD_7&</i></PARAM>
<PARAM NAME="FIELD_6_ELSE"><a href="xact_buy.html?add_player_id=&FIELD_2&" class="altlink" onClick="if(!confirm('Are you sure you want to buy &FIELD_9& for &FIELD_7&?')) return false;">&FIELD_7&</a></PARAM>
<PARAM NAME="FIELD_6_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_8_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_8_SUFFIX"></td></PARAM>
<PARAM NAME="MISSING"><td colspan="5">Top Players will be available when the season begins.</td></PARAM>
</IXLSNACK>
</td></tr></table>
</div>
<div class="right">
<h3>Top Players - Last Week</h3>
<table class="infotable w50">
<tr>
<th class="tright">Rk</td>
<th class="tleft">Player</th>
<th class="tleft">Team</th>
<th class="tright">Price</th>
<th class="tright">TSNP</th>
</tr>
<IXLSNACK NAME="sql_call">
<PARAM NAME="QUERY">
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
</PARAM>
<PARAM NAME="MAX_ROWS">25</PARAM>
<PARAM NAME="FIELD_2_INV"></PARAM>
<PARAM NAME="FIELD_4_INV"></PARAM>
<PARAM NAME="FIELD_7_INV"></PARAM>
<PARAM NAME="FIELD_9_INV"></PARAM>
<PARAM NAME="FIELD_10_INV"></PARAM>
<PARAM NAME="ALTERNATING_ROWS"></PARAM>
<PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM>
<PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM>
<PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM>
<PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM>
<PARAM NAME="FIELD_1_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_1_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_3_PREFIX"><td><a href="player.html?player_id=&FIELD_2&"></PARAM>
<PARAM NAME="FIELD_3_SUFFIX"></a> (&FIELD_10&)</td></PARAM>
<PARAM NAME="FIELD_5_PREFIX"><td><a href="team_page.html?team_id=&FIELD_4&"></PARAM>
<PARAM NAME="FIELD_5_SUFFIX"></a></td></PARAM>
<PARAM NAME="FIELD_6_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_6_IF">1</PARAM>
<PARAM NAME="FIELD_6_THEN"><i>&FIELD_7&</i></PARAM>
<PARAM NAME="FIELD_6_ELSE"><a href="xact_buy.html?add_player_id=&FIELD_2&" class="altlink" onClick="if(!confirm('Are you sure you want to buy &FIELD_9& for &FIELD_7&?')) return false;">&FIELD_7&</a></PARAM>
<PARAM NAME="FIELD_6_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_8_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_8_SUFFIX"></td></PARAM>
<PARAM NAME="MISSING"><td colspan="5">Top Players will be available when the season begins.</td></PARAM>
</IXLSNACK>
</td>
</tr>
</table>
<h3>Top Players - Last 4 Weeks</h3>
<table class="infotable w50">
<tr>
<th class="tright">Rk</td>
<th class="tleft">Player</th>
<th class="tleft">Team</th>
<th class="tright">Price</th>
<th class="tright">TSNP</th>
</tr>
<IXLSNACK NAME="sql_call">
<PARAM NAME="QUERY">
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
</PARAM>
<PARAM NAME="MAX_ROWS">25</PARAM>
<PARAM NAME="FIELD_2_INV"></PARAM>
<PARAM NAME="FIELD_4_INV"></PARAM>
<PARAM NAME="FIELD_7_INV"></PARAM>
<PARAM NAME="FIELD_9_INV"></PARAM>
<PARAM NAME="FIELD_10_INV"></PARAM>
<PARAM NAME="ALTERNATING_ROWS"></PARAM>
<PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM>
<PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM>
<PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM>
<PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM>
<PARAM NAME="FIELD_1_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_1_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_3_PREFIX"><td><a href="player.html?player_id=&FIELD_2&"></PARAM>
<PARAM NAME="FIELD_3_SUFFIX"></a> (&FIELD_10&)</td></PARAM>
<PARAM NAME="FIELD_5_PREFIX"><td><a href="team_page.html?team_id=&FIELD_4&"></PARAM>
<PARAM NAME="FIELD_5_SUFFIX"></a></td></PARAM>
<PARAM NAME="FIELD_6_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_6_IF">1</PARAM>
<PARAM NAME="FIELD_6_THEN"><i>&FIELD_7&</i></PARAM>
<PARAM NAME="FIELD_6_ELSE"><a href="xact_buy.html?add_player_id=&FIELD_2&" class="altlink" onClick="if(!confirm('Are you sure you want to buy &FIELD_9& for &FIELD_7&?')) return false;">&FIELD_7&</a></PARAM>
<PARAM NAME="FIELD_6_SUFFIX"></td></PARAM>
<PARAM NAME="FIELD_8_PREFIX"><td class="tright"></PARAM>
<PARAM NAME="FIELD_8_SUFFIX"></td></PARAM>
<PARAM NAME="MISSING"><tr><td colspan="5">Top Players will be available when the season begins.</td></tr></PARAM>
</IXLSNACK>
</td>
</tr>
</table>
</div>
<br style="clear:both;" />
<IXLSNACK NAME="insert_file"><PARAM NAME="PATH">/football/fullseason/ultimate/splitters/bottom_page.txt</PARAM></IXLSNACK>