4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2023
 
Copa Filipinas 2023
2022/2023

Fase de Grupos

Copa Filipinas 2023

  • Kaya
  • CF Manila
  • Philippine Air Force
  • Far Eastern University
  • Loyola
  • Garelli United
  • DH Cebu FC
  • Maharlika
  • UP Men's Football Team
  • Pilipinas Dragons
  • Manila Digger
  • Stallion Laguna
  • Aguilas
  • Mendiola
  • Tuloy
  • Philippine Army
  • Adamson Falcons Students
11 jugadores
Kaya Kaya
A. Syy A. Syy
Maru Maru
M. Angeles M. Angeles
Justin Baas Justin Baas 24 años 185cm 77kg DEF
F. Arboleda F. Arboleda 31 años 168cm MED
M. Swainston M. Swainston 24 años 179cm MED
R. Sendra R. Sendra 36 años MED
Arnel Amita Arnel Amita 29 años 165cm MED
Jarvey Gayoso Jarvey Gayoso 27 años DEL
D. Horikoshi D. Horikoshi 27 años 171cm DEL
J. Melliza J. Melliza 32 años DEL
10 jugadores
Stallion Laguna Stallion Laguna
S. Felongco S. Felongco 31 años 170cm DEF
J. Aristorenas J. Aristorenas 30 años 165cm MED
J. Jarvis J. Jarvis 26 años MED
C. Schaffner C. Schaffner 170cm 63kg MED
A. Placito A. Placito 30 años 178cm 82kg MED
J. Trujillo J. Trujillo 24 años DEL
Y. Nomura Y. Nomura 25 años DEL
C. Ivanobski C. Ivanobski 34 años 169cm 63kg DEL
Charles Pickering Charles Pickering 22 años DEL
G. Mcdaniel G. Mcdaniel 24 años DEL
3 jugadores
Loyola Loyola
R. Baña R. Baña MED
J. Montelibano J. Montelibano 30 años MED
F. Anoh F. Anoh DEL
8 jugadores
DH Cebu FC DH Cebu FC
C. Dabao C. Dabao 26 años DEF
G. Demiroğlu G. Demiroğlu 24 años DEF
K. Miyagi K. Miyagi 26 años DEF
R. Togashi R. Togashi 27 años 180cm MED
I. Ouano I. Ouano 24 años DEL
R. Hama R. Hama 24 años DEL
Arda Çınkır Arda Çınkır 22 años DEL
C. Uzoka C. Uzoka 25 años 190cm DEL
3 jugadores
Philippine Army Philippine Army
R. Becite R. Becite 38 años MED
J. Gatinao J. Gatinao 28 años MED
J. Ariola J. Ariola 27 años DEL
3 jugadores
Philippine Air Force Philippine Force
J. Delariarte J. Delariarte
Z. Abraham Z. Abraham POR
A. Albor A. Albor DEF
3 jugadores
Aguilas Aguilas
M. Angeles M. Angeles 33 años MED
N. Ferrer N. Ferrer 29 años DEL
Y. Tuason Y. Tuason 35 años 175cm DEL
1 jugadores
Garelli United Garelli United
B. Mahinay B. Mahinay DEF
2 jugadores
Manila Digger Manila Digger
J. Azares J. Azares DEF
K. Stuart K. Stuart MED
3 jugadores
CF Manila CF Manila
J. L. Alon J. L. Alon 28 años MED
P. Grogg P. Grogg 21 años MED
M. Al-Mohjili M. Al-Mohjili MED
1 jugadores
Tuloy Tuloy
John Jalique John Jalique 20 años DEL
2 jugadores
Adamson Falcons Students Adamson Falcons
A. Buenaobra A. Buenaobra
I. Francisco I. Francisco DEF
4 jugadores
Far Eastern University Eastern
S. Basindahan S. Basindahan
M. Rey M. Rey 24 años MED
S. Mamon S. Mamon DEL
K. Valenzuela K. Valenzuela DEL

Clasificación

Equipo PJ GF GC Puntos
1 Kaya Kaya 5 40 2 15
2 CF Manila CF Manila 5 9 12 10
3 Philippine Air Force Philippine 5 8 14 7
4 Far Eastern University Eastern 5 10 10 6
5 Loyola Loyola 5 8 15 4
6 Garelli United Garelli 5 3 25 0
7 DH Cebu FC DH Cebu FC 4 16 3 12
8 Maharlika Maharlika 4 5 3 7
9 UP Men's Football Team Men's 4 6 5 6
10 Pilipinas Dragons Pilipinas 4 3 12 3
11 Manila Digger Manila 4 3 10 1
12 Stallion Laguna Stallion 5 28 4 12
13 Aguilas Aguilas 5 14 10 10
14 Mendiola Mendiola 5 10 8 9
15 Tuloy Tuloy 5 11 20 7
16 Philippine Army Philippine 5 9 15 3
17 Adamson Falcons Students Adamson 5 3 18 1

  USO DE MEMORIA  
5,115,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0754
Total Execution Time  0.0773
  CADENA URL  
/copa-filipinas2023/grupo1/jugadores
  GET DATOS  
$_GET['/copa-filipinas2023/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'copa-filipinas2023'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa-filipinas' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2528 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2528 ORDER BY order_id ASC
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2528 GROUP BY l.categoryId
0.0018  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=2528 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 72844 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72844 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0029  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 = 72844 AND dt.id IN (11524,11528,11526,148420,121138,11532,139551,11523,101421,159273,159293,159294,159297,159300,159299,159292,159295) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 12:30:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 12:30:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 12:30:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 12:30:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa-filipinas' 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.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2528 AND l.year = 2023
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72844,74238) 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, e.player_id ASC LIMIT 10
0.0024  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72844,74238) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3438946,3413145,371613,652850,697161,848583,883166,222283,379607,3158315) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2528 AND l.year = 2023
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72844,74238) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2528 AND l.year = 2023
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72844,74238) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72844,74238) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3437157,3393062,3438106,3439025,3443620) ORDER BY rp.in_squad = 1 DESC
0.0031  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 = 72844 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC