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 CFI Alicante B Alicante 12 40 10 27
2 CD Iraklis CD Iraklis 12 25 9 27
3 Novelda C Novelda C 12 22 15 25
4 Bonavista Bonavista 12 33 16 23
5 Elche Dream Elche Dream 12 16 28 20
6 Mediterraneo CF Mediterraneo 12 24 16 19
7 Barrio Obrero Barrio 12 17 14 18
8 SCD Carolinas Carolinas 12 15 20 16
9 Monnegre de Mutxamel B Monnegre 12 22 21 13
10 The Warriors Burnham Warriors 12 21 30 12
11 United Elche A United Elche 12 13 26 10
12 Elche Sporting Elche 12 16 37 9
13 UD de Alicante Alicante 12 11 33 7
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Cox Cox 30 90 30 69
2 CFP Orihuela Deportiva Orihuela 30 67 25 69
3 Sp. Saladar Sp. Saladar 30 77 25 66
4 Bigastro Bigastro 30 79 44 61
5 SC Torrevieja CF Torrevieja 30 67 35 52
6 Sp. Albatera Albatera 30 76 49 52
7 G. Caliche G. Caliche 30 69 50 50
8 Daya Nueva Atletic Daya Nueva. 30 78 62 48
9 Atl. Orihuela Atl. 30 67 49 41
10 Formentera Formentera 30 40 60 37
11 Atlético Algorfa Atlético 30 57 72 33
12 Thader B Thader B 30 43 65 33
13 Sporting Orihuela Sporting 30 51 68 29
14 Benijofar Benijofar 30 47 70 28
15 SC Torrevieja B Torrevieja 30 43 97 13
16 Montesinos Todo Deporte Montesinos 30 13 163 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Murada Murada 26 67 27 59
2 S. Fulgencio Fulgencio 26 82 36 54
3 Sporting Orihuela Sporting 27 58 41 53
4 Atl. Orihuela Atl. 26 72 45 49
5 Benijofar Benijofar 26 67 38 47
6 G. Caliche G. Caliche 25 68 39 43
7 Bigastro Bigastro 26 64 34 41
8 CFP Orihuela Deportiva Orihuela 26 55 45 41
9 Daya Nueva Atletic Daya Nueva. 26 67 52 38
10 Formentera Formentera 26 41 65 28
11 Atlético Algorfa Atlético 25 35 64 24
12 Redovan B Redovan B 26 42 60 19
13 Thader B Thader B 26 35 87 19
14 Playas de Orihuela Playas 1 1 0 3
15 Montesinos Todo Deporte Montesinos 26 14 135 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 S. Guardamar CF Guardamar 25 49 16 57
2 Il-Licitana Raval A Il-Licitana 26 81 26 55
3 Crevillente Crevillente 26 56 35 53
4 Ciutat d'Elx RCF Ciutat d'Elx 26 64 39 49
5 Daya Nueva Atletic Daya Nueva. 26 64 42 44
6 Elche Sporting Elche 26 68 60 37
7 S. Fulgencio Fulgencio 26 41 41 37
8 UD Aspense UD Aspense 26 65 57 36
9 Algueña Cf Algueña Cf 26 43 44 34
10 San Isidro A Isidro 26 43 57 34
11 Santa Pola Santa Pola 25 53 55 32
12 Almoradi B Almoradi B 25 25 62 18
13 Formentera Formentera 24 21 56 15
14 Altet B Altet B 25 17 100 8
15 Crevillente Deportivo B Crevillente 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Dolores Dolores 30 88 22 72
2 San Miguel CF Miguel 30 83 35 66
3 Playas de Orihuela Playas 30 75 26 66
4 CD Montesinos A Montesinos 30 59 25 61
5 Benijofar Benijofar 30 68 41 57
6 S. Fulgencio Fulgencio 30 57 23 54
7 Murada Murada 30 78 48 53
8 Almoradi B Almoradi B 30 50 43 51
9 Deportivo Orihuela Deportivo 30 56 40 49
10 G. Caliche G. Caliche 30 73 69 44
11 Callosa D. B Callosa 30 42 59 41
12 Sporting Orihuela Sporting 30 58 61 32
13 Borneo Borneo 30 47 76 31
14 Benejuzar Benejuzar 30 44 98 23
15 Formentera Formentera 30 32 67 21
16 Montesinos Todo Deporte Montesinos 30 42 122 16
17 San Isidro A Isidro 30 48 105 16
18 R. Orihuela A Orihuela 30 35 75 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Bigastro Bigastro 33 89 17 82
2 Sporting Orihuela Sporting 33 70 30 77
3 Dolores Dolores 32 91 26 72
4 Almoradi B Almoradi B 33 82 29 70
5 San Miguel CF Miguel 33 68 44 58
6 CD Montesinos A Montesinos 33 76 58 57
7 Playas de Orihuela Playas 32 66 38 55
8 Formentera Formentera 33 60 44 52
9 Benijofar Benijofar 33 72 61 52
10 Callosa D. B Callosa 33 69 63 45
11 G. Caliche G. Caliche 32 70 57 44
12 Benejuzar Benejuzar 33 50 88 36
13 Borneo Borneo 33 55 77 33
14 Murada Murada 33 50 77 32
15 Crevillente Crevillente 32 44 75 31
16 R. Orihuela A Orihuela 34 35 99 14
17 Montesinos Todo Deporte Montesinos 32 29 106 13
18 San Isidro A Isidro 33 33 120 13

  USO DE MEMORIA  
5,446,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0732
Total Execution Time  0.0751
  CADENA URL  
/segunda_regional_valencia2021/grupo15/historico
  GET DATOS  
$_GET['/segunda_regional_valencia2021/grupo15/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_regional_valencia2021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_valencia' AND (l.group_code = 15 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=15 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1138 ORDER BY order_id ASC
0.0020  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 = 59574 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1138 AND group_code = 15 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  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 = 59574 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 45324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39674 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 35318 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 16892 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 7127 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 06:20:52' 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-05-07 06:20:52' 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=4 AND last_update > '2024-05-07 06:20:52' 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-05-07 06:20:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_valencia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2021 e ON e.player_id = p.id AND e.league_id = 59574 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59574 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 events2021 e ON e.player_id = p.id AND e.league_id = 59574 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59574 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 events2021 e ON e.player_id = p.id AND e.league_id = 59574 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59574 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  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 = 59574 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC