2.855.770 resultados, 9.127.069 comentarios, 804.045 imágenes, 79.786 vídeos, 85.880 noticias
Liga Rusa
2021/2022

Liga Rusa

Publicidad 600x120.gif
  • Zenit
  • Dinamo Moskva
  • Sochi
  • Lokomotiv Moskva
  • FK Krasnodar
  • CSKA Moskva
  • Krylia Sovetov
  • Rubin Kazán
  • Akhmat Grozny
  • Spartak Moskva
  • FK Rostov
  • Ufa
  • FK Nizhny Novgorod
  • Arsenal Tula
  • FK Khimki
  • Ural Yekaterinburg
27 Nov 21
Sin comenzar
Ural Yekaterinburg Ural Yekaterinburg
12:00
Sochi Sochi más información 1
27 Nov 21
Sin comenzar
Akhmat Grozny Akhmat Grozny
14:30
FK Rostov FK Rostov más información ...
27 Nov 21
Sin comenzar
FK Khimki FK Khimki
17:00
FK Krasnodar FK Krasnodar más información ...
28 Nov 21
Sin comenzar
FK Nizhny Novgorod FK Nizhny Novgorod
12:00
Krylia Sovetov Krylia Sovetov más información ...
28 Nov 21
Sin comenzar
Rubin Kazán Rubin Kazán
14:30
Dinamo Moskva Dinamo Moskva más información ...
28 Nov 21
Sin comenzar
CSKA Moskva CSKA Moskva
18:00
Zenit Zenit más información ...
29 Nov 21
Sin comenzar
Ufa Ufa
15:00
Spartak Moskva Spartak Moskva más información 1
29 Nov 21
Sin comenzar
Arsenal Tula Arsenal Tula
17:00
Lokomotiv Moskva Lokomotiv Moskva más información ...
Equipos Puntos J. G. E. P. F. C. Forma
1 Zenit Zenit 33 15 10 3 2 39 17
  • DERROTA
  • Arsenal Tula 2
  • Zenit 1
  • VICTORIA
  • Zenit 7
  • Spartak Moskva 1
  • VICTORIA
  • Zenit 4
  • Dinamo Moskva 1
  • EMPATE
  • Ural Yekaterinburg 0
  • Zenit 0
  • VICTORIA
  • Zenit 5
  • FK Nizhny Novgorod 1
2 Dinamo Moskva Dinamo Moskva 29 15 9 2 4 27 17
  • EMPATE
  • Spartak Moskva 2
  • Dinamo Moskva 2
  • VICTORIA
  • Dinamo Moskva 4
  • FK Khimki 1
  • DERROTA
  • Zenit 4
  • Dinamo Moskva 1
  • VICTORIA
  • Dinamo Moskva 1
  • FK Krasnodar 0
  • VICTORIA
  • Dinamo Moskva 5
  • Arsenal Tula 1
3 Sochi Sochi 27 15 9 0 6 25 18
  • VICTORIA
  • Sochi 3
  • FK Rostov 2
  • DERROTA
  • Lokomotiv Moskva 2
  • Sochi 1
  • VICTORIA
  • Arsenal Tula 1
  • Sochi 2
  • VICTORIA
  • Sochi 4
  • CSKA Moskva 1
  • DERROTA
  • Sochi 1
  • Rubin Kazán 2
4 Lokomotiv Moskva Lokomotiv Moskva 25 15 6 7 2 21 15
  • EMPATE
  • Rubin Kazán 2
  • Lokomotiv Moskva 2
  • VICTORIA
  • Lokomotiv Moskva 2
  • Sochi 1
  • VICTORIA
  • FK Nizhny Novgorod 1
  • Lokomotiv Moskva 2
  • EMPATE
  • Spartak Moskva 1
  • Lokomotiv Moskva 1
  • DERROTA
  • Lokomotiv Moskva 1
  • Akhmat Grozny 2
5 FK Krasnodar FK Krasnodar 24 15 7 3 5 24 14
  • EMPATE
  • FK Krasnodar 1
  • Ufa 1
  • VICTORIA
  • FK Nizhny Novgorod 1
  • FK Krasnodar 4
  • DERROTA
  • FK Krasnodar 0
  • Krylia Sovetov 1
  • DERROTA
  • Dinamo Moskva 1
  • FK Krasnodar 0
  • VICTORIA
  • FK Krasnodar 2
  • Spartak Moskva 1
6 CSKA Moskva CSKA Moskva 24 15 7 3 5 18 14
  • VICTORIA
  • Ural Yekaterinburg 0
  • CSKA Moskva 1
  • VICTORIA
  • CSKA Moskva 3
  • Krylia Sovetov 1
  • DERROTA
  • Rubin Kazán 1
  • CSKA Moskva 0
  • DERROTA
  • Sochi 4
  • CSKA Moskva 1
  • EMPATE
  • CSKA Moskva 0
  • FK Khimki 0
7 Krylia Sovetov Krylia Sovetov 23 15 7 2 6 20 17
  • VICTORIA
  • Krylia Sovetov 2
  • FK Nizhny Novgorod 0
  • DERROTA
  • CSKA Moskva 3
  • Krylia Sovetov 1
  • VICTORIA
  • FK Krasnodar 0
  • Krylia Sovetov 1
  • VICTORIA
  • Krylia Sovetov 3
  • FK Khimki 0
  • EMPATE
  • Krylia Sovetov 1
  • Ural Yekaterinburg 1
8 Rubin Kazán Rubin Kazán 22 15 6 4 5 20 20
  • EMPATE
  • Rubin Kazán 2
  • Lokomotiv Moskva 2
  • EMPATE
  • Ufa 1
  • Rubin Kazán 1
  • VICTORIA
  • Rubin Kazán 1
  • CSKA Moskva 0
  • DERROTA
  • FK Rostov 5
  • Rubin Kazán 1
  • VICTORIA
  • Sochi 1
  • Rubin Kazán 2
9 Akhmat Grozny Akhmat Grozny 21 15 7 0 8 17 21
  • DERROTA
  • FK Khimki 2
  • Akhmat Grozny 0
  • VICTORIA
  • Akhmat Grozny 1
  • Ural Yekaterinburg 0
  • DERROTA
  • Ufa 1
  • Akhmat Grozny 0
  • VICTORIA
  • Akhmat Grozny 3
  • FK Nizhny Novgorod 1
  • VICTORIA
  • Lokomotiv Moskva 1
  • Akhmat Grozny 2
10 Spartak Moskva Spartak Moskva 19 15 5 4 6 17 21
  • EMPATE
  • Spartak Moskva 2
  • Dinamo Moskva 2
  • DERROTA
  • Zenit 7
  • Spartak Moskva 1
  • EMPATE
  • Spartak Moskva 1
  • FK Rostov 1
  • EMPATE
  • Spartak Moskva 1
  • Lokomotiv Moskva 1
  • DERROTA
  • FK Krasnodar 2
  • Spartak Moskva 1
11 FK Rostov FK Rostov 17 15 4 5 6 27 27
  • DERROTA
  • Sochi 3
  • FK Rostov 2
  • VICTORIA
  • FK Rostov 4
  • Arsenal Tula 0
  • EMPATE
  • Spartak Moskva 1
  • FK Rostov 1
  • VICTORIA
  • FK Rostov 5
  • Rubin Kazán 1
  • EMPATE
  • FK Rostov 2
  • Ufa 2
12 Ufa Ufa 15 15 3 6 6 16 21
  • EMPATE
  • FK Krasnodar 1
  • Ufa 1
  • EMPATE
  • Ufa 1
  • Rubin Kazán 1
  • VICTORIA
  • Ufa 1
  • Akhmat Grozny 0
  • EMPATE
  • Arsenal Tula 0
  • Ufa 0
  • EMPATE
  • FK Rostov 2
  • Ufa 2
13 FK Nizhny Novgorod Nizhny Novgorod 14 15 4 2 9 16 29
  • DERROTA
  • Krylia Sovetov 2
  • FK Nizhny Novgorod 0
  • DERROTA
  • FK Nizhny Novgorod 1
  • FK Krasnodar 4
  • DERROTA
  • FK Nizhny Novgorod 1
  • Lokomotiv Moskva 2
  • DERROTA
  • Akhmat Grozny 3
  • FK Nizhny Novgorod 1
  • DERROTA
  • Zenit 5
  • FK Nizhny Novgorod 1
14 Arsenal Tula Arsenal Tula 13 15 3 4 8 16 31
  • VICTORIA
  • Arsenal Tula 2
  • Zenit 1
  • DERROTA
  • FK Rostov 4
  • Arsenal Tula 0
  • DERROTA
  • Arsenal Tula 1
  • Sochi 2
  • EMPATE
  • Arsenal Tula 0
  • Ufa 0
  • DERROTA
  • Dinamo Moskva 5
  • Arsenal Tula 1
15 FK Khimki FK Khimki 13 15 2 7 6 11 22
  • VICTORIA
  • FK Khimki 2
  • Akhmat Grozny 0
  • DERROTA
  • Dinamo Moskva 4
  • FK Khimki 1
  • EMPATE
  • FK Khimki 0
  • Ural Yekaterinburg 0
  • DERROTA
  • Krylia Sovetov 3
  • FK Khimki 0
  • EMPATE
  • CSKA Moskva 0
  • FK Khimki 0
16 Ural Yekaterinburg Ural 12 15 2 6 7 6 16
  • DERROTA
  • Ural Yekaterinburg 0
  • CSKA Moskva 1
  • DERROTA
  • Akhmat Grozny 1
  • Ural Yekaterinburg 0
  • EMPATE
  • FK Khimki 0
  • Ural Yekaterinburg 0
  • EMPATE
  • Ural Yekaterinburg 0
  • Zenit 0
  • EMPATE
  • Krylia Sovetov 1
  • Ural Yekaterinburg 1
Champions League : Zenit
Previa de Champions : Dinamo Moskva
Conference League : Sochi, Lokomotiv Moskva
Playoff Descenso : Nizhny Novgorod, Arsenal Tula
Descenso : FK Khimki, Ural

Realiza tu pronóstico

¿Quién ganará? Apuesta en RF
1
X
2
La Liga Premier de Rusia, (en ruso: Rossiiskaya futbol'naya prem'er-liga) es la máxima categoría de la liga de fútbol de ese país. Se creó en 1992, tras la desaparición de la URSS. El club que tiene el honor de ser el máximo vencedor es el Spartak de Moscú, con 9 títulos.
Liga Rusa
27 Nov 21 12:00
Ekaterinburg Arena
27 Nov 21 14:30
Stadion Im. Sultana Bilimkhanova
27 Nov 21 17:00
Arena Khimki
28 Nov 21 14:30
Kazan 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  
12,822,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.2278
Total Execution Time  0.2300
  CADENA URL  
/rusia
  GET DATOS  
$_GET['/rusia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018  SELECT type FROM routes WHERE alias = 'rusia'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27 AND type_rel = 3
0.0038  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 27 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 (1072869,1072754,1072722,1072471,1071937) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 62835 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2021-11-27 08:43:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2021-11-27 08:43:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2021-11-27 08:43:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2021-11-27 08:43:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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=62835 AND rel.round=16
0.0019  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 62835 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2021-10-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 62835 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2021-10-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 62835
0.0020  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 `calendars2022` 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` = 62835 AND c.`round` = 16 ORDER BY shedule ASC LIMIT 200
0.0022  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 events2022 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2022 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 62835 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 (6601,6596,6602,6599,6597,6595,6600,6598) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0028  SELECT name,eventId,odds,id_,live_id,site, link FROM bet_relations WHERE typeId=40 AND (site='bet365' AND eventId IN (110201008,110201010,110201012,110201015,110201020,110201022)) ORDER BY FIELD(site,'mbet', 'bet365', 'sportium', 'marca', 'bwin', 'b888sport'), eventId ASC
0.0063  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 `events2022` e INNER JOIN calendars2022 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 = 16 AND e.real_date IS NOT NULL AND e.league_id = 62835 ORDER BY total DESC LIMIT 40
0.0023  SELECT 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 `events2022` e INNER JOIN calendars2022 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 62835 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0046  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 `tables2022` 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 = 62835 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 62835 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT distinct(shedule), round FROM `calendars2022` as c WHERE c.`league_id` = 62835 AND shedule >= '2021/11/01' AND shedule < '2021/12/01' ORDER BY shedule ASC
0.0021  SELECT c.id, 2022 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 `calendars2022` 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 tables2022 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2022 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2021-11-27 00:00:00' AND c.`shedule` < '2021-12-01 23:59:59' AND l.id = 62835 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022   SELECT c.*,l.year,cat.id as categoryId,cat.name,dt1.stadium, dt1.seats, dt1.yearBuilt, dt1.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 calendars2022 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 WHERE c.id = 6601
0.0021   SELECT c.*,l.year,cat.id as categoryId,cat.name,dt1.stadium, dt1.seats, dt1.yearBuilt, dt1.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 calendars2022 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 WHERE c.id = 6596
0.0021   SELECT c.*,l.year,cat.id as categoryId,cat.name,dt1.stadium, dt1.seats, dt1.yearBuilt, dt1.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 calendars2022 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 WHERE c.id = 6602
0.0022   SELECT c.*,l.year,cat.id as categoryId,cat.name,dt1.stadium, dt1.seats, dt1.yearBuilt, dt1.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 calendars2022 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 WHERE c.id = 6599
0.0018   SELECT c.*,l.year,cat.id as categoryId,cat.name,dt1.stadium, dt1.seats, dt1.yearBuilt, dt1.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 calendars2022 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 WHERE c.id = 6597
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=27
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=27 AND year=2022