• 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) 10 queries took 32 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `teams`995
2DESCRIBE `players`11116
3DESCRIBE `mister_roles`445
4DESCRIBE `misters`884
5DESCRIBE `sponsors`444
6SELECT `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 20202
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 `Player`.`id` ASC 221
8SELECT `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
9SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (60) 22221
10SELECT `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 223
(phpbb3) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)