4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sammaurese

Sammaurese

Entrenador: Mirko Taccola

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 AC Carpi AC Carpi 32 63 31 68
2 Ravenna FC Ravenna FC 32 56 13 66
3 Lentigione Lentigione 32 51 30 58
4 Corticella Corticella 32 57 40 55
5 Forli Forli 32 45 36 55
6 Victor San Marino Victor 32 42 38 54
7 Sangiuliano City Nova Sangiuliano 32 35 34 47
8 Prato Prato 32 39 40 47
9 Fanfulla Fanfulla 32 30 34 45
10 Aglianese Aglianese 32 33 34 44
11 Imolese Imolese 32 32 31 43
12 Sant Angelo Sant Angelo 31 46 45 38
13 Sammaurese Sammaurese 32 34 46 35
14 Progresso Progresso 32 25 42 35
15 Pistoiese Pistoiese 31 22 39 32
16 Borgo San Donnino Borgo 32 31 55 28
17 Calcio Certaldo Calcio 32 20 49 24
18 Mezzolara Mezzolara 32 22 46 23
TEMPORADA 2022/2023
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Giana Erminio Giana 38 77 31 80
2 Pistoiese Pistoiese 38 56 32 73
3 AC Carpi AC Carpi 38 58 44 59
4 Forli Forli 38 54 42 57
5 Real Forte Querceta Real Forte. 38 49 41 57
6 Corticella Corticella 38 63 62 57
7 Ravenna FC Ravenna FC 38 52 47 56
8 Sammaurese Sammaurese 38 49 44 51
9 Aglianese Aglianese 38 51 46 50
10 Riccione Riccione 38 50 51 50
11 Prato Prato 38 57 59 49
12 Mezzolara Mezzolara 38 43 47 49
13 Crema Crema 38 56 56 48
14 Lentigione Lentigione 38 49 52 48
15 Correggese Correggese 38 41 48 48
16 Fanfulla Fanfulla 38 48 57 48
17 Sant Angelo Sant Angelo 38 45 51 45
18 Scandicci Scandicci 38 46 57 42
19 Bagnolese Bagnolese 38 30 48 38
20 Salsomaggiore Salsomaggior 38 21 80 13
TEMPORADA 2021/2022
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Rimini Rimini 38 72 21 87
2 Ravenna FC Ravenna FC 38 85 40 83
3 Lentigione Lentigione 38 75 42 83
4 Correggese Correggese 38 47 38 58
5 AC Carpi AC Carpi 38 59 52 58
6 Mezzolara Mezzolara 38 48 44 56
7 Prato Prato 38 47 52 51
8 Forli Forli 38 46 47 50
9 Aglianese Aglianese 38 44 56 50
10 Sammaurese Sammaurese 38 44 50 50
11 Alcione Alcione 38 52 49 48
12 Seravezza Seravezza 38 42 54 46
13 Fanfulla Fanfulla 38 44 49 45
14 Ghivizzano Borgo Ghivizzano 38 51 61 45
15 Real Forte Querceta Real Forte. 38 36 43 44
16 Bagnolese Bagnolese 38 26 39 38
17 Sasso Marconi Sasso 38 37 61 37
18 Progresso Progresso 38 36 48 36
19 Borgo San Donnino Borgo 38 34 52 36
20 Tritium Tritium 38 38 65 35
TEMPORADA 2020/2021
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Fiorenzuola Fiorenzuola 34 76 32 75
2 Aglianese Aglianese 34 61 35 73
3 Lentigione Lentigione 34 57 27 65
4 Prato Prato 34 50 41 54
5 Rimini Rimini 34 56 44 52
6 Forli Forli 34 51 46 52
7 Pro Livorno Pro Livorno 34 56 59 48
8 Correggese Correggese 34 53 58 47
9 Real Forte Querceta Real Forte. 34 45 47 46
10 Sammaurese Sammaurese 34 50 53 42
11 Ghivizzano Borgo Ghivizzano 34 44 48 41
12 Bagnolese Bagnolese 34 40 41 40
13 Mezzolara Mezzolara 34 40 49 39
14 Seravezza Seravezza 34 41 54 36
15 Progresso Progresso 34 41 56 36
16 Sasso Marconi Sasso 34 36 57 33
17 Marignanese Marignanese 34 42 57 29
18 Corticella Corticella 34 33 68 24
TEMPORADA 2019/2020
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Mantova Mantova 24 59 31 51
2 Fiorenzuola Fiorenzuola 24 36 27 44
3 Correggese Correggese 25 42 31 41
4 Calvina Calvina 25 40 32 41
5 Lentigione Lentigione 24 39 31 40
6 Fanfulla Fanfulla 24 38 31 40
7 Mezzolara Mezzolara 25 34 33 36
8 Forli Forli 24 26 26 32
9 Franciacorta Franciacorta 24 41 44 31
10 Breno Futura Breno Futura 24 32 28 30
11 Sasso Marconi Sasso 25 41 43 29
12 Vigor Carpaneto Vigor 24 33 38 29
13 Progresso Progresso 24 24 33 29
14 Sammaurese Sammaurese 25 33 38 26
15 Crema Crema 24 27 34 25
16 Pol. Ciliverghe Pol. 25 28 41 25
17 Alfonsine FC 1921 Alfonsine 25 15 33 22
18 Savignanese Savignanese 25 24 38 21
TEMPORADA 2018/2019
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Cesena Cesena 38 69 28 83
2 Matelica Calcio Matelica 38 74 36 80
3 Recanatese Recanatese 38 55 35 63
4 Pineto Pineto 38 59 41 62
5 Sangiustese Sangiustese 38 49 38 61
6 Francavilla Calcio Francavilla 38 59 44 60
7 SN Notaresco 2018 Notaresco 38 48 43 54
8 Jesina Jesina 38 34 38 51
9 Montegiorgio Montegiorgio 38 36 43 51
10 Città di Campobasso Città 38 49 49 49
11 Sammaurese Sammaurese 38 36 48 49
12 Savignanese Savignanese 38 42 43 48
13 Avezzano Avezzano 38 47 50 45
14 Real Giulianova Real 38 34 47 44
15 Forli Forli 38 47 47 43
16 Vastese Vastese 38 47 61 42
17 Olympia Agnonese Olympia 38 36 46 41
18 Santarcangelo Santarcangel 38 41 61 37
19 Isernia Isernia 38 28 53 35
20 Castelfidardo Calcio Castelfidard 38 34 73 23
TEMPORADA 2017/2018
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Rimini Rimini 38 65 38 80
2 Imolese Imolese 38 72 45 71
3 Forli Forli 38 60 43 65
4 Fiorenzuola Fiorenzuola 38 50 32 64
5 Sangiovannese Sangiovannes 38 42 38 61
6 Lentigione Lentigione 38 45 33 60
7 Villabiagio Villabiagio 38 52 49 59
8 Pianese Pianese 38 54 35 58
9 Montevarchi Calcio Montevarchi 38 42 40 56
10 Romagna Centro Romagna 38 49 42 54
11 Sammaurese Sammaurese 38 34 29 54
12 Vigor Carpaneto Vigor 38 50 48 45
13 Sasso Marconi Sasso 38 35 48 45
14 Tuttocuoio Tuttocuoio 38 25 34 42
15 Sporting Trestina Sporting 38 36 52 41
16 Castelvetro Castelvetro 38 46 62 38
17 Mezzolara Mezzolara 38 34 50 36
18 Sansepolcro Calcio Sansepolcro 38 40 62 33
19 Correggese Correggese 38 37 55 32
20 VF Colligiana Colligiana 38 27 60 29
TEMPORADA 2016/2017
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Fermana Fermana 32 51 28 69
2 Matelica Calcio Matelica 32 56 30 63
3 SN Notaresco 2018 Notaresco 32 53 29 60
4 Vis Pesaro Vis Pesaro 32 48 32 53
5 Olympia Agnonese Olympia 32 45 33 51
6 Sammaurese Sammaurese 32 37 25 50
7 Monticelli Monticelli 32 37 33 47
8 Vastese Vastese 32 43 32 45
9 San Marino Calcio Marino 32 43 38 41
10 Jesina Jesina 32 35 44 40
11 Romagna Centro Romagna 32 34 42 39
12 Pineto Pineto 32 35 44 39
13 Città di Campobasso Città 32 32 44 38
14 Alfonsine FC 1921 Alfonsine 32 33 45 30
15 Castelfidardo Calcio Castelfidard 32 28 44 28
16 Recanatese Recanatese 32 30 50 27
17 Civitanovese Civitanovese 32 22 69 17
18 Chieti Chieti 0 0 0 0
TEMPORADA 2015/2016
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Parma Parma 38 82 17 94
2 Alto Vicentino Alto 38 84 43 77
3 Forli Forli 38 69 46 69
4 San Marino Calcio Marino 38 55 41 65
5 Correggese Correggese 38 66 49 64
6 Imolese Imolese 38 63 41 63
7 Delta Porto Tolle Delta Porto 38 68 51 61
8 Ribelle Ribelle 38 63 54 61
9 Lentigione Lentigione 38 52 50 59
10 Sammaurese Sammaurese 38 53 50 54
11 Arzignano Valchiampo Arzignano 38 60 54 53
12 Legnago Salus Legnago 38 55 53 51
13 Ravenna FC Ravenna FC 38 50 59 44
14 Romagna Centro Romagna 38 40 51 44
15 Virtus Castelfranco Virtus 38 50 59 42
16 Mezzolara Mezzolara 38 30 55 35
17 Villafranca Villafranca 38 45 62 33
18 Bellaria Igea Bellaria 38 38 76 29
19 Clodiense Clodiense 38 35 81 27
20 Fortis Juventus Fortis 38 31 97 13

  USO DE MEMORIA  
6,356,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1157
Total Execution Time  0.1170
  CADENA URL  
/historico/Sammaurese
  GET DATOS  
$_GET['/historico/Sammaurese']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0037  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 = 'Sammaurese' 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=66520 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=66520 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=66520 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=66520 AND type_rel = 2
0.0026  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 = '66520' 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 = '66520' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '66520' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=66520 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 (73982,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 = 73982 AND teamId = 66520
0.0058  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 66520
0.0043  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 = 73982 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '66520' 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 = '66520' and rp.type = 4
0.0021  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 = '66520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0050  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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 66520 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.0046  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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 66520 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 66520 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 66520 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 64278 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.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 `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 = 58829 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.0024  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 = 51159 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.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 `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 = 44801 AND t.round = 38 ORDER BY team.conference 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 `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 = 39598 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 33454 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15652 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73982 ORDER BY nameShow LIMIT 100