4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
12 Ago 23 Chernolomets 1919Chernolomet 1 - 0 Ludogorets IIILudogorets ...
12 Ago 23 FratriaFratria 4 - 1 DorostolDorostol ...
12 Ago 23 Septemvri TervelSeptemvri 2 - 0 RiltziRiltzi ...
12 Ago 23 Sportist General ToshevoSportist Apl Ustrem DonchevoUstrem ...
12 Ago 23 Dunav Ruse IIDunav Ruse 1 - 1 Lokomotiv RuseLokomotiv ...
13 Ago 23 KubratKubrat 0 - 3 Benkovski IsperihBenkovski ...
12 Ago 23 Svetkavitsa TargovishteSvetkavitsa 0 - 4 Spartak Varna IISpartak ...
Jornada 2
19 Ago 23 DorostolDorostol 1 - 4 Cherno More Varna IICherno More ...
19 Ago 23 RiltziRiltzi 3 - 1 KubratKubrat ...
19 Ago 23 FratriaFratria Apl Sportist General ToshevoSportist ...
19 Ago 23 Ludogorets IIILudogorets 6 - 1 Septemvri TervelSeptemvri ...
20 Ago 23 Benkovski IsperihBenkovski 2 - 0 Dunav Ruse IIDunav Ruse ...
20 Ago 23 Lokomotiv RuseLokomotiv 1 - 1 Svetkavitsa TargovishteSvetkavitsa ...
18 Oct 23 Spartak Varna IISpartak Apl Volov ShumenVolov ...
20 Ago 23 Ustrem DonchevoUstrem 1 - 2 Chernolomets 1919Chernolomet ...
Jornada 3
23 Ago 23 Cherno More Varna IICherno More 3 - 1 Spartak Varna IISpartak ...
26 Ago 23 KubratKubrat 1 - 3 Ludogorets IIILudogorets ...
26 Ago 23 Septemvri TervelSeptemvri 5 - 1 Ustrem DonchevoUstrem ...
26 Ago 23 Volov ShumenVolov Apl Lokomotiv RuseLokomotiv ...
26 Ago 23 Sportist General ToshevoSportist Apl DorostolDorostol ...
26 Ago 23 Svetkavitsa TargovishteSvetkavitsa 1 - 1 Benkovski IsperihBenkovski ...
26 Ago 23 Chernolomets 1919Chernolomet 0 - 2 FratriaFratria ...
26 Ago 23 Dunav Ruse IIDunav Ruse 0 - 2 RiltziRiltzi ...
Jornada 4
02 Sep 23 Benkovski IsperihBenkovski Apl Volov ShumenVolov ...
02 Sep 23 RiltziRiltzi 3 - 3 Svetkavitsa TargovishteSvetkavitsa ...
02 Sep 23 FratriaFratria 2 - 1 Septemvri TervelSeptemvri ...
02 Sep 23 Lokomotiv RuseLokomotiv 0 - 1 Cherno More Varna IICherno More ...
20 Sep 23 Ludogorets IIILudogorets 6 - 1 Dunav Ruse IIDunav Ruse ...
02 Sep 23 Sportist General ToshevoSportist Apl Chernolomets 1919Chernolomet ...
02 Sep 23 DorostolDorostol 1 - 4 Spartak Varna IISpartak ...
03 Sep 23 Ustrem DonchevoUstrem 5 - 2 KubratKubrat ...
Jornada 5
09 Sep 23 Cherno More Varna IICherno More 3 - 0 Benkovski IsperihBenkovski ...
09 Sep 23 Septemvri TervelSeptemvri Apl Sportist General ToshevoSportist ...
09 Sep 23 Volov ShumenVolov Apl RiltziRiltzi ...
09 Sep 23 Svetkavitsa TargovishteSvetkavitsa 0 - 1 Ludogorets IIILudogorets ...
11 Oct 23 Chernolomets 1919Chernolomet 2 - 1 DorostolDorostol ...
24 Sep 23 Dunav Ruse IIDunav Ruse 2 - 0 Ustrem DonchevoUstrem ...
10 Sep 23 Spartak Varna IISpartak 6 - 1 Lokomotiv RuseLokomotiv ...
03 Dic 23 FratriaFratria 2 - 0 KubratKubrat ...
Jornada 6
16 Sep 23 DorostolDorostol 2 - 1 Lokomotiv RuseLokomotiv ...
16 Sep 23 RiltziRiltzi 1 - 1 Cherno More Varna IICherno More ...
16 Sep 23 Ludogorets IIILudogorets Apl Volov ShumenVolov ...
16 Sep 23 Sportist General ToshevoSportist Apl KubratKubrat ...
16 Sep 23 Benkovski IsperihBenkovski 0 - 1 Spartak Varna IISpartak ...
17 Sep 23 Chernolomets 1919Chernolomet 0 - 1 Septemvri TervelSeptemvri ...
16 Sep 23 FratriaFratria 3 - 0 Dunav Ruse IIDunav Ruse ...
17 Sep 23 Ustrem DonchevoUstrem 5 - 1 Svetkavitsa TargovishteSvetkavitsa ...
Jornada 7
23 Sep 23 Cherno More Varna IICherno More 0 - 0 Ludogorets IIILudogorets ...
23 Sep 23 Septemvri TervelSeptemvri 3 - 0 DorostolDorostol ...
23 Sep 23 Volov ShumenVolov Apl Ustrem DonchevoUstrem ...
23 Sep 23 Svetkavitsa TargovishteSvetkavitsa 2 - 2 FratriaFratria ...
24 Sep 23 Dunav Ruse IIDunav Ruse Apl Sportist General ToshevoSportist ...
24 Sep 23 KubratKubrat 0 - 2 Chernolomets 1919Chernolomet ...
24 Sep 23 Lokomotiv RuseLokomotiv 1 - 6 Benkovski IsperihBenkovski ...
23 Sep 23 Spartak Varna IISpartak 2 - 1 RiltziRiltzi ...
Jornada 8
30 Sep 23 RiltziRiltzi 7 - 2 Lokomotiv RuseLokomotiv ...
29 Sep 23 Ludogorets IIILudogorets 5 - 2 Spartak Varna IISpartak ...
30 Sep 23 Septemvri TervelSeptemvri 1 - 0 KubratKubrat ...
12 Ago 23 Ustrem DonchevoUstrem 1 - 2 Cherno More Varna IICherno More ...
01 Oct 23 Chernolomets 1919Chernolomet 2 - 1 Dunav Ruse IIDunav Ruse ...
01 Oct 23 DorostolDorostol 1 - 0 Benkovski IsperihBenkovski ...
Jornada 9
07 Oct 23 Benkovski IsperihBenkovski 1 - 0 RiltziRiltzi ...
08 Nov 23 Cherno More Varna IICherno More 5 - 0 FratriaFratria ...
02 Dic 23 Lokomotiv RuseLokomotiv 0 - 1 Ludogorets IIILudogorets ...
07 Oct 23 Svetkavitsa TargovishteSvetkavitsa 0 - 0 Chernolomets 1919Chernolomet ...
08 Oct 23 Dunav Ruse IIDunav Ruse 0 - 1 Septemvri TervelSeptemvri ...
07 Oct 23 DorostolDorostol 4 - 0 KubratKubrat ...
07 Oct 23 Spartak Varna IISpartak 7 - 0 Ustrem DonchevoUstrem ...
Jornada 10
14 Oct 23 DorostolDorostol 1 - 0 RiltziRiltzi ...
14 Oct 23 Ludogorets IIILudogorets 5 - 2 Benkovski IsperihBenkovski ...
10 Dic 23 Septemvri TervelSeptemvri 4 - 0 Svetkavitsa TargovishteSvetkavitsa ...
14 Oct 23 Sportist General ToshevoSportist Apl Cherno More Varna IICherno More ...
15 Oct 23 Chernolomets 1919Chernolomet Apl Volov ShumenVolov ...
15 Oct 23 FratriaFratria 2 - 0 Spartak Varna IISpartak ...
15 Oct 23 KubratKubrat 1 - 0 Dunav Ruse IIDunav Ruse ...
15 Oct 23 Ustrem DonchevoUstrem 2 - 1 Lokomotiv RuseLokomotiv ...
Jornada 11
21 Oct 23 Benkovski IsperihBenkovski 2 - 1 Ustrem DonchevoUstrem ...
21 Oct 23 Cherno More Varna IICherno More 4 - 2 Chernolomets 1919Chernolomet ...
21 Oct 23 RiltziRiltzi 1 - 1 Ludogorets IIILudogorets ...
21 Oct 23 Volov ShumenVolov Apl Septemvri TervelSeptemvri ...
21 Oct 23 Svetkavitsa TargovishteSvetkavitsa 2 - 0 KubratKubrat ...
22 Oct 23 Dunav Ruse IIDunav Ruse 1 - 2 DorostolDorostol ...
22 Oct 23 Lokomotiv RuseLokomotiv 0 - 3 FratriaFratria ...
22 Oct 23 Spartak Varna IISpartak Apl Sportist General ToshevoSportist ...
Jornada 12
09 Dic 23 Chernolomets 1919Chernolomet 2 - 1 Spartak Varna IISpartak ...
16 Dic 23 DorostolDorostol 0 - 6 Ludogorets IIILudogorets ...
31 Oct 23 Dunav Ruse IIDunav Ruse 2 - 1 Svetkavitsa TargovishteSvetkavitsa ...
26 Nov 23 FratriaFratria 4 - 0 Benkovski IsperihBenkovski ...
28 Oct 23 KubratKubrat Apl Volov ShumenVolov ...
25 Nov 23 Septemvri TervelSeptemvri 1 - 2 Cherno More Varna IICherno More ...
28 Oct 23 Sportist General ToshevoSportist Apl Lokomotiv RuseLokomotiv ...
03 Dic 23 Ustrem DonchevoUstrem 1 - 0 RiltziRiltzi ...
Jornada 13
04 Nov 23 Benkovski IsperihBenkovski Apl Sportist General ToshevoSportist ...
04 Nov 23 Cherno More Varna IICherno More 3 - 0 KubratKubrat ...
04 Nov 23 RiltziRiltzi 1 - 3 FratriaFratria ...
04 Nov 23 Lokomotiv RuseLokomotiv 0 - 2 Chernolomets 1919Chernolomet ...
09 Dic 23 Ludogorets IIILudogorets 1 - 0 Ustrem DonchevoUstrem 1
04 Nov 23 Volov ShumenVolov Apl Dunav Ruse IIDunav Ruse ...
04 Nov 23 Spartak Varna IISpartak 0 - 2 Septemvri TervelSeptemvri ...
03 Dic 23 Svetkavitsa TargovishteSvetkavitsa 1 - 1 DorostolDorostol ...
Jornada 14
11 Nov 23 DorostolDorostol 2 - 0 Ustrem DonchevoUstrem ...
29 Nov 23 FratriaFratria 0 - 1 Ludogorets IIILudogorets 1
11 Nov 23 Septemvri TervelSeptemvri 1 - 1 Lokomotiv RuseLokomotiv ...
11 Nov 23 Sportist General ToshevoSportist Apl RiltziRiltzi ...
11 Nov 23 Svetkavitsa TargovishteSvetkavitsa Apl Volov ShumenVolov ...
12 Nov 23 Chernolomets 1919Chernolomet 2 - 0 Benkovski IsperihBenkovski ...
13 Nov 23 Dunav Ruse IIDunav Ruse 0 - 3 Cherno More Varna IICherno More ...
11 Nov 23 KubratKubrat 0 - 2 Spartak Varna IISpartak ...
Jornada 15
18 Nov 23 Benkovski IsperihBenkovski 2 - 3 Septemvri TervelSeptemvri ...
18 Nov 23 Cherno More Varna IICherno More 1 - 2 Svetkavitsa TargovishteSvetkavitsa ...
18 Nov 23 RiltziRiltzi 1 - 2 Chernolomets 1919Chernolomet ...
18 Nov 23 Ludogorets IIILudogorets Apl Sportist General ToshevoSportist ...
18 Nov 23 Volov ShumenVolov Apl DorostolDorostol ...
19 Nov 23 Lokomotiv RuseLokomotiv 3 - 1 KubratKubrat ...
30 Nov 23 Spartak Varna IISpartak 7 - 0 Dunav Ruse IIDunav Ruse ...
16 Dic 23 Ustrem DonchevoUstrem 0 - 1 FratriaFratria ...
Jornada 16
24 Feb 24 Benkovski IsperihBenkovski 5 - 0 KubratKubrat ...
24 Feb 24 DorostolDorostol 1 - 1 FratriaFratria ...
24 Feb 24 RiltziRiltzi 0 - 0 Septemvri TervelSeptemvri ...
24 Abr 24 Lokomotiv RuseLokomotiv 1 - 4 Dunav Ruse IIDunav Ruse ...
25 Feb 24 Ludogorets IIILudogorets 1 - 1 Chernolomets 1919Chernolomet ...
25 Feb 24 Spartak Varna IISpartak 2 - 1 Svetkavitsa TargovishteSvetkavitsa ...
Jornada 17
02 Mar 24 Cherno More Varna IICherno More 2 - 2 DorostolDorostol ...
02 Mar 24 KubratKubrat 0 - 3 RiltziRiltzi ...
08 May 24 Septemvri TervelSeptemvri
16:00
Ludogorets IIILudogorets ...
02 Mar 24 Svetkavitsa TargovishteSvetkavitsa 0 - 0 Lokomotiv RuseLokomotiv ...
03 Mar 24 Chernolomets 1919Chernolomet 5 - 0 Ustrem DonchevoUstrem ...
03 Mar 24 Dunav Ruse IIDunav Ruse 2 - 2 Benkovski IsperihBenkovski ...
Jornada 18
09 Mar 24 Benkovski IsperihBenkovski 3 - 1 Svetkavitsa TargovishteSvetkavitsa ...
10 Mar 24 RiltziRiltzi 2 - 2 Dunav Ruse IIDunav Ruse ...
09 Mar 24 FratriaFratria 3 - 1 Chernolomets 1919Chernolomet ...
10 Mar 24 Ludogorets IIILudogorets 9 - 0 KubratKubrat ...
12 Mar 24 Spartak Varna IISpartak 0 - 0 Cherno More Varna IICherno More ...
10 Mar 24 Ustrem DonchevoUstrem 0 - 0 Septemvri TervelSeptemvri ...
Jornada 19
16 Mar 24 Cherno More Varna IICherno More 1 - 1 Lokomotiv RuseLokomotiv ...
15 Mar 24 Dunav Ruse IIDunav Ruse 0 - 3 Ludogorets IIILudogorets ...
16 Mar 24 Septemvri TervelSeptemvri 1 - 0 FratriaFratria ...
16 Mar 24 Spartak Varna IISpartak 7 - 0 DorostolDorostol ...
16 Mar 24 Svetkavitsa TargovishteSvetkavitsa 1 - 2 RiltziRiltzi ...
17 Mar 24 KubratKubrat 1 - 3 Ustrem DonchevoUstrem ...
Jornada 20
23 Mar 24 Benkovski IsperihBenkovski 0 - 1 Cherno More Varna IICherno More ...
23 Mar 24 DorostolDorostol 0 - 1 Chernolomets 1919Chernolomet ...
24 Mar 24 Ludogorets IIILudogorets 3 - 0 Svetkavitsa TargovishteSvetkavitsa ...
24 Mar 24 KubratKubrat 0 - 5 FratriaFratria ...
24 Mar 24 Lokomotiv RuseLokomotiv 0 - 1 Spartak Varna IISpartak ...
24 Mar 24 Ustrem DonchevoUstrem 2 - 2 Dunav Ruse IIDunav Ruse ...
Jornada 21
30 Mar 24 Cherno More Varna IICherno More 0 - 0 RiltziRiltzi ...
30 Mar 24 Lokomotiv RuseLokomotiv 1 - 2 DorostolDorostol ...
30 Mar 24 Septemvri TervelSeptemvri 3 - 1 Chernolomets 1919Chernolomet ...
30 Mar 24 Svetkavitsa TargovishteSvetkavitsa 1 - 3 Ustrem DonchevoUstrem ...
31 Mar 24 Dunav Ruse IIDunav Ruse 0 - 5 FratriaFratria ...
31 Mar 24 Spartak Varna IISpartak 1 - 0 Benkovski IsperihBenkovski ...
Jornada 22
06 Abr 24 Benkovski IsperihBenkovski 7 - 0 Lokomotiv RuseLokomotiv ...
06 Abr 24 DorostolDorostol 1 - 1 Septemvri TervelSeptemvri ...
06 Abr 24 RiltziRiltzi 2 - 1 Spartak Varna IISpartak ...
06 Abr 24 FratriaFratria 5 - 2 Svetkavitsa TargovishteSvetkavitsa ...
05 Abr 24 Ludogorets IIILudogorets 1 - 0 Cherno More Varna IICherno More ...
07 Abr 24 Chernolomets 1919Chernolomet 6 - 1 KubratKubrat ...
Jornada 23
13 Abr 24 Benkovski IsperihBenkovski 3 - 2 DorostolDorostol ...
14 Abr 24 Cherno More Varna IICherno More 2 - 2 Ustrem DonchevoUstrem ...
13 Abr 24 Dunav Ruse IIDunav Ruse 0 - 4 Chernolomets 1919Chernolomet ...
13 Abr 24 Lokomotiv RuseLokomotiv 0 - 2 RiltziRiltzi ...
17 Abr 24 Spartak Varna IISpartak 2 - 1 Ludogorets IIILudogorets ...
14 Abr 24 KubratKubrat 0 - 4 Septemvri TervelSeptemvri ...
Jornada 24
20 Abr 24 RiltziRiltzi 2 - 5 Benkovski IsperihBenkovski ...
20 Abr 24 FratriaFratria 1 - 1 Cherno More Varna IICherno More ...
20 Abr 24 Ludogorets IIILudogorets 4 - 1 Lokomotiv RuseLokomotiv ...
20 Abr 24 Septemvri TervelSeptemvri 4 - 1 Dunav Ruse IIDunav Ruse ...
20 Abr 24 Chernolomets 1919Chernolomet 2 - 1 Svetkavitsa TargovishteSvetkavitsa ...
21 Abr 24 KubratKubrat 0 - 2 DorostolDorostol ...
21 Abr 24 Ustrem DonchevoUstrem 2 - 2 Spartak Varna IISpartak ...
Jornada 25
28 Abr 24 Benkovski IsperihBenkovski 0 - 3 Ludogorets IIILudogorets ...
27 Abr 24 RiltziRiltzi 1 - 0 DorostolDorostol ...
27 Abr 24 Lokomotiv RuseLokomotiv 2 - 1 Ustrem DonchevoUstrem ...
27 Abr 24 Spartak Varna IISpartak 0 - 1 FratriaFratria ...
27 Abr 24 Svetkavitsa TargovishteSvetkavitsa 0 - 2 Septemvri TervelSeptemvri ...
28 Abr 24 Dunav Ruse IIDunav Ruse 6 - 0 KubratKubrat ...
Jornada 26
01 May 24 Chernolomets 1919Chernolomet 0 - 1 Cherno More Varna IICherno More ...
01 May 24 DorostolDorostol 2 - 0 Dunav Ruse IIDunav Ruse ...
01 May 24 FratriaFratria 5 - 1 Lokomotiv RuseLokomotiv ...
01 May 24 KubratKubrat 0 - 2 Svetkavitsa TargovishteSvetkavitsa ...
01 May 24 Ludogorets IIILudogorets 3 - 1 RiltziRiltzi ...
01 May 24 Ustrem DonchevoUstrem 1 - 2 Benkovski IsperihBenkovski ...
Jornada 27
11 May 24 Benkovski IsperihBenkovski
16:00
FratriaFratria ...
11 May 24 Cherno More Varna IICherno More
16:00
Septemvri TervelSeptemvri ...
11 May 24 RiltziRiltzi
16:00
Ustrem DonchevoUstrem ...
11 May 24 Ludogorets IIILudogorets
16:00
DorostolDorostol ...
11 May 24 Svetkavitsa TargovishteSvetkavitsa
16:00
Dunav Ruse IIDunav Ruse ...
11 May 24 Spartak Varna IISpartak
16:00
Chernolomets 1919Chernolomet ...
Jornada 28
18 May 24 Chernolomets 1919Chernolomet
16:00
Lokomotiv RuseLokomotiv ...
18 May 24 DorostolDorostol
16:00
Svetkavitsa TargovishteSvetkavitsa ...
18 May 24 FratriaFratria
16:00
RiltziRiltzi ...
18 May 24 Septemvri TervelSeptemvri
16:00
Spartak Varna IISpartak ...
19 May 24 KubratKubrat
16:00
Cherno More Varna IICherno More ...
19 May 24 Ustrem DonchevoUstrem
16:00
Ludogorets IIILudogorets ...
Jornada 29
25 May 24 Benkovski IsperihBenkovski
17:00
Chernolomets 1919Chernolomet ...
25 May 24 Cherno More Varna IICherno More
17:00
Dunav Ruse IIDunav Ruse ...
25 May 24 Lokomotiv RuseLokomotiv
17:00
Septemvri TervelSeptemvri ...
25 May 24 Ludogorets IIILudogorets
17:00
FratriaFratria ...
25 May 24 Spartak Varna IISpartak
17:00
KubratKubrat ...
25 May 24 Ustrem DonchevoUstrem
17:00
DorostolDorostol ...
Jornada 30
01 Jun 24 Chernolomets 1919Chernolomet
17:00
RiltziRiltzi ...
01 Jun 24 Dunav Ruse IIDunav Ruse
17:00
Spartak Varna IISpartak ...
01 Jun 24 FratriaFratria
17:00
Ustrem DonchevoUstrem ...
01 Jun 24 KubratKubrat
17:00
Lokomotiv RuseLokomotiv ...
01 Jun 24 Septemvri TervelSeptemvri
17:00
Benkovski IsperihBenkovski ...
01 Jun 24 Svetkavitsa TargovishteSvetkavitsa
17:00
Cherno More Varna IICherno More ...

Clasificación

Equipo PJ GF GC Puntos
1 Ludogorets III Ludogorets 22 64 14 54
2 Fratria Fratria 22 54 18 51
3 Septemvri Tervel Septemvri 21 41 17 46
4 Cherno More Varna II Cherno More 22 40 16 44
5 Chernolomets 1919 Chernolomets 22 40 22 44
6 Spartak Varna II Spartak 22 53 24 41
7 Benkovski Isperih Benkovski 23 46 35 35
8 Dorostol Dorostol 23 29 43 31
9 Riltzi Riltzi 23 35 32 30
10 Ustrem Donchevo Ustrem 22 31 45 22
11 Svetkavitsa Targovishte Svetkavitsa 23 23 47 16
12 Dunav Ruse II Dunav Ruse 23 25 56 16
13 Lokomotiv Ruse Lokomotiv 23 19 61 11
14 Kubrat Kubrat 23 8 78 3
15 Sportist General Toshevo Sportist 0 0 0 0
16 Volov Shumen Volov Shumen 0 0 0 0

  USO DE MEMORIA  
6,251,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1137
Total Execution Time  0.1158
  CADENA URL  
/v_afg_bulgaria2024/grupo3/calendario
  GET DATOS  
$_GET['/v_afg_bulgaria2024/grupo3/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = 'v_afg_bulgaria2024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'v_afg_bulgaria' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=238 ORDER BY order_id ASC
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 = 73007 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 73007 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 10:33:58' 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 > '2024-05-04 10:33:58' 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=4 AND last_update > '2024-05-04 10:33:58' 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=3 AND last_update > '2024-05-04 10:33:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'v_afg_bulgaria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 73007 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73007 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 73007 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73007 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 73007 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73007 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 73007 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