Publicidad 600x120.gif
Primera División Femenina
2023/2024

Primera División Femenina

  • Barcelona Fem
  • Madrid CFF Fem
  • Real Madrid Fem
  • Atlético Fem
  • Levante Fem
  • Levante Las Planas Fem
  • Costa Adeje Tenerife Fem
  • Athletic Fem
  • Valencia Fem
  • Real Sociedad Fem
  • Sevilla FC Fem
  • Villarreal Fem
  • Eibar Fem
  • Real Betis Fem
  • Granada CF Fem
  • Sporting Huelva Fem
21 Oct 23
12:00 Finalizado
Real Betis Fem Real Betis Fem 2-2 Valencia Fem Valencia Fem más información Jugadas destacadas 3
0-1 27' Anita
0-2 33' Fiamma
43' C. Álvarez 1-2
64' Carol Férez 2-2
79' Pauleta
21 Oct 23
12:00 Finalizado
Eibar Fem Eibar Fem 0-0 Villarreal Fem Villarreal Fem más información 2
21 Oct 23
16:00 Finalizado
Sporting Huelva Fem Sporting Huelva Fem 0-2 Atlético Fem Atlético Fem más información Jugadas destacadas 3
0-1 31' Sheila
0-2 46' Cinta Rodríguez
21 Oct 23
18:30 Finalizado
Barcelona Fem Barcelona Fem 6-1 Granada CF Fem Granada CF Fem más información Jugadas destacadas 11
6' Patri Guijarro 1-0
29' Ona Batlle 2-0
59' S. Paralluelo 3-0
66' Mariona 4-0
80' A. Oshoala 5-0
82' A. Oshoala 6-0
6-1 93' Laura Pérez
22 Oct 23
12:00 Finalizado
Athletic Fem Athletic Fem 2-1 Real Sociedad Fem Real Sociedad Fem más información Jugadas destacadas 39
0-1 41' N. Eizagirre
45' Azkona 1-1
84' Jone Amezaga 2-1
22 Oct 23
12:00 Finalizado
Madrid CFF Fem Madrid CFF Fem 3-2 Costa Adeje Tenerife Fem Costa Adeje Tenerife más información Jugadas destacadas 4
37' Aida Esteve 1-0
42' R. Kundananji 2-0
2-1 44' A. Barroso
2-2 85' E. Okoronkwo
94' Laurita 3-2
22 Oct 23
16:00 Finalizado
Levante Las Planas Fem Levante Las Planas Fem 1-2 Sevilla FC Fem Sevilla FC Fem más información Jugadas destacadas 12
17' A. Lahmari 1-0
1-1 36' E. Llamas
1-2 91' I. Gabarro
22 Oct 23
18:30 Finalizado
Real Madrid Fem Real Madrid Fem 1-2 Levante Fem Levante Fem más información Jugadas destacadas 77
0-1 12' Paula
50' L. Caicedo 1-1
1-2 67' Gabriela Nunes
Equipos Puntos J. G. E. P. F. C. Forma
1 Barcelona Fem Barcelona Fem 18 6 6 0 0 20 2
  • VICTORIA
  • Sporting Huelva Fe. 1
  • Barcelona Fem 2
  • VICTORIA
  • Barcelona Fem 6
  • Valencia Fem 0
  • VICTORIA
  • Barcelona Fem 3
  • Real Sociedad Fem 0
  • VICTORIA
  • Atlético Fem 0
  • Barcelona Fem 1
  • VICTORIA
  • Barcelona Fem 6
  • Granada CF Fem 1
2 Madrid CFF Fem Madrid CFF Fem 15 6 5 0 1 18 7
  • VICTORIA
  • Sevilla FC Fem 1
  • Madrid CFF Fem 5
  • VICTORIA
  • Eibar Fem 1
  • Madrid CFF Fem 6
  • VICTORIA
  • Madrid CFF Fem 1
  • Granada CF Fem 0
  • VICTORIA
  • Sporting Huelva Fe. 1
  • Madrid CFF Fem 3
  • VICTORIA
  • Madrid CFF Fem 3
  • Costa Adeje Teneri. 2
3 Real Madrid Fem Real Madrid Fem 15 6 5 0 1 16 6
  • VICTORIA
  • Costa Adeje Teneri. 1
  • Real Madrid Fem 2
  • VICTORIA
  • Real Madrid Fem 5
  • Real Betis Fem 1
  • VICTORIA
  • Real Madrid Fem 1
  • Villarreal Fem 0
  • VICTORIA
  • Granada CF Fem 2
  • Real Madrid Fem 5
  • DERROTA
  • Real Madrid Fem 1
  • Levante Fem 2
4 Atlético Fem Atlético Fem 13 6 4 1 1 11 4
  • EMPATE
  • Levante Fem 1
  • Atlético Fem 1
  • VICTORIA
  • Villarreal Fem 1
  • Atlético Fem 3
  • VICTORIA
  • Atlético Fem 2
  • Sevilla FC Fem 1
  • DERROTA
  • Atlético Fem 0
  • Barcelona Fem 1
  • VICTORIA
  • Sporting Huelva Fe. 0
  • Atlético Fem 2
5 Levante Fem Levante Fem 12 6 3 3 0 11 4
  • EMPATE
  • Levante Fem 1
  • Atlético Fem 1
  • EMPATE
  • Real Sociedad Fem 1
  • Levante Fem 1
  • VICTORIA
  • Real Betis Fem 0
  • Levante Fem 4
  • EMPATE
  • Levante Fem 1
  • Levante Las Planas. 1
  • VICTORIA
  • Real Madrid Fem 1
  • Levante Fem 2
6 Levante Las Planas Fem Levante Planas 9 6 2 3 1 8 7
  • VICTORIA
  • Levante Las Planas. 2
  • Athletic Fem 1
  • EMPATE
  • Levante Las Planas. 1
  • Sporting Huelva Fe. 1
  • EMPATE
  • Valencia Fem 1
  • Levante Las Planas. 1
  • EMPATE
  • Levante Fem 1
  • Levante Las Planas. 1
  • DERROTA
  • Levante Las Planas. 1
  • Sevilla FC Fem 2
7 Costa Adeje Tenerife Fem Costa Adeje Ten. 9 6 3 0 3 8 10
  • DERROTA
  • Costa Adeje Teneri. 1
  • Real Madrid Fem 2
  • DERROTA
  • Sevilla FC Fem 5
  • Costa Adeje Teneri. 1
  • VICTORIA
  • Eibar Fem 0
  • Costa Adeje Teneri. 1
  • VICTORIA
  • Costa Adeje Teneri. 1
  • Real Betis Fem 0
  • DERROTA
  • Madrid CFF Fem 3
  • Costa Adeje Teneri. 2
8 Athletic Fem Athletic Fem 9 6 3 0 3 7 9
  • DERROTA
  • Levante Las Planas. 2
  • Athletic Fem 1
  • VICTORIA
  • Athletic Fem 1
  • Granada CF Fem 0
  • VICTORIA
  • Athletic Fem 3
  • Sporting Huelva Fe. 0
  • DERROTA
  • Villarreal Fem 3
  • Athletic Fem 0
  • VICTORIA
  • Athletic Fem 2
  • Real Sociedad Fem 1
9 Valencia Fem Valencia Fem 8 6 2 2 2 7 13
  • VICTORIA
  • Villarreal Fem 1
  • Valencia Fem 2
  • DERROTA
  • Barcelona Fem 6
  • Valencia Fem 0
  • EMPATE
  • Valencia Fem 1
  • Levante Las Planas. 1
  • VICTORIA
  • Sevilla FC Fem 1
  • Valencia Fem 2
  • EMPATE
  • Real Betis Fem 2
  • Valencia Fem 2
10 Real Sociedad Fem Real Sociedad 7 6 2 1 3 8 10
  • VICTORIA
  • Real Sociedad Fem 2
  • Real Betis Fem 1
  • EMPATE
  • Real Sociedad Fem 1
  • Levante Fem 1
  • DERROTA
  • Barcelona Fem 3
  • Real Sociedad Fem 0
  • VICTORIA
  • Real Sociedad Fem 3
  • Eibar Fem 1
  • DERROTA
  • Athletic Fem 2
  • Real Sociedad Fem 1
11 Sevilla FC Fem Sevilla FC Fem 6 6 2 0 4 10 13
  • DERROTA
  • Sevilla FC Fem 1
  • Madrid CFF Fem 5
  • VICTORIA
  • Sevilla FC Fem 5
  • Costa Adeje Teneri. 1
  • DERROTA
  • Atlético Fem 2
  • Sevilla FC Fem 1
  • DERROTA
  • Sevilla FC Fem 1
  • Valencia Fem 2
  • VICTORIA
  • Levante Las Planas. 1
  • Sevilla FC Fem 2
12 Villarreal Fem Villarreal Fem 4 6 1 1 4 5 7
  • DERROTA
  • Villarreal Fem 1
  • Valencia Fem 2
  • DERROTA
  • Villarreal Fem 1
  • Atlético Fem 3
  • DERROTA
  • Real Madrid Fem 1
  • Villarreal Fem 0
  • VICTORIA
  • Villarreal Fem 3
  • Athletic Fem 0
  • EMPATE
  • Eibar Fem 0
  • Villarreal Fem 0
13 Eibar Fem Eibar Fem 4 6 1 1 4 5 13
  • VICTORIA
  • Granada CF Fem 1
  • Eibar Fem 2
  • DERROTA
  • Eibar Fem 1
  • Madrid CFF Fem 6
  • DERROTA
  • Eibar Fem 0
  • Costa Adeje Teneri. 1
  • DERROTA
  • Real Sociedad Fem 3
  • Eibar Fem 1
  • EMPATE
  • Eibar Fem 0
  • Villarreal Fem 0
14 Real Betis Fem Real Betis Fem 4 6 1 1 4 5 14
  • DERROTA
  • Real Sociedad Fem 2
  • Real Betis Fem 1
  • DERROTA
  • Real Madrid Fem 5
  • Real Betis Fem 1
  • DERROTA
  • Real Betis Fem 0
  • Levante Fem 4
  • DERROTA
  • Costa Adeje Teneri. 1
  • Real Betis Fem 0
  • EMPATE
  • Real Betis Fem 2
  • Valencia Fem 2
15 Granada CF Fem Granada CF Fem 3 6 1 0 5 6 16
  • DERROTA
  • Granada CF Fem 1
  • Eibar Fem 2
  • DERROTA
  • Athletic Fem 1
  • Granada CF Fem 0
  • DERROTA
  • Madrid CFF Fem 1
  • Granada CF Fem 0
  • DERROTA
  • Granada CF Fem 2
  • Real Madrid Fem 5
  • DERROTA
  • Barcelona Fem 6
  • Granada CF Fem 1
16 Sporting Huelva Fem Sporting Huelva 1 6 0 1 5 3 13
  • DERROTA
  • Sporting Huelva Fe. 1
  • Barcelona Fem 2
  • EMPATE
  • Levante Las Planas. 1
  • Sporting Huelva Fe. 1
  • DERROTA
  • Athletic Fem 3
  • Sporting Huelva Fe. 0
  • DERROTA
  • Sporting Huelva Fe. 1
  • Madrid CFF Fem 3
  • DERROTA
  • Sporting Huelva Fe. 0
  • Atlético Fem 2
Champions League : Barcelona Fem
Previa de Champions : Madrid CFF Fem, Real Madrid Fem
Descenso : Granada CF Fem, Sporting Huelva

INFORMACIÓN
La Primera División Femenina,anteriormente conocida como Superliga, es la máxima categoría de la liga española de fútbol femenino.La competición la disputan 18 equipos que juegan todos contra todos a doble partido (un partido en el campo de cada equipo), según un calendario previamente establecido por sorteo. Los equipos puntuan en función de sus resultados: tres puntos por partido ganado, uno por el empate y ninguno por las derrotas. El club que suma más puntos al término del campeonato se proclama campeón de liga y obtiene una plaza para la siguiente edición de la Liga de Campeones de la UEFA. Asimismo, los cuatro primeros clasificados disputan la Copa de la Reina al término de la liga. Los clasificados en los puestos 15 a 18 descienden a Segunda División Femenina.
Primera División Femenina
30 Mar 24 12:00
Estadio Jesús Navas
30 Mar 24 14:00
Ciudad Deportiva Luis Del Sol
30 Mar 24 16:00
Centro Deportivo Cívitas Alcalá De Henares
30 Mar 24 19:00
Ciudad Deportiva José Manuel Llaneza
31 Mar 24 12:00
Antonio Toledo Sánchez
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  
5,776,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3844
Total Execution Time  0.3865
  CADENA URL  
/primera_division_femenina/grupo1/jornada6
  GET DATOS  
$_GET['/primera_division_femenina/grupo1/jornada6']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=282 AND type_rel = 3
0.0176  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 282 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1308363,1308264,1308227,1307993,1307906) ORDER BY n.cover_points DESC, update_date DESC
0.0108  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=282 ORDER BY l.group_code ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 10:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 10:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 10:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 10:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  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=72467 AND rel.round=6
0.0132  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` = 72467 AND c.`round` = 6 ORDER BY shedule ASC LIMIT 200
0.0161  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 = 72467 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 (426347,426401,426410,426330,426326,426341,426334,426414) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0148  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 = 6 AND e.real_date IS NOT NULL AND e.league_id = 72467 ORDER BY total DESC LIMIT 40
0.0110  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 = 72467 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0224  SELECT *,(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 = 72467 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72467 AND shedule >= '2023/10/01' AND shedule < '2023/11/01' ORDER BY shedule ASC
0.0116  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 72467 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0139  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 = 426596
0.0161  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 = 426537
0.0118  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 = 426534
0.0118  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 = 426542
0.0118  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 = 426540
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=282
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=282 AND year=2024