4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
13 jugadores
Thimphu City Thimphu City
Tenzin Namgyel Tenzin Namgyel
Dawa Tshering Jr. Dawa Tshering Jr. 26 años DEF
D. Tshering D. Tshering 29 años MED
O. Tshering O. Tshering 24 años MED
Sonam Wangyal Sonam Wangyal 24 años MED
K. Tshering K. Tshering 34 años MED
Abhishek Gurung Abhishek Gurung 21 años MED
A. Beadum A. Beadum MED
T. Namgyel T. Namgyel 21 años MED
K. Tobgay K. Tobgay 32 años MED
C. Gyeltshen C. Gyeltshen 27 años 173cm DEL
Dorji Dorji 28 años 176cm 71kg DEL
K. Rabgay K. Rabgay 26 años DEL
14 jugadores
Transport United Transport United
D. Aakash D. Aakash
Yeewong Tobden Yeewong Tobden
Jersei Jersei
M. Gyabaah M. Gyabaah
U. Dorji U. Dorji
J. Wangchuk J. Wangchuk 21 años DEF
Tenzin Dorji Tenzin Dorji 26 años DEF
T. Drakpa T. Drakpa 21 años DEF
J. Dorjee J. Dorjee 29 años MED
Phurba Tenzin Phurba Tenzin 24 años MED
U. Dorji U. Dorji 31 años MED
Tsenda Dorji Tsenda Dorji 29 años DEL
K. Rai K. Rai 27 años DEL
A. Dave A. Dave 27 años DEL
12 jugadores
Paro FC Paro FC
P. Thinley P. Thinley 26 años DEF
N. Tshering N. Tshering 26 años DEF
F. Koara F. Koara 29 años 186cm DEF
Kinley Wangchuk Kinley Wangchuk 32 años DEF
S. Dang S. Dang 24 años MED
T. Namgyel T. Namgyel 21 años MED
K. Chetrim K. Chetrim 21 años MED
E. Asante E. Asante 29 años DEL
P. Wangchuk P. Wangchuk 28 años DEL
K. Homma K. Homma 44 años 175cm 70kg DEL
P. Wangchuk P. Wangchuk 28 años DEL
Yeshey Dorji Yeshey Dorji 35 años DEL
15 jugadores
Druk Lhayul FC Druk Lhayul FC
Eranaso Eranaso
Aung Aung
P. Ekom P. Ekom
S. Jorden S. Jorden
D. Khando D. Khando
D. Phub D. Phub
T. Dendup T. Dendup 32 años POR
N. Jamphel N. Jamphel 31 años POR
K. Jamtsho K. Jamtsho 26 años DEF
P. Jigme P. Jigme 26 años DEF
Takuya Miyabayashi Takuya Miyabayashi 33 años MED
Aung Kyaw Naing Aung Kyaw Naing 29 años 166cm MED
E. Philip E. Philip 29 años DEL
K. Zacharie K. Zacharie 24 años DEL
Lekpai Dendup Lekpai Dendup DEL
5 jugadores
Thimphu Raven Thimphu Raven
Anthony Amoh Anthony Amoh
P. Segun P. Segun
A. Beadum A. Beadum MED
J. Tshering J. Tshering MED
A. Kayode A. Kayode 30 años DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Paro FC Paro FC 18 79 14 49
2 Thimphu City Thimphu City 18 65 25 42
3 Transport United Transport 18 68 29 37
4 RTC RTC 18 40 22 35
5 Druk Lhayul FC Druk Lhayul 18 47 54 25
6 Tensung Tensung 18 31 36 22
7 BFF Academy Sub 19 Academy 18 30 45 17
8 Ugyen Academy Ugyen 18 30 50 15
9 Thimphu Raven Thimphu 18 18 68 10
10 Namlha Namlha 18 15 80 7

  USO DE MEMORIA  
5,083,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3729
Total Execution Time  0.3749
  CADENA URL  
/liga_nacional_de_butan2023/grupo1/jugadores
  GET DATOS  
$_GET['/liga_nacional_de_butan2023/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0127  SELECT type FROM routes WHERE alias = 'liga_nacional_de_butan2023'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nacional_de_butan' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1933 AND type_rel = 3
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1933 ORDER BY order_id ASC
0.0132  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1933 GROUP BY l.categoryId
0.0133  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=1933 GROUP BY l.year ORDER BY l.year DESC
0.0134  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 = 72843 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72843 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0178  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 = 72843 AND dt.id IN (63106,88313,100767,85804,122004,100765,142810,151318,151319,151320) ORDER BY dt.relations DESC,dp.role ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 02:50:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 02:50:24' 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-04-29 02:50:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 02:50:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nacional_de_butan' 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.0326  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 = 72843 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72843 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.0141  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 = 72843 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72843 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0143  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 = 72843 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72843 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0172  SELECT *,(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 = 72843 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