• 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) 5 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 20201
2SELECT `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
3SELECT `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
4SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (60) 22221
5SELECT `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) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)