CF La Solana CF La Solana
M. Muñoz M. Muñoz
J. Luque J. Luque
D. Sevilla D. Sevilla
L. Ramirez L. Ramirez
M. Leon M. Leon
R. Martin R. Martin
I. Sidibe I. Sidibe
Monreal Monreal 27 años POR
S. Padilla S. Padilla DEF
V. Bonilla V. Bonilla DEF
F. Marin F. Marin 23 años DEF
De La Hoz De La Hoz 35 años DEF
Sancho Sancho 39 años DEF
O. El Cabriti O. El Cabriti 25 años MED
Mini Mini 35 años MED
J. Olmo J. Olmo 26 años MED
J. Lopez J. Lopez 26 años MED
R. Delgado R. Delgado 27 años MED
G. Ruiz G. Ruiz MED
J. Jimeno J. Jimeno 21 años MED
J. Almarcha J. Almarcha 32 años MED
J. Gomez J. Gomez 30 años MED
A. Ruiz A. Ruiz DEL
D. Sevilla D. Sevilla 30 años DEL
Reyes Reyes 26 años 175cm 70kg DEL
Atlético Tomelloso Atlético
A. Benito A. Benito
R. Lopez R. Lopez
J. Lara J. Lara
R. Romera R. Romera
J. Collado J. Collado
S. Madrid S. Madrid
J. Serna J. Serna
J. Contreras J. Contreras
L. Zaragoza L. Zaragoza
I. Cano I. Cano
F. Gallego F. Gallego
D. Cano D. Cano POR
J. Asenjo J. Asenjo 25 años POR
R. Alamo R. Alamo POR
J. Garcia J. Garcia POR
D. Soria D. Soria DEF
J. Mutis J. Mutis DEF
F. Lopez F. Lopez DEF
Garceso Garceso 34 años 188cm 78kg DEF
A. Gil A. Gil 25 años DEF
A. Dueñas A. Dueñas DEF
B. Galindo B. Galindo 33 años DEF
J. Morales J. Morales 31 años MED
Lapa Lapa MED
J. Navarro J. Navarro MED
J. Lopez J. Lopez 28 años MED
A. Scorus A. Scorus 23 años MED
Carreton Carreton 22 años MED
José Cruz José Cruz 23 años DEL
Gallego Gallego 34 años DEL
A. Leon A. Leon 20 años DEL
Clasificación
Equipo PJ GF GC Puntos
1 CF La Solana Solana 33 77 30 74
2 Atlético Tomelloso Atlético 34 50 36 63
3 Manzanares CF Manzanares 34 57 27 62
4 CD Pedroñeras Pedroñeras 34 57 37 61
5 Valdepeñas Valdepeñas 34 67 48 57
6 AD Campillo AD Campillo 34 53 42 52
7 UD Carrión UD Carrión 34 59 47 49
8 CD Quintanar de la Orden Quintanar 34 48 34 48
9 Criptanense Criptanense 34 45 34 48
10 Sporting de Alcazar Sporting 34 37 48 45
11 Atlético Ibañés Atlético 34 50 41 44
12 UD La Fuente Fuente 34 59 58 44
13 EFB La Roda EFB La Roda 34 44 47 42
14 CDB Herencia Herencia 34 49 53 40
15 C.F. Almodovar C.F. 34 37 53 37
16 Munera Munera 34 52 76 34
17 C.D. Caudetano C.D. 33 31 98 27
18 Almagro CF Almagro CF 34 26 89 16
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,737,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.3552
Total Execution Time  0.3585
  CADENA URL  
/primera_autonomica_castilla_la_mancha2022/grupo1/jugadores
  GET DATOS  
$_GET['/primera_autonomica_castilla_la_mancha2022/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0104  SELECT type FROM routes WHERE alias = 'primera_autonomica_castilla_la_mancha2022'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 86 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0110  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 (1304399,1199941,1184917,1070918,701719) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=86 ORDER BY order_id ASC
0.0110  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0272  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 = 63675 AND dt.id IN (11446,1641,1498,11447,4306,66457,11456,4273,2550,1754,11448,11451,18983,18980,18977,30536,30503,66465) ORDER BY dt.relations DESC,dp.role ASC
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 13:09:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 13:09:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 13:09:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 13:09:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0280  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 events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 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.0376  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 events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 events2022 e ON e.player_id = p.id AND e.league_id = 63675 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63675 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT *,(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 = 63675 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC