4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pego B
TEMPORADA 2021/2022
2ª SAFOR INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Villalonga B Villalonga 23 102 5 65
2 Club Tenis de Oliva Club Tenis. 23 112 14 60
3 La Font D'encarros A Font 23 102 12 55
4 Piles Piles 24 88 32 51
5 Castello Les Gerres Castello 24 81 51 39
6 Rotova Rotova 23 47 65 33
7 Real de Gandia B Real Gandia 24 41 53 27
8 Portuarios Disarp B Portuarios 24 35 79 27
9 Javea B Javea B 24 45 82 23
10 Oliva C Oliva C 23 31 75 20
11 Bellreguard B Bellreguard 23 21 71 18
12 Pego B Pego B 24 27 70 17
13 Pedreguer C Pedreguer C 24 23 146 6
TEMPORADA 2019/2020
2ª VALENCIA INFANTIL GRUPO 14
Equipo PJ GF GC Puntos
1 Miramar Miramar 11 47 4 31
2 Castello Les Gerres Castello 11 46 9 28
3 Almoines A Almoines A 11 53 9 26
4 Rotova A Rotova A 11 34 7 25
5 CAE Bellreguard '' B' ' Bellreguard 10 28 19 24
6 La Oliva AF La Oliva AF 11 30 11 22
7 Pego B Pego B 10 28 22 17
8 CE Emf Pedreguer 'b' Pedreguer 11 26 28 17
9 Beniopa A Beniopa A 11 29 29 14
10 Esportiu Beniarjo A Esportiu 11 20 27 11
11 Tavernes de La Valldigna B Tavernes 10 25 35 10
12 Benirredra B Benirredra 11 11 43 9
13 CDF Javea 'c' Javea 11 9 46 7
14 Denia D Denia D 11 13 49 5
15 La Font D'encarros A Font 10 13 43 3
16 CE Esport Viu Ondara 'b' Esport 11 7 38 0
TEMPORADA 2018/2019
2ª ALICANTE INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Pego B Pego B 30 228 26 85
2 Calpe A Calpe A 30 160 25 77
3 Finestrat A Finestrat A 30 116 45 66
4 Teulada Moraira A Teulada 30 147 54 65
5 Javea C Javea C 30 102 56 60
6 Pedreguer Sub 14 Pedreguer 30 105 42 58
7 Denia C Denia C 30 124 56 56
8 SFFCV Benidorm A SFFCV 30 95 64 51
9 Altea A Altea A 30 74 73 44
10 Cef El Verger A Verger 30 47 75 31
11 Esport Viu Ondara A Esport 30 75 102 29
12 Alfaz Pi B Alfaz Pi B 30 52 124 26
13 La Nucia C La Nucia C 30 47 126 23
14 Callosa Callosa 30 45 185 15
15 Benisa B Benisa B 30 26 186 4
16 Ciudad Benidorm D Ciudad 30 20 224 3
TEMPORADA 2017/2018
2ª SAFOR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Gandia Sub 14 B Gandia 24 132 11 69
2 Benirredra B Benirredra 24 132 21 66
3 Pego B Pego B 24 102 38 54
4 Tavernes de La Valldigna C Tavernes 24 114 45 52
5 Ath. Xeresa Ath. Xeresa 24 73 33 40
6 Miramar Miramar 23 60 53 36
7 Benifaio B Benifaio B 24 62 93 28
8 Benifairo La Valldigna A Benifairo 24 71 117 28
9 Oliva C Oliva C 24 43 69 25
10 La Font D'encarros B Font 24 37 76 21
11 Promeses Sueca B Promeses 24 43 78 20
12 Esportiu Beniarjo A Esportiu 23 23 123 9
13 Cullera C Cullera C 24 34 169 5
TEMPORADA 2016/2017
2ª SAFOR INFANTIL
Equipo PJ GF GC Puntos
1 Unió Esportiva Gandia C Unió 30 121 23 77
2 Miramar Miramar 30 108 35 77
3 Villalonga Villalonga 30 110 31 73
4 Pego B Pego B 30 80 30 59
5 Castello Les Gerres Castello 30 77 51 59
6 Beniopa A Beniopa A 30 69 61 47
7 Oliva B Oliva B 29 57 58 41
8 Rotova A Rotova A 30 54 87 36
9 Denia D Denia D 30 28 41 33
10 Piles Piles 30 63 131 33
11 Javea B Javea B 30 67 97 31
12 Almoines A Almoines A 29 45 68 30
13 Xeraco Xeraco 30 36 77 27
14 Gandia Sub 14 B Gandia 30 52 92 22
15 Benirredra Sub 14 Benirredra 30 38 84 21
16 Conde Conde 30 46 85 19
TEMPORADA 2015/2016
2ª SAFOR INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Beniopa A Beniopa A 28 170 16 82
2 Miramar Miramar 28 118 38 70
3 Tavernes de La Valldigna B Tavernes 28 87 32 64
4 UE Gandia B UE Gandia B 28 63 31 53
5 Castello Les Gerres Castello 28 78 42 51
6 Benirredra Sub 14 Benirredra 28 40 36 46
7 Javea B Javea B 28 62 52 38
8 Bellreguard B Bellreguard 28 61 70 35
9 Pego B Pego B 28 61 102 32
10 La Font D'encarros Font 28 76 76 32
11 Conde Conde 28 41 48 28
12 Oliva B Oliva B 28 44 74 24
13 Denia D Denia D 28 39 105 18
14 Rotova A Rotova A 28 43 181 15
15 Villalonga Villalonga 28 35 115 14

  USO DE MEMORIA  
5,144,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5452
Total Execution Time  0.5464
  CADENA URL  
/historico/Pego-Cf-B-Infantil
  GET DATOS  
$_GET['/historico/Pego-Cf-B-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0150  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Pego-Cf-B-Infantil' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0165  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Pego-Cf-B-Infantil' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=79373 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0182  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 65166
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=79373 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1155 AND type_rel = 3
0.0164  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '79373' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0163  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '79373' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 65166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=79373 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0147  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (65166) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65166 AND teamId = 79373
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 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 = 65166 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '79373' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0154  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '79373' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 79373 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0169  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_base` 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 = 65166 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0177  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_base` 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 = 46511 AND t.round = 30 ORDER BY team.conference 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 `tables2018_base` 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 = 40985 AND t.round = 26 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_base` 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 = 36219 AND t.round = 30 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_base` 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 = 19122 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC