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 Ceuta 6 de Junio Ceuta Junio 8 15 3 22
2 Betis de Hadú Betis Hadú 8 20 7 19
3 Príncipe Alfonso Príncipe 8 25 11 17
4 Polillas Atlético Polillas 8 23 7 15
5 Polillas Sporting Polillas 8 17 15 9
6 Ucidce Ucidce 8 10 18 5
7 AD Ceuta FC C Ceuta 8 11 17 4
8 CD Mirador CD Mirador 8 2 45 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Ceuta 6 de Junio Ceuta Junio 14 53 15 40
2 Betis de Hadú Betis Hadú 14 52 19 34
3 Polillas Atlético Polillas 14 27 25 20
4 Sporting de Ceuta Sporting 14 29 30 20
5 AD Ceuta FC C Ceuta 14 37 38 19
6 Tercio Duque de Alba Tercio Duque 14 30 41 13
7 At. Ciudad de Ceuta Ciudad Ceuta 14 33 51 9
8 Hilal Deportivo Hilal 14 18 60 -3
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 AD Ceuta FC B Ceuta 26 89 12 71
2 Ceuta 6 de Junio Ceuta Junio 25 107 21 64
3 Betis de Hadú Betis Hadú 26 75 41 53
4 Bahía de Ceuta Atl. Bahía Ceuta 26 70 36 52
5 Sporting Atlético Sporting 26 69 41 49
6 Racing del Principe Racing 26 57 49 44
7 At. Ciudad de Ceuta Ciudad Ceuta 25 63 67 37
8 C.B. Ramón y Cajal C.B. Ramón 25 64 29 36
9 Betis de Hadú Atlético Betis Hadú 25 48 53 34
10 Polillas Ceuta Polillas 26 56 68 30
11 Real Sociedad La Pantera Real 26 41 77 17
12 Ceuta CF Base Ceuta Base 26 49 109 14
13 Natación Ceuta Natación 25 40 151 12
14 Hilal Deportivo Hilal 25 20 94 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 AUGC Deportiva Ceuta AUGC 9 27 6 25
2 AgD Ceuta AgD Ceuta 9 21 4 21
3 CF Rosales CF Rosales 8 40 7 19
4 C.B. Ramón y Cajal C.B. Ramón 9 24 16 16
5 Bahía de Ceuta Atl. Bahía Ceuta 9 23 21 14
6 Hilal Deportivo Hilal 7 16 13 12
7 Murallas de Ceuta Murallas 9 15 25 10
8 Natación Ceuta Natación 9 13 39 4
9 CD San José José 8 13 25 2
10 Betis de Hadú Betis Hadú 9 13 49 1
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 C.B. Ramón y Cajal C.B. Ramón 22 71 15 60
2 Bahía de Ceuta Atl. Bahía Ceuta 22 56 18 53
3 AgD Ceuta AgD Ceuta 21 66 17 47
4 Murallas de Ceuta Murallas 22 47 21 45
5 Sporting de Ceuta Sporting 15 37 26 21
6 CD Aimolar CD Aimolar 15 25 27 21
7 Ucidce Ucidce 15 35 32 19
8 Betis de Hadú Betis Hadú 16 19 36 16
9 Sporting Atlético Sporting 16 27 48 8
10 Colegio Rey Juan Carlos I Colegio Juan 15 16 45 8
11 C.D. Dinamo Ceutí C.D. Dinamo 15 16 84 4
12 Ceuta Base Ceuta Base 14 9 55 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 16 64 10 43
2 Sporting de Ceuta Sporting 16 53 12 40
3 C.B. Ramón y Cajal C.B. Ramón 16 70 18 35
4 Murallas de Ceuta Murallas 16 48 36 31
5 Sporting Atlético Sporting 16 37 37 24
6 Hilal Deportivo Hilal 16 26 26 22
7 CD Mirador CD Mirador 16 14 51 6
8 Severo Ochoa Severo Ochoa 16 23 69 6
9 Betis de Hadú Betis Hadú 16 16 92 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 AD Ceuta FC B Ceuta 14 44 13 32
2 Club Sporting de Ceuta Club 14 41 14 32
3 Imperio Ceuta Imperio 14 43 26 28
4 Hilal Deportivo Hilal 14 34 17 24
5 Murallas de Ceuta Murallas 14 41 23 23
6 Betis de Hadú Betis Hadú 14 23 51 9
7 Ceuta Base Ceuta Base 14 15 60 8
8 Carmelitas Carmelitas 14 13 50 2
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Ramón Y Cajal Ramón Cajal 16 59 10 41
2 Hilal Deportivo Hilal 16 51 15 39
3 AD Ceuta FC B Ceuta 16 60 18 35
4 Murallas de Ceuta Murallas 16 46 26 32
5 Colegio Rey Juan Carlos I Colegio Juan 16 44 48 20
6 Sindi Bar Sindi Bar 16 34 46 14
7 Carmelitas Carmelitas 16 25 54 13
8 Rayo de Ceuta Rayo Ceuta 16 20 60 10
9 Puerto Atlético Puerto 16 29 91 4
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 C.B. Ramón y Cajal C.B. Ramón 14 41 15 38
2 AD Ceuta FC B Ceuta 14 48 20 29
3 Hilal Deportivo Hilal 14 28 17 25
4 C.D. Dinamo Ceutí C.D. Dinamo 14 38 36 25
5 Murallas de Ceuta Murallas 14 36 41 17
6 Super Sport Atlético Super Sport 14 26 34 15
7 Natación Ceuta Natación 14 17 32 10
8 Ceuta Base Ceuta Base 14 3 42 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Sporting de Ceuta Sporting 20 65 18 51
2 CD Super Sport Super Sport 20 59 19 49
3 AD Ceuta FC B Ceuta 20 64 21 46
4 C.B. Ramón y Cajal C.B. Ramón 20 59 16 42
5 Coleg. Juan Carlos I Coleg. Juan 20 33 41 25
6 Murallas de Ceuta Murallas 20 31 39 22
7 Imperio Ceuta Imperio 20 34 46 22
8 C.D. Dinamo Ceutí C.D. Dinamo 20 35 64 15
9 C.D. Puerto Disa C.D. Puerto 20 19 63 15
10 Betis de Hadú Betis Hadú 20 31 68 12
11 Super Sport Atlético Super Sport 20 21 56 10

  USO DE MEMORIA  
5,421,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4664
Total Execution Time  0.4682
  CADENA URL  
/regional_preferente_ceuta2024/grupo1/historico
  GET DATOS  
$_GET['/regional_preferente_ceuta2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'regional_preferente_ceuta2024'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'regional_preferente_ceuta' 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.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=243 ORDER BY order_id ASC
0.0145  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 = 74562 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 243 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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 = 74562 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `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 = 65875 AND t.round = 14 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 `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 = 51661 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 51663 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 51665 AND t.round = 18 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 = 33996 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 20267 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 7458 AND t.round = 14 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 `tables2013` 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 = 1746 AND t.round = 22 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-27 09:06:48' 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=2 AND last_update > '2024-04-27 09:06:48' 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=4 AND last_update > '2024-04-27 09:06:48' 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-27 09:06:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'regional_preferente_ceuta' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0165  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 = 74562 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74562 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.0169  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 = 74562 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74562 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0148  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 = 74562 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74562 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0152  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 = 74562 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC