Team NORDIC-eSport.CSS


Team info                        

NameNORDIC-eSport.CSS
Type5on5 Counter Strike: Source (non-BYOC)
TagNE.Pentia
PincodeAsk the manager or teamleader for it, if you want to join the team.
Websitewww.NORDIC-eSport.com


Team members

  • Casper 'Acker' Ackermann (Player)
  • Christian 'moen' Moen (Player)
  • Halvor 'vENdetta' Gulestøl (TeamLeader)
  • Johannes 'mythi' Sandberg (Player)
  • Magnus 'rod' Wennemo (Player)
  • Ole Andre 'Immz' Muhle (Player)

Your account

       Forgot pass?
.
(default) 18 queries took 18 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `teams`881
5DESCRIBE `teamtypes`441
6DESCRIBE `users`26262
7DESCRIBE `roles`551
8DESCRIBE `countries`331
9DESCRIBE `teams_users`661
10DESCRIBE `events`661
11DESCRIBE `news`991
12DESCRIBE `categories`221
13DESCRIBE `events_teams`661
14DESCRIBE `ip2nations`331
15SELECT `Team`.`id`, `Team`.`name`, `Team`.`tag`, `Team`.`teamtype_id`, `Team`.`website`, `Team`.`pincode`, `Team`.`updated`, `Team`.`created`, `Teamtype`.`id`, `Teamtype`.`name`, `Teamtype`.`updated`, `Teamtype`.`created` FROM `teams` AS `Team` LEFT JOIN `teamtypes` AS `Teamtype` ON (`Team`.`teamtype_id` = `Teamtype`.`id`) WHERE `Team`.`id` = 92 ORDER BY `Team`.`teamtype_id` ASC, `Team`.`name` ASC LIMIT 1111
16SELECT `User`.`id`, `User`.`role_id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`steamid`, `User`.`guid`, `User`.`bnetid`, `User`.`bnetcharcode`, `User`.`ip`, `User`.`firstname`, `User`.`lastname`, `User`.`age`, `User`.`address`, `User`.`zip`, `User`.`city`, `User`.`country_id`, `User`.`phone`, `User`.`website`, `User`.`activation_key`, `User`.`image`, `User`.`bio`, `User`.`timezone`, `User`.`status`, `User`.`updated`, `User`.`created`, `TeamsUser`.`id`, `TeamsUser`.`team_id`, `TeamsUser`.`user_id`, `TeamsUser`.`usertype`, `TeamsUser`.`updated`, `TeamsUser`.`created` FROM `users` AS `User` JOIN `teams_users` AS `TeamsUser` ON (`TeamsUser`.`team_id` = 92 AND `TeamsUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY firstname ASC 662
17SELECT `Event`.`id`, `Event`.`name`, `Event`.`starting`, `Event`.`ending`, `Event`.`updated`, `Event`.`created`, `EventsTeam`.`id`, `EventsTeam`.`event_id`, `EventsTeam`.`team_id`, `EventsTeam`.`paid`, `EventsTeam`.`updated`, `EventsTeam`.`created` FROM `events` AS `Event` JOIN `events_teams` AS `EventsTeam` ON (`EventsTeam`.`team_id` = 92 AND `EventsTeam`.`event_id` = `Event`.`id`) WHERE 1 = 1 110
18SELECT `Teamtype`.`id`, `Teamtype`.`name` FROM `teamtypes` AS `Teamtype` WHERE 1 = 1 15150