4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 La Floresta La Floresta 23 88 9 67
2 Reus FC Reddis Reus Reddis 23 82 18 59
3 Vilaseca Vilaseca 23 70 23 53
4 Hospitalet de l'Infant Hospitalet 23 51 33 44
5 Escola La Pastoreta Escola 23 52 43 37
6 Falset Falset 22 51 43 36
7 Icomar Icomar 23 47 45 34
8 Mas Pellicer Pellicer 23 36 44 32
9 Salou Salou 21 52 33 30
10 Porrera Porrera 22 35 43 26
11 Montroig Montroig 23 39 46 25
12 Montbrió Montbrió 23 31 44 25
13 Maspujols A Maspujols A 23 32 65 24
14 Vallmoll Vallmoll 23 33 47 23
15 La Selva del Camp Selva Camp 23 32 68 22
16 E.F. San Pedro San Pablo E.F. Pedro. 23 39 68 18
17 Unió Astorga Unió 23 24 56 16
18 España Canonja España 23 25 91 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Bonavista Bonavista 34 97 39 84
2 Les Borges del Camp A Borges Camp 34 103 32 82
3 La Floresta La Floresta 34 87 39 69
4 Hospitalet de l'Infant Hospitalet 34 80 56 60
5 Salou Salou 34 84 60 59
6 Falset Falset 34 95 76 53
7 Racing Bonavista Racing 34 73 62 51
8 Mas Pellicer Pellicer 34 60 60 51
9 Montroig Montroig 34 55 59 49
10 E.F. San Pedro San Pablo E.F. Pedro. 34 65 87 42
11 Vallmoll Vallmoll 34 78 80 42
12 Porrera Porrera 34 52 58 42
13 La Selva del Camp Selva Camp 34 55 77 36
14 España Canonja España 34 74 102 35
15 Montbrió Montbrió 34 58 88 34
16 Maspujols A Maspujols A 34 59 69 32
17 At. Camp Clar Camp Clar 34 57 109 32
18 Pare Manyanet Pare 34 44 123 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Riudoms Riudoms 34 97 35 84
2 Escola La Pastoreta Escola 34 89 50 72
3 Bonavista Bonavista 34 76 42 72
4 Racing Bonavista Racing 34 84 57 57
5 At. Camp Clar Camp Clar 34 72 49 57
6 España Canonja España 34 70 58 57
7 Les Borges del Camp A Borges Camp 34 70 52 54
8 Falset Falset 34 91 94 49
9 Salou Salou 34 77 69 48
10 La Selva del Camp Selva Camp 34 81 79 45
11 E.F. San Pedro San Pablo E.F. Pedro. 34 67 67 45
12 Montroig Montroig 34 69 73 45
13 Porrera Porrera 34 54 67 39
14 La Floresta La Floresta 34 65 74 36
15 Pare Manyanet Pare 34 57 94 34
16 Mas Pellicer Pellicer 34 68 111 27
17 Montbrió Montbrió 34 42 86 23
18 Icomar Icomar 34 53 125 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Canonja Canonja 34 104 29 85
2 Falset Falset 34 101 48 77
3 Bonavista Bonavista 34 72 51 71
4 España Canonja España 34 86 47 64
5 E.F. San Pedro San Pablo E.F. Pedro. 34 80 61 61
6 Escola La Pastoreta Escola 34 78 57 60
7 Racing Bonavista Racing 34 65 51 59
8 Riudoms Riudoms 34 75 66 58
9 La Selva del Camp Selva Camp 34 53 55 45
10 Vilaseca B Vilaseca B 34 67 72 43
11 Icomar Icomar 34 69 85 38
12 La Floresta La Floresta 34 63 72 37
13 At. Camp Clar Camp Clar 34 53 72 35
14 Mas Pellicer Pellicer 34 69 85 34
15 Pare Manyanet Pare 34 40 69 32
16 Porrera Porrera 34 60 117 27
17 Montroig Montroig 34 37 77 27
18 SPO Granada de Reus Granada Reus 34 34 92 18
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Cambrils United Cambrils 34 79 22 84
2 Salou Salou 34 98 42 74
3 Canonja Canonja 34 99 45 72
4 Bonavista Bonavista 34 67 41 68
5 Falset Falset 34 75 67 57
6 Escola La Pastoreta Escola 34 68 64 48
7 La Selva del Camp Selva Camp 34 63 58 46
8 La Floresta La Floresta 34 70 70 45
9 At. Camp Clar Camp Clar 34 63 62 44
10 Vilafortuny Vilafortuny 34 60 69 42
11 Vilaseca B Vilaseca B 34 62 55 41
12 Mas Pellicer Pellicer 34 54 68 41
13 Montroig Montroig 34 50 74 41
14 Alcover Alcover 34 69 67 39
15 SPO Granada de Reus Granada Reus 34 55 62 39
16 E.F. San Pedro San Pablo E.F. Pedro. 34 70 83 38
17 Icomar Icomar 34 70 105 32
18 Unió Astorga Unió 34 19 137 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Racing Bonavista Racing 32 75 23 78
2 Hospitalet de l'Infant Hospitalet 32 72 30 75
3 Cambrils United Cambrils 32 73 33 74
4 Escola La Pastoreta Escola 32 52 47 57
5 Falset Falset 32 67 47 50
6 Bonavista Bonavista 32 57 64 50
7 España Canonja España 32 78 57 49
8 Alcover Alcover 32 66 58 45
9 Vilafortuny Vilafortuny 32 51 55 39
10 La Selva del Camp Selva Camp 32 54 63 37
11 Mas Pellicer Pellicer 32 50 75 36
12 Unió Astorga Unió 32 46 66 34
13 Vilaseca B Vilaseca B 32 36 60 34
14 Salou Salou 32 47 57 33
15 E.F. San Pedro San Pablo B E.F. Pedro. 32 50 61 33
16 SPO Granada de Reus Granada Reus 32 39 73 22
17 Salauris Futbol Club Salauris 32 43 87 21
18 Internacional de Reus Internaciona 0 0 0 0

  USO DE MEMORIA  
5,726,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3609
Total Execution Time  0.3629
  CADENA URL  
/tercera_catalana2020/grupo2/historico
  GET DATOS  
$_GET['/tercera_catalana2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0129  SELECT type FROM routes WHERE alias = 'tercera_catalana2020'
0.0262  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0128  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 = 50744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 2 and tables = 1 AND year <= 2020 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 `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 = 50744 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.0130  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 = 44417 AND t.round = 34 ORDER BY team.conference 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 `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 = 39000 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 `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 = 34081 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 = 16679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 3960 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-04-27 07:18:56' 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-04-27 07:18:56' 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=4 AND last_update > '2024-04-27 07:18:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 07:18:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  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 events2020 e ON e.player_id = p.id AND e.league_id = 50744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50744 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.0127  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 events2020 e ON e.player_id = p.id AND e.league_id = 50744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50744 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  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 events2020 e ON e.player_id = p.id AND e.league_id = 50744 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50744 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0168  SELECT *,(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 = 50744 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