4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Troina
TEMPORADA 2021/2022
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Gelbison Gelbison 36 63 23 78
2 Cavese 1919 Cavese 1919 36 58 21 77
3 Acireale Acireale 36 58 31 69
4 Lamezia Terme Lamezia 36 58 35 69
5 Cittá Di Sant'Agata Cittá 36 47 31 60
6 Paternò Paternò 36 45 41 52
7 Cittanova Interpiana Cittanova 36 48 56 52
8 Santa Maria Cilento Santa Maria 36 58 50 51
9 Licata Licata 36 57 45 50
10 Real Agro Aversa Real Agro A. 36 36 34 49
11 Portici Portici 36 42 44 44
12 Trapani Trapani 36 44 47 41
13 San Luca San Luca 36 45 52 41
14 Sancataldese Sancataldese 36 34 60 40
15 Giarre Giarre 36 33 42 39
16 Castrovillari Castrovillar 36 39 48 38
17 Rende Rende 36 35 50 36
18 Troina Troina 36 39 71 29
19 Biancavilla Biancavilla 36 25 83 13
20 FC Messina FC Messina 0 0 0 0
TEMPORADA 2020/2021
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 66 25 74
2 FC Messina FC Messina 34 59 25 72
3 Gelbison Gelbison 34 54 34 64
4 San Luca San Luca 34 46 38 58
5 Acireale Acireale 34 51 32 57
6 Dattilo Dattilo 34 52 47 52
7 Rotonda Rotonda 34 31 33 49
8 Biancavilla Biancavilla 34 44 47 47
9 Santa Maria Cilento Santa Maria 34 43 29 45
10 Licata Licata 34 36 39 43
11 Castrovillari Castrovillar 34 39 37 41
12 Paternò Paternò 34 28 35 39
13 Cittanova Cittanova 34 42 51 39
14 Cittá Di Sant'Agata Cittá 34 32 48 36
15 Troina Troina 34 27 47 36
16 Rende Rende 34 38 58 34
17 Marina di Ragusa Marina 34 38 58 33
18 Roccella Roccella 34 25 68 20
TEMPORADA 2019/2020
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Palermo FC Palermo FC 26 47 16 63
2 FC Savoia 1908 Savoia 1908 26 41 15 56
3 SSC Giugliano Giugliano 26 40 26 47
4 FC Messina FC Messina 26 37 20 46
5 Troina Troina 26 30 28 46
6 Acireale Acireale 26 44 32 43
7 Licata Licata 26 36 30 41
8 ACR Messina ACR Messina 26 30 29 36
9 Nola 1925 Nola 1925 26 32 31 36
10 Biancavilla Biancavilla 26 23 32 35
11 Cittanova Cittanova 26 31 37 33
12 Castrovillari Castrovillar 26 43 39 32
13 Marina di Ragusa Marina 26 22 29 28
14 Roccella Roccella 26 22 26 25
15 ASD Corigliano Corigliano 26 26 52 25
16 Marsala Marsala 26 25 38 24
17 San Tommaso San Tommaso 26 25 46 21
18 Palmese Palmese 26 21 49 12
TEMPORADA 2018/2019
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 34 69 22 78
2 Turris Neapolis Turris 34 73 27 69
3 Marsala Marsala 34 44 30 53
4 Portici Portici 34 47 46 50
5 Castrovillari Castrovillar 34 40 39 49
6 Cittanova Cittanova 34 55 53 47
7 Palmese Palmese 34 34 32 47
8 Acireale Acireale 34 50 51 47
9 Nocerina Nocerina 34 35 40 47
10 Troina Troina 34 34 35 45
11 Gela Gela 34 49 50 44
12 ACR Messina ACR Messina 34 40 44 43
13 Sancataldese Sancataldese 34 52 51 42
14 FC Messina FC Messina 34 32 50 40
15 Locri 1909 Locri 1909 34 41 60 39
16 Roccella Roccella 34 32 46 38
17 Rotonda Rotonda 34 33 47 31
18 Igea Virtus Igea Virtus 34 17 54 21
TEMPORADA 2017/2018
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 US Vibonese Calcio Vibonese 34 67 24 76
2 Troina Troina 34 59 28 76
3 Nocerina Nocerina 34 50 20 69
4 Granata 1924 Granata 1924 34 58 33 64
5 Igea Virtus Igea Virtus 34 43 25 60
6 ACR Messina ACR Messina 34 57 39 53
7 Gela Gela 34 56 46 52
8 Acireale Acireale 34 47 45 51
9 Gelbison Gelbison 34 36 42 47
10 Palmese Palmese 34 47 54 43
11 Cittanova Cittanova 34 43 46 42
12 Portici Portici 34 35 44 42
13 Sancataldese Sancataldese 34 40 41 40
14 Roccella Roccella 34 41 49 38
15 Ebolitana Ebolitana 34 32 50 30
16 AC Palazzolo Palazzolo 34 26 53 25
17 Paceco Paceco 34 30 74 21
18 Isola Capo Rizzuto Isola Capo. 34 15 69 12

  USO DE MEMORIA  
5,718,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5753
Total Execution Time  0.5764
  CADENA URL  
/historico/Asd-Troina-Calcio/2022
  GET DATOS  
$_GET['/historico/Asd-Troina-Calcio/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0153  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 = 'Asd-Troina-Calcio' AND l.year = 2022 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.0145  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=102094 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=102094 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=102094 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102094 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '102094' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '102094' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '102094' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = '102094' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=102094 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (64283,64181) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 64283 AND teamId = 102094
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 64181 AND teamId = 102094
0.0295  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 64283 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '102094' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '102094' and rp.type = 4
0.0147  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 = '102094' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0180  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 events2022 e ON e.player_id = p.id AND e.league_id = 64283 WHERE rp.league_id = 64283 AND rp.teamId = 102094 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.0160  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 events2022 e ON e.player_id = p.id AND e.league_id = 64283 WHERE rp.league_id = 64283 AND rp.teamId = 102094 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 events2022 e ON e.player_id = p.id AND e.league_id = 64283 WHERE rp.league_id = 64283 AND rp.teamId = 102094 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 102094 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  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 `tables2022` 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 = 64283 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.0156  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 `tables2021` 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 = 58834 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 51164 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 44804 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2018` 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 = 39602 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC