4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Primera División Femenina
2023/2024

Primera División Femenina

  • Barcelona Fem
  • Atlético Fem
  • Real Madrid Fem
  • Levante Fem
  • Madrid CFF Fem
  • Sevilla FC Fem
  • Levante Las Planas Fem
  • Costa Adeje Tenerife Fem
  • Real Sociedad Fem
  • Athletic Fem
  • Real Betis Fem
  • Valencia Fem
  • Villarreal Fem
  • Eibar Fem
  • Granada CF Fem
  • Sporting Huelva Fem
Resultados
« Jornada Anterior
Jornada 11
Jornada Siguiente »
09 Dic 23
12:00 Finalizado 		Costa Adeje Tenerife Fem Costa Adeje Tenerife 2-0 Granada CF Fem Granada CF Fem más información Jugadas destacadas 7
10' Ange N'guessan 1-0
61' Thais Ferreira 2-0
09 Dic 23
14:00 Finalizado 		Sporting Huelva Fem Sporting Huelva Fem 1-2 Real Sociedad Fem Real Sociedad Fem más información Jugadas destacadas 11
0-1 21' M. Uria
40' K. Konat 1-1
1-2 72' S. Jensen
09 Dic 23
16:30 Finalizado 		Barcelona Fem Barcelona Fem 5-0 Eibar Fem Eibar Fem más información Jugadas destacadas 26
57' C. Graham 1-0
58' E. Brugts 2-0
61' E. Brugts 3-0
66' E. Brugts 4-0
88' Ari 5-0
09 Dic 23
18:30 Finalizado 		Real Madrid Fem Real Madrid Fem 1-3 Sevilla FC Fem Sevilla FC Fem más información Jugadas destacadas 80
51' Oihane
85' C. Moller Hansen 2-0
2-1 94' Arola
2-2 100' Gemma
10 Dic 23
12:00 Finalizado 		Athletic Fem Athletic Fem 1-0 Levante Fem Levante Fem más información Jugadas destacadas 9
54' Azkona 1-0
10 Dic 23
14:00 Finalizado 		Villarreal Fem Villarreal Fem 2-2 Levante Las Planas Fem Levante Las Planas Fem más información Jugadas destacadas 1
25' Bicho 1-0
47' María Llompart 2-0
2-1 82' C. Baudet
2-2 97' J. Martínez
10 Dic 23
16:30 Finalizado 		Real Betis Fem Real Betis Fem 0-2 Atlético Fem Atlético Fem más información Jugadas destacadas 8
0-1 6' E. Banini
0-2 73' R. Ajibade
10 Dic 23
18:30 Finalizado 		Valencia Fem Valencia Fem 3-4 Madrid CFF Fem Madrid CFF Fem más información Jugadas destacadas 9
26' I. Chacón 1-0
50' Pauleta 2-0
2-1 57' R. Kundananji
59' I. Chacón 3-1
3-2 74' K. Araya
3-3 80' A. Cometti
3-4 91' Ana González
Clasificación
« Jornada Anterior
Jornada 11
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Barcelona Fem Barcelona Fem 33 11 11 0 0 48 2
  • VICTORIA
  • Barcelona Fem 8
  • Sevilla FC Fem 0
  • VICTORIA
  • Villarreal Fem 0
  • Barcelona Fem 6
  • VICTORIA
  • Barcelona Fem 5
  • Real Madrid Fem 0
  • VICTORIA
  • Athletic Fem 0
  • Barcelona Fem 4
  • VICTORIA
  • Barcelona Fem 5
  • Eibar Fem 0
2 Atlético Fem Atlético Fem 25 11 8 1 2 23 7
  • DERROTA
  • Costa Adeje Teneri. 2
  • Atlético Fem 1
  • VICTORIA
  • Atlético Fem 3
  • Eibar Fem 0
  • VICTORIA
  • Madrid CFF Fem 1
  • Atlético Fem 4
  • VICTORIA
  • Atlético Fem 2
  • Granada CF Fem 0
  • VICTORIA
  • Real Betis Fem 0
  • Atlético Fem 2
3 Real Madrid Fem Real Madrid Fem 24 11 8 0 3 30 17
  • VICTORIA
  • Eibar Fem 0
  • Real Madrid Fem 1
  • VICTORIA
  • Real Madrid Fem 7
  • Real Sociedad Fem 1
  • DERROTA
  • Barcelona Fem 5
  • Real Madrid Fem 0
  • VICTORIA
  • Real Madrid Fem 5
  • Sporting Huelva Fe. 2
  • DERROTA
  • Real Madrid Fem 1
  • Sevilla FC Fem 3
4 Levante Fem Levante Fem 24 11 7 3 1 19 6
  • VICTORIA
  • Madrid CFF Fem 0
  • Levante Fem 1
  • VICTORIA
  • Levante Fem 3
  • Valencia Fem 1
  • VICTORIA
  • Costa Adeje Teneri. 0
  • Levante Fem 1
  • VICTORIA
  • Levante Fem 3
  • Eibar Fem 0
  • DERROTA
  • Athletic Fem 1
  • Levante Fem 0
5 Madrid CFF Fem Madrid CFF Fem 24 11 8 0 3 29 19
  • DERROTA
  • Madrid CFF Fem 0
  • Levante Fem 1
  • VICTORIA
  • Athletic Fem 1
  • Madrid CFF Fem 2
  • DERROTA
  • Madrid CFF Fem 1
  • Atlético Fem 4
  • VICTORIA
  • Levante Las Planas. 3
  • Madrid CFF Fem 4
  • VICTORIA
  • Valencia Fem 3
  • Madrid CFF Fem 4
6 Sevilla FC Fem Sevilla FC Fem 18 11 6 0 5 22 23
  • DERROTA
  • Barcelona Fem 8
  • Sevilla FC Fem 0
  • VICTORIA
  • Sevilla FC Fem 1
  • Granada CF Fem 0
  • VICTORIA
  • Real Sociedad Fem 1
  • Sevilla FC Fem 2
  • VICTORIA
  • Sevilla FC Fem 6
  • Real Betis Fem 0
  • VICTORIA
  • Real Madrid Fem 1
  • Sevilla FC Fem 3
7 Levante Las Planas Fem Levante Planas 16 11 4 4 3 17 15
  • VICTORIA
  • Granada CF Fem 0
  • Levante Las Planas. 1
  • VICTORIA
  • Levante Las Planas. 3
  • Costa Adeje Teneri. 1
  • DERROTA
  • Real Betis Fem 1
  • Levante Las Planas. 0
  • DERROTA
  • Levante Las Planas. 3
  • Madrid CFF Fem 4
  • EMPATE
  • Villarreal Fem 2
  • Levante Las Planas. 2
8 Costa Adeje Tenerife Fem Costa Adeje Ten. 16 11 5 1 5 14 16
  • VICTORIA
  • Costa Adeje Teneri. 2
  • Atlético Fem 1
  • DERROTA
  • Levante Las Planas. 3
  • Costa Adeje Teneri. 1
  • DERROTA
  • Costa Adeje Teneri. 0
  • Levante Fem 1
  • EMPATE
  • Villarreal Fem 1
  • Costa Adeje Teneri. 1
  • VICTORIA
  • Costa Adeje Teneri. 2
  • Granada CF Fem 0
9 Real Sociedad Fem Real Sociedad 16 11 5 1 5 15 20
  • VICTORIA
  • Real Sociedad Fem 1
  • Villarreal Fem 0
  • DERROTA
  • Real Madrid Fem 7
  • Real Sociedad Fem 1
  • DERROTA
  • Real Sociedad Fem 1
  • Sevilla FC Fem 2
  • VICTORIA
  • Real Sociedad Fem 2
  • Valencia Fem 0
  • VICTORIA
  • Sporting Huelva Fe. 1
  • Real Sociedad Fem 2
10 Athletic Fem Athletic Fem 15 11 5 0 6 11 17
  • DERROTA
  • Real Betis Fem 1
  • Athletic Fem 0
  • DERROTA
  • Athletic Fem 1
  • Madrid CFF Fem 2
  • VICTORIA
  • Valencia Fem 1
  • Athletic Fem 2
  • DERROTA
  • Athletic Fem 0
  • Barcelona Fem 4
  • VICTORIA
  • Athletic Fem 1
  • Levante Fem 0
11 Real Betis Fem Real Betis Fem 13 11 4 1 6 10 23
  • VICTORIA
  • Real Betis Fem 1
  • Athletic Fem 0
  • VICTORIA
  • Sporting Huelva Fe. 1
  • Real Betis Fem 3
  • VICTORIA
  • Real Betis Fem 1
  • Levante Las Planas. 0
  • DERROTA
  • Sevilla FC Fem 6
  • Real Betis Fem 0
  • DERROTA
  • Real Betis Fem 0
  • Atlético Fem 2
12 Valencia Fem Valencia Fem 11 11 3 2 6 14 24
  • VICTORIA
  • Valencia Fem 2
  • Sporting Huelva Fe. 0
  • DERROTA
  • Levante Fem 3
  • Valencia Fem 1
  • DERROTA
  • Valencia Fem 1
  • Athletic Fem 2
  • DERROTA
  • Real Sociedad Fem 2
  • Valencia Fem 0
  • DERROTA
  • Valencia Fem 3
  • Madrid CFF Fem 4
13 Villarreal Fem Villarreal Fem 9 11 2 3 6 10 18
  • DERROTA
  • Real Sociedad Fem 1
  • Villarreal Fem 0
  • DERROTA
  • Villarreal Fem 0
  • Barcelona Fem 6
  • VICTORIA
  • Granada CF Fem 1
  • Villarreal Fem 2
  • EMPATE
  • Villarreal Fem 1
  • Costa Adeje Teneri. 1
  • EMPATE
  • Villarreal Fem 2
  • Levante Las Planas. 2
14 Eibar Fem Eibar Fem 7 11 2 1 8 6 25
  • DERROTA
  • Eibar Fem 0
  • Real Madrid Fem 1
  • DERROTA
  • Atlético Fem 3
  • Eibar Fem 0
  • VICTORIA
  • Eibar Fem 1
  • Sporting Huelva Fe. 0
  • DERROTA
  • Levante Fem 3
  • Eibar Fem 0
  • DERROTA
  • Barcelona Fem 5
  • Eibar Fem 0
15 Granada CF Fem Granada CF Fem 3 11 1 0 10 7 24
  • DERROTA
  • Granada CF Fem 0
  • Levante Las Planas. 1
  • DERROTA
  • Sevilla FC Fem 1
  • Granada CF Fem 0
  • DERROTA
  • Granada CF Fem 1
  • Villarreal Fem 2
  • DERROTA
  • Atlético Fem 2
  • Granada CF Fem 0
  • DERROTA
  • Costa Adeje Teneri. 2
  • Granada CF Fem 0
16 Sporting Huelva Fem Sporting Huelva 1 11 0 1 10 7 26
  • DERROTA
  • Valencia Fem 2
  • Sporting Huelva Fe. 0
  • DERROTA
  • Sporting Huelva Fe. 1
  • Real Betis Fem 3
  • DERROTA
  • Eibar Fem 1
  • Sporting Huelva Fe. 0
  • DERROTA
  • Real Madrid Fem 5
  • Sporting Huelva Fe. 2
  • DERROTA
  • Sporting Huelva Fe. 1
  • Real Sociedad Fem 2
Champions League : Barcelona Fem
Previa de Champions : Atlético 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

20 Abr 24 12:00
Ciudad Deportiva De Buñol
20 Abr 24 14:00
Ciudad Deportiva Del Granada CF
20 Abr 24 16:00
Antonio Toledo Sánchez
20 Abr 24 18:00
Estadio Fernando Torres
21 Abr 24 12:00
Centro Deportivo Cívitas Alcalá De Henares

  USO DE MEMORIA  
5,710,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.3897
Total Execution Time  0.3926
  CADENA URL  
/primera_division_femenina/grupo1/jornada11
  GET DATOS  
$_GET['/primera_division_femenina/grupo1/jornada11']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=282 AND type_rel = 3
0.0190  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 (1311508,1311144,1309329,1309081,1308811) 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-04-18 19:29:49' 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-04-18 19:29:50' 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=4 AND last_update > '2024-04-18 19:29:50' 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=3 AND last_update > '2024-04-18 19:29:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 282 GROUP BY l.categoryId
0.0106  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=282 GROUP BY l.year ORDER BY l.year DESC
0.0107  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=11
0.0110  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` = 11 ORDER BY shedule ASC LIMIT 200
0.0114  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 (426412,426418,426422,426355,426349,426406,426364,426416) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0125  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 = 11 AND e.real_date IS NOT NULL AND e.league_id = 72467 ORDER BY total DESC LIMIT 40
0.0114  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 = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72467 AND shedule >= '2023/12/01' AND shedule < '2024/01/01' ORDER BY shedule ASC
0.0133  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-04-18 00:00:00' AND c.`shedule` < '2024-04-22 23:59:59' AND l.id = 72467 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0169  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 = 426492
0.0121  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 = 426487
0.0117  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 = 426500
0.0117  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 = 426493
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 = 426486
0.0105  SELECT data1, data2 FROM services_tags WHERE categoryId=282
0.0106  SELECT group_code, extraName from `leagues` WHERE categoryId=282 AND year=2024