4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pineto
TEMPORADA 2023/2024
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Cesena Cesena 37 78 19 93
2 Sassari Torres Sassari 37 54 36 74
3 Carrarese Carrarese 37 52 29 70
4 Perugia Perugia 37 44 33 63
5 AS Gubbio 1910 Gubbio 1910 37 46 38 56
6 Juventus Next Gen Juventus 37 49 42 54
7 Pescara Pescara 37 57 54 52
8 Pontedera Pontedera 37 52 52 52
9 Rimini Rimini 37 52 50 50
10 SS Arezzo SS Arezzo 37 44 43 50
11 SPAL SPAL 37 37 39 46
12 Pineto Pineto 37 36 40 44
13 Sestri Levante Sestri 37 41 53 44
14 Lucchese Libertas Lucchese 37 34 43 44
15 Virtus Entella Virtus 37 32 35 42
16 Ancona Ancona 37 41 51 41
17 Recanatese Recanatese 37 47 64 38
18 Vis Pesaro Vis Pesaro 37 37 46 36
19 Fermana Fermana 37 29 56 31
20 Olbia Calcio Olbia Calcio 37 24 63 26
TEMPORADA 2022/2023
SERIE D GRUPO 13
Equipo PJ GF GC Puntos
1 Sestri Levante Sestri 2 5 2 6
2 Lumezzane Lumezzane 2 4 3 3
3 Legnago Salus Legnago 2 2 6 0
4 Pineto Pineto 2 4 3 3
5 SS Arezzo SS Arezzo 2 4 4 3
6 Giana Erminio Giana 2 3 4 3
7 Sorrento Sorrento 2 5 0 6
8 Catania Catania 2 2 3 3
9 Brindisi Brindisi 2 1 5 0
TEMPORADA 2021/2022
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Recanatese Recanatese 34 69 23 68
2 Trastevere Trastevere 34 54 33 59
3 Tolentino Tolentino 34 42 30 56
4 Sambenedettese Sambenedette 34 41 36 55
5 Vastese Vastese 34 44 32 53
6 Pineto Pineto 34 43 29 52
7 Fiuggi Fiuggi 34 41 45 51
8 SN Notaresco 2018 Notaresco 34 45 41 49
9 Matese Matese 34 44 41 49
10 Porto D'Ascoli Porto 34 41 39 49
11 Montegiorgio Montegiorgio 34 38 36 49
12 Chieti Chieti 34 38 38 49
13 Fano Fano 34 44 39 48
14 Vastogirardi Vastogirardi 34 48 51 46
15 Castelnuovo Vomano Castelnuovo 34 49 51 44
16 Castelfidardo Calcio Castelfidard 34 36 36 41
17 Nereto Nereto 34 23 80 12
18 Aurora Alto Casertano Aurora Alto 34 21 81 7
TEMPORADA 2020/2021
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Città di Campobasso Città 34 63 29 72
2 SN Notaresco 2018 Notaresco 34 59 34 64
3 Pineto Pineto 34 45 35 56
4 Cynthialbalonga Cynthialbalo 34 51 36 56
5 Matese Matese 34 46 38 56
6 Castelfidardo Calcio Castelfidard 34 46 33 55
7 Recanatese Recanatese 34 62 45 50
8 Castelnuovo Vomano Castelnuovo 34 53 53 50
9 Vastese Vastese 34 47 37 48
10 Montegiorgio Montegiorgio 34 42 42 46
11 Rieti Rieti 34 38 42 44
12 Aprilia Aprilia 34 43 49 44
13 Tolentino Tolentino 34 52 53 40
14 Fiuggi Fiuggi 34 40 41 40
15 Vastogirardi Vastogirardi 34 46 51 40
16 Real Giulianova Real 34 33 50 31
17 Porto Sant'Elpidio Porto 34 22 63 17
18 Olympia Agnonese Olympia 34 26 83 15
TEMPORADA 2019/2020
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Matelica Calcio Matelica 26 49 17 55
2 Città di Campobasso Città 26 47 24 52
3 SN Notaresco 2018 Notaresco 26 43 30 52
4 Recanatese Recanatese 26 48 42 48
5 Pineto Pineto 26 35 30 43
6 Vastese Vastese 26 40 33 42
7 Olympia Agnonese Olympia 26 40 34 40
8 Montegiorgio Montegiorgio 26 32 27 38
9 Tolentino Tolentino 26 33 37 36
10 Porto Sant'Elpidio Porto 26 40 40 34
11 Vastogirardi Vastogirardi 26 42 45 34
12 Fiuggi Fiuggi 26 37 38 33
13 Cattolica Cattolica 26 31 36 28
14 Real Giulianova Real 26 29 40 28
15 Sangiustese Sangiustese 26 27 39 20
16 Avezzano Avezzano 26 16 33 20
17 Chieti Chieti 26 26 51 18
18 Jesina Jesina 26 27 46 13
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 6
Equipo PJ GF GC Puntos
1 Vis Pesaro Vis Pesaro 34 61 29 73
2 Matelica Calcio Matelica 34 66 28 71
3 Avezzano Avezzano 34 51 26 62
4 Pineto Pineto 34 53 41 57
5 L'Aquila L'Aquila 34 57 40 55
6 Francavilla Calcio Francavilla 34 47 38 53
7 San Marino Calcio Marino 34 45 35 51
8 Vastese Vastese 34 55 50 51
9 Città di Campobasso Città 34 41 40 49
10 Sangiustese Sangiustese 34 39 41 48
11 Castelfidardo Calcio Castelfidard 34 43 54 44
12 Recanatese Recanatese 34 47 47 43
13 Olympia Agnonese Olympia 34 34 35 41
14 SN Notaresco 2018 Notaresco 34 42 51 40
15 Jesina Jesina 34 32 46 34
16 Monticelli Monticelli 34 25 45 30
17 Fabriano Cerreto Fabriano 34 29 69 20
18 Nerostellati Pratola Nerostellati 34 19 71 18
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

  USO DE MEMORIA  
6,247,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0989
Total Execution Time  0.1002
  CADENA URL  
/historico/Pineto-Calcio
  GET DATOS  
$_GET['/historico/Pineto-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90188 AND type_rel = 2
0.0024  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 = '90188' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=90188 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 (74153,72300,71796,71432,68661) 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 = 72300 AND teamId = 90188
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71796 AND teamId = 90188
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 90188
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 90188
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90188
0.0020  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 = '90188' 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 = '90188' 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 = '90188' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72300 WHERE rp.league_id = 72300 AND rp.teamId = 90188 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.0041  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 = 72300 WHERE rp.league_id = 72300 AND rp.teamId = 90188 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 72300 WHERE rp.league_id = 72300 AND rp.teamId = 90188 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 90188 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0044  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 = 68752 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 `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 = 71666 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.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 `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 = 64280 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 `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 = 58831 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 = 51161 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.0034  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.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 `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 = 39599 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 `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