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 At. Lliria At. Lliria 24 110 27 64
2 Racing de Paterna Racing 24 72 27 58
3 Benimamet Benimamet 24 64 27 55
4 Los Silos A Los Silos A 24 67 31 47
5 Loriguilla Loriguilla 24 65 40 46
6 Betera B Betera B 24 53 53 36
7 Unio Esprotiva de Rocafort Unio 24 49 44 35
8 Vallbonense B Vallbonense 24 57 59 32
9 Godella B Godella B 24 48 53 32
10 UD Paterna UD Paterna 23 45 50 31
11 Pedralba Pedralba 24 51 60 31
12 Moncada Moncada 24 47 50 26
13 Rayo Santonio Benageber B Rayo 24 52 73 18
14 Losa del Obispo Losa Obispo 23 35 99 13
15 Sp. Rocafort A Rocafort 24 40 82 12
16 Sporting de Manises A Sporting 24 24 104 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Vilamarxant B Vilamarxant 28 103 26 74
2 Cracks Cracks 28 107 25 71
3 Serranos B Serranos B 28 66 32 55
4 S. Almassera Almassera 28 78 38 54
5 Los Silos A Los Silos A 28 70 51 49
6 Atlético Casinos A Atlético 28 63 43 47
7 Sp. Rocafort A Rocafort 28 70 49 41
8 Benimamet Benimamet 28 42 53 37
9 UD Paterna UD Paterna 28 52 73 30
10 Bonrepos i Mirambell B Bonrepos 28 41 78 27
11 Godella B Godella B 28 57 66 26
12 Vallbonense B Vallbonense 28 51 78 24
13 Rayo Santonio Benageber B Rayo 28 40 96 22
14 Sporting de Manises A Sporting 28 37 109 22
15 Mislata B Mislata B 28 44 104 20
16 J. Manisense B Manisense 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Rayo Santonio Benageber B Rayo 30 105 43 74
2 Benisano Benisano 30 71 38 64
3 Cracks Cracks 30 82 40 62
4 Ciutat de Valencia A Ciutat 30 80 32 60
5 Torrefiel Ath. Torrefiel 30 94 56 57
6 Atlético Casinos A Atlético 30 56 48 54
7 Los Silos A Los Silos A 29 75 42 53
8 Mislata B Mislata B 30 72 56 47
9 Sporting de Manises B Sporting 30 72 65 42
10 Ribarroja C Ribarroja C 30 71 75 35
11 Sp. Mislata B Mislata 30 58 68 33
12 Vallbonense B Vallbonense 29 51 75 30
13 Vilamarxant B Vilamarxant 30 44 95 23
14 J. Manisense B Manisense 30 44 81 22
15 Losa del Obispo Losa Obispo 28 48 111 16
16 Benaguasil B Benaguasil 30 31 129 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Ribarroja B Ribarroja B 28 167 13 78
2 Bugarra Bugarra 28 121 32 68
3 Rayo Santonio Benageber B Rayo 28 92 46 60
4 Cracks Cracks 28 123 30 59
5 Benisano Benisano 27 77 27 57
6 Godella B Godella B 28 74 37 53
7 Vilamarxant B Vilamarxant 28 74 51 48
8 Losa del Obispo Losa Obispo 28 60 66 44
9 Atlético Casinos A Atlético 28 47 73 33
10 Q. Manises Q. Manises 28 50 61 31
11 Naquera Naquera 27 56 72 27
12 R. Paterna R. Paterna 28 45 104 24
13 FB Benaguasil C Benaguasil 28 32 108 14
14 C.F. Robella Mislata B C.F. Robella 28 23 164 9
15 San Antonio de Benageber B Antonio 0 0 0 0
16 Benaguasil Benaguasil 28 9 166 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Lliria UD B Lliria UD B 30 91 24 71
2 Bétera Bétera 30 74 22 68
3 Ribarroja B Ribarroja B 30 84 34 63
4 UD Paterna UD Paterna 30 94 43 60
5 Bugarra Bugarra 30 85 39 59
6 Rayo Santonio Benageber B Rayo 30 74 36 57
7 Vilamarxant B Vilamarxant 30 71 44 54
8 Benisano Benisano 30 54 49 42
9 Losa del Obispo Losa Obispo 30 62 72 41
10 Godella B Godella B 30 62 51 39
11 Los Silos B Los Silos B 30 48 71 36
12 La Eliana La Eliana 30 50 48 32
13 R. Paterna R. Paterna 30 43 93 27
14 Sp. Rocafort A Rocafort 30 44 108 20
15 Tuejar Tuejar 30 35 117 7
16 Benaguasil Benaguasil 30 27 147 5
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Bétera Bétera 29 93 24 70
2 Paterna B Paterna B 29 80 23 70
3 Benaguasil Benaguasil 29 76 20 70
4 Bugarra Bugarra 29 75 31 65
5 UD Paterna UD Paterna 29 82 35 55
6 Sp. Rocafort A Rocafort 29 58 56 49
7 Benisano Benisano 28 52 36 46
8 Burjassot B Burjassot B 29 47 65 38
9 R. Benageber B Benageber 29 66 60 35
10 Losa Obispo A Losa Obispo 29 58 56 34
11 Los Silos B Los Silos B 29 34 57 34
12 San Antonio Benagéber Antonio 29 44 66 31
13 Tuejar Tuejar 28 44 70 30
14 Benaguasil Benaguasil 29 42 81 22
15 La Eliana La Eliana 29 25 98 8
16 R. Paterna B Paterna 29 28 126 7

  USO DE MEMORIA  
5,559,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0735
Total Execution Time  0.0755
  CADENA URL  
/segunda_regional_valencia2020/grupo5/historico
  GET DATOS  
$_GET['/segunda_regional_valencia2020/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_regional_valencia2020'
0.0041  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 = 5 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=5 DESC LIMIT 1
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 = 51382 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1138 AND group_code = 5 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 51382 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.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 `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 = 45314 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39664 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 `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 = 35308 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 16882 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 7110 AND t.round = 30 ORDER BY team.conference 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-05-02 04:05:26' 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=2 AND last_update > '2024-05-02 04:05:26' 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-05-02 04:05:26' 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=3 AND last_update > '2024-05-02 04:05:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2020 e ON e.player_id = p.id AND e.league_id = 51382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51382 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 51382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51382 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 events2020 e ON e.player_id = p.id AND e.league_id = 51382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51382 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  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 = 51382 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