• Juniores Regionale

• Giocatori
Andrea Accardo
Luca Bellu
Alessio Beneventi
Filippo Canu
Francesco Demurtas
Nicola Fele
Alberto Furiolu
Federico Guerra
Alessandro Magliona
Gabriele Pasqua
Gabriele Pignalosa
Fabrizio Pintori
Gabriele Pischedda
Samuele Poddighe
Federico Ruiu
Alessio Sechi
Mattia Serra
Alessio Serra
Giuseppe Uda
Alessandro Uras
• Allenatori
Gerolamo Masala
Gian Mario Marteddu
• Link utili
(default) 9 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `teams`992
2DESCRIBE `players`11112
3DESCRIBE `mister_roles`443
4DESCRIBE `misters`882
5SELECT `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` = 43 AND `ruolo` != 'Allenatore' ORDER BY `cognome` ASC 20201
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` = 43 AND `ruolo` = 'Allenatore' ORDER BY `Player`.`id` ASC 221
7SELECT `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` = 43 ORDER BY `Team`.`order` ASC LIMIT 1110
8SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (43) 22220
9SELECT `MisterRole`.`id`, `MisterRole`.`mister_id`, `MisterRole`.`team_id`, `MisterRole`.`role` FROM `mister_roles` AS `MisterRole` WHERE `MisterRole`.`team_id` = (43) ORDER BY `MisterRole`.`role` ASC 220
(phpbb3) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)