Tournaments

Datum: 1 January 1970, -
Plaatsen vrij: 0 van de
$tournament not set! Aborting!
(default) 132 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `tournaments`10101
2DESCRIBE `team_types`220
3DESCRIBE `teams`550
4DESCRIBE `tournament_members`440
5DESCRIBE `users`23231
6DESCRIBE `groups`220
7DESCRIBE `medals`440
8DESCRIBE `medal_types`330
9DESCRIBE `tournament_results`770
10DESCRIBE `titles`550
11SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id`, `TeamType`.`id`, `TeamType`.`title` FROM `tournaments` AS `Tournament` LEFT JOIN `team_types` AS `TeamType` ON (`Tournament`.`team_type_id` = `TeamType`.`id`) WHERE `Tournament`.`id` = 31 AND `Tournament`.`date` >= '2010-03-10' ORDER BY `Tournament`.`date` ASC LIMIT 1000
12DESCRIBE `configs`222
13SELECT `Config`.`key`, `Config`.`value` FROM `configs` AS `Config` WHERE `Config`.`key` = 'title' LIMIT 1110
14DESCRIBE `news`881
15SELECT `News`.`id`, `News`.`title`, `News`.`summary`, `News`.`body`, `News`.`date`, `News`.`image_front`, `News`.`topic_id`, `News`.`position` FROM `news` AS `News` WHERE 1 = 1 ORDER BY `date` DESC LIMIT 1010100
16SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id`, `TeamType`.`id`, `TeamType`.`title` FROM `tournaments` AS `Tournament` LEFT JOIN `team_types` AS `TeamType` ON (`Tournament`.`team_type_id` = `TeamType`.`id`) WHERE `Tournament`.`date` >= '2010-03-10' ORDER BY `Tournament`.`date` ASC 660
17SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 1 110
18SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (1) ORDER BY `Team`.`position` DESC 18180
19SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (1) 440
20SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 8 110
21SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (8) ORDER BY `Team`.`position` DESC 16160
22SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (8) 330
23SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 5 110
24SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (5) ORDER BY `Team`.`position` DESC 29290
25SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (5) 550
26SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 3 110
27SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (3) ORDER BY `Team`.`position` DESC 52520
28SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (3) 770
29SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 4 110
30SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (4) ORDER BY `Team`.`position` DESC 24240
31SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (4) 770
32SELECT `TeamType`.`id`, `TeamType`.`title` FROM `team_types` AS `TeamType` WHERE `TeamType`.`id` = 3 110
33SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`team_type_id` = (3) ORDER BY `Team`.`position` DESC 52520
34SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`team_type_id` = (3) 770
35SELECT `TournamentMember`.`id`, `TournamentMember`.`tournament_id`, `TournamentMember`.`user_id`, `TournamentMember`.`team_id` FROM `tournament_members` AS `TournamentMember` WHERE `TournamentMember`.`tournament_id` IN (32, 36, 35, 33, 37, 38) 30300
36SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 21 110
37SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 15 110
38SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 14 110
39SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 2 110
40SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 20 110
41SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 153 110
42SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 223 110
43SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 19 110
44SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 94 110
45SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 105 110
46SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 226 110
47SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 227 110
48SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 161 110
49SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 1 110
50SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 1 110
51SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 170 110
52SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 352 110
53SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 163 110
54SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 2 110
55SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 225 110
56SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 356 110
57SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 20 110
58SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 16 110
59SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 133 110
60SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 21 110
61SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 151 110
62SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 85 110
63SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 21 110
64SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 306 110
65SELECT `Team`.`id`, `Team`.`title`, `Team`.`logo`, `Team`.`team_type_id`, `Team`.`position` FROM `teams` AS `Team` WHERE `Team`.`id` = 73 110
66SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
67SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
68SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 22 110
69SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 22 110
70SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 10 110
71SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 10 110
72SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
73SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 13 110
74SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
75SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 13 110
76SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
77SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 13 110
78SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
79SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 149 110
80SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 106 110
81SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 13 111
82SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
83SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 117 110
84SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 49 110
85SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 49 110
86SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 49 110
87SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 49 110
88SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 7 110
89SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 49 110
90SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 13 110
91SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 39 110
92SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
93SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
94SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
95SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address` FROM `users` AS `User` WHERE `User`.`id` = 94 110
96SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
97SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
98SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
99SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
100SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
101SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
102SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 36 110
103SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
104SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 35 110
105SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 35 110
106SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 36 110
107SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 36 110
108SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
109SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
110SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
111SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 111
112SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 37 110
113SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
114SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
115SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 36 110
116SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 35 110
117SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
118SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 38 110
119SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 37 110
120SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 38 110
121SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 32 110
122SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 35 110
123SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 33 110
124SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 37 110
125SELECT `Tournament`.`id`, `Tournament`.`title`, `Tournament`.`summary`, `Tournament`.`body`, `Tournament`.`date`, `Tournament`.`start_time`, `Tournament`.`end_time`, `Tournament`.`max_players`, `Tournament`.`image`, `Tournament`.`team_type_id` FROM `tournaments` AS `Tournament` WHERE `Tournament`.`id` = 38 110
126DESCRIBE `reviews`771
127SELECT DISTINCT `Review`.`year` FROM `reviews` AS `Review` WHERE 1 = 1 ORDER BY `Review`.`year` ASC 335
128DESCRIBE `pages`551
129SELECT `User`.`id`, `User`.`username`, `User`.`real_name`, `User`.`password`, `User`.`email`, `User`.`address`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`mobile`, `User`.`group_id`, `User`.`phpbb_user_id`, `User`.`favo_club`, `User`.`favo_player`, `User`.`favo_country`, `User`.`favo_tournament`, `User`.`favo_competition`, `User`.`best_player`, `User`.`best_proevogame`, `User`.`target`, `User`.`date_registered`, `User`.`score_points`, `User`.`ip_address`, `Group`.`id`, `Group`.`name` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE 1 = 1 ORDER BY `User`.`score_points` DESC, `User`.`username` ASC LIMIT 2020200
130SELECT `Medal`.`id`, `Medal`.`user_id`, `Medal`.`medal_type_id`, `Medal`.`year` FROM `medals` AS `Medal` WHERE `Medal`.`user_id` IN (7, 22, 119, 49, 143, 117, 149, 10, 94, 349, 39, 320, 291, 302, 108, 241, 61, 60, 150, 324) 66660
131SELECT `TournamentResult`.`id`, `TournamentResult`.`user_id`, `TournamentResult`.`year`, `TournamentResult`.`win`, `TournamentResult`.`draw`, `TournamentResult`.`lose`, `TournamentResult`.`matches` FROM `tournament_results` AS `TournamentResult` WHERE `TournamentResult`.`user_id` IN (7, 22, 119, 49, 143, 117, 149, 10, 94, 349, 39, 320, 291, 302, 108, 241, 61, 60, 150, 324) 23230
132SELECT `Title`.`id`, `Title`.`user_id`, `Title`.`title`, `Title`.`logo`, `Title`.`special` FROM `titles` AS `Title` WHERE `Title`.`user_id` IN (7, 22, 119, 49, 143, 117, 149, 10, 94, 349, 39, 320, 291, 302, 108, 241, 61, 60, 150, 324) 29290