• Under 17 Regionali A1

• Giocatori
Ian Binkovski
Emanuele Bussu
Giuseppe Cagnoni
Mathias Dattena
Gianluca Deiola
Daniele Demurtas
Thomas Doro
Andrea Lurani
Francesco Manca
Marco Marras
Andrea Moi
Stefano Mureddu
Francesco Pazzola
Riccardo Pulina
Gabreile Rubattu
Alioune Badara Sylla
Guido Tolu
Federico Usai
Andrea Vettori
Pietro Virdis
• Allenatori
Augusto Cagnoni
Roberto Demartis
• Link utili
(default) 11 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `teams`993
2DESCRIBE `players`11112
3DESCRIBE `mister_roles`442
4DESCRIBE `misters`881
5DESCRIBE `menus`992
6DESCRIBE `sponsors`442
7SELECT `Player`.`id`, `Player`.`user_id`, `Player`.`team_id`, `Player`.`nome`, `Player`.`cognome`, `Player`.`ruolo`, `Player`.`nascita`, `Player`.`luogo`, `Player`.`imgpath`, `Player`.`url`, `Player`.`note`, `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `players` AS `Player` LEFT JOIN `teams` AS `Team` ON (`Player`.`team_id` = `Team`.`id`) WHERE `team_id` = 60 AND `ruolo` != 'Allenatore' ORDER BY `cognome` ASC 20204
8SELECT `Player`.`id`, `Player`.`user_id`, `Player`.`team_id`, `Player`.`nome`, `Player`.`cognome`, `Player`.`ruolo`, `Player`.`nascita`, `Player`.`luogo`, `Player`.`imgpath`, `Player`.`url`, `Player`.`note`, `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `players` AS `Player` LEFT JOIN `teams` AS `Team` ON (`Player`.`team_id` = `Team`.`id`) WHERE `team_id` = 60 AND `ruolo` = 'Allenatore' ORDER BY `Player`.`id` ASC 222
9SELECT `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `teams` AS `Team` WHERE `Team`.`id` = 60 ORDER BY `Team`.`order` ASC LIMIT 1111
10SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (60) 22221
11SELECT `MisterRole`.`id`, `MisterRole`.`mister_id`, `MisterRole`.`team_id`, `MisterRole`.`role` FROM `mister_roles` AS `MisterRole` WHERE `MisterRole`.`team_id` = (60) ORDER BY `MisterRole`.`role` ASC 220
(phpbb3) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `phpbb_users`76762