4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Frontera FC
TEMPORADA 2023/2024
APERTURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 CS Marítimo Marítimo 7 10 5 13
2 Atlético La Cruz Atlético 7 9 6 13
3 Dynamo Puerto La Cruz Dynamo 7 8 6 11
4 Academia Anzoátegui Academia 7 6 6 11
5 Deportivo Miranda Deportivo 7 4 4 9
6 Fundación AIFI Fundación 8 5 8 9
7 Nueva Esparta FC Nueva 7 4 5 6
8 Bolivar SC Bolivar SC 8 4 10 6
9 Yaracuyanos Yaracuyanos 7 10 3 16
10 Héroes de Falcón Héroes 7 9 5 11
11 Atlético El Vigía FC Atlético 7 15 14 10
12 Trujillanos Trujillanos 7 7 6 10
13 Real Frontera FC Real 7 7 9 8
14 Aragua FC Aragua FC 7 7 9 6
15 Ureña Ureña 7 11 16 6
16 Academia Rey Academia 7 5 9 5
TEMPORADA 2022/2023
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 CS Marítimo Marítimo 14 23 16 25
2 Dynamo Puerto La Cruz Dynamo 14 21 18 22
3 Bolivar SC Bolivar SC 14 19 12 21
4 Fundación AIFI Fundación 14 14 13 20
5 Academia Anzoátegui Academia 14 13 12 16
6 Deportivo Miranda Deportivo 14 15 17 16
7 Nueva Esparta FC Nueva 14 9 13 13
8 Atlético La Cruz Atlético 14 12 25 13
9 Ureña Ureña 13 19 7 25
10 Yaracuyanos Yaracuyanos 14 17 10 23
11 Titanes FC Titanes FC 14 18 15 23
12 Atlético El Vigía FC Atlético 14 18 12 22
13 Héroes de Falcón Héroes 14 20 17 21
14 Trujillanos Trujillanos 14 14 14 18
15 Real Frontera FC Real 13 16 23 15
16 Academia Rey Academia 14 12 36 2
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN VENEZUELA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético La Cruz Atlético 18 22 11 34
2 Yaracuyanos Yaracuyanos 18 28 18 34
3 Academia Anzoátegui Academia 18 30 16 30
4 Angostura Angostura 18 23 18 27
5 Deportivo Miranda Deportivo 18 15 13 25
6 Bolivar SC Bolivar SC 18 20 21 25
7 Fundación AIFI Fundación 18 18 21 22
8 Nueva Esparta FC Nueva 18 14 20 21
9 Libertador Libertador 18 13 23 15
10 Dynamo Puerto La Cruz Dynamo 18 12 34 10
11 Titanes FC Titanes FC 18 28 16 35
12 Rayo Zuliano Rayo Zuliano 18 37 22 31
13 Ureña Ureña 18 16 21 29
14 Héroes de Falcón Héroes 18 21 18 26
15 Academia Rey Academia 18 21 19 26
16 Real Frontera FC Real 18 18 16 25
17 Trujillanos Trujillanos 18 20 15 24
18 Atlético El Vigía FC Atlético 18 20 19 21
19 ULA Mérida ULA Mérida 18 19 28 18
20 Llaneros de Guanare Llaneros 18 10 36 9
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Atlético La Cruz Atlético 14 22 10 28
2 Libertador Libertador 14 21 7 26
3 Bolivar SC Bolivar SC 14 15 7 26
4 Deportivo Miranda Deportivo 14 17 11 22
5 Fundación AIFI Fundación 14 18 20 20
6 Angostura Angostura 14 20 14 17
7 Dynamo Puerto La Cruz Dynamo 14 22 25 14
8 AC Minervén Minervén 14 9 50 1
9 Ureña Ureña 18 31 18 34
10 Academia Rey Academia 18 30 12 32
11 Titanes FC Titanes FC 18 27 16 31
12 ULA Mérida ULA Mérida 18 25 14 28
13 Real Frontera FC Real 18 25 21 28
14 Yaracuy Yaracuy 18 23 20 27
15 Atlético El Vigía FC Atlético 18 24 21 25
16 Rayo Zuliano Rayo Zuliano 18 11 14 22
17 Deportivo JBL del Zulia Deportivo 18 9 31 8
18 Llaneros de Guanare Llaneros 18 15 53 7
TEMPORADA 2019/2020
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Ureña Ureña 10 16 7 23
2 Inter De Barinas Inter 10 21 12 20
3 ULA Mérida ULA Mérida 10 16 16 15
4 Atlético El Vigía FC Atlético 10 14 16 11
5 Deportivo JBL del Zulia Deportivo 10 12 16 11
6 Real Frontera FC Real 10 12 24 4
7 Llaneros de Guanare Llaneros 10 14 8 21
8 UCV UCV 10 10 4 19
9 Yaracuy Yaracuy 10 10 9 13
10 Academia Rey Academia 10 7 8 12
11 Angostura Angostura 10 6 9 8
12 Fundación AIFI Fundación 10 6 15 5
TEMPORADA 2018/2019
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Atl. Furrial Atl. Furrial 10 16 8 20
2 Yaracuyanos Yaracuyanos 10 18 8 19
3 Deportivo Miranda Deportivo 10 12 11 17
4 Yaracuy Yaracuy 10 14 12 16
5 Libertador Libertador 10 7 14 7
6 Gran Valencia Gran 10 10 24 7
7 Titanes FC Titanes FC 12 25 17 26
8 Atlético El Vigía FC Atlético 12 25 12 24
9 Inter De Barinas Inter 12 23 19 21
10 Real Frontera FC Real 12 22 19 17
11 Deportivo JBL del Zulia Deportivo 12 33 31 14
12 ULA Mérida ULA Mérida 12 19 28 10
13 Ureña Ureña 12 8 29 5
14 Angostura Angostura 12 26 11 25
15 Petroleros de Anzoátegui Petroleros 12 20 10 25
16 UCV UCV 12 14 8 22
17 Fundación AIFI Fundación 12 14 18 16
18 Ciudad Vinotinto Ciudad 12 8 13 10
19 Dynamo Puerto La Cruz Dynamo 12 9 20 9
20 Chicó de Guayana Chicó 12 10 21 8
TEMPORADA 2017/2018
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Margarita Margarita 20 33 25 38
2 LALA LALA 20 27 19 37
3 Gran Valencia Gran 20 24 21 32
4 Angostura Angostura 20 24 17 31
5 Chicó de Guayana Chicó 20 22 20 31
6 Yaracuy Yaracuy 20 38 31 30
7 Atl. Furrial Atl. Furrial 20 19 20 23
8 Petroleros de Anzoátegui Petroleros 20 25 28 23
9 Libertador Libertador 20 21 31 23
10 Deportivo Miranda Deportivo 20 18 25 21
11 UCV UCV 20 18 32 17
12 ULA Mérida ULA Mérida 18 36 21 36
13 Llaneros de Guanare Llaneros 18 27 20 34
14 Ureña Ureña 18 45 28 33
15 Titanes FC Titanes FC 18 25 17 28
16 Real Frontera FC Real 18 28 25 26
17 Inter De Barinas Inter 18 24 25 22
18 Atlético El Vigía FC Atlético 18 26 28 21
19 Deportivo JBL del Zulia Deportivo 18 23 33 20
20 Yaracuyanos Yaracuyanos 18 22 37 12
21 Falcon Falcon 18 20 42 10
TEMPORADA 2016/2017
TRANSICIÓN SEGUNDA VENEZUELA GRUPO 5
Equipo PJ GF GC Puntos
1 Yaracuyanos Yaracuyanos 6 4 2 11
2 Yaracuy Yaracuy 6 10 6 10
3 Caracas II Caracas II 6 7 8 7
4 Deportivo Miranda Deportivo 6 2 7 5
5 Real Frontera FC Real 6 12 9 12
6 Zamora II Zamora II 6 10 8 9
7 Atlético Guanare Atlético 6 9 10 7
8 Titanes FC Titanes FC 6 3 7 7
9 Margarita Margarita 6 9 3 12
10 Chicó de Guayana Chicó 6 12 7 12
11 Atlético Venezuela II Atlético 6 4 4 8
12 Tucanes FC Tucanes FC 6 4 15 1
TEMPORADA 2015/2016
APERTURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Puerto Cabello Puerto 28 59 36 53
2 Yaracuyanos Yaracuyanos 28 39 24 47
3 UCV UCV 28 35 26 45
4 Caracas II Caracas II 28 33 29 37
5 Tucanes FC Tucanes FC 28 26 36 35
6 Atlético Venezuela II Atlético 28 34 34 33
7 Gran Valencia Gran 28 34 51 29
8 Arroceros de Calabozo Arroceros 28 28 52 21
9 Atlético El Vigía FC Atlético 28 61 22 65
10 Atlético Socopó Atlético 28 44 28 55
11 Falcon Falcon 28 58 34 53
12 Zamora II Zamora II 28 43 38 39
13 Titanes FC Titanes FC 28 42 50 35
14 Real Frontera FC Real 28 27 32 30
15 Potros de Barinas Potros 28 38 45 29
16 Policia de Lara Policia Lara 28 9 73 9
17 Metropolitanos Metropolitan 28 48 25 55
18 Petroleros de Anzoátegui Petroleros 28 48 23 50
19 LALA LALA 28 42 25 49
20 Angostura Angostura 28 45 40 46
21 Chicó de Guayana Chicó 28 44 54 36
22 Margarita Margarita 28 39 51 34
23 Deportivo La Guaira II Deportivo 28 33 45 26
24 Mineros de Guayana B Mineros 28 23 59 16

  USO DE MEMORIA  
5,963,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4266
Total Execution Time  0.4279
  CADENA URL  
/historico/Real-Frontera-Fc
  GET DATOS  
$_GET['/historico/Real-Frontera-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0255  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 = 75625
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=84199 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=212 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 212 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1154368,604889,405850,273503,253908) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '84199' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '84199' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 75625 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 = 84199 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 `tables2024` 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 = 75625 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2023` 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 = 71250 AND t.round = 14 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 `tables2023` 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 = 72919 AND t.round = 14 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 `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 = 67091 AND t.round = 18 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 `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 = 62639 AND t.round = 9 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 `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 = 63309 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 55451 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 59975 AND t.round = 10 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 `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 = 48931 AND t.round = 14 ORDER BY team.conference 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 `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 = 50191 AND t.round = 14 ORDER BY team.conference 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 `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 = 42703 AND t.round = 22 ORDER BY team.conference 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 `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 = 44558 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 37784 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 41776 AND t.round = 6 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 = 15537 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC