Publicidad 600x120.gif
Partidos Amistosos
2023/2024

Partidos Amistosos

Resultados
 
04 Ago 23
Aplazado
CD Rincón CD Rincón Apl El Palo FC El Palo FC más información 2
 
04 Ago 23
08:00 Finalizado
Hapoel Marmorek Hapoel Marmorek 3-2 Hapoel Kfar Shalem Hapoel Kfar Shalem más información 2
 
04 Ago 23
10:00 Finalizado
NK Kustošija NK Kustošija 1-4 Dubrava Tim kabel Dubrava Tim kabel más información Jugadas destacadas 1
0-1 21' M. Pavlovic
0-2 68' P. Kesse
0-3 90' J. Raužan
0-4 90' J. Zorica
 
04 Ago 23
10:30 Finalizado
Cremonese Cremonese 1-2 Giana Erminio Giana Erminio más información Jugadas destacadas 26
4' F. Tsadjout 1-0
1-1 5' T. Fumagalli
1-2 67' F. Perna
 
04 Ago 23
11:00 Finalizado
Osasuna Osasuna 2-3 Deportivo Alavés Deportivo Alavés más información Jugadas destacadas 70
0-1 10' A. Sedlar
0-2 19' M. De La Fuente
29' A. Budimir 1-2
36' Javi Martínez 2-2
2-3 46' M. De La Fuente
 
04 Ago 23
13:00 Finalizado
Den Bosch Den Bosch 2-1 De Graafschap De Graafschap más información Jugadas destacadas 19
7' K. Kostorz 1-0
33' Nick De Groot 2-0
2-1 56' Jeffry Fortes
 
04 Ago 23
14:00 Finalizado
Jong PSV Jong PSV 1-3 Roda JC Roda JC más información Jugadas destacadas 19
0-1 10' W. Ould-Chikh
0-2 28' E. Peña
0-3 39' M. Bangura
 
04 Ago 23
14:00 Finalizado
Emmen Emmen 2-3 TOP Oss TOP Oss más información Jugadas destacadas 19
0-1 46' A. Allemeersch
0-2 51' Konstantinos Doumtsios
58' M. Te Wierik 1-2
1-3 65' Konstantinos Doumtsios
79' P. Parzyszek 2-3
 
04 Ago 23
14:00 Aplazado
Go Ahead Eagles Go Ahead Eagles Apl Kifisia Kifisia más información 1
 
04 Ago 23
15:00 Finalizado
Atalanta Sub 23 Atalanta Sub 23 2-1 RG Ticino RG Ticino más información Jugadas destacadas 2
0-1 22' P. González
29' M. Cissé 1-1
85' D. Vavassori 2-1
 
04 Ago 23
16:00 Finalizado
1461 Trabzon FK 1461 Trabzon FK 0-5 Trabzonspor Trabzonspor más información Jugadas destacadas 1
0-1 20' Eren Elmali
0-2 22' Maxi Gómez
0-3 52' Trezeguet
0-4 74' E. Destan
0-5 82' Kerem Şen
 
04 Ago 23
16:00 Finalizado
Club NXT Club NXT 1-0 Jong AZ Jong AZ más información Jugadas destacadas 7
72' W. Simba 1-0
 
04 Ago 23
16:30 Finalizado
Trento Trento 0-3 Palermo FC Palermo FC más información Jugadas destacadas 51
0-1 30' P. Ceccaroni
0-2 37' Aljosa Vasic
0-3 44' M. Brunori
 
04 Ago 23
17:00 Finalizado
Sivasspor Sivasspor 2-2 Kayserispor Kayserispor más información Jugadas destacadas 9
0-1 25' M. Thiam
27' Y. Konak 1-1
73' C. N'jie 2-1
2-2 76' G. Sazdagi
 
04 Ago 23
17:30 Finalizado
KF Besa KF Besa 4-1 Teteks Teteks más información Jugadas destacadas 6
0-1 21' M. Jakimoski
60' F. Ademi 1-1
61' A. Alimi 2-1
76' K. Ivanovski 3-1
88' L. Skenderi 4-1
 
04 Ago 23
17:30 Finalizado
Ascoli Ascoli 1-2 Recanatese Recanatese más información Jugadas destacadas 28
0-1 6' D. Ferretti
0-2 33' D. Ferretti
68' L. Simic 1-2
 
04 Ago 23
18:00 Finalizado
Le Mans Le Mans 1-1 Red Star Red Star más información Jugadas destacadas 10
20' E. Colas 1-0
1-1 29' K. Cissé
 
04 Ago 23
18:00 Finalizado
NK Croatia Zmijavci NK Croatia Zmijavci 2-1 HNK Sibenik HNK Sibenik más información Jugadas destacadas 2
23' A. Šuto 1-0
1-1 28' I. Božić
45' M. Šabić 2-1
 
04 Ago 23
18:00 Finalizado
Versailles Versailles 3-1 US Fleury-Merogis US Fleury-Merogis más información Jugadas destacadas 2
17' D. Bangoura 1-0
1-1 30' F. Sauvadet
41' M. Prunier 2-1
43' G. Lefebvre 3-1
 
04 Ago 23
18:00 Finalizado
Dijon FCO Dijon FCO 1-0 Bourg-Péronnas Bourg-Péronnas más información Jugadas destacadas 1
87' C. Irié 1-0
 
04 Ago 23
18:00 Aplazado
Annecy Annecy Apl Nancy Nancy más información 1
 
04 Ago 23
18:00 Finalizado
Calangianus Calangianus 0-5 Olbia Calcio Olbia Calcio más información 1
 
04 Ago 23
18:00 Finalizado
PAS Giannina PAS Giannina 1-1 Panserraikos FC Panserraikos FC más información Jugadas destacadas 9
0-1 41' K. Aleksić
61' Pedro Conde 1-1
 
04 Ago 23
18:00 Finalizado
NEC Nijmegen NEC Nijmegen 3-1 Venezia Venezia más información Jugadas destacadas 17
26' Koki Ogawa 1-0
51' M. Mattsson 2-0
2-1 55' T. Tessmann
64' M. Mattsson 3-1
 
04 Ago 23
18:30 Finalizado
Cholet Cholet 1-0 Voltigeurs Châteaubriant Voltigeurs más información Jugadas destacadas 10
20' O. Abdeldjelil 1-0
 
04 Ago 23
18:30 Finalizado
Floriana FC Floriana FC 2-0 Hibernians Hibernians más información Jugadas destacadas 1
21' K. Nwoko 1-0
40' Kemar Reid 2-0
 
04 Ago 23
18:30 Finalizado
FC Spich FC Spich 1-3 Bonner SC Bonner SC más información Jugadas destacadas 1
0-1 5' M. Wipperfürth
54' Alexander Dick 1-1
1-2 55' R. González
1-3 67' R. González
 
04 Ago 23
18:30 Finalizado
Chateauroux Chateauroux 1-1 UNFP UNFP más información Jugadas destacadas 1
47' G. Durbant 1-0
1-1 88' Yanick Aguemon
 
04 Ago 23
19:00 Finalizado
Beerschot VA Beerschot VA 0-0 Fortuna Sittard Fortuna Sittard más información Jugadas destacadas 2
50' A. Ferati
 
04 Ago 23
19:00 Aplazado
Cambuur Cambuur Apl Emmen Emmen más información 1
 
04 Ago 23
19:00 Aplazado
FC Rouen 1899 FC Rouen 1899 Apl Trouville Deauville Trouville Deauville más información 1
 
04 Ago 23
19:00 Finalizado
Leganés Leganés 2-0 Osasuna Promesas Osasuna Promesas más información Jugadas destacadas 16
18' Diego García 1-0
57' J. Hernández 2-0
 
04 Ago 23
19:00 Finalizado
Huesca Huesca 0-1 FC Andorra FC Andorra más información Jugadas destacadas 23
0-1 68' A. Vilanova
 
04 Ago 23
19:00 Finalizado
Silla CF Silla CF 0-1 Torrent Torrent más información Jugadas destacadas 2
0-1 45' Christian
 
04 Ago 23
19:00 Finalizado
Dinamo Helfort 15 Dinamo Helfort 15 2-2 Zwettl Zwettl más información Jugadas destacadas 1
43' M. Parmakovic 1-0
60' Christiano Ivkic 2-0
2-1 79' Sebastian Thomas Penz
2-2 79' G. Schmidt
 
04 Ago 23
19:00 Finalizado
FC Rouen 1899 FC Rouen 1899 1-1 AF Virois AF Virois más información Jugadas destacadas 1
0-1 59' A. Bekombo
 
04 Ago 23
19:00 Finalizado
Burgos Burgos 1-2 Osasuna Osasuna más información Jugadas destacadas 68
0-1 17' Aimar Oroz
0-2 80' Lucas Torró
87' Borja González 1-2
 
04 Ago 23
19:30 Finalizado
Orléans Orléans 1-1 Saint-Pryve Saint-Pryve más información Jugadas destacadas 1
0-1 85' T. Mothmora
90' N. Saint-Ruf 1-1
 
04 Ago 23
19:30 Finalizado
Real Valladolid Promesas Real Valladolid Promesas 1-0 SD Almazán SD Almazán más información 3
 
04 Ago 23
19:30 Finalizado
Villefranche Villefranche 1-2 Thonon Évian Thonon Évian más información Jugadas destacadas 1
0-1 15' O. Lesueur
0-2 41' M. Clairicia
 
04 Ago 23
19:30 Finalizado
NAC Breda NAC Breda 1-1 Alanyaspor Alanyaspor más información Jugadas destacadas 20
0-1 19' Anderson Silva
68' T. Boere 1-1
 
04 Ago 23
19:30 Finalizado
Tropezón Tropezón 2-1 Gimnástica Torrelavega Gimnástica Torrelavega más información Jugadas destacadas 2
0-1 26' Saul García
43' Saza 1-1
85' Kevin 2-1
 
04 Ago 23
19:45 Finalizado
Fafe Fafe 2-1 Nacional Nacional más información 1
 
04 Ago 23
20:00 Finalizado
Tienen Tienen 1-0 Diegem Sport Diegem Sport más información Jugadas destacadas 1
64' J. Vanweerts 1-0
 
04 Ago 23
20:00 Finalizado
CD Rincón CD Rincón 2-2 CD Llano Perchel CD Llano Perchel más información Jugadas destacadas 3
23' Chechu 1-0
55' Pepe Capitán 2-0
 
04 Ago 23
20:00 Finalizado
Corellano Corellano 1-2 CD Alfaro CD Alfaro más información Jugadas destacadas 3
0-1 35' I. Jiménez
0-2 89' L. Jimenez
 
04 Ago 23
20:00 Finalizado
Real Avilés Industrial Real Avilés Industrial 0-0 Real Sporting Real Sporting más información 47
 
04 Ago 23
20:30 Finalizado
Chaves Chaves 0-1 Famalicão Famalicão más información Jugadas destacadas 6
0-1 80' Gustavo Sá
 
04 Ago 23
20:30 Finalizado
Udinese Udinese 2-1 Al-Rayyan Al-Rayyan más información Jugadas destacadas 5
0-1 22' B. Al-Rawi
34' Beto 1-1
50' F. Thauvin 2-1
 
04 Ago 23
20:30 Finalizado
Marine Marine 3-0 Nantwich Town Nantwich Town más información Jugadas destacadas 4
70' M. Mampala 1-0
73' Will Russ 2-0
76' Will Russ 3-0
 
04 Ago 23
20:30 Finalizado
CD Alhaurino CD Alhaurino 1-2 At. Malagueño At. Malagueño más información 2
 
04 Ago 23
20:30 Finalizado
Córdoba CF Córdoba CF (4) 1-1 (5) Cádiz Cádiz más información Jugadas destacadas 83
82' D. Gudelj 1-0
1-1 87' Darwin Machís
 
04 Ago 23
20:30 Finalizado
Mickleover Sports FC Mickleover Sports FC 0-1 Derby County Sub 21 Derby County Sub 21 más información 1
 
04 Ago 23
20:45 Finalizado
Belper Town FC Belper Town FC 1-3 Matlock Town Matlock Town más información Jugadas destacadas 1
0-1 7' J. Margetts
0-2 28' R. Styche
66' C. Burrows 1-2
1-3 71' N. Crofts
 
04 Ago 23
20:45 Aplazado
Cray Wanderers Cray Wanderers Apl Erith & Belvedere Erith & Belvedere más información 1
 
04 Ago 23
21:00 Finalizado
UD Montijo UD Montijo 0-0 CD Badajoz CD Badajoz más información 7
 
04 Ago 23
21:30 Finalizado
AD Ceuta FC AD Ceuta FC 1-0 UD Melilla UD Melilla más información Jugadas destacadas 31
51' Aisar 1-0

INFORMACIÓN
Partidos Amistosos entren clubes de todo el mundo.Se realizan antes de comenzar sus respectivas ligas.
Partidos Amistosos
28 Mar 24 00:01
Neo Química Arena
28 Mar 24 11:30
Bolt Arena
28 Mar 24 14:00
Vodafone Arena
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,534,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2217
Total Execution Time  0.2236
  CADENA URL  
/partidos_amistosos/grupo1/jornada65
  GET DATOS  
$_GET['/partidos_amistosos/grupo1/jornada65']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0096  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1307741,1307681,1307639,1307019,1302410) ORDER BY n.cover_points DESC, update_date DESC
0.0205  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 71432 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT type,rule FROM rules WHERE categoryId = 153 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 13:26:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 13:26:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 13:26:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 13:26:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=71432 AND rel.round=65
0.0049  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name 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` = 71432 AND c.`round` = 65 ORDER BY shedule ASC LIMIT 200
0.0085  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 71432 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (400839,443277,458776,143710,40536,15683,2512,450705,443361,443364,458567,455773,443365,458788,455782,454511,207491,458581,455787,455783,455781,86465,454512,443366,453205,453206,443112,44131,458800,7675,439426,36275,111634,458808,458803,189354,40537,454524,458813,123115,455796,455797,458815,458818,458195,451676,425337,458819,455806,454527,443757,443756,469704,2517,455808,469708,208664) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0343  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 65 AND e.real_date IS NOT NULL AND e.league_id = 71432 ORDER BY total DESC LIMIT 40
0.0133  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 71432 AND shedule >= '2023/08/01' AND shedule < '2023/09/01' ORDER BY shedule ASC
0.0080  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 71432 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0030  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 721304
0.0030  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 720025
0.0031  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 677005
0.0034  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 685141
0.0030  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 719957
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0028  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2024