rendered paste body<IXLSNACK NAME="sql_call"> <PARAM NAME="QUERY"> SELECT pr.player_id, pr.period, decode(pg.home, 0, '@')||substr(tm2.name,0, length(tm2.name)-4) AS opp_name, NVL (pr.sw_points, 0) swp, (case when nvl(pr.points_for, 0) > nvl(pr.points_vs,0) then 'W ' else 'L ' end) ||nvl(pr.points_for,0)||' - '||nvl(pr.points_vs,0) as result FROM player_results pr, (SELECT NAME, player_id, position_id FROM player_research WHERE timeframe_id = 1) tm, (SELECT NAME, player_id, position_id FROM player_research WHERE timeframe_id = 1) tm2, cfoot_stat.player_game pg WHERE pr.player_id = :var1 AND pr.player_id = tm.player_id AND pr.opp_team_id = tm2.player_id AND pr.position_id = 1 AND tm.position_id = pr.position_id AND tm2.position_id = pr.position_id AND pr.player_id = pg.player_id AND pr.period = pg.period AND pr.period < current_pick_period () ORDER BY period ASC </PARAM> <PARAM NAME="BIND_VAR_1">player_id</PARAM> <PARAM NAME="ALTERNATING_ROWS">1</PARAM> <PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM> <PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM> <PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM> <PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM> <PARAM NAME="FIELD_1_SUFFIX"> <td>&FIELD_2&</td> <td>&FIELD_3&</td> <td>&FIELD_5&</td> <td>&FIELD_4&</td> </PARAM> <PARAM NAME="FIELD_2_INV"></PARAM> <PARAM NAME="FIELD_3_INV"></PARAM> <PARAM NAME="FIELD_4_INV"></PARAM> <PARAM NAME="FIELD_5_INV"></PARAM> <PARAM NAME="MISSING"></PARAM> </IXLSNACK>