4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Estacion A
Información

Histórico de participación

Partidos del Atletico Estacion A

Ir al LIVESCORE
12 Jun 21  Finalizado Atletico Estacion A
1 - 2
Juventud Torremolinos 0
06 Jun 21  Aplazado Ronda UD
-
Atletico Estacion A 0
02 Jun 21  Finalizado Alhaurín de la Torre
3 - 2
Atletico Estacion A 0
23 May 21  Finalizado Unión Sierra Nieves
2 - 3
Atletico Estacion A 0
21 May 21   Atletico Estacion A
18:45
Churriana 0
12 May 21  Finalizado Juventud Torremolinos
5 - 0
Atletico Estacion A 0
08 May 21  Finalizado Atletico Estacion A
1 - 4
Athletic Puerta Blanca 0
01 May 21  Finalizado CD Alhaurino
3 - 0
Atletico Estacion A 0
24 Abr 21  Finalizado Atletico Estacion A
1 - 3
Cartama 0
18 Abr 21  Finalizado Arriate CD ADSetenil
3 - 0
Atletico Estacion A 0
11 Abr 21  Aplazado Atletico Estacion A
-
Ronda Union Deportiva 0
04 Abr 21  Finalizado Atletico Estacion A
2 - 5
Unión Sierra Nieves 0
03 Abr 21   Churriana
10:00
Atletico Estacion A 0
27 Mar 21  Finalizado Lauro A
0 - 4
Atletico Estacion A 0
25 Mar 21  Finalizado Atletico Estacion A
10 - 2
Lauro A 0
20 Mar 21  Finalizado Atletico Estacion A
1 - 5
Athletic de Coin Sub 16 0
13 Mar 21  Finalizado Los Prados A
3 - 0
Atletico Estacion A 0
06 Mar 21  Finalizado Atletico Estacion A
5 - 7
CD Campanillas 0
27 Feb 21  Finalizado Atletico Estacion A
3 - 3
Alhaurín de la Torre 0
14 Feb 21  Aplazado Atletico Estacion A
-
Ronda UD 0
16 Ene 21  Finalizado Athletic Puerta Blanca
6 - 2
Atletico Estacion A 0
09 Ene 21  Finalizado Atletico Estacion A
2 - 4
CD Alhaurino 0
02 Ene 21  Finalizado Atletico Estacion A
1 - 6
Los Prados A 0
26 Dic 20  Finalizado CD Campanillas
3 - 2
Atletico Estacion A 0
23 Dic 20  Finalizado Athletic de Coin Sub 16
4 - 0
Atletico Estacion A 0
19 Dic 20  Finalizado Cartama
6 - 1
Atletico Estacion A 0
12 Dic 20  Finalizado Atletico Estacion A
0 - 4
Arriate CD ADSetenil 0
06 Dic 20  Aplazado Ronda Union Deportiva
-
Atletico Estacion A 0

Últimas noticias

Ver últimas noticias

Los Joaos se quedan si la economía lo permite

El FC Barcelona ya sabe la hoja de ruta que va a seguir en su decisión de quedarse o no con los jugadores portugueses Joao Cancelo y Joao Félix. Todo va a depender del tema económico, ya que el conjunto 'culé' no hará ningún esfuerzo en este aspecto. El lateral es más prioritario que el atacante, que se contempla simplemente como un complemento para la plantilla.

¡Esto empieza! Ya está el balón en juego

Vive con nosotros todo lo que pase en el Las Palmas-Girona, partido correspondiente a la 33ª Jornada de LaLiga EA Sports 2023-24 que se va a disputar en Gran Canaria.

El Lopetegui más cotizado: Milan, United, West Ham...

Julen Lopetegui es uno de los nombres más repetidos en las quinielas de los banquillos para la próxima temporada. 'Relevo' insiste en que mantiene conversaciones muy activas por el Milan, pero no es el único club de élite con el que se le ha relacionado en las últimas semanas.

El Atlético quiere a Le Normand para solucionar sus problemas defensivos

El jugador de la Real Sociedad Robin Le Normand está en la órbita del Atlético de Madrid. El mal rendimiento defensivo de los rojiblancos ha provocado que el conjunto dirigido por el Cholo Simeone se esté moviendo en el mercado en busca de refuerzos para el centro de la zaga.

El Barça quiere recuperar La Masía

Durante décadas, La Masía de Can Planes fue el hogar de la cantera del FC Barcelona. Un símbolo que hoy le da nombre y que el club tratará de recuperar para otros menesteres dentro de sus planes de modernización. Según ha informado en un comunicado, las obras comenzarán en 2025.




  USO DE MEMORIA  
4,742,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3120
Total Execution Time  0.3139
  CADENA URL  
/Atletico-Estacion-A-Cadete/2021
  GET DATOS  
$_GET['/Atletico-Estacion-A-Cadete/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0116  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Atletico-Estacion-A-Cadete' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25536 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25536 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0218  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 60450
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25536 AND type_rel = 2
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=768 AND type_rel = 3
0.0116  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '25536' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0175  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '25536' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0114  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '25536' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 60450 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0121  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2021_base as c ON c.league_id = l.id WHERE (c.datateam1 = 25536 or c.datateam2 = 25536) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0140  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2021_base as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 25536 or c.datateam2 = 25536) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0111  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021_base as c ON c.league_id = l.id INNER JOIN events2021_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 25536 or c.datateam2 = 25536) AND l.year = 2021)
0.0116  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=25536 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0108  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (66358) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0108  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66358 AND teamId = 25536
0.0109  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` 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 = 60450 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0110  SELECT rp.team_id as teamId FROM rel_players_base AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 25536 AND rp.league_id = 60450 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0110  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 60450 ORDER BY nameShow LIMIT 100