Partido AD San Juan - Tudelano | Segunda Federación G 2

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

AD San Juan - Tudelano AD San Juan - Tudelano

Jornada 20

FINALIZADO

167 Pts. Elo

17º

AD San Juan

316 Pts. Elo

9º

Tudelano

1-1

Sábado, 27 Enero 2024, 17:00

Estadio: Agrupación Deportiva San Juan

			0 - 1		20'	Dani Santigosa
Inach Fernández	61'		1 - 1

AD San Juan

4-5-1

Alineación Inicial

13

M. Aldave
4

Iker Ezcurra
3

Alex Mendoza
17
87'

Galeano
2

Alejandro Tierno
6

Morillas
19

Aimar Martiarena
22
72'

Alex Gómez
11
79'

Iñaki Alberca
18
72'

Inach Fernández
7
87'

Iriguibel

Suplentes

1

Tasio
15
87'

Mario Adot
16

Lander Mañeru
8
87'

Lalinde
21
72'

Bicho
10
72'

M. Olcoz
20
79'

E. Ezcurra

Tudelano

5-4-1

Alineación Inicial

13

R. Santamaría
5
90'

Santamaría
12

Borja Vicent
22

Irurita
3

Ramón Riego
18

Álvaro García
14

Dani Santigosa
8
68'

A. Otegui
10

Colau
19

Eder
16
87'

Joel Rodríguez

Suplentes

1

De Prados
17
90'

Sito
2

Mario Sánchez
15

Unai Velez
21
87'

I. Amorrortu
9
68'

G. Simeone
6

Rodrigo Sanz

Ficha del partido

Datos del partido AD San Juan - CD Tudelano de la jornada 20 de la competición Campeonato de Segunda Federación (FASE REGULAR - GRUPO 2).

Fecha: Hora: 17:00:00 Estadio: (Pamplona)
Equipo local	Resultado	Equipo visitante
AD San Juan	1 - 1	CD Tudelano
Campeonato de Segunda Federación (FASE REGULAR - GRUPO 2) \| (Jornada 20)

Entrenador	Árbitros	Entrenador
Julen Foncillas Lozano	Alonso Luiña Martínez González Agoultim Boumater	No Presenta

Jugadores

Titulares
13	Mikel Aldave Latienda
2	Alejandro Tierno Villafranca
3	Alejandro Mendoza Lezaun
4	Iker Ezcurra Arriaran
6	Ruben Morillas Idoate
7	Ander Iriguibel Azcarate
11	Iñaki Alberca Laquidain
17	Asier Galeano Fernandez
18	Ignacio Fernandez Ibarburu
19	Aimar Martiarena Tihista
22	Alejandro Gomez Sanz

Titulares
13	Roberto Santamaria Ciprian
3	Ramon Riego Garcia
5	Mikel Santamaria Ciprian
8	Antonio Islam Otegui Khalifi
10	Alejandro Forner Fernandez
12	Borja Vicent Garces
14	Daniel Santigosa Funes
16	Joel Rodriguez Satorres
18	Alvaro Garcia Murillo
19	Eder Iribarren Aramburu
22	Xabier Irurita Larrayoz

Suplentes
1	Tasio Villacampa Apesteguia
8	Iñaki Lalinde Sainz
10	Marcos Olcoz Blanco
15	Mario Adot Villanueva
16	Lander Mañeru Oses
20	Eneko Ezcurra Arriaran
21	Alejandro Galdeano Echarri

Suplentes
1	Eduardo De Prados Orradre
2	Mario Sanchez Salvador
6	Rodrigo Sanz Garro
9	Gianluca Simeone Baldini
15	Unai Velez Galvan
17	Andres Barrera Baigorri
21	Iker Amorrortu Andrinua

Sustituciones

Min		Jugador
72'		Alejandro Galdeano Echarri
72'		Alejandro Gomez Sanz
72'		Ignacio Fernandez Ibarburu
72'		Marcos Olcoz Blanco
79'		Eneko Ezcurra Arriaran
79'		Iñaki Alberca Laquidain
87'		Ander Iriguibel Azcarate
87'		Asier Galeano Fernandez
87'		Iñaki Lalinde Sainz
87'		Mario Adot Villanueva

Min		Jugador
68'		Antonio Islam Otegui Khalifi
68'		Gianluca Simeone Baldini
87'		Iker Amorrortu Andrinua
87'		Joel Rodriguez Satorres
90'		Andres Barrera Baigorri
90'		Mikel Santamaria Ciprian

Tarjetas

Min		Jugador
74'		Ruben Morillas Idoate
90'		Eneko Ezcurra Arriaran

Min		Jugador
38'		Mikel Santamaria Ciprian
53'		Antonio Islam Otegui Khalifi
62'		Roberto Santamaria Ciprian
81'		Borja Vicent Garces
90'		Gianluca Simeone Baldini

Goles

Min		Jugador
61'		Ignacio Fernandez Ibarburu

Min		Jugador
20'		Daniel Santigosa Funes

INCIDENCIAS

Jugadores
1. Amonestaciones
  - AD San Juan
    - En el minuto 74 el jugador (6) Ruben Morillas Idoate fue amonestado por el siguiente motivo: Por derribar a un contrario en la disputa del balón, cortando así su avance, evitando un ataque prometedor.
    - En el minuto 90 el jugador (20) Eneko Ezcurra Arriaran fue amonestado por el siguiente motivo: Por discutir con un adversario sin llegar a insultos ni a la amenaza.
  - CD Tudelano
    - En el minuto 38 el jugador (5) Mikel Santamaria Ciprian fue amonestado por el siguiente motivo: Por desaprobar con palabras una de mis decisiones.
    - En el minuto 53 el jugador (8) Antonio Islam Otegui Khalifi fue amonestado por el siguiente motivo: Por derribar a un contrario de forma temeraria en la disputa del balón
    - En el minuto 62 el jugador (13) Roberto Santamaria Ciprian fue amonestado por el siguiente motivo: Por desaprobar con palabras una de mis decisiones.
    - En el minuto 81 el jugador (12) Borja Vicent Garces fue amonestado por el siguiente motivo: Por sujetar a un adversario en la disputa del balón, haciéndolo de forma ostensible y persistente.
    - En el minuto 90 el jugador (9) Gianluca Simeone Baldini fue amonestado por el siguiente motivo: Por discutir con un adversario sin llegar a insultos ni a la amenaza.
2. Expulsiones
  - AD San Juan
    - Ninguna
  - CD Tudelano
    - Ninguna
3. Otras Incidencias
  - Ninguna
  - Ninguna
Público
- Ninguna
Deficiencias observadas en el terreno de juego e instalaciones
- Ninguna
Otras observaciones o ampliaciones a las anteriores
- Ninguna

AD San Juan

Tudelano

Eventos del partido

Goles

minuto 20'

Gol de Dani Santigosa

Gol de penalti

Inach Fernández

minuto 61'

Tarjetas

minuto 38'

T. Amarilla Santamaría

minuto 53'

T. Amarilla A. Otegui

minuto 62'

T. Amarilla R. Santamaría

T. Amarilla

Morillas

minuto 74'

minuto 81'

T. Amarilla Borja Vicent

minuto 90'

T. Amarilla G. Simeone

T. Amarilla

E. Ezcurra

minuto 90'

Ocasiones

minuto 80'

Tiro al palo Colau

Cambios

minuto 68'

Entra en el partido G. Simeone

minuto 68'

Sale del partido A. Otegui

Entra en el partido

M. Olcoz

minuto 72'

Sale del partido

Inach Fernández

minuto 72'

Sale del partido

Alex Gómez

minuto 72'

Entra en el partido

Bicho

minuto 72'

Sale del partido

Iñaki Alberca

minuto 79'

Entra en el partido

E. Ezcurra

minuto 79'

Entra en el partido

Mario Adot

minuto 87'

Sale del partido Joel Rodríguez

Entra en el partido

Lalinde

minuto 87'

Entra en el partido I. Amorrortu

Sale del partido

Galeano

minuto 87'

Sale del partido

Iriguibel

minuto 87'

minuto 90'

Sale del partido Santamaría

minuto 90'

Entra en el partido Sito

0 Comentarios

No hay comentarios

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

Otros partidos

CD Valle de Egüés

0-0

Brea 5

Mutilvera

1-0

Náxara 0

Arenas de Getxo

0-1

CD Calahorra 10

Deportivo Alavés B

1-2

SD Gernika 8

Deportivo Aragón

3-1

Real Sociedad C 0

Barbastro

0-0

Bilbao Ath. 31

Izarra

0-2

UD Logroñés 9

Barakaldo

1-1

Utebo 22

Clasificación | Jornada 20

LIGAS RELACIONADAS

Equipos de esta liga

USO DE MEMORIA

6,958,272 bytes

BENCHMARKS

Loading Time Base Classes	0.0009
Controller Execution Time ( Match / Index )	0.7698
Total Execution Time	0.7708

CADENA URL

/partido/San-Juan/Tudelano/2024

GET DATOS

$_GET['/partido/San-Juan/Tudelano/2024']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0004	SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '72363' AND c.`match_id` = '197016'
0.0189	SELECT c., c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'San-Juan' AND dt2.basealias = 'Tudelano'
0.0109	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=197016 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0131	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72363 WHERE dp.id IN (145420,992917,41343,195878,33112,119013,314702,353243,474896,281719,876273,3303463,759963,1005590,951658,337571,356432,336047,772642,92320,311499) AND (rp.team_id=6587612 OR rp.team_id=6587619)
0.0111	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=197016 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0143	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72363 WHERE dp.id IN (145420,41343,195878,992917,33112,353243,876273,3303463,759963,119013,1005590,474896,281719,314702,951658,337571,356432,336047,772642,92320,311499) AND (rp.team_id=6587612 OR rp.team_id=6587619)
0.0107	SELECT data1 FROM stats2024 t WHERE league_id = 72363 AND teamId = 6587612 and type = 33
0.0107	SELECT data1 FROM stats2024 t WHERE league_id = 72363 AND teamId = 6587619 and type = 33
0.0114	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72363 AND id_match = 197016
0.0141	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72363' AND relp.team_id = drea.team_id WHERE rel.team_number=5168804 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0114	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72363' AND relp.team_id = drea.team_id WHERE rel.team_number=5168819 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0133	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72363' AND relp.team_id=6587612 WHERE mp.`match_id` = '197016' AND mp.year='2024' AND p.id NOT IN (33112,41343,314702,951717,176171,170783,145420,195878,281719,849752,337571,877266,117400,3303450,772642,3147513,119013,997091,3303463,1005590,992917,92320) ORDER BY mp.`team` ASC, p.`role` ASC
0.0144	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72363' AND relp.team_id=6587619 WHERE mp.`match_id` = '197016' AND mp.year='2024' AND p.id NOT IN (33112,41343,314702,951717,176171,170783,145420,195878,281719,849752,337571,877266,117400,3303450,772642,3147513,119013,997091,3303463,1005590,992917,92320) ORDER BY mp.`team` ASC, p.`role` ASC
0.0109	SELECT kit FROM kit_data_real WHERE league_id = 72363 AND id_match = 197016
0.0108	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '197016' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '197016' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 72363 AND rel.team1 = 6587612 AND rel.team2 = 6587619 ORDER BY FIELD(m.location,'es','en') DESC
0.0106	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197016 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0107	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197016 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0114	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 72363 AND rel.team1 = 6587612 AND rel.team2 = 6587619 ORDER BY FIELD(m.location,'es','en') DESC
0.0123	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72363 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 12
0.0122	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 72363 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 72363 AND round >= 33 AND round <= 33 AND team = 6587612 ORDER BY round ASC
0.0115	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2024 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2024 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2024 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6587612 AND c.team2 = 6587619 AND c.league_id = 72363
0.0109	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197016' AND `active` = 1 AND year = 2024
0.0109	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='197016' AND `active` = 1 AND year = 2024
0.0210	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72363' AND relp.team_id=6587612 WHERE relp.in_squad=1 and mp.`match_id` = '197016' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0159	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72363' AND relp.team_id=6587619 WHERE relp.in_squad=1 and mp.`match_id` = '197016' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '72363' AND id_match = '197016'
0.0106	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5168804' ORDER BY rating DESC LIMIT 1
0.0105	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5168819' ORDER BY rating DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197016 AND extraId = 72363 AND type_rel = 4
0.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0105	SELECT rating1, rating2 FROM calendars_elo WHERE id=197016 AND league_id=72363 AND year=2024
0.0105	SELECT position FROM tables2024 WHERE team=6587612 AND league_id=72363 AND round=20
0.0105	SELECT position FROM tables2024 WHERE team=6587619 AND league_id=72363 AND round=20
0.0105	SELECT * FROM futbol.calendars_lineups WHERE id = 197016 AND league_id = 72363 AND year = 2024


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Agrupación Deportiva San Juan

Ficha del partido

AD San Juan

CD Tudelano

Jugadores

Sustituciones

Tarjetas

Goles

INCIDENCIAS

Jugadores

Público

Deficiencias observadas en el terreno de juego e instalaciones

Otras observaciones o ampliaciones a las anteriores

AD San Juan

Tudelano

Eventos del partido

Goles

Tarjetas

Ocasiones

Cambios

NOTICIAS RELACIONADAS

Otros partidos

Clasificación | Jornada 20

LIGAS RELACIONADAS

Equipos de esta liga