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 Ontinyent 1931 Ontinyent 13 38 8 39
2 Contestano Contestano 13 42 12 33
3 SB Ontinyent Ontinyent 13 36 14 32
4 Villena Villena 13 33 18 27
5 C.F. C Ciudad de Alcoy C.F. Ciudad 13 25 19 20
6 Algueña Cf Algueña Cf 13 23 19 18
7 Pinoso Pinoso 13 18 22 17
8 Moixent C.F. Moixent C.F. 13 21 17 16
9 Sax Sax 13 28 27 16
10 Montaverner Montaverner 13 21 31 16
11 Rayo Ibense B Rayo Ibense 13 17 31 10
12 Caramanchel A Caramanchel 13 11 32 6
13 Beniarres Beniarres 13 10 38 6
14 Atletic Muro A Atletic Muro 13 10 45 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Santa Pola Cf Santa Pola 24 51 17 51
2 Il-Licitana Raval A Il-Licitana 24 45 23 43
3 San Miguel CF Miguel 24 38 34 42
4 Sax Sax 24 46 36 40
5 Atlético Catral Atlético 24 45 29 39
6 Callosa D. B Callosa 24 31 26 37
7 Rafal Rafal 24 32 29 37
8 Cox Cox 24 32 35 34
9 H. Nieves H. Nieves 24 42 42 32
10 Altet Altet 24 41 44 32
11 Torrevieja Torrevieja 24 26 29 31
12 CFP Orihuela Deportiva Orihuela 24 34 42 29
13 Castalla Castalla 24 56 58 27
14 Algueña Cf Algueña Cf 24 27 40 23
15 S. Fulgencio Fulgencio 24 25 56 16
16 Monovar C.D. Monovar C.D. 24 23 54 16
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 AC Torrellano Torrellano 30 74 31 68
2 Murada Murada 30 56 23 67
3 San Miguel CF Miguel 30 50 31 55
4 Santa Pola Cf Santa Pola 30 56 31 54
5 H. Nieves H. Nieves 30 52 45 52
6 Santa Pola Santa Pola 30 69 29 51
7 S. Fulgencio Fulgencio 30 52 57 44
8 Monovar C.D. Monovar C.D. 29 47 47 38
9 Callosa D. B Callosa 30 36 48 35
10 Atlético Catral Atlético 30 43 44 34
11 Altet Altet 30 47 62 34
12 Rafal Rafal 30 43 56 33
13 Dolores Dolores 30 40 59 31
14 Betis Florida Betis 29 44 63 30
15 CD Montesinos A Montesinos 30 37 40 29
16 Monforte Monforte 30 36 116 15
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 30 85 18 76
2 UD Horadada UD Horadada 30 60 17 66
3 Santa Pola Cf Santa Pola 30 58 30 52
4 CD Montesinos A Montesinos 30 75 54 50
5 San Miguel CF Miguel 30 48 34 50
6 Dolores Dolores 29 42 46 42
7 Atlético Catral Atlético 30 36 41 40
8 Santa Pola Santa Pola 30 57 57 39
9 Rafal Rafal 30 47 44 37
10 Callosa D. B Callosa 30 49 53 37
11 CF San Gabriel Gabriel 29 53 66 37
12 Altet Altet 30 32 51 37
13 H. Nieves H. Nieves 30 48 58 34
14 S. Guardamar CF Guardamar 30 32 49 31
15 Cox Cox 30 31 69 25
16 SC Torrevieja CF Torrevieja 30 26 92 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Monforte Monforte 30 51 25 61
2 Rafal Rafal 30 64 36 58
3 Pinoso Pinoso 30 57 35 58
4 Santa Pola Santa Pola 30 56 41 50
5 Santa Pola Santa Pola 30 60 43 47
6 Atlético Catral Atlético 30 40 31 45
7 Dolores Dolores 29 48 39 44
8 San Miguel CF Miguel 29 54 39 42
9 UD Horadada UD Horadada 30 35 38 42
10 Algorfa Algorfa 30 40 44 41
11 Altet Altet 30 41 38 40
12 H. Nieves H. Nieves 29 45 50 39
13 SC Torrevieja CF Torrevieja 30 43 64 31
14 Bigastro Bigastro 30 35 44 29
15 AC Torrellano Torrellano 29 39 70 20
16 Sp. Saladar Sp. Saladar 30 32 103 7
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Redovan Redovan 30 73 27 71
2 Carrús UD Ilicitana Carrús 30 68 22 70
3 Santa Pola Santa Pola 30 73 43 60
4 Altet Altet 30 52 36 58
5 Aspe UD Aspe UD 30 49 39 51
6 Pinoso Pinoso 30 51 31 45
7 Algorfa Algorfa 30 59 39 45
8 Atlético Catral Atlético 30 55 51 41
9 Bigastro Bigastro 30 47 52 38
10 Santa Pola Santa Pola 30 51 66 37
11 SC Torrevieja CF Torrevieja 30 46 55 33
12 Sp. Saladar Sp. Saladar 30 45 67 30
13 AC Torrellano Torrellano 30 50 58 28
14 Algueña Cf Algueña Cf 30 37 72 21
15 Coca de Aspe Coca Aspe 30 44 87 20
16 Albaterense Albaterense 30 30 85 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Rafal Rafal 30 57 34 57
2 Jove Espanyol B Jove 30 60 35 54
3 Atlético Catral Atlético 30 50 34 54
4 H. Nieves H. Nieves 30 49 38 54
5 Carrús UD Ilicitana Carrús 30 63 24 53
6 Aspe UD Aspe UD 30 51 46 45
7 SC Torrevieja CF Torrevieja 30 47 51 43
8 Albaterense Albaterense 30 53 40 42
9 Redovan Redovan 30 40 36 40
10 Coca de Aspe Coca Aspe 30 45 43 39
11 Santa Pola Santa Pola 30 38 35 38
12 Algorfa Algorfa 30 45 52 32
13 Orihuela B Orihuela B 29 40 55 31
14 Sp. Saladar Sp. Saladar 29 47 73 29
15 S. Fulgencio Fulgencio 30 37 68 24
16 Alicante Rvo. A Alicante 30 25 83 17

  USO DE MEMORIA  
5,603,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0725
Total Execution Time  0.0744
  CADENA URL  
/primera_regional_valenciana2021/grupo8/historico
  GET DATOS  
$_GET['/primera_regional_valenciana2021/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_valenciana' AND (l.group_code = 8 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=8 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1137 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 = 59532 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1137 AND group_code = 8 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0021  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 = 59532 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.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 `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 = 51333 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 45237 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 = 39368 AND t.round = 30 ORDER BY team.conference 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 `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 = 34298 AND t.round = 30 ORDER BY team.conference 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 `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 = 16847 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 = 7091 AND t.round = 30 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-06 20:43:40' 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-06 20:43:40' 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-06 20:43:40' 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-06 20:43:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 59532 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59532 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.0019  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 = 59532 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59532 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 59532 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59532 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 59532 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