4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Juan

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre San Juan

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1980
  • Presupuesto 82000
Internet

Información sobre el estadio

  • Nombre del estadio Polideportivo Municipal Primero de Mayo
  • Dirección Avenida Cuesta de Cross, s/n
Polideportivo Municipal Primero de Mayo

Partidos del San Juan

Ir al LIVESCORE
2ª Andaluza Sevilla 2ª Andaluza Sevilla »
12 May 24  en 16 días San Juan
-
 Camas 0
05 May 24  en 9 días La Barrera
-
 San Juan 0
28 Abr 24  en 3 días San Juan
20:00
 Pilas 0
14 Abr 24  Finalizado La Liara Balompie
0 - 1
 San Juan 0
07 Abr 24  Finalizado San Juan
3 - 4
 Juventud Dva. Gines 0
17 Mar 24  Finalizado San Juan
3 - 0
 Marchena Balompié 0
10 Mar 24  Finalizado Alcolea del Río F.C.
2 - 3
 San Juan 0
03 Mar 24  Finalizado San Juan
1 - 1
 UD Villaverde 0
25 Feb 24  Finalizado El Palmar Vereda Real
1 - 0
 San Juan 0
18 Feb 24  Finalizado San Juan
2 - 1
 Lora CF 0
11 Feb 24  Finalizado Real Betis C
10 - 0
 San Juan 2
04 Feb 24  Finalizado San Juan
0 - 1
 Atlético Algabeño 0
28 Ene 24  Finalizado La Motilla
0 - 2
 San Juan 0
21 Ene 24  Finalizado San Juan
1 - 2
 Palomares 0
14 Ene 24  Finalizado Camino Viejo
1 - 1
 San Juan 0
07 Ene 24  Finalizado Camas
2 - 2
 San Juan 0

Noticias del San Juan

Ver últimas noticias

Cirbonero y San Juan, favoritos en el Grupo XV de Tercera

Isabel Ruiz - Sábado, 23 Julio 2016
0 1.966

Ya se conoce el calendario en el Grupo XV de Tercera División. Cirbonero y San Juan, clubes que acabaron segundos y terceros respectivamente en la pasada temporada, parten como principales favoritos.

Ver más noticias del equipo»



  USO DE MEMORIA  
4,728,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3143
Total Execution Time  0.3162
  CADENA URL  
/ad-san-juan
  GET DATOS  
$_GET['/ad-san-juan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0192  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 = 'ad-san-juan' AND l.year = 2024 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.0150  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=7814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=7814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7814 AND type_rel = 2
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7814 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0153  SELECT /*35 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 (93226) ORDER BY n.cover_points DESC, update_date DESC
0.0165  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 = '7814' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0165  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=7814 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (73639) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73639 AND teamId = 7814
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73639 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150  SELECT rp.team_id as teamId FROM rel_players 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 = 7814 AND rp.league_id = 73639 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1