Team Profile

SK Gaming  

Sweden
Founded: December 21st, 2009
Website:
http://www.sk-gaming.com
Tag: SK

Activity

Show:
5
|
15
|
25
|
ALL
Table 'winout_cs16stats.match_games' doesn't exist
SELECT *, UNIX_TIMESTAMP(match_timestamp) as wall_post_date, IF(match_team1_linkid=253,match_team2_linkid,match_team1_linkid) as foe_teamid, (SELECT team_name FROM wo_sub_teams WHERE team_id = foe_teamid) as foe_teamname, (SELECT team_name FROM wo_sub_teams WHERE team_id = match_team2_linkid) as team2name, (SELECT team_name FROM wo_sub_teams WHERE team_id = match_team1_linkid) as team1name, (SELECT team_country FROM wo_sub_teams WHERE team_id = match_team2_linkid) as team2country, (SELECT team_country FROM wo_sub_teams WHERE team_id = match_team1_linkid) as team1country, (SELECT team_logo FROM wo_sub_teams WHERE team_id = match_team2_linkid) as team2logo, (SELECT team_logo FROM wo_sub_teams WHERE team_id = match_team1_linkid) as team1logo FROM winout_cs16stats.match_games WHERE match_team1_linkid = '253' or match_team2_linkid = '253' ORDER BY match_timestamp DESC LIMIT 5