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 Vecindario Vecindario 30 107 19 79
2 Castillo CF Castillo CF 30 112 26 73
3 UD San Fernando B Fernando 29 120 34 70
4 Unión Carrizal Unión 30 86 56 53
5 Agüimes CF Agüimes CF 30 68 46 51
6 San Pedro Mártir Pedro 30 78 49 49
7 Las Longueras Longueras 30 71 48 47
8 Tablero Tablero 29 62 44 45
9 Club Atlético Fomento Club 29 75 73 40
10 Juan Grande Juan Grande 30 70 71 39
11 CF Las Majoreras Majoreras 29 49 54 36
12 Cerruda Cerruda 30 61 66 34
13 Unión Viera B Unión Viera 29 60 53 33
14 Las Huesas Las Huesas 30 60 99 30
15 Union Marina Union Marina 30 45 95 30
16 Doramas B Doramas B 29 59 77 29
17 UD Los Vélez Vélez 30 44 68 26
18 Cercado de Espino Cercado 30 17 255 4
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 At. Gran Canaria Gran Canaria 38 127 30 91
2 Telde Telde 38 128 33 89
3 Tablero Tablero 38 101 54 79
4 Las Longueras Longueras 38 127 54 78
5 San Pedro Mártir Pedro 38 102 48 74
6 Castillo CF Castillo CF 38 101 59 72
7 Club Atlético Fomento Club 38 130 77 62
8 Unión Carrizal Unión 38 76 62 61
9 Agüimes CF Agüimes CF 38 89 64 59
10 CF Las Majoreras Majoreras 38 87 85 58
11 Unión Viera B Unión Viera 38 84 72 55
12 Union Marina Union Marina 38 83 80 47
13 Cerruda Cerruda 38 69 77 46
14 Las Huesas Las Huesas 38 76 95 45
15 Cercado de Espino Cercado 38 68 91 41
16 Valsequillo Valsequillo 38 55 65 39
17 Futboltec Futboltec 38 67 119 36
18 Casa Pastores Casa 38 72 115 25
19 Las Rosas Las Rosas 38 54 101 21
20 Calero Calero 38 9 255 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CF Pedro Hidalgo Pedro 32 125 31 82
2 At. Gran Canaria Gran Canaria 32 124 31 76
3 UD San Antonio Antonio 32 115 41 76
4 Real Sporting San José Real 32 106 34 72
5 Los Nidillos Nidillos 32 88 49 62
6 Club Atlético Fomento Club 32 69 53 52
7 UD Muelle Grande Muelle 32 70 64 52
8 Inter del Pilar CF Inter Pilar 32 109 66 51
9 Acodetti CF Acodetti CF 32 91 72 51
10 Piletas Piletas 32 65 60 42
11 Union Marina Union Marina 32 77 77 40
12 Atlético Isleta Atlético 32 45 74 39
13 UD Almenara UD Almenara 32 58 101 29
14 Calero Calero 32 36 106 24
15 Aregranca Aregranca 32 61 114 21
16 Talleres Canary Talleres 32 27 157 9
17 Street Canarias Street 32 30 166 5
18 Barrio Atlántico Barrio 0 0 0 0

  USO DE MEMORIA  
5,315,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.0738
Total Execution Time  0.0769
  CADENA URL  
/primera-regional-canarias2024/grupo2/historico
  GET DATOS  
$_GET['/primera-regional-canarias2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = 'primera-regional-canarias2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera-regional-canarias' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2523 ORDER BY order_id ASC
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2523 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0028  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 = 73641 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.0032  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 = 69367 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.0032  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 = 66025 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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:36:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:36:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:36:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:36:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  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 = 73641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73641 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.0020  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 = 73641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73641 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 = 73641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73641 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  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 = 73641 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