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 Gorgos Gorgos 13 39 13 29
2 Benissa Benissa 13 25 11 29
3 CF Cullera CF Cullera 13 27 14 26
4 UD Oliva UD Oliva 13 25 17 24
5 Simat Simat 13 20 9 23
6 La Font D'encarros Font 13 26 16 21
7 UE Benifairó Benifairó 13 24 21 21
8 Real de Gandia Real Gandia 13 20 16 19
9 Xeraco Xeraco 13 13 28 15
10 Ciutat D'Alzira Futbol Base Ciutat 13 16 29 14
11 Safor CF Gandia Safor Gandia 13 14 29 11
12 Senyera Senyera 13 14 26 10
13 Bellreguard Bellreguard 13 10 25 9
14 UD Ondarense Ondarense 13 11 30 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Calpe Calpe 23 65 24 54
2 La Nucia B La Nucia B 24 55 25 53
3 Novelda UCF Novelda UCF 23 37 19 45
4 UD Aspe UD Aspe 23 36 29 41
5 UD Altea UD Altea 24 47 33 39
6 Betis Florida Betis 24 36 37 34
7 Gorgos Gorgos 24 46 44 31
8 Racing de San Gabriel Racing 24 32 40 31
9 El Campello El Campello 24 44 36 30
10 Alicante City Alicante 24 48 56 30
11 Salesianos Alicante Salesianos 24 43 54 28
12 Mutxamel Mutxamel 23 34 49 27
13 Atletico Jonense Atletico 24 46 53 25
14 Polop Polop 24 27 40 25
15 Benissa Benissa 24 35 51 23
16 UD Ondarense Ondarense 24 19 60 11
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CF Benidorm CF Benidorm 28 54 27 63
2 Pedreguer Pedreguer 28 62 21 61
3 La Nucia B La Nucia B 28 69 25 59
4 UD Altea UD Altea 28 65 36 58
5 Il-Licitana Raval A Il-Licitana 28 55 35 47
6 El Campello El Campello 28 45 36 44
7 Mutxamel Mutxamel 28 50 45 41
8 Caramanchel A Caramanchel 28 32 47 34
9 Gorgos Gorgos 28 49 59 33
10 San Gabriel A Gabriel 28 45 50 32
11 Benissa Benissa 28 36 47 32
12 Polop Polop 28 35 57 26
13 UD Ondarense Ondarense 28 33 55 22
14 Mediterraneo CF Mediterraneo 28 40 69 19
15 Coca de Aspe Coca Aspe 28 25 86 10
16 Novelda B Novelda B 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Pego Pego 30 85 22 75
2 Rafelcofer Rafelcofer 30 57 31 68
3 UD Oliva UD Oliva 30 60 47 49
4 UD Altea UD Altea 30 52 39 49
5 El Campello El Campello 30 43 37 45
6 Gorgos Gorgos 30 52 54 44
7 Real de Gandia Real Gandia 30 50 55 42
8 Mutxamel Mutxamel 30 54 50 40
9 Pedreguer Pedreguer 30 50 59 37
10 UD Ondarense Ondarense 29 36 55 36
11 Benissa Benissa 30 36 57 36
12 Alginet B Alginet B 30 53 68 35
13 Orba Orba 30 43 52 33
14 Polop Polop 29 45 57 31
15 Benirredra Benirredra 30 55 77 30
16 Xeraco Xeraco 30 44 55 28
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 C. Benidorm C. Benidorm 29 56 26 63
2 Rafelcofer Rafelcofer 28 64 34 62
3 CFI Alicante Alicante 29 79 39 59
4 San Gabriel A Gabriel 28 47 41 45
5 D. La Voz D. La Voz 29 54 49 44
6 Polop Polop 30 58 55 41
7 Real de Gandia Real Gandia 29 43 45 39
8 Xeraco Xeraco 29 33 49 39
9 UD Ondarense Ondarense 29 42 42 38
10 Pedreguer Pedreguer 28 60 50 37
11 Orba Orba 28 47 53 36
12 Mutxamel Mutxamel 29 39 37 35
13 El Campello El Campello 30 33 37 34
14 Font d'en Carròs Font d'en C. 29 35 50 30
15 CF Cullera CF Cullera 30 45 82 25
16 Jove Espanyol B Jove 30 35 81 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 UD Altea UD Altea 30 73 31 73
2 San Joan San Joan 30 82 23 73
3 Pedreguer Pedreguer 30 83 44 59
4 D. La Voz D. La Voz 30 81 50 56
5 Mutxamel Mutxamel 30 63 35 51
6 Polop Polop 30 52 42 46
7 Jove Espanyol B Jove 30 70 43 45
8 Orba Orba 30 48 52 43
9 Rafelcofer Rafelcofer 30 43 56 42
10 El Campello El Campello 30 62 55 39
11 Xeraco Xeraco 30 48 40 38
12 C. Benidorm C. Benidorm 30 35 44 37
13 Real de Gandia Real Gandia 30 36 47 33
14 Benissa Benissa 30 40 45 28
15 Callosa Callosa 30 18 111 9
16 CF Gandia CF Gandia 30 15 131 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Calpe Calpe 30 71 24 70
2 UD Oliva UD Oliva 30 71 23 68
3 San Joan San Joan 30 68 18 65
4 Altet Altet 30 67 32 62
5 Rafelcofer Rafelcofer 30 54 34 54
6 Benissa Benissa 30 46 41 53
7 Mutxamel Mutxamel 29 65 34 49
8 Xeraco Xeraco 30 44 46 42
9 C. Benidorm C. Benidorm 30 45 48 42
10 Polop Polop 28 47 44 37
11 UD Altea UD Altea 30 51 57 35
12 Callosa Callosa 30 44 51 29
13 CF Gandia CF Gandia 30 33 89 22
14 Cullera B Cullera B 29 29 68 18
15 UD Ondarense Ondarense 28 23 88 15
16 Finestrat Finestrat 30 25 86 10

  USO DE MEMORIA  
5,594,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3769
Total Execution Time  0.3788
  CADENA URL  
/primera_regional_valenciana2021/grupo7/historico
  GET DATOS  
$_GET['/primera_regional_valenciana2021/grupo7/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0252  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 = 7 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=7 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1137 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1137 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1115864,973799,932798,909788,909342) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1137 ORDER BY order_id ASC
0.0126  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 = 59531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1137 AND group_code = 7 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 = 59531 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.0129  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 = 51332 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.0130  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 = 45236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 34297 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16846 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 7090 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 09:36:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 09:36:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 09:36:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 09:36:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  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 = 59531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59531 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.0126  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 = 59531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59531 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 = 59531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59531 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 59531 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