4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Donato Tavarnelle
TEMPORADA 2023/2024
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Pianese Pianese 33 61 34 67
2 Grosseto Grosseto 33 52 30 63
3 Follonica Gavorrano Follonica 33 43 25 62
4 Livorno Livorno 33 49 31 59
5 Tau Altopascio Altopascio 33 54 30 57
6 Seravezza Seravezza 33 47 39 54
7 Ghivizzano Borgo Ghivizzano 33 54 53 50
8 Poggibonsi Poggibonsi 33 44 41 49
9 AS Figline AS Figline 33 44 39 49
10 Sangiovannese Sangiovannes 33 29 34 42
11 Montevarchi Calcio Montevarchi 33 39 40 40
12 Sporting Trestina Sporting 33 40 44 40
13 San Donato Tavarnelle Donato 33 29 32 39
14 Orvietana Calcio Orvietana 33 32 44 35
15 Real Forte Querceta Real Forte. 33 30 44 28
16 Vivi Altotevere Sansepolcro Vivi 33 23 45 28
17 Ponsacco Ponsacco 33 33 57 20
18 SC Cenaia SC Cenaia 33 26 67 16
TEMPORADA 2022/2023
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Reggiana Reggiana 38 63 27 81
2 Cesena Cesena 38 66 24 79
3 Virtus Entella Virtus 38 60 31 79
4 Carrarese Carrarese 38 51 42 62
5 AS Gubbio 1910 Gubbio 1910 38 50 34 61
6 Pontedera Pontedera 38 48 39 60
7 Ancona Ancona 38 55 44 58
8 Lucchese Libertas Lucchese 38 36 32 51
9 Siena Siena 38 40 40 48
10 Rimini Rimini 38 43 41 47
11 Recanatese Recanatese 38 39 43 47
12 Fermana Fermana 38 43 49 44
13 Olbia Calcio Olbia Calcio 38 43 50 41
14 Fiorenzuola Fiorenzuola 38 31 44 41
15 Sassari Torres Sassari 38 33 36 41
16 Vis Pesaro Vis Pesaro 38 24 55 39
17 US Alessandria Alessandria 38 33 52 38
18 San Donato Tavarnelle Donato 38 40 62 37
19 Imolese Imolese 38 29 55 30
20 Montevarchi Calcio Montevarchi 38 32 59 28
TEMPORADA 2021/2022
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 Sangiuliano City Nova Sangiuliano 2 4 0 6
2 Novara Novara 2 1 1 3
3 Arzignano Valchiampo Arzignano 2 0 4 0
4 Recanatese Recanatese 2 4 3 4
5 Rimini Rimini 2 3 3 2
6 San Donato Tavarnelle Donato 2 2 3 1
7 SSC Giugliano Giugliano 2 4 1 6
8 Audace Cerignola Audace 2 2 3 3
9 Gelbison Gelbison 2 0 2 0
TEMPORADA 2020/2021
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Montevarchi Calcio Montevarchi 34 68 32 71
2 Trastevere Trastevere 34 56 38 60
3 Sporting Trestina Sporting 34 48 33 56
4 San Donato Tavarnelle Donato 34 48 41 54
5 Siena Siena 34 48 40 53
6 Pianese Pianese 34 42 34 51
7 Follonica Gavorrano Follonica 34 48 37 51
8 Lornano Badesse Lornano 34 51 44 48
9 Tiferno Lerchi Tiferno 34 44 48 47
10 Cannara Cannara 34 41 48 47
11 Sangiovannese Sangiovannes 34 42 43 45
12 Montespaccato Montespaccat 34 40 47 41
13 Ostia Mare Ostia Mare 34 50 54 39
14 Flaminia Flaminia 34 44 57 39
15 Foligno Calcio Foligno 34 35 48 36
16 Scandicci Scandicci 34 42 49 35
17 Grassina Grassina 34 32 52 30
18 Sinalunghese Sinalunghese 34 24 58 23
TEMPORADA 2019/2020
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Grosseto Grosseto 26 44 25 52
2 Monterosi Tuscia Monterosi 26 35 20 50
3 Grassina Grassina 26 39 32 46
4 Albalonga Albalonga 26 36 24 45
5 Montevarchi Calcio Montevarchi 26 35 26 40
6 Scandicci Scandicci 26 45 30 39
7 Foligno Calcio Foligno 26 33 27 36
8 Aglianese Aglianese 26 35 30 34
9 Follonica Gavorrano Follonica 26 33 31 34
10 Flaminia Flaminia 26 31 29 34
11 Cannara Cannara 26 31 31 33
12 Sporting Trestina Sporting 26 34 35 33
13 Sangiovannese Sangiovannes 26 25 37 32
14 San Donato Tavarnelle Donato 26 30 32 31
15 Pomezia Pomezia 26 23 34 26
16 Bastia Calcio Bastia 26 22 36 26
17 Ponsacco Ponsacco 26 20 46 17
18 Tuttocuoio Tuttocuoio 26 19 45 16
TEMPORADA 2018/2019
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Pianese Pianese 38 58 21 74
2 Ponsacco Ponsacco 38 61 27 73
3 Seravezza Seravezza 38 62 42 65
4 Follonica Gavorrano Follonica 38 49 34 64
5 Montevarchi Calcio Montevarchi 38 49 38 64
6 San Donato Tavarnelle Donato 38 51 32 63
7 Ghivizzano Borgo Ghivizzano 38 50 37 60
8 Prato Prato 38 50 48 55
9 Tuttocuoio Tuttocuoio 38 43 43 55
10 Cannara Cannara 38 33 38 51
11 Sporting Trestina Sporting 38 39 40 50
12 Aglianese Aglianese 38 43 52 46
13 Real Forte Querceta Real Forte. 38 42 54 46
14 Sangiovannese Sangiovannes 38 36 41 45
15 Bastia Calcio Bastia 38 45 56 45
16 Scandicci Scandicci 38 44 53 43
17 Viareggio Viareggio 38 42 50 37
18 Sinalunghese Sinalunghese 38 30 54 37
19 Sangimignanosport Sangimignano 38 22 51 36
20 Massese Massese 38 26 64 16
TEMPORADA 2017/2018
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Albissola Albissola 34 56 30 69
2 Sanremese Sanremese 34 58 34 67
3 Ponsacco Ponsacco 34 49 31 62
4 Real Forte Querceta Real Forte. 34 50 27 60
5 Viareggio Viareggio 34 57 46 60
6 Massese Massese 34 50 33 56
7 Savona Savona 34 53 34 55
8 Seravezza Seravezza 34 44 33 51
9 San Donato Tavarnelle Donato 34 41 34 46
10 Ghivizzano Borgo Ghivizzano 34 48 45 44
11 Ligorna Ligorna 34 41 50 43
12 Sestri Levante Sestri 34 35 34 42
13 Lavagnese Lavagnese 34 35 42 41
14 USD Rignanese Rignanese 34 36 60 38
15 Scandicci Scandicci 34 42 54 34
16 FBC Finale 1908 Finale 1908 34 38 49 30
17 Argentina SSD Argentina 34 29 71 21
18 Valdinievole Montecatini Valdinievole 34 19 74 15
TEMPORADA 2016/2017
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Ravenna FC Ravenna FC 34 52 26 65
2 Imolese Imolese 34 60 35 63
3 Delta Porto Tolle Delta Porto 34 57 37 61
4 Lentigione Lentigione 34 40 31 58
5 Correggese Correggese 34 58 48 56
6 Castelvetro Castelvetro 34 60 57 50
7 Pianese Pianese 34 46 48 46
8 Scandicci Scandicci 34 45 55 46
9 Mezzolara Mezzolara 34 43 46 45
10 San Donato Tavarnelle Donato 34 50 47 44
11 USD Rignanese Rignanese 34 34 35 44
12 VF Colligiana Colligiana 34 46 47 43
13 Fiorenzuola Fiorenzuola 34 39 45 43
14 Adriese Adriese 34 46 51 39
15 Ribelle Ribelle 34 45 46 38
16 Sangiovannese Sangiovannes 34 42 51 37
17 Virtus Castelfranco Virtus 34 25 41 33
18 Poggibonsi Poggibonsi 34 24 66 21
TEMPORADA 2014/2015
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 Triestina Triestina 1 3 1 3
2 VF Colligiana Colligiana 1 2 0 3
3 AC Isola Liri Isola Liri 1 3 2 3
4 Battipagliese Battipaglies 1 2 1 3
5 Giorgione Giorgione 1 2 1 3
6 Romagna Centro Romagna 1 2 1 3
7 Noto Noto 1 1 0 3
8 Pomigliano Pomigliano 1 1 0 3
9 Pro Sesto Pro Sesto 1 1 0 3
10 Amiternina Amiternina 1 1 1 1
11 Castelfidardo Calcio Castelfidard 1 1 1 1
12 Palestrina Palestrina 1 2 3 0
13 Fidenza Fidenza 1 1 2 0
14 Nk Kras Asd Nk Kras Asd 1 1 2 0
15 Sorrento Sorrento 1 1 2 0
16 Arzanese Arzanese 1 0 1 0
17 Caravaggio Caravaggio 1 0 1 0
18 Tiger Brolo Tiger Brolo 1 0 1 0
19 Dro Calcio Dro Calcio 1 1 3 0
20 San Donato Tavarnelle Donato 1 0 2 0

  USO DE MEMORIA  
6,268,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1516
Total Execution Time  0.1529
  CADENA URL  
/historico/San-Donato-Tavarnelle
  GET DATOS  
$_GET['/historico/San-Donato-Tavarnelle']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0048  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 = 'San-Donato-Tavarnelle' 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=24974 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=24974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=24974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73983
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24974 AND type_rel = 2
0.0041  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 = '24974' ORDER BY l.year DESC,cat.coefficient DESC
0.0044  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 = '24974' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '24974' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73983 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=24974 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73983,73559,71547,67320) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71547 AND teamId = 24974
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 73983 AND teamId = 24974
0.0067  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 24974
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 24974
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73983 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = '24974' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24974' and rp.type = 4
0.0022  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 = '24974' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 24974 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.0042  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 24974 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 24974 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 24974 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 73983 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.0028  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 = 68592 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.0026  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 = 64279 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.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 `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 = 67680 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 58830 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.0029  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 = 51160 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.0031  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 = 44800 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 38853 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 33452 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables2015` 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 = 4818 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables2015` 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 = 14783 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC