4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
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
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Nesebar Nesebar 38 84 32 83
2 Chernomorets 1919 Burgas Chernomorets 38 82 26 80
3 Gigant Saedinenie Gigant 38 69 28 78
4 Zagorets Zagorets 38 64 19 76
5 FK Haskovo 2009 Haskovo 2009 38 68 36 69
6 Rozova dolina Rozova 38 66 29 68
7 Spartak Plovdiv Spartak 38 73 43 65
8 Lokomotiv Plovdiv II Lokomotiv 38 57 33 64
9 Asenovets Asenovets 38 69 41 64
10 Yambol 1915 Yambol 1915 38 57 48 57
11 Rodopa Smolyan Rodopa 38 51 48 55
12 Dimitrovgrad Dimitrovgrad 38 52 54 52
13 Sokol Markovo Sokol 38 54 58 48
14 Levski Karlovo Levski 38 45 69 42
15 Karnobat Karnobat 38 37 57 41
16 Beroe Stara Zagora II Beroe Stara 38 45 74 37
17 FK Sliven FK Sliven 38 58 93 36
18 Atletik Kuklen Atletik 38 37 83 36
19 Borislav 2009 Borislav 38 34 92 21
20 Vereya Vereya 38 24 163 6
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Belasitsa Belasitsa 38 90 26 88
2 Vitosha Bistritsa Vitosha 38 81 25 81
3 Chavdar Etropole Chavdar 38 70 20 80
4 Kyustendil Kyustendil 38 75 26 80
5 Oborishte Oborishte 38 69 51 74
6 Balkan Botevgrad Balkan 38 62 38 71
7 Bansko Bansko 38 56 36 68
8 Pirin Gotse Delchev Pirin Gotse 38 48 51 51
9 Granit Vladaya Granit 38 40 60 48
10 Rilski Sportist Rilski 38 56 64 48
11 Pirin Razlog Pirin Razlog 38 49 50 47
12 Nadezhda Dobroslavtsi Nadezhda 38 50 62 46
13 Kostinbrod Kostinbrod 38 44 53 46
14 Septemvri Sofia II Septemvri 38 64 77 45
15 Slivnishki Geroy Slivnishki 38 44 47 44
16 Botev Ihtiman Botev 38 40 55 43
17 Vihren Vihren 38 58 70 43
18 Hebar II Hebar II 38 43 56 41
19 Pirin Blagoevgrad II Pirin 38 24 82 17
20 Levski Chepintsi Levski 38 17 131 3
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 28 81 11 71
2 Chernomorets Balchik Chernomorets 28 72 28 60
3 Svetkavitsa Targovishte Svetkavitsa 28 67 25 55
4 Septemvri Tervel Septemvri 27 56 23 55
5 Dunav Ruse Dunav Ruse 28 60 33 53
6 Chernomorets 1919 Burgas Chernomorets 28 60 33 50
7 Ludogorets III Ludogorets 27 73 29 48
8 Shumen 2007 Shumen 2007 27 58 35 47
9 Ustrem Donchevo Ustrem 28 62 48 44
10 Dorostol Dorostol 27 33 48 38
11 Sportist General Toshevo Sportist 27 34 76 26
12 Botev Novi Pazar Botev Novi. 27 24 64 21
13 Topoli Topoli 28 25 75 16
14 Kubrat Kubrat 28 9 82 8
15 Inter Dobrich Inter 28 22 126 7
16 Benkovski Byala Benkovski 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Dobrudzha Dobrich Dobrudzha 15 51 7 45
2 Ustrem Donchevo Ustrem 16 31 22 34
3 Suvorovo Suvorovo 16 42 16 32
4 Chernolomets 1919 Chernolomets 15 34 14 30
5 Septemvri Tervel Septemvri 16 29 12 28
6 Svetkavitsa Targovishte Svetkavitsa 16 30 32 24
7 Shumen 2007 Shumen 2007 15 30 23 22
8 Topoli Topoli 15 18 19 21
9 Hitrino Hitrino 16 17 30 14
10 Kaliakra Kaliakra 13 18 34 13
11 Kubrat Kubrat 15 11 34 13
12 Benkovski Byala Benkovski 15 12 43 5
13 Botev Novi Pazar Botev Novi. 15 10 47 2
14 Lokomotiv Ruse Lokomotiv 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 30 75 11 79
2 Yantra Gabrovo Yantra 30 90 30 70
3 FC Sevlievo FC Sevlievo 30 50 27 59
4 Vihar Slavyanovo Vihar 30 44 25 54
5 Pavlikeni Pavlikeni 30 46 44 48
6 Bdin Bdin 30 55 43 42
7 Partizan Partizan 30 48 44 41
8 Akademik Svishtov Akademik 30 47 51 41
9 Parva Atomna Parva Atomna 30 53 52 38
10 Botev Lukovit Botev 30 40 42 38
11 Kom Berkovitsa Berkovitsa 30 36 42 38
12 Lokomotiv Mezdra Lokomotiv 30 49 67 37
13 Tryavna Tryavna 30 27 57 27
14 Lokomotiv Dryanovo Lokomotiv 30 34 65 24
15 OFK Levski OFK Levski 30 34 80 24
16 Yantra Polski Trambesh Yantra 30 29 77 24
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 34 95 16 92
2 Hebar Pazardzhik Hebar 34 72 24 84
3 Vihren Vihren 34 70 49 62
4 FK Minyor Pernik Minyor 34 53 42 54
5 Bansko Bansko 34 48 34 53
6 Chavdar Etropole Chavdar 34 63 49 52
7 Septemvri Simitli Septemvri 34 46 37 50
8 Slivnishki Geroy Slivnishki 34 50 41 46
9 Belasitsa Belasitsa 34 40 46 42
10 Balkan Botevgrad Balkan 34 49 60 41
11 Botev Ihtiman Botev 34 41 64 40
12 Pirin Razlog Pirin Razlog 34 40 40 38
13 Svoboda Svoboda 34 37 59 38
14 Marek Marek 34 35 48 37
15 Rilski Sportist Rilski 34 40 51 36
16 Germaneya Germaneya 34 38 63 35
17 Pirin Gotse Delchev Pirin Gotse 34 27 66 32
18 OFK Elin Pelin Elin Pelin 34 34 89 21
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 28 114 9 77
2 Kariana Erden Kariana 28 90 18 67
3 FC Sevlievo FC Sevlievo 28 69 33 58
4 OFK Levski OFK Levski 28 50 26 55
5 Bdin Bdin 28 82 33 52
6 Vihar Slavyanovo Vihar 28 70 29 50
7 Akademik Svishtov Akademik 28 43 41 38
8 Parva Atomna Parva Atomna 28 43 56 35
9 Pavlikeni Pavlikeni 28 42 49 34
10 Yantra Gabrovo Yantra 28 49 61 34
11 Tryavna Tryavna 28 35 50 31
12 Mizia 2005 Mizia 2005 28 38 59 31
13 Partizan Partizan 28 23 72 23
14 Kom Berkovitsa Berkovitsa 28 20 140 7
15 Juventus Malchika Juventus 28 18 110 5
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 32 146 10 94
2 Vitosha Bistritsa Vitosha 32 72 16 74
3 Slivnishki Geroy Slivnishki 32 80 35 69
4 Strumska Slava Strumska 32 58 36 60
5 FK Minyor Pernik Minyor 32 55 35 59
6 Vihren Vihren 32 48 36 55
7 Chiko Byaga Chiko Byaga 32 57 67 43
8 Septemvri Sofia Septemvri 32 67 62 42
9 Belasitsa Belasitsa 32 41 52 39
10 Botev Ihtiman Botev 32 52 66 37
11 Rilski Sportist Rilski 32 41 43 35
12 Velbazhd Velbazhd 32 42 56 34
13 Sofia 2010 Sofia 2010 32 51 72 34
14 Chepinets Chepinets 32 35 72 32
15 Pirin Gotse Delchev Pirin Gotse 32 33 63 28
16 Germaneya Germaneya 32 20 122 19
17 Balkan Varvara Balkan 32 25 80 17
18 Lokomotiv Sofia Lokomotiv 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Oborishte Oborishte 30 91 21 70
2 FK Minyor Pernik Minyor 30 56 21 65
3 Pirin Gotse Delchev Pirin Gotse 30 53 18 62
4 Vitosha Bistritsa Vitosha 30 57 22 60
5 Slivnishki Geroy Slivnishki 30 69 38 58
6 Belasitsa Belasitsa 30 48 33 51
7 Strumska Slava Strumska 30 38 36 42
8 Vihren Vihren 30 37 40 39
9 Velbazhd Velbazhd 30 38 42 37
10 Koneliano German Koneliano 30 46 80 37
11 Balkan Varvara Balkan 30 47 69 34
12 Germaneya Germaneya 30 32 55 33
13 Chepinets Chepinets 30 35 58 32
14 Rilski Sportist Rilski 30 26 46 27
15 Sportist Svoge Sportist 30 26 69 20
16 Mesta Mesta 30 15 66 15
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 23 72 19 55
2 Etar Etar 23 50 13 53
3 Botev Lukovit Botev 23 45 23 53
4 Gorna Lokomotiv Oryahovitsa Gorna 23 80 23 52
5 Spartak Pleven Spartak 23 52 22 51
6 Partizan Partizan 23 34 35 40
7 Bdin Bdin 23 36 29 32
8 Vidima-Rakovski Vidima-Rakov 23 43 31 31
9 Parva Atomna Parva Atomna 23 35 34 29
10 Gigant Belene Gigant 22 20 39 21
11 Sitomir Sitomir 23 24 46 20
12 Yantra Gabrovo Yantra 22 14 53 18
13 OFK Levski OFK Levski 23 26 50 17
14 Pavlikeni Pavlikeni 23 22 69 16
15 Kom Berkovitsa Berkovitsa 23 28 48 15
16 Tryavna Tryavna 23 14 61 14
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Marek Marek 30 70 13 72
2 Vitosha Bistritsa Vitosha 30 52 10 71
3 Pirin Blagoevgrad Pirin 30 69 26 62
4 Slivnishki Geroy Slivnishki 30 44 18 57
5 Oborishte Oborishte 30 49 30 54
6 Strumska Slava Strumska 30 41 26 49
7 Perun Perun 30 36 37 41
8 Velbazhd Velbazhd 30 29 32 40
9 Germaneya Germaneya 30 33 48 38
10 Chepinets Chepinets 30 37 44 37
11 Mesta Mesta 30 32 42 36
12 Botev Ihtiman Botev 30 29 38 32
13 Vitosha Dolna Dikanya Vitosha 30 25 52 30
14 Septemvri Sofia Septemvri 30 27 60 25
15 Rilski Sportist Rilski 30 28 71 22
16 Minyor Bobov dol Minyor Bobov 30 12 66 11
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 30 102 21 85
2 Spartak Pleven Spartak 30 111 10 83
3 Parva Atomna Parva Atomna 30 78 24 61
4 Akademik Svishtov Akademik 30 65 34 58
5 Dunav 98 Selanovtsi Dunav 30 49 22 55
6 Torpedo Torpedo 30 62 43 55
7 Gigant Belene Gigant 30 43 34 46
8 Partizan Partizan 30 45 63 41
9 Gorna Lokomotiv Oryahovitsa Gorna 30 34 31 37
10 Sitomir Sitomir 30 42 80 36
11 Tryavna Tryavna 30 33 60 29
12 Botev Krivodol Botev 28 22 54 23
13 Yantra Gabrovo Yantra 29 20 60 23
14 Balkan Belogradchik Balkan 30 24 83 20
15 OFK Levski OFK Levski 30 29 85 17
16 Lokomotiv Dryanovo Lokomotiv 29 13 68 11
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Bdin Bdin 30 82 17 74
2 Parva Atomna Parva Atomna 30 57 16 61
3 Lokomotiv Mezdra Lokomotiv 30 53 24 58
4 Yantra Gabrovo Yantra 30 57 34 53
5 Spartak Pleven Spartak 30 49 27 51
6 Samovodene Samovodene 30 57 25 50
7 Akademik Svishtov Akademik 30 52 29 48
8 Tryavna Tryavna 30 42 37 45
9 Sitomir Sitomir 30 39 53 41
10 Torpedo Torpedo 30 39 35 35
11 Botev Dimovo Botev Dimovo 30 25 58 32
12 Balkan Belogradchik Balkan 30 40 65 31
13 Gorna Lokomotiv Oryahovitsa Gorna 30 28 42 29
14 Gigant Belene Gigant 30 25 70 26
15 Lokomotiv Dryanovo Lokomotiv 30 17 76 23
16 OFK Levski OFK Levski 30 24 78 22
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Ravda 1954 Ravda 1954 36 111 20 96
2 Maritsa Plovdiv Maritsa 36 101 25 96
3 Neftochimik Neftochimik 36 89 28 77
4 Botev Galabovo Botev 36 58 28 64
5 Levski Karlovo Levski 36 54 28 62
6 Sozopol Sozopol 36 58 33 62
7 Stambolovo Stambolovo 36 47 35 56
8 Arda Kardzhali Arda 36 42 38 56
9 Hebros Hebros 36 52 41 55
10 Tundzha Yagoda Tundzha 36 75 67 54
11 Gigant Saedinenie Gigant 36 51 43 54
12 Zagorets Zagorets 36 50 60 43
13 Rozova dolina Rozova 36 54 76 40
14 Dimitrovgrad Dimitrovgrad 36 43 57 38
15 Strandzha-Metalurg Strandzha-Me 36 39 71 37
16 Metalik Metalik 36 46 90 37
17 Gabrovnitsa Gabrovnitsa 36 33 98 24
18 Tundzha Yambol Tundzha 36 20 105 17
19 FK Haskovo 2009 Haskovo 2009 36 10 90 14
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
6,853,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.5632
Total Execution Time  0.5661
  CADENA URL  
/v_afg_bulgaria2024/grupo3/historico
  GET DATOS  
$_GET['/v_afg_bulgaria2024/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0296  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.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=238 ORDER BY order_id ASC
0.0147  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.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 238 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0151  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 = 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
0.0152  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 `tables2023` 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 = 68509 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 63580 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2021` 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 = 57815 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2020` 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 = 51128 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2019` 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 = 44691 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2018` 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 = 39352 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2017` 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 = 34148 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2016` 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 = 15844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2015` 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 = 4373 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 `tables2014` 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 = 3576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 `tables2012` 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 = 24582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables2011` 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 = 24592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables2010` 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 = 24623 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2009` 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 = 24629 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 20:43:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 20:43:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 20:43:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 20:43:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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.0147  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.0155  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.0155  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.0199  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