4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2023
 
Primera División Venezuela 2023
2022/2023

Final Campeonato

Primera División Venezuela 2023

28 jugadores
Caracas Caracas
A. Baroja A. Baroja 34 años 183cm 81kg POR
Frankarlos Benítez Frankarlos Benítez 20 años 184cm 70kg POR
W. Hernández W. Hernández 23 años 185cm 82kg POR
D. Luna D. Luna 24 años 184cm 81kg DEF
A. González A. González 31 años 177cm 75kg DEF
Luis Casiani Luis Casiani 22 años 176cm 72kg DEF
R. Manríque R. Manríque 25 años 183cm 70kg DEF
Renné Rivas Renné Rivas 21 años 183cm 78kg DEF
G. Guzmán G. Guzmán 22 años 187cm 86kg DEF
Luis Urbina Luis Urbina 22 años 174cm 68kg DEF
L. Salazar L. Salazar 21 años 184cm DEF
R. Quijada R. Quijada 35 años 186cm 77kg DEF
B. Tamayo B. Tamayo 19 años 185cm 80kg DEF
A. Kinsler A. Kinsler DEF
Bryant Ortega Bryant Ortega 21 años 175cm 63kg MED
D. Padilla D. Padilla 19 años 168cm 57kg MED
L. Flores L. Flores 28 años 176cm 70kg MED
V. Rodríguez V. Rodríguez 34 años 177cm 71kg MED
A. Contreras A. Contreras 23 años 176cm 62kg MED
Ade Oguns Ade Oguns 23 años 179cm 81kg DEL
M. Sulbarán M. Sulbarán 21 años 165cm 59kg DEL
E. Echenique E. Echenique 20 años 170cm 62kg DEL
R. Celis R. Celis 28 años 178cm 62kg DEL
Saúl Guarirapa Saúl Guarirapa 21 años 189cm 78kg DEL
A. Rivas A. Rivas 21 años 172cm 62kg DEL
E. Mercado E. Mercado 27 años 184cm 71kg DEL
E. Rivas E. Rivas 22 años 186cm 77kg DEL
N. Jiménez N. Jiménez 21 años 175cm 66kg DEL
26 jugadores
Deportivo Táchira Deportivo
Alejandro Araque Alejandro Araque 28 años 180cm 70kg POR
J. Camargo J. Camargo 26 años 183cm 82kg POR
Yanniel Hernández Yanniel Hernández 26 años 173cm 66kg DEF
N. Hernandez N. Hernandez 31 años 170cm 73kg DEF
G. Mottes G. Mottes 26 años 192cm DEF
C. Calzadilla C. Calzadilla 22 años 181cm 72kg DEF
J. Sánchez J. Sánchez 18 años DEF
Carlos Vivas Carlos Vivas 22 años 182cm 72kg DEF
J. Marrufo J. Marrufo 27 años 183cm 81kg DEF
J. Ramos J. Ramos 27 años 186cm 75kg DEF
P. Camacho P. Camacho 33 años 178cm 81kg DEF
G. Ritacco G. Ritacco 30 años 175cm 70kg MED
C. Méndez C. Méndez 20 años 165cm MED
J. Figueroa J. Figueroa 31 años 175cm 73kg MED
M. Cova M. Cova 31 años 173cm 59kg MED
L. Fioravanti L. Fioravanti 32 años 178cm 81kg MED
D. Díaz D. Díaz 34 años 170cm 67kg MED
L. Carrero L. Carrero 17 años 173cm MED
J. Castillo J. Castillo 21 años 168cm 66kg DEL
A. Uribe A. Uribe 33 años 181cm 80kg DEL
Yerson Chacón Yerson Chacón 20 años 169cm 57kg DEL
K. Aladesanmi K. Aladesanmi 25 años 183cm 74kg DEL
B. Castillo B. Castillo 22 años 186cm 70kg DEL
E. García E. García 23 años 165cm 55kg DEL
Jesús Duarte Jesús Duarte 18 años 170cm DEL
Armando Araque Armando Araque 35 años 183cm 75kg DEL

JUGADORES DESTACADOS

Nombre Goles Equipo
J. Castillo ve J. Castillo 1 TAC Deportivo Táchira
Bryant Ortega ve Bryant Ortega 1 CFC Caracas

Equipos de esta liga

2

  USO DE MEMORIA  
4,462,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3424
Total Execution Time  0.3443
  CADENA URL  
/torneo_transicion_venezuela2023/grupo0/jugadores
  GET DATOS  
$_GET['/torneo_transicion_venezuela2023/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0127  SELECT type FROM routes WHERE alias = 'torneo_transicion_venezuela2023'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_transicion_venezuela' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1807 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1807 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0141  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 (1255428,1251694,1244507,1234211,1233134) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1807 ORDER BY order_id ASC
0.0131  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1807 GROUP BY l.categoryId
0.0132  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1807 GROUP BY l.year ORDER BY l.year DESC
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 = 74564 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74564 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0139  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 74564 AND dt.id IN (5602,3606) ORDER BY dt.relations DESC,dp.role ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 04:08:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 04:08:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 04:08:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 04:08:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 events2023 e ON e.player_id = p.id AND e.league_id = 74564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74564 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.0149  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 events2023 e ON e.player_id = p.id AND e.league_id = 74564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74564 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  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 events2023 e ON e.player_id = p.id AND e.league_id = 74564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74564 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10