4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Ebre Escola A Ebre Escola 16 50 6 41
2 Rapitenca UE B Rapitenca 16 52 21 37
3 Batea CF Batea CF 16 56 25 32
4 Jesus y Maria Jesus Maria 16 38 22 32
5 Roquetenc CD Roquetenc 16 39 24 32
6 Jesus Catalonia Jesus 16 40 23 29
7 La Cava La Cava 16 38 23 29
8 Olimpic Mora D'Ebre A Olimpic Mora 16 39 25 29
9 L'Ametlla de mar SCER L'Ametlla 16 35 28 24
10 Corbera D' Ebre CF Corbera Ebre 16 30 41 22
11 Santa Barbara CF Santa 16 22 28 21
12 Amposta B Amposta B 16 24 31 18
13 Godall FC Godall FC 16 22 30 14
14 Flix JD Flix JD 16 20 41 10
15 Benissanet Benissanet 16 29 54 9
16 Alcanar Alcanar 16 16 45 9
17 Sant Jaume D'Enveja UE Sant Jaume. 16 11 94 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Remolins Bítem Remolins 23 67 17 54
2 Aldeana Aldeana 23 51 22 51
3 Olimpic Mora D'Ebre A Olimpic Mora 23 72 35 50
4 Batea CF Batea CF 23 75 47 46
5 La Cava La Cava 23 45 34 41
6 Jesus y Maria Jesus Maria 23 50 36 40
7 L'Ametlla de mar SCER L'Ametlla 23 39 24 38
8 Ebre Escola A Ebre Escola 23 48 37 36
9 Santa Barbara CF Santa 23 43 40 33
10 Jesus Catalonia Jesus 23 41 39 33
11 Flix JD Flix JD 23 39 43 33
12 Arnes Esportiu A Arnes 23 38 50 31
13 Godall FC Godall FC 23 30 40 29
14 Rapitenca UE B Rapitenca 23 48 43 26
15 Roquetenc CD Roquetenc 23 31 46 19
16 Amposta B Amposta B 23 37 58 14
17 Corbera D' Ebre CF Corbera Ebre 23 29 58 13
18 Sant Jaume D'Enveja UE Sant Jaume. 23 10 124 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Jesus y Maria Jesus Maria 34 81 45 65
2 Perelló Perelló 34 86 49 62
3 Jesus Catalonia Jesus 34 60 39 60
4 Aldeana Aldeana 34 68 37 59
5 Batea CF Batea CF 34 77 51 59
6 Olimpic Mora D'Ebre A Olimpic Mora 34 73 49 57
7 Flix JD Flix JD 34 74 50 57
8 Santa Barbara CF Santa 34 55 48 56
9 Rapitenca UE B Rapitenca 34 85 62 53
10 La Cava La Cava 34 68 53 51
11 Remolins Bítem Remolins 34 78 55 50
12 Corbera D' Ebre CF Corbera Ebre 34 78 60 47
13 L'Ametlla de mar SCER L'Ametlla 34 54 52 45
14 Roquetenc CD Roquetenc 34 45 53 44
15 Godall FC Godall FC 34 52 78 36
16 Sant Jaume D'Enveja UE Sant Jaume. 34 43 68 30
17 Masdenverge A A Masdenverge 34 47 89 24
18 Alcanar Alcanar 34 19 205 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Ampolla Ampolla 34 111 34 91
2 At. Móra la Nova Móra Nova 34 115 38 88
3 Aldeana Aldeana 34 58 35 65
4 Jesus y Maria Jesus Maria 34 57 58 62
5 Remolins Bítem Remolins 34 76 53 60
6 Perelló Perelló 34 77 42 58
7 Alcanar Alcanar 34 85 66 49
8 Roquetenc CD Roquetenc 34 59 75 47
9 Santa Barbara CF Santa 34 75 76 41
10 Sant Jaume D'Enveja UE Sant Jaume. 34 38 65 40
11 L'Ametlla de mar SCER L'Ametlla 34 52 68 39
12 Godall FC Godall FC 34 56 64 38
13 Corbera D' Ebre CF Corbera Ebre 34 38 65 38
14 Olimpic Mora D'Ebre A Olimpic Mora 34 71 66 37
15 Masdenverge A A Masdenverge 34 53 93 31
16 Pinell CF Pinell CF 34 33 84 29
17 Vilalba A Vilalba A 34 40 66 28
18 Arnes Esportiu A Arnes 34 49 95 25
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 La Sénia La Sénia 34 107 48 81
2 Jesus Catalonia Jesus 34 83 43 76
3 Ampolla Ampolla 34 99 45 74
4 Remolins Bítem Remolins 34 80 38 69
5 Aldeana Aldeana 34 68 40 68
6 Alcanar Alcanar 34 64 60 52
7 Perelló Perelló 34 49 50 48
8 Olimpic Mora D'Ebre A Olimpic Mora 34 67 71 47
9 Santa Barbara CF Santa 34 65 65 45
10 Roquetenc CD Roquetenc 34 53 76 41
11 Sant Jaume D'Enveja UE Sant Jaume. 34 63 102 40
12 Pinell CF Pinell CF 34 63 66 39
13 Vilalba A Vilalba A 34 54 70 36
14 L'Ametlla de mar SCER L'Ametlla 34 51 63 35
15 Corbera D' Ebre CF Corbera Ebre 34 54 81 35
16 Godall FC Godall FC 34 52 82 31
17 Flix JD Flix JD 34 44 75 27
18 Jesus Y Maria B Jesus Maria 34 49 90 21
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Batea CF Batea CF 34 110 54 75
2 Flix JD Flix JD 34 65 46 62
3 Aldeana Aldeana 34 86 54 60
4 Santa Barbara CF Santa 34 89 62 60
5 L'Ametlla de mar SCER L'Ametlla 34 63 46 58
6 Perelló Perelló 34 82 47 58
7 Roquetenc CD Roquetenc 34 73 47 57
8 La Sénia La Sénia 34 71 48 52
9 Olimpic Mora D'Ebre A Olimpic Mora 34 74 57 52
10 Corbera D' Ebre CF Corbera Ebre 34 71 70 49
11 Vilalba A Vilalba A 34 59 58 47
12 Asco B Asco B 34 55 64 46
13 At. Móra la Nova Móra Nova 34 70 62 45
14 Jesus Y Maria B Jesus Maria 34 53 76 44
15 Horta Sant Joan CDR Horta Sant. 34 49 76 38
16 Deltebre Deltebre 34 61 64 35
17 Ginestar CD Ginestar CD 34 36 141 11
18 Campredo UD Campredo UD 34 38 133 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Godall FC Godall FC 34 83 46 67
2 Ulldecona Ulldecona 34 71 39 66
3 Flix JD Flix JD 34 70 47 63
4 Aldeana Aldeana 34 75 45 58
5 Corbera D' Ebre CF Corbera Ebre 34 68 45 58
6 Batea CF Batea CF 34 72 50 58
7 Roquetenc CD Roquetenc 34 67 45 55
8 Santa Barbara CF Santa 34 76 60 53
9 Perelló Perelló 34 46 40 51
10 At. Móra la Nova Móra Nova 34 44 39 49
11 La Sénia La Sénia 34 65 57 48
12 Campredo UD Campredo UD 34 47 57 42
13 Horta Sant Joan CDR Horta Sant. 34 54 63 41
14 L'Ametlla de mar SCER L'Ametlla 34 45 61 40
15 Ginestar CD Ginestar CD 34 64 87 38
16 Pinell CF Pinell CF 34 48 73 34
17 Alcanar CD B Alcanar 34 39 82 28
18 Sant Jaume D'Enveja UE Sant Jaume. 34 23 121 12

  USO DE MEMORIA  
5,823,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3299
Total Execution Time  0.3317
  CADENA URL  
/tercera_catalana2021/grupo1/historico
  GET DATOS  
$_GET['/tercera_catalana2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=685 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58785 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 = 58785 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 50743 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 44416 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 38999 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 34080 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 16678 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3959 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 14:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 14:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 14:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 14:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58785 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58785 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58785 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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 = 58785 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC