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 player_id 1 &FIELD_2& &FIELD_3& &FIELD_5& &FIELD_4&