4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fezzanese
TEMPORADA 2023/2024
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Alcione Alcione 37 69 26 78
2 Chisola Calcio Chisola 37 59 36 69
3 RG Ticino RG Ticino 37 57 36 65
4 Città di Varese Città 37 48 32 65
5 Vado FC Vado FC 37 50 27 64
6 AS Bra AS Bra 37 45 30 62
7 Ligorna Ligorna 37 44 37 62
8 ASD Asti ASD Asti 37 42 31 59
9 Albenga Albenga 37 49 32 57
10 Fezzanese Fezzanese 37 41 45 51
11 Sanremese Sanremese 37 31 32 49
12 Lavagnese Lavagnese 37 45 45 44
13 Gozzano Gozzano 37 34 37 44
14 Derthona Derthona 37 34 52 40
15 Chieri Chieri 37 39 51 39
16 Voghera Voghera 37 40 56 39
17 Pinerolo Pinerolo 37 25 42 37
18 Alba Calcio Alba Calcio 37 37 63 34
19 PDHAE PDHAE 37 24 60 22
20 Borgosesia Borgosesia 37 24 67 19
TEMPORADA 2022/2023
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Sestri Levante Sestri 38 77 29 94
2 AS Bra AS Bra 38 59 31 74
3 Sanremese Sanremese 38 59 33 74
4 Vado FC Vado FC 38 61 40 69
5 Ligorna Ligorna 38 50 36 66
6 AC Legnano AC Legnano 38 53 35 60
7 ASD Asti ASD Asti 38 44 35 57
8 Gozzano Gozzano 38 51 48 55
9 Borgosesia Borgosesia 38 54 54 52
10 PDHAE PDHAE 38 33 43 47
11 Castellanzese Castellanzes 38 51 55 46
12 Chieri Chieri 38 41 45 45
13 Fezzanese Fezzanese 38 47 58 45
14 Chisola Calcio Chisola 38 43 53 43
15 Pinerolo Pinerolo 38 38 44 42
16 Derthona Derthona 38 55 62 42
17 Castanese Castanese 38 43 57 39
18 Stresa Stresa 38 37 47 34
19 Casale Casale 38 28 79 24
20 Fossano Calcio Fossano 38 40 80 14
TEMPORADA 2019/2020
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Lucchese Libertas Lucchese 25 32 19 48
2 Prato Prato 25 47 26 47
3 Seravezza Seravezza 25 46 33 43
4 Casale Casale 25 40 28 43
5 Caronnese Caronnese 24 45 29 42
6 Savona Savona 25 33 31 36
7 Real Forte Querceta Real Forte. 25 29 27 36
8 Borgosesia Borgosesia 25 34 31 35
9 Sanremese Sanremese 25 30 27 33
10 Chieri Chieri 25 30 31 33
11 Fossano Calcio Fossano 25 38 38 32
12 Lavagnese Lavagnese 25 25 31 27
13 AS Bra AS Bra 25 32 34 26
14 Ghivizzano Borgo Ghivizzano 25 35 47 26
15 Fezzanese Fezzanese 25 26 39 26
16 Vado FC Vado FC 25 30 43 24
17 Verbania Verbania 24 19 42 23
18 Ligorna Ligorna 25 31 46 22
TEMPORADA 2018/2019
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Lecco Lecco 34 75 23 86
2 Sanremese Sanremese 34 49 35 59
3 Savona Savona 34 49 33 55
4 Inveruno Inveruno 34 59 45 54
5 Folgore Caratese Folgore 34 55 39 54
6 Casale Casale 34 40 28 54
7 Ligorna Ligorna 34 49 40 54
8 AS Bra AS Bra 34 47 45 48
9 Chieri Chieri 34 53 45 45
10 Lavagnese Lavagnese 34 47 47 42
11 Borgosesia Borgosesia 34 43 50 41
12 Fezzanese Fezzanese 34 40 49 41
13 Bustese Milano City FC Bustese 34 36 51 40
14 Sestri Levante Sestri 34 36 50 38
15 Arconatese Arconatese 34 37 47 36
16 Pro Dronero Pro Dronero 34 37 66 29
17 Stresa Stresa 34 26 49 26
18 Borgaro Nobis Borgaro 34 27 63 26
TEMPORADA 2016/2017
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Follonica Gavorrano Follonica 34 64 36 70
2 Massese Massese 34 59 37 64
3 Savona Savona 34 58 31 62
4 Lavagnese Lavagnese 34 58 40 61
5 FBC Finale 1908 Finale 1908 34 51 46 51
6 Sanremese Sanremese 34 50 34 50
7 Argentina SSD Argentina 34 42 35 48
8 Ponsacco Ponsacco 34 46 45 48
9 Real Forte Querceta Real Forte. 34 52 41 47
10 Ligorna Ligorna 34 54 56 46
11 Valdinievole Montecatini Valdinievole 34 40 44 46
12 Sestri Levante Sestri 34 46 45 42
13 Jolly Montemurlo Jolly 34 34 35 41
14 Fezzanese Fezzanese 34 40 52 39
15 Viareggio Viareggio 34 43 59 38
16 Ghivizzano Borgo Ghivizzano 34 43 53 34
17 Sporting Recco Sporting 34 36 64 27
18 Grosseto Grosseto 34 27 90 16
TEMPORADA 2015/2016
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Bellinzago Bellinzago 38 74 31 86
2 Caronnese Caronnese 38 74 23 82
3 Lavagnese Lavagnese 38 66 30 74
4 Chieri Chieri 38 74 41 72
5 Argentina SSD Argentina 38 48 25 66
6 Sestri Levante Sestri 38 41 23 62
7 Gozzano Gozzano 38 64 38 61
8 Pinerolo Pinerolo 38 50 47 61
9 Rapallo Boglia.. Rapallo 38 51 40 57
10 Voghera Voghera 38 53 44 53
11 Derthona Derthona 38 52 48 52
12 AS Bra AS Bra 38 53 55 51
13 Borgosesia Borgosesia 38 40 46 47
14 ASD Pro Settimo Settimo 38 35 45 43
15 Vado FC Vado FC 38 43 61 40
16 Ligorna Ligorna 38 45 73 40
17 Fezzanese Fezzanese 38 38 74 34
18 Acqui Acqui 38 30 70 28
19 Castellazzo Castellazzo 38 29 73 22
20 Novese Novese 38 26 99 19

  USO DE MEMORIA  
5,854,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1055
Total Execution Time  0.1074
  CADENA URL  
/historico/Fezzanese
  GET DATOS  
$_GET['/historico/Fezzanese']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0031  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fezzanese' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=66502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=66502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=66502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66502 AND type_rel = 2
0.0030  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '66502' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '66502' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0035  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '66502' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=66502 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0055  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73979,73559) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73979 AND teamId = 66502
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 66502
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '66502' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66502' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '66502' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 66502 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 66502 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 66502 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 66502 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73979 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68747 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51156 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44796 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33453 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15649 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC