Partido Turquía Sub 18 - Estonia Sub 19 | Amistosos Selecciones Sub 19 2024

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

Turquía Sub 18 - Estonia Sub 19 Turquía Sub 18 - Estonia Sub 19

Jornada 3

FINALIZADO

324 Pts. Elo

Turquía Sub 18

138 Pts. Elo

Estonia Sub 19

1-2

Miércoles, 20 Marzo 2024, 11:00

		0 - 1	36'	Evert Talviste
		0 - 2	70'	P. Kristal
Emre Gökay	90'	1 - 2

Eventos del partido

Goles

minuto 36'

Gol de Evert Talviste

minuto 70'

Gol de P. Kristal

Gol de penalti

Emre Gökay

minuto 90'

Cambios

Sale del partido

Zeki Dursun

minuto 46'

Entra en el partido

K. Subasi

minuto 46'

Entra en el partido

Gökdeniz Gürpüz

minuto 46'

Sale del partido

A. Koçaş

minuto 46'

Entra en el partido

M. Kaya

minuto 61'

Entra en el partido Sigvard Suppi

minuto 61'

Entra en el partido S. Tovstik

minuto 61'

Sale del partido Oscar Pihela

minuto 61'

Sale del partido G. Roivassepp

minuto 61'

Sale del partido Evert Talviste

Entra en el partido

Emre Gökay

minuto 61'

Sale del partido

E. Arkutcu

minuto 61'

Entra en el partido

E. Akman

minuto 61'

Sale del partido

B. İngenç

minuto 61'

Sale del partido

Halim Yükseloğlu

minuto 61'

Entra en el partido Aron Kirt

Entra en el partido

A. Usluoğlu

minuto 61'

Sale del partido

Adnan Karahisar

minuto 61'

Sale del partido

Ö. Kirişkuzu

minuto 71'

Entra en el partido

Taylan Aydin

minuto 71'

Sale del partido

M. Akyildiz

minuto 71'

Sale del partido

Eren Paşahan

minuto 71'

Sale del partido

Ege Arslan

minuto 71'

Entra en el partido

Efe Korkut

minuto 71'

Entra en el partido

E. Bayrak

minuto 71'

Entra en el partido

Bedirhan Çetin

minuto 71'

minuto 72'

Entra en el partido Tony Varjund

minuto 72'

Sale del partido M. Tomberg

minuto 72'

Entra en el partido H. Planken

minuto 72'

Sale del partido Enriko Kajari

minuto 90'

Sale del partido M. Kalimullin

minuto 90'

Entra en el partido Imre Kartau

Otros

minuto 36'

Asistencia P. Kristal

minuto 70'

Asistencia Rommi Siht

Alineaciones

Turquía Sub 18

4-3-3

Alineación Inicial

12

O. Çevikkan
4
71'

Eren Paşahan
2
71'

M. Akyildiz
5
71'

Ö. Kirişkuzu
3
46'

A. Koçaş
8
71'

Ege Arslan
19
61'

B. İngenç
20
46'

Zeki Dursun
17
61'

E. Arkutcu
9
61'

Adnan Karahisar
21
61'

Halim Yükseloğlu

Suplentes

1

K. Arıcan
13
46'

K. Subasi
16
71'

Taylan Aydin
15
71'

E. Bayrak
22
71'

Bedirhan Çetin
10
46'

Gökdeniz Gürpüz
6
71'

Efe Korkut
18
61'

E. Akman
7
61'

M. Kaya
14
61'

A. Usluoğlu
11
61'

Emre Gökay

Estonia Sub 19

4-5-1

Alineación Inicial

1

Jan Martti Vainula
6
72'

Enriko Kajari
16
61'

Oscar Pihela
5

Airon Kollo
4

Matvei Jekimov
14

Rommi Siht
15
72'

M. Tomberg
9
90'

M. Kalimullin
10

P. Kristal
17
61'

Evert Talviste
7
61'

G. Roivassepp

Suplentes

12

J. Sakkis
8

K. Leppsalu
2
61'

Aron Kirt
3

Stevin Kerge
18
61'

Sigvard Suppi
20
90'

Imre Kartau
13

Jan Samuilovski
11
72'

Tony Varjund
23
61'

S. Tovstik
19
72'

H. Planken

Otros partidos

España Sub 19 2-1 Noruega Sub 19 0

Montenegro Sub 19 2-2 Lituania Sub 19 1

República Checa Sub 19 1-3 Dinamarca Sub 19 7

Georgia Sub 19 0-0 Israel Sub 19 1

Bosnia Sub 19 0-2 Macedonia del Norte Sub 19 6

Malta Sub 19 0-1 Albania Sub 19 0

Jordania Sub 19 1-3 Japón Sub 19 0

Chipre Sub 19 0-1 Polonia Sub 19 0

Turquía Sub 18 2-1 Moldavia Sub 19 0

Estonia Sub 19 0-3 Macedonia del Norte Sub 18 0

Estados Unidos Sub 19 3-2 Inglaterra Sub 19 0

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,060,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Match / Index )	1.8109
Total Execution Time	1.8122

CADENA URL

/partido/Turquia-Sub-18/Estonia-Sub-19/2024?section=legal

GET DATOS

$_GET['/partido/Turquia-Sub-18/Estonia-Sub-19/2024']
$_GET['section']	legal

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0117	SELECT c., c.stadium as real_stadium, 2025 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* calendars2025 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 = 'Turquia-Sub-18' AND dt2.basealias = 'Estonia-Sub-19'
0.0120	SELECT c., c.stadium as real_stadium, 2026 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* calendars2026 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 = 'Turquia-Sub-18' AND dt2.basealias = 'Estonia-Sub-19'
0.0214	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 = 'Turquia-Sub-18' AND dt2.basealias = 'Estonia-Sub-19'
0.0124	SELECT c., 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, dt1.id 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Turquia-Sub-18' AND dt2.basealias = 'Estonia-Sub-19'
0.0115	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=757736 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.0137	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=75096 WHERE dp.id IN (3186652,3251744,3266195,3394029,3336242,3186670,3466883,3291753,3176934,3205081,3176944,3176842,3306219,3266190,3266192,3266193,3176884,3240229,3266437,3448861,3332702,3449123,3362013,3233033,3198962,3333790,3333189,3251757,3176885,3176889,3272104,3186653,3176897,3176840) AND (rp.team_id=6635253 OR rp.team_id=6634694)
0.0110	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=757736 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0110	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=75096 WHERE dp.id IN (3251744,3186652,3394029,3336242,3186670,3466883,3291753,3176934,3205081,3176944,3176842,3266195,3306219,3266190,3266192,3266193,3176884,3240229,3266437,3176840,3448861,3332702,3449123,3362013,3233033,3198962,3333790,3333189,3251757,3176885,3176889,3272104,3186653,3176897) AND (rp.team_id=6635253 OR rp.team_id=6634694)
0.0104	SELECT data1 FROM stats2024 t WHERE league_id = 75096 AND teamId = 6635253 and type = 33
0.0104	SELECT data1 FROM stats2024 t WHERE league_id = 75096 AND teamId = 6634694 and type = 33
0.0105	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75096 AND id_match = 757736
0.0113	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='75096' AND relp.team_id = drea.team_id WHERE rel.team_number=5796589 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0113	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='75096' AND relp.team_id = drea.team_id WHERE rel.team_number=5796590 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0122	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='75096' AND relp.team_id=6635253 WHERE mp.`match_id` = '757736' AND mp.year='2024' AND p.id NOT IN (3154422,3362013,3449123,3448861,3466883,3233033,3266192,3394029,3306219,3266437,3266193,3413896,3272104,3176944,3272094,3186657,3176840,3176885,3186653,3251744,3186652,3176842) ORDER BY mp.`team` ASC, p.`role` ASC
0.0142	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='75096' AND relp.team_id=6634694 WHERE mp.`match_id` = '757736' AND mp.year='2024' AND p.id NOT IN (3154422,3362013,3449123,3448861,3466883,3233033,3266192,3394029,3306219,3266437,3266193,3413896,3272104,3176944,3272094,3186657,3176840,3176885,3186653,3251744,3186652,3176842) ORDER BY mp.`team` ASC, p.`role` ASC
0.0110	SELECT kit FROM kit_data_real WHERE league_id = 75096 AND id_match = 757736
0.0111	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '757736' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0114	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '757736' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0118	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 = 75096 AND rel.team1 = 6635253 AND rel.team2 = 6634694 ORDER BY FIELD(m.location,'es','en') DESC
0.0109	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 757736 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0108	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 757736 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0107	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 = 75096 AND rel.team1 = 6635253 AND rel.team2 = 6634694 ORDER BY FIELD(m.location,'es','en') DESC
0.0105	SELECT teamId FROM teams WHERE id = 6635253
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 101249 OR c.datateam2 = 101249) ORDER BY shedule DESC LIMIT 10
0.0108	SELECT teamId FROM teams WHERE id = 6634694
0.0108	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 9223 OR c.datateam2 = 9223) ORDER BY shedule DESC LIMIT 10
0.0135	SELECT teamId FROM teams WHERE id = 6635253
0.0109	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 101249 OR c.datateam2 = 101249) ORDER BY shedule ASC LIMIT 10
0.0112	SELECT teamId FROM teams WHERE id = 6634694
0.0109	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 9223 OR c.datateam2 = 9223) ORDER BY shedule ASC LIMIT 10
0.0105	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` = 75096 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 12
0.0105	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 75096 AND round >= 12 AND round <= 12 AND team = 6635253 ORDER BY round ASC
0.0124	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 = 75096 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 6635253 AND c.team2 = 6634694 AND c.league_id = 75096
0.0106	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='757736' AND `active` = 1 AND year = 2024
0.0106	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='757736' AND `active` = 1 AND year = 2024
0.0106	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='75096' AND relp.team_id=6635253 WHERE relp.in_squad=1 and mp.`match_id` = '757736' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106	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='75096' AND relp.team_id=6634694 WHERE relp.in_squad=1 and mp.`match_id` = '757736' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0113	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '75096' AND id_match = '757736'
0.0109	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 = '5796589' ORDER BY rating DESC LIMIT 1
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 = '5796590' ORDER BY rating DESC LIMIT 1
0.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=757736 AND extraId = 75096 AND type_rel = 4
0.0106	SELECT rating1, rating2 FROM calendars_elo WHERE id=757736 AND league_id=75096 AND year=2024
0.0106	SELECT avg_rating FROM elo_teams WHERE id=9223
0.0106	SELECT position FROM tables2024 WHERE team=6635253 AND league_id=75096 AND round=3
0.0106	SELECT position FROM tables2024 WHERE team=6634694 AND league_id=75096 AND round=3
0.0106	SELECT * FROM futbol.calendars_lineups WHERE id = 757736 AND league_id = 75096 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: