Jornada 1
26 Jul 21 Botev VratsaBotev 0 - 0 Arda KardzhaliArda 10
24 Jul 21 Levski SofiaLevski 1 - 2 Slavia SofiaSlavia 4
23 Jul 21 Tsarsko SeloTsarsko 0 - 0 Cherno More VarnaCherno More 3
24 Jul 21 Botev PlovdivBotev 2 - 1 Pirin BlagoevgradPirin 1
23 Jul 21 BeroeBeroe 1 - 0 Lokomotiv SofiaLokomotiv ...
25 Jul 21 Lokomotiv PlovdivLokomotiv 1 - 3 LudogoretsLudogorets 2
25 Jul 21 CSKA 1948 SofiaCSKA 1948. 2 - 4 CSKA SofiaCSKA Sofia 2
Jornada 2
30 Jul 21 Slavia SofiaSlavia 0 - 0 Tsarsko SeloTsarsko 21
31 Jul 21 Botev VratsaBotev 2 - 0 Levski SofiaLevski 3
31 Jul 21 LudogoretsLudogorets 3 - 0 CSKA 1948 SofiaCSKA 1948. 9
01 Ago 21 Lokomotiv SofiaLokomotiv 1 - 0 Lokomotiv PlovdivLokomotiv 3
16 Dic 21 Arda KardzhaliArda 2 - 2 CSKA SofiaCSKA Sofia 114
02 Ago 21 Cherno More VarnaCherno More 2 - 0 Botev PlovdivBotev 3
02 Ago 21 Pirin BlagoevgradPirin 2 - 3 BeroeBeroe 2
Jornada 3
06 Ago 21 Tsarsko SeloTsarsko 1 - 2 Botev VratsaBotev 6
06 Ago 21 CSKA 1948 SofiaCSKA 1948. 1 - 1 Lokomotiv SofiaLokomotiv 8
07 Ago 21 Botev PlovdivBotev 1 - 0 Slavia SofiaSlavia 4
07 Ago 21 BeroeBeroe 0 - 2 Cherno More VarnaCherno More ...
08 Ago 21 Levski SofiaLevski 0 - 2 Arda KardzhaliArda 3
20 Dic 21 CSKA SofiaCSKA Sofia 1 - 0 LudogoretsLudogorets 257
19 Oct 21 Lokomotiv PlovdivLokomotiv 2 - 1 Pirin BlagoevgradPirin 4
Jornada 4
13 Ago 21 Pirin BlagoevgradPirin 4 - 1 CSKA 1948 SofiaCSKA 1948. ...
14 Ago 21 Slavia SofiaSlavia 3 - 2 BeroeBeroe 2
14 Ago 21 Levski SofiaLevski 3 - 1 Tsarsko SeloTsarsko ...
13 Feb 22 Lokomotiv SofiaLokomotiv 1 - 1 CSKA SofiaCSKA Sofia 3
13 Feb 22 Arda KardzhaliArda 0 - 4 LudogoretsLudogorets 4
16 Ago 21 Cherno More VarnaCherno More 0 - 0 Lokomotiv PlovdivLokomotiv 25
16 Ago 21 Botev VratsaBotev 1 - 1 Botev PlovdivBotev 3
Jornada 5
20 Ago 21 Tsarsko SeloTsarsko 1 - 0 Arda KardzhaliArda 22
20 Ago 21 Botev PlovdivBotev 3 - 1 Levski SofiaLevski 4
21 Ago 21 CSKA 1948 SofiaCSKA 1948. 2 - 3 Cherno More VarnaCherno More ...
21 Ago 21 LudogoretsLudogorets 5 - 0 Lokomotiv SofiaLokomotiv 1
22 Ago 21 Lokomotiv PlovdivLokomotiv 0 - 1 Slavia SofiaSlavia 1
22 Ago 21 CSKA SofiaCSKA Sofia 1 - 0 Pirin BlagoevgradPirin 1
23 Ago 21 BeroeBeroe 1 - 0 Botev VratsaBotev 5
Jornada 6
26 Ago 21 Tsarsko SeloTsarsko 0 - 0 Botev PlovdivBotev 10
27 Ago 21 Slavia SofiaSlavia 2 - 1 CSKA 1948 SofiaCSKA 1948. 18
27 Ago 21 Arda KardzhaliArda 1 - 1 Lokomotiv SofiaLokomotiv 1
28 Ago 21 Botev VratsaBotev 0 - 0 Lokomotiv PlovdivLokomotiv ...
28 Ago 21 Levski SofiaLevski 2 - 1 BeroeBeroe 1
29 Ago 21 Cherno More VarnaCherno More 0 - 1 CSKA SofiaCSKA Sofia 1
29 Ago 21 Pirin BlagoevgradPirin 1 - 3 LudogoretsLudogorets 5
Jornada 7
13 Sep 21 Botev PlovdivBotev 2 - 1 Arda KardzhaliArda ...
13 Sep 21 BeroeBeroe 1 - 0 Tsarsko SeloTsarsko 11
12 Sep 21 Lokomotiv PlovdivLokomotiv 2 - 2 Levski SofiaLevski 2
12 Sep 21 CSKA 1948 SofiaCSKA 1948. 5 - 1 Botev VratsaBotev ...
11 Sep 21 CSKA SofiaCSKA Sofia 1 - 1 Slavia SofiaSlavia 6
11 Sep 21 LudogoretsLudogorets 2 - 0 Cherno More VarnaCherno More 1
10 Sep 21 Lokomotiv SofiaLokomotiv 2 - 1 Pirin BlagoevgradPirin 9
Jornada 8
17 Sep 21 Arda KardzhaliArda 3 - 0 Pirin BlagoevgradPirin 6
18 Sep 21 Cherno More VarnaCherno More 1 - 1 Lokomotiv SofiaLokomotiv ...
19 Sep 21 Slavia SofiaSlavia 1 - 0 LudogoretsLudogorets 10
19 Sep 21 Botev VratsaBotev 2 - 4 CSKA SofiaCSKA Sofia ...
18 Sep 21 Levski SofiaLevski 0 - 0 CSKA 1948 SofiaCSKA 1948. ...
17 Sep 21 Tsarsko SeloTsarsko 0 - 2 Lokomotiv PlovdivLokomotiv 31
17 Sep 21 Botev PlovdivBotev 2 - 1 BeroeBeroe ...
Jornada 9
24 Sep 21 BeroeBeroe 1 - 1 Arda KardzhaliArda 3
25 Sep 21 Lokomotiv PlovdivLokomotiv 1 - 1 Botev PlovdivBotev 1
25 Sep 21 CSKA 1948 SofiaCSKA 1948. 1 - 0 Tsarsko SeloTsarsko ...
26 Sep 21 CSKA SofiaCSKA Sofia 2 - 1 Levski SofiaLevski 2
26 Sep 21 LudogoretsLudogorets 3 - 1 Botev VratsaBotev ...
27 Sep 21 Lokomotiv SofiaLokomotiv 1 - 0 Slavia SofiaSlavia 21
27 Sep 21 Pirin BlagoevgradPirin 2 - 2 Cherno More VarnaCherno More 3
Jornada 10
02 Oct 21 Arda KardzhaliArda 0 - 3 Cherno More VarnaCherno More ...
02 Oct 21 Slavia SofiaSlavia 1 - 1 Pirin BlagoevgradPirin 16
02 Oct 21 Botev VratsaBotev 2 - 2 Lokomotiv SofiaLokomotiv ...
03 Oct 21 Levski SofiaLevski 2 - 4 LudogoretsLudogorets 1
03 Oct 21 Tsarsko SeloTsarsko 1 - 2 CSKA SofiaCSKA Sofia 2
01 Oct 21 Botev PlovdivBotev 3 - 1 CSKA 1948 SofiaCSKA 1948. 14
01 Oct 21 BeroeBeroe 1 - 0 Lokomotiv PlovdivLokomotiv 2
Jornada 11
15 Oct 21 Lokomotiv PlovdivLokomotiv 0 - 0 Arda KardzhaliArda 5
18 Oct 21 CSKA 1948 SofiaCSKA 1948. 1 - 0 BeroeBeroe 10
17 Oct 21 CSKA SofiaCSKA Sofia 3 - 2 Botev PlovdivBotev 7
16 Oct 21 LudogoretsLudogorets 4 - 0 Tsarsko SeloTsarsko 5
16 Oct 21 Lokomotiv SofiaLokomotiv 1 - 2 Levski SofiaLevski ...
15 Oct 21 Pirin BlagoevgradPirin 3 - 1 Botev VratsaBotev ...
17 Oct 21 Cherno More VarnaCherno More 1 - 1 Slavia SofiaSlavia ...
Jornada 12
23 Oct 21 Arda KardzhaliArda 1 - 1 Slavia SofiaSlavia ...
23 Oct 21 Botev VratsaBotev 0 - 0 Cherno More VarnaCherno More 1
23 Oct 21 Levski SofiaLevski 3 - 0 Pirin BlagoevgradPirin 3
22 Oct 21 Tsarsko SeloTsarsko 2 - 0 Lokomotiv SofiaLokomotiv 6
25 Oct 21 Botev PlovdivBotev 1 - 3 LudogoretsLudogorets 27
24 Oct 21 BeroeBeroe 0 - 0 CSKA SofiaCSKA Sofia 6
22 Oct 21 Lokomotiv PlovdivLokomotiv 2 - 1 CSKA 1948 SofiaCSKA 1948. ...
Jornada 13
01 Nov 21 CSKA 1948 SofiaCSKA 1948. 2 - 3 Arda KardzhaliArda 7
31 Oct 21 CSKA SofiaCSKA Sofia 1 - 3 Lokomotiv PlovdivLokomotiv 12
31 Oct 21 LudogoretsLudogorets 2 - 0 BeroeBeroe 5
30 Oct 21 Lokomotiv SofiaLokomotiv 0 - 0 Botev PlovdivBotev ...
31 Oct 21 Pirin BlagoevgradPirin 2 - 1 Tsarsko SeloTsarsko 1
30 Oct 21 Cherno More VarnaCherno More 1 - 0 Levski SofiaLevski 2
30 Oct 21 Slavia SofiaSlavia 1 - 0 Botev VratsaBotev 1
Jornada 14
07 Nov 21 Arda KardzhaliArda 3 - 2 Botev VratsaBotev ...
06 Nov 21 Slavia SofiaSlavia 0 - 1 Levski SofiaLevski 2
06 Nov 21 Cherno More VarnaCherno More 1 - 1 Tsarsko SeloTsarsko 3
06 Nov 21 Pirin BlagoevgradPirin 0 - 1 Botev PlovdivBotev ...
05 Nov 21 Lokomotiv SofiaLokomotiv 0 - 3 BeroeBeroe 19
07 Nov 21 LudogoretsLudogorets 1 - 0 Lokomotiv PlovdivLokomotiv 23
08 Nov 21 CSKA SofiaCSKA Sofia 1 - 0 CSKA 1948 SofiaCSKA 1948. 114
Jornada 15
20 Nov 21 CSKA SofiaCSKA Sofia 2 - 1 Arda KardzhaliArda ...
21 Nov 21 CSKA 1948 SofiaCSKA 1948. 2 - 0 LudogoretsLudogorets 7
21 Nov 21 Lokomotiv PlovdivLokomotiv 2 - 1 Lokomotiv SofiaLokomotiv ...
19 Nov 21 BeroeBeroe 1 - 1 Pirin BlagoevgradPirin 22
20 Nov 21 Botev PlovdivBotev 0 - 2 Cherno More VarnaCherno More 2
20 Nov 21 Tsarsko SeloTsarsko 2 - 5 Slavia SofiaSlavia 2
22 Nov 21 Levski SofiaLevski 0 - 0 Botev VratsaBotev 47
Jornada 16
27 Nov 21 Arda KardzhaliArda 0 - 0 Levski SofiaLevski ...
26 Nov 21 Botev VratsaBotev 0 - 0 Tsarsko SeloTsarsko 17
26 Nov 21 Slavia SofiaSlavia 0 - 0 Botev PlovdivBotev 17
26 Nov 21 Cherno More VarnaCherno More 1 - 0 BeroeBeroe 14
27 Nov 21 Pirin BlagoevgradPirin 2 - 3 Lokomotiv PlovdivLokomotiv ...
28 Nov 21 Lokomotiv SofiaLokomotiv 2 - 2 CSKA 1948 SofiaCSKA 1948. ...
29 Nov 21 LudogoretsLudogorets 2 - 0 CSKA SofiaCSKA Sofia 72
Jornada 17
02 Dic 21 LudogoretsLudogorets 4 - 1 Arda KardzhaliArda 12
02 Dic 21 CSKA SofiaCSKA Sofia 2 - 0 Lokomotiv SofiaLokomotiv 69
02 Dic 21 CSKA 1948 SofiaCSKA 1948. 1 - 0 Pirin BlagoevgradPirin 30
01 Dic 21 Lokomotiv PlovdivLokomotiv 1 - 1 Cherno More VarnaCherno More 12
30 Nov 21 BeroeBeroe 2 - 1 Slavia SofiaSlavia 23
30 Nov 21 Botev PlovdivBotev 2 - 1 Botev VratsaBotev 6
01 Dic 21 Tsarsko SeloTsarsko 0 - 1 Levski SofiaLevski 3
Jornada 18
06 Dic 21 Arda KardzhaliArda 2 - 0 Tsarsko SeloTsarsko 8
04 Dic 21 Levski SofiaLevski 2 - 0 Botev PlovdivBotev 1
04 Dic 21 Botev VratsaBotev 1 - 0 BeroeBeroe ...
05 Dic 21 Slavia SofiaSlavia 1 - 1 Lokomotiv PlovdivLokomotiv 4
06 Dic 21 Cherno More VarnaCherno More 2 - 0 CSKA 1948 SofiaCSKA 1948. 10
05 Dic 21 Pirin BlagoevgradPirin 1 - 1 CSKA SofiaCSKA Sofia 12
05 Dic 21 Lokomotiv SofiaLokomotiv 2 - 4 LudogoretsLudogorets 2
Jornada 19
11 Dic 21 Lokomotiv SofiaLokomotiv 2 - 0 Arda KardzhaliArda 11
13 Dic 21 LudogoretsLudogorets 3 - 5 Pirin BlagoevgradPirin 141
12 Dic 21 CSKA SofiaCSKA Sofia 2 - 0 Cherno More VarnaCherno More ...
11 Dic 21 CSKA 1948 SofiaCSKA 1948. 1 - 1 Slavia SofiaSlavia 38
10 Dic 21 Lokomotiv PlovdivLokomotiv 2 - 4 Botev VratsaBotev 21
12 Dic 21 BeroeBeroe 1 - 1 Levski SofiaLevski ...
11 Dic 21 Botev PlovdivBotev 2 - 1 Tsarsko SeloTsarsko ...
Jornada 20
18 Feb 22 Arda KardzhaliArda 0 - 2 Botev PlovdivBotev 5
20 Feb 22 Tsarsko SeloTsarsko 1 - 2 BeroeBeroe ...
19 Feb 22 Levski SofiaLevski 2 - 1 Lokomotiv PlovdivLokomotiv ...
19 Feb 22 Botev VratsaBotev 0 - 4 CSKA 1948 SofiaCSKA 1948. 1
20 Feb 22 Slavia SofiaSlavia 2 - 3 CSKA SofiaCSKA Sofia 4
20 Feb 22 Cherno More VarnaCherno More 1 - 2 LudogoretsLudogorets 2
21 Feb 22 Pirin BlagoevgradPirin 2 - 1 Lokomotiv SofiaLokomotiv 13
Jornada 21
28 Feb 22 Pirin BlagoevgradPirin 1 - 0 Arda KardzhaliArda 25
27 Feb 22 Lokomotiv SofiaLokomotiv 0 - 3 Cherno More VarnaCherno More ...
26 Feb 22 LudogoretsLudogorets 3 - 1 Slavia SofiaSlavia ...
25 Feb 22 CSKA SofiaCSKA Sofia 4 - 0 Botev VratsaBotev 26
26 Feb 22 CSKA 1948 SofiaCSKA 1948. 0 - 2 Levski SofiaLevski 1
25 Feb 22 Lokomotiv PlovdivLokomotiv 1 - 0 Tsarsko SeloTsarsko 13
26 Feb 22 BeroeBeroe 1 - 1 Botev PlovdivBotev 4
Jornada 22
07 Mar 22 Arda KardzhaliArda 1 - 0 BeroeBeroe 16
05 Mar 22 Botev PlovdivBotev 2 - 1 Lokomotiv PlovdivLokomotiv 1
04 Mar 22 Tsarsko SeloTsarsko 0 - 2 CSKA 1948 SofiaCSKA 1948. 43
06 Mar 22 Levski SofiaLevski 0 - 0 CSKA SofiaCSKA Sofia 6
07 Mar 22 Botev VratsaBotev 1 - 2 LudogoretsLudogorets 69
07 Mar 22 Slavia SofiaSlavia 3 - 0 Lokomotiv SofiaLokomotiv 8
05 Mar 22 Cherno More VarnaCherno More 1 - 1 Pirin BlagoevgradPirin ...
Jornada 23
12 Mar 22 Cherno More VarnaCherno More 2 - 0 Arda KardzhaliArda ...
14 Mar 22 Pirin BlagoevgradPirin 0 - 0 Slavia SofiaSlavia 49
12 Mar 22 Lokomotiv SofiaLokomotiv 1 - 0 Botev VratsaBotev 5
13 Mar 22 LudogoretsLudogorets 2 - 1 Levski SofiaLevski 26
12 Mar 22 CSKA SofiaCSKA Sofia 0 - 0 Tsarsko SeloTsarsko 8
11 Mar 22 CSKA 1948 SofiaCSKA 1948. 2 - 2 Botev PlovdivBotev 48
13 Mar 22 Lokomotiv PlovdivLokomotiv 2 - 0 BeroeBeroe 2
Jornada 24
18 Mar 22 Arda KardzhaliArda 5 - 1 Lokomotiv PlovdivLokomotiv ...
19 Mar 22 BeroeBeroe 1 - 0 CSKA 1948 SofiaCSKA 1948. ...
20 Mar 22 Botev PlovdivBotev 2 - 0 CSKA SofiaCSKA Sofia 3
19 Mar 22 Tsarsko SeloTsarsko 1 - 1 LudogoretsLudogorets 8
19 Mar 22 Levski SofiaLevski 1 - 0 Lokomotiv SofiaLokomotiv ...
20 Mar 22 Botev VratsaBotev 0 - 3 Pirin BlagoevgradPirin 2
20 Mar 22 Slavia SofiaSlavia 0 - 1 Cherno More VarnaCherno More 3
Jornada 25
02 Abr 22 Slavia SofiaSlavia 1 - 0 Arda KardzhaliArda ...
04 Abr 22 Cherno More VarnaCherno More 5 - 0 Botev VratsaBotev 21
03 Abr 22 Pirin BlagoevgradPirin 0 - 3 Levski SofiaLevski ...
04 Abr 22 Lokomotiv SofiaLokomotiv 2 - 1 Tsarsko SeloTsarsko 11
03 Abr 22 LudogoretsLudogorets 3 - 0 Botev PlovdivBotev 13
02 Abr 22 CSKA SofiaCSKA Sofia 1 - 0 BeroeBeroe 3
03 Abr 22 CSKA 1948 SofiaCSKA 1948. 4 - 0 Lokomotiv PlovdivLokomotiv 1
Jornada 26
10 Abr 22 Arda KardzhaliArda 0 - 0 CSKA 1948 SofiaCSKA 1948. ...
08 Abr 22 Lokomotiv PlovdivLokomotiv 2 - 0 CSKA SofiaCSKA Sofia 39
09 Abr 22 BeroeBeroe 0 - 1 LudogoretsLudogorets 12
10 Abr 22 Botev PlovdivBotev 2 - 0 Lokomotiv SofiaLokomotiv 2
11 Abr 22 Tsarsko SeloTsarsko 1 - 0 Pirin BlagoevgradPirin 13
09 Abr 22 Levski SofiaLevski 2 - 0 Cherno More VarnaCherno More 1
08 Abr 22 Botev VratsaBotev 2 - 1 Slavia SofiaSlavia 40
Clasificación
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 26 64 23 64
2 CSKA Sofia CSKA Sofia 26 39 25 52
3 Botev Plovdiv Botev 26 34 28 46
4 Cherno More Varna Cherno More 26 35 18 45
5 Levski Sofia Levski Sofia 26 33 25 42
6 Slavia Sofia Slavia Sofia 26 30 26 36
7 Lokomotiv Plovdiv Lokomotiv 26 30 35 34
8 Beroe Beroe 26 23 27 32
9 CSKA 1948 Sofia CSKA 1948 S. 26 36 37 30
10 Arda Kardzhali Arda 26 27 34 29
11 Pirin Blagoevgrad Pirin 26 34 41 27
12 Lokomotiv Sofia Lokomotiv 26 22 42 25
13 Botev Vratsa Botev Vratsa 26 23 48 22
14 Tsarsko Selo Tsarsko Selo 26 15 36 16
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,257,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.2032
Total Execution Time  0.2056
  CADENA URL  
/bulgaria2022/grupo1/calendario
  GET DATOS  
$_GET['/bulgaria2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0035  SELECT type FROM routes WHERE alias = 'bulgaria2022'
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bulgaria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0035  SELECT id,name,alias,stepParent FROM categories WHERE parentId=205 ORDER BY order_id ASC
0.0036  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 = 63159 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0074  SELECT 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, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63159 ORDER BY round ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 13:44:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 13:44:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 13:44:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 13:44:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bulgaria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0202  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63159 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63159 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0344  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63159 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63159 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0059  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63159 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63159 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0080  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 = 63159 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC