4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletic Sant Just C G
Información

Histórico de participación

Partidos del Atletic Sant Just C G

Ir al LIVESCORE
05 Jun 22  Finalizado Espluguenc CFA B Espluguenc CFA B
3 - 2
Atletic Sant Just C G Atletic Sant Just C G 0
04 Jun 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
2 - 10
Atletic Prat Delta A Atletic Prat Delta A 0
29 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 3
Santboia Santboia 0
29 May 22  Finalizado Espluguenc CFA A Espluguenc CFA A
13 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
21 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
3 - 4
Fontsanta-Fatjo CD C Fontsanta-Fatjo CD C 0
21 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 2
Sant Joan Despi Pancrac Sant Joan Despi Pancrac 0
14 May 22  Finalizado Marianao Poblet UD A Marianao Poblet UD A
3 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
14 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 7
Almeda A Almeda A 0
08 May 22  Finalizado Marianao Poblet UD C Marianao Poblet UD C
3 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
08 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 3
Levante Las Planas B Levante Las Planas B 0
01 May 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
3 - 5
Begues A Begues A 0
30 Abr 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 4
Escola F Gava C H Escola F Gava C H 0
24 Abr 22  Finalizado Castelldefels UE G Castelldefels UE G
1 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
24 Abr 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
2 - 3
Colegio Aleman Salberto Colegio Aleman Salberto 0
09 Abr 22  Finalizado Escola F Gava C G Escola F Gava C G
2 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
09 Abr 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 11
Sant Lluis Associació E. Sant Lluis Associació E. 0
03 Abr 22  Finalizado Ciudad Cooperativa B Ciudad Cooperativa B
2 - 2
Atletic Sant Just C G Atletic Sant Just C G 0
02 Abr 22  Finalizado Prat C Prat C
7 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
26 Mar 22  Finalizado Viladecans B Viladecans B
2 - 3
Atletic Sant Just C G Atletic Sant Just C G 0
26 Mar 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 6
Terlenka Barcelonista C. Terlenka Barcelonista C. 0
20 Mar 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
2 - 0
Fundacio Unio Esportiva Fundacio Unio Esportiva 0
19 Mar 22  Finalizado Base Vilanova 2015 Club Base Vilanova 2015 Club
10 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
13 Mar 22  Finalizado Sporting Gava 2013 Futb. Sporting Gava 2013 Futb.
4 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
12 Mar 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 6
Athletic Viladecans Athletic Viladecans 0
06 Mar 22  Finalizado Sant Ildefons C Sant Ildefons C
9 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
06 Mar 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 6
Rec.San Feliu Llobregat Rec.San Feliu Llobregat 0
20 Feb 22  Finalizado Santfeliuenc D Santfeliuenc D
8 - 4
Atletic Sant Just C G Atletic Sant Just C G 0
19 Feb 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 1
Escola Esportiva Llor A Escola Esportiva Llor A 0
13 Feb 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 7
Castelldefels D Castelldefels D 0
13 Feb 22  Finalizado Fundacio Unio Esportiva Fundacio Unio Esportiva
6 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
06 Feb 22  Finalizado Atletic Prat Delta A Atletic Prat Delta A
4 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
05 Feb 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
4 - 0
Espluguenc CFA B Espluguenc CFA B 0
30 Ene 22  Finalizado Santboia Santboia
3 - 3
Atletic Sant Just C G Atletic Sant Just C G 0
29 Ene 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 14
Espluguenc CFA A Espluguenc CFA A 0
23 Ene 22  Finalizado Fontsanta-Fatjo CD C Fontsanta-Fatjo CD C
2 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
23 Ene 22  Finalizado Sant Joan Despi Pancrac Sant Joan Despi Pancrac
1 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
15 Ene 22  Finalizado Almeda A Almeda A
10 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
15 Ene 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 13
Marianao Poblet UD A Marianao Poblet UD A 0
09 Ene 22  Finalizado Levante Las Planas B Levante Las Planas B
0 - 3
Atletic Sant Just C G Atletic Sant Just C G 0
08 Ene 22  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 14
Marianao Poblet UD C Marianao Poblet UD C 0
18 Dic 21  Aplazado Escola F Gava C H Escola F Gava C H
-
Atletic Sant Just C G Atletic Sant Just C G 0
18 Dic 21  Finalizado Begues A Begues A
5 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
12 Dic 21  Finalizado Colegio Aleman Salberto Colegio Aleman Salberto
4 - 2
Atletic Sant Just C G Atletic Sant Just C G 0
11 Dic 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
4 - 2
Castelldefels UE G Castelldefels UE G 0
28 Nov 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 4
Escola F Gava C G Escola F Gava C G 0
28 Nov 21  Finalizado Sant Lluis Associació E. Sant Lluis Associació E.
3 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
21 Nov 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 2
Ciudad Cooperativa B Ciudad Cooperativa B 0
20 Nov 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 7
Prat C Prat C 0
14 Nov 21  Finalizado Terlenka Barcelonista C. Terlenka Barcelonista C.
8 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
14 Nov 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 4
Viladecans B Viladecans B 0
06 Nov 21  Finalizado Fundacio Unio Esportiva Fundacio Unio Esportiva
4 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
06 Nov 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
1 - 10
Base Vilanova 2015 Club Base Vilanova 2015 Club 0
31 Oct 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 7
Sporting Gava 2013 Futb. Sporting Gava 2013 Futb. 0
30 Oct 21  Finalizado Athletic Viladecans Athletic Viladecans
14 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
24 Oct 21  Finalizado Rec.San Feliu Llobregat Rec.San Feliu Llobregat
5 - 1
Atletic Sant Just C G Atletic Sant Just C G 0
23 Oct 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 11
Sant Ildefons C Sant Ildefons C 0
17 Oct 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
2 - 8
Santfeliuenc D Santfeliuenc D 0
16 Oct 21  Finalizado Escola Esportiva Llor A Escola Esportiva Llor A
1 - 3
Atletic Sant Just C G Atletic Sant Just C G 0
10 Oct 21  Finalizado Castelldefels D Castelldefels D
11 - 0
Atletic Sant Just C G Atletic Sant Just C G 0
09 Oct 21  Finalizado Atletic Sant Just C G Atletic Sant Just C G
0 - 14
Fundacio Unio Esportiva Fundacio Unio Esportiva 0

Noticias de 2ª Catalana Infantil

Ver últimas noticias

La capitana del Lleida infantil promete que el equipo intentará ganar la Liga otra vez

Andrea Gómez, la capitana del AEM Lleida Infantil, cuyas futbolistas se proclamaron campeonas de la Liga de segunda división infantil masculina, ha asegurado en declaraciones a EFE que intentarán "ganar la Liga otra vez", a pesar de que ocho jugadoras, de las 17 que forman la plantilla, tienen que dejar el equipo.

Un equipo infantil femenino gana una Liga... ¡masculina!

El AEM Lleida, un equipo femenino, se ha alzado con el título de la Liga de Segunda infantil masculina tras derrotar 1-2 al Pardinyes B y conquistar el campeonato a cuatro jornadas del final del mismo con 16 puntos de ventaja sobre el segundo clasificado.




  USO DE MEMORIA  
5,084,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3019
Total Execution Time  0.3038
  CADENA URL  
/Atletic-Sant-Just-F-C-G-Infantil/2022
  GET DATOS  
$_GET['/Atletic-Sant-Just-F-C-G-Infantil/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0162  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 = 'Atletic-Sant-Just-F-C-G-Infantil' AND l.year = 2022 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.0146  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=115163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=115163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=115163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 65272
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=115163 AND type_rel = 2
0.0146  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 = '115163' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '115163' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=115163 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (65275) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65275 AND teamId = 115163
0.0146  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 = 115163 AND rp.league_id = 65272 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1