Temporada 2022
 
1ª Baleares Alevín Primer Año 2022 G 1
2021/2022

Mallorca Grupo A

1ª Baleares Alevín Primer Año 2022 G 1

  • San Pedro Atlético
  • Sta Ponsa Talarrubias
  • Son Cladera Atlético del Sc
  • Santa MÒnica B
  • CD Atlético Rafal A
  • Ferriolense
  • Esporles
  • Campusesport Atlético D
  • Sant Marçal Atlético Dspsm
  • Son Caliu del RSC B
  • Madre Alberta Atlético Dma
  • UD Arenal A
  • La Unión A
  • Calvia

Cruce de partidos 1ª Baleares Alevín Primer Año - Todos los partidos de la temporada

IdaVuelta
 CD Atlético Rafal A La Unión A UD Arenal A Ferriolense Campusesport Atlético D Esporles Madre Alberta Atlético Dma San Pedro Atlético Son Cladera Atlético del Sc Sant Marçal Atlético Dspsm Calvia Santa MÒnica B Son Caliu del RSC B Sta Ponsa Talarrubias
CD Atlético Rafal A CD Atlético Rafal A
La Unión A La Unión A
UD Arenal A UD Arenal A
Ferriolense Ferriolense
Campusesport Atlético D Campusesport Atlético D
Esporles Esporles
Madre Alberta Atlético Dma Madre Alberta Atlético Dma
San Pedro Atlético San Pedro Atlético
Son Cladera Atlético del Sc Son Cladera Atlético del Sc
Sant Marçal Atlético Dspsm Sant Marçal Atlético Dspsm
Calvia Calvia
Santa MÒnica B Santa MÒnica B
Son Caliu del RSC B Son Caliu del RSC B
Sta Ponsa Talarrubias Sta Ponsa Talarrubias

  USO DE MEMORIA  
4,780,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2819
Total Execution Time  0.2838
  CADENA URL  
/primera_baleares_alevin_primer_ano2022/grupo1/cruces
  GET DATOS  
$_GET['/primera_baleares_alevin_primer_ano2022/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0106  SELECT type FROM routes WHERE alias = 'primera_baleares_alevin_primer_ano2022'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_baleares_alevin_primer_ano' 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.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2518 AND type_rel = 3
0.0109  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2518 ORDER BY order_id ASC
0.0111  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2518 GROUP BY l.categoryId
0.0111  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=2518 GROUP BY l.year ORDER BY l.year DESC
0.0115  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 = 65840 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2022 AS c WHERE c.league_id='65840' ORDER BY c.id ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 23:06:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 23:06:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 23:06:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 23:06:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0122  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_baleares_alevin_primer_ano' 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.0117  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 = 65840 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65840 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.0116  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 = 65840 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65840 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 65840 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65840 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022_base` 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 = 65840 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC