4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Sauleda Sauleda 26 78 30 59
2 La Punxa CF A Punxa 27 75 47 53
3 Sant Pere Pescador FC Sant Pere P. 27 67 39 53
4 Monells AE Monells AE 27 64 39 53
5 Roses City FC Roses City 27 58 40 52
6 Base Roses Base Roses 27 54 52 45
7 Agullana CD Agullana CD 25 40 34 39
8 Llançà Llançà 27 46 43 36
9 Portbou Portbou 27 52 55 35
10 Roses B Roses B 27 49 59 35
11 Bascara A Bascara A 26 38 42 32
12 Pals Atletic Pals Atletic 26 30 43 28
13 Alt EmpordÀ de Peralada A EmpordÀ 27 38 50 27
14 Mont-Ras CE Mont-Ras CE 26 47 67 24
15 Empuriabrava Castello B Empuriabrava 27 41 84 18
16 Viladamat CF Viladamat 27 33 86 14
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Gandesa Gandesa 30 104 21 79
2 Amposta Amposta 30 113 30 76
3 L'Ametlla de mar SCER L'Ametlla 27 72 38 58
4 La Cava La Cava 29 62 39 56
5 Rapitenca UE B Rapitenca 30 79 40 53
6 Masdenverge A A Masdenverge 30 52 44 46
7 Tortosa Ebre B Tortosa Ebre 30 55 47 42
8 Santa Barbara CF Santa 29 52 48 42
9 Flix JD Flix JD 29 48 67 35
10 Godall FC Godall FC 30 49 70 35
11 Xerta A Xerta A 30 47 64 34
12 Roquetenc CD Roquetenc 29 55 54 33
13 Perelló Perelló 30 36 71 26
14 Jesus Y Maria B Jesus Maria 30 36 69 25
15 Corbera D' Ebre CF Corbera Ebre 30 33 106 13
16 Benissanet Benissanet 29 29 114 6
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Jesus Catalonia Jesus 28 100 30 71
2 Jesus y Maria Jesus Maria 29 85 26 69
3 La Cava La Cava 29 83 25 67
4 Gandesa Gandesa 30 65 32 64
5 Roquetenc CD Roquetenc 26 53 15 58
6 L'Ametlla de mar SCER L'Ametlla 29 70 43 49
7 Rapitenca UE B Rapitenca 28 64 51 49
8 Santa Barbara CF Santa 29 57 44 41
9 Flix JD Flix JD 28 53 44 40
10 Amposta B Amposta B 30 53 69 31
11 Godall FC Godall FC 30 48 84 26
12 Tortosa Ebre B Tortosa Ebre 29 43 65 25
13 Corbera D' Ebre CF Corbera Ebre 28 56 83 24
14 Benissanet Benissanet 29 40 88 24
15 Alcanar Alcanar 27 30 96 11
16 Olimpic Mora D'Ebre A Olimpic Mora 29 21 126 8
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  
6,178,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.4690
Total Execution Time  0.4716
  CADENA URL  
/tercera_catalana2024/grupo1/historico
  GET DATOS  
$_GET['/tercera_catalana2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_catalana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=685 ORDER BY order_id ASC
0.0158  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 = 73166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0153  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 = 73166 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 68567 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 63746 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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.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 `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.0163  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.0150  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.0149  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.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 `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.0150  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:16:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 06:16:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:16:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:16:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 73166 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73166 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.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 73166 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73166 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 73166 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73166 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  SELECT *,(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 = 73166 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC