4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartak Varna

Spartak Varna

Entrenador: Valentin Iliev

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 30 51 22 63
2 Septemvri Sofia Septemvri 30 41 24 58
3 Marek Marek 30 31 21 54
4 Montana Montana 30 38 28 50
5 Dobrudzha Dobrich Dobrudzha 30 42 28 49
6 Yantra Gabrovo Yantra 30 35 32 44
7 Ludogorets II Ludogorets 30 35 30 42
8 Spartak Pleven Spartak 30 27 27 42
9 Dunav Ruse Dunav Ruse 30 27 31 42
10 Strumska Slava Strumska 30 28 28 41
11 Litex Lovech Litex Lovech 30 25 29 41
12 CSKA 1948 Sofia II CSKA 1948 S. 30 32 34 40
13 Belasitsa Belasitsa 30 33 29 37
14 Chernomorets 1919 Burgas Chernomorets 30 28 35 34
15 Sportist Svoge Sportist 30 28 39 33
16 Maritsa Plovdiv Maritsa 30 28 46 28
17 Chernomorets Balchik Chernomorets 30 28 45 27
18 Bdin Bdin 30 12 41 18
TEMPORADA 2022/2023
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Pirin Blagoevgrad Pirin 35 28 43 34
2 Hebar Pazardzhik Hebar 35 30 59 32
3 Botev Vratsa Botev Vratsa 35 29 64 32
4 Beroe Beroe 35 31 54 32
5 Septemvri Sofia Septemvri 35 31 52 28
6 Spartak Varna Spartak 35 32 65 25
TEMPORADA 2021/2022
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Septemvri Sofia Septemvri 36 77 35 70
2 Spartak Varna Spartak 36 64 39 70
3 Hebar Pazardzhik Hebar 36 54 33 70
4 Etar Etar 36 69 42 68
5 FK Minyor Pernik Minyor 36 50 35 63
6 Ludogorets II Ludogorets 36 70 48 61
7 Montana Montana 36 39 31 58
8 Strumska Slava Strumska 36 40 37 54
9 Maritsa Plovdiv Maritsa 36 51 48 50
10 Sportist Svoge Sportist 36 38 46 48
11 CSKA 1948 Sofia II CSKA 1948 S. 36 53 50 45
12 Dobrudzha Dobrich Dobrudzha 36 39 45 45
13 Litex Lovech Litex Lovech 36 41 42 45
14 Yantra Gabrovo Yantra 36 30 46 40
15 Sozopol Sozopol 36 40 56 39
16 Botev Plovdiv II Botev 36 34 47 38
17 Marek Marek 36 29 46 36
18 Septemvri Simitli Septemvri 36 41 68 33
19 Levski 2020 Lom Levski 2020 36 12 77 8
20 Neftochimik Neftochimik 0 0 0 0
TEMPORADA 2020/2021
TERCERA BULGARIA V AFG GRUPO 3
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
TEMPORADA 2019/2020
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 21 59 18 55
2 Septemvri Sofia Septemvri 20 47 19 52
3 Montana Montana 22 43 17 45
4 Lokomotiv Sofia Lokomotiv 22 37 18 42
5 Neftochimik Neftochimik 21 35 29 33
6 Hebar Pazardzhik Hebar 21 35 30 33
7 Litex Lovech Litex Lovech 20 29 15 32
8 Kariana Erden Kariana 20 30 24 32
9 Gorna Lokomotiv Oryahovitsa Gorna 21 32 30 29
10 Botev Galabovo Botev 22 26 32 28
11 Ludogorets II Ludogorets 22 23 25 27
12 Pirin Blagoevgrad Pirin 20 24 29 25
13 Strumska Slava Strumska 21 21 34 22
14 Chernomorets Balchik Chernomorets 20 15 27 22
15 Spartak Varna Spartak 22 9 42 13
16 Spartak Pleven Spartak 22 13 41 10
17 Pomorie Pomorie 27 15 63 6
TEMPORADA 2018/2019
TERCERA BULGARIA V AFG GRUPO 5
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 5 13 3 13
2 Suvorovo Suvorovo 5 14 3 10
3 Septemvri Tervel Septemvri 5 6 7 7
4 Svetkavitsa Targovishte Svetkavitsa 5 9 6 5
5 Hitrino Hitrino 5 4 5 4
6 Botev Novi Pazar Botev Novi. 5 2 24 1
TEMPORADA 2017/2018
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Dobrudzha Dobrich Dobrudzha 30 101 10 86
2 Suvorovo Suvorovo 30 81 21 64
3 Lokomotiv Ruse Lokomotiv 30 49 31 51
4 Hitrino Hitrino 30 43 36 51
5 Septemvri Tervel Septemvri 30 48 49 46
6 Svetkavitsa Targovishte Svetkavitsa 30 44 26 42
7 Kaliakra Kaliakra 30 40 43 42
8 Spartak Varna Spartak 30 43 61 36
9 Botev Novi Pazar Botev Novi. 30 25 78 21
10 Kubrat Kubrat 30 22 61 17
11 Benkovski Byala Benkovski 30 20 100 12
12 Dorostol Dorostol 0 0 0 0
TEMPORADA 2016/2017
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomorets Balchik Chernomorets 22 49 7 60
2 Dobrudzha Dobrich Dobrudzha 22 55 8 55
3 Suvorovo Suvorovo 22 42 20 39
4 Kaliakra Kaliakra 22 33 24 36
5 Botev Novi Pazar Botev Novi. 22 21 38 34
6 Septemvri Tervel Septemvri 22 21 25 28
7 Lokomotiv Ruse Lokomotiv 22 28 24 27
8 Svetkavitsa Targovishte Svetkavitsa 22 15 28 23
9 Kubrat Kubrat 22 21 39 22
10 Hitrino Hitrino 22 18 32 20
11 Dorostol Dorostol 22 15 43 15
12 Spartak Varna Spartak 22 21 51 13
13 Inter Dobrich Inter 0 0 0 0
TEMPORADA 2014/2015
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Montana Montana 30 72 16 78
2 Pirin Blagoevgrad Pirin 30 52 15 61
3 Gorna Lokomotiv Oryahovitsa Gorna 30 60 34 59
4 Bansko Bansko 30 38 18 53
5 Sozopol Sozopol 30 39 25 46
6 Dobrudzha Dobrich Dobrudzha 30 41 28 46
7 Master Burgas Master 30 34 30 43
8 Botev Galabovo Botev 30 35 40 42
9 Lokomotiv Mezdra Lokomotiv 30 43 41 41
10 Pirin Razlog Pirin Razlog 30 33 38 40
11 Vereya Vereya 30 25 24 37
12 Septemvri Simitli Septemvri 30 30 47 36
13 Botev Vratsa Botev Vratsa 30 26 43 29
14 Chernomoretz Burgas Chernomoretz 30 25 40 28
15 Rakovski 2011 Rakovski 29 25 71 19
16 Spartak Varna Spartak 29 9 77 6
TEMPORADA 2013/2014
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Marek Marek 26 40 17 54
2 FK Haskovo 2009 Haskovo 2009 26 35 20 46
3 Dobrudzha Dobrich Dobrudzha 26 33 20 46
4 Montana Montana 26 36 24 44
5 Bansko Bansko 26 40 24 42
6 Botev Vratsa Botev Vratsa 26 32 23 38
7 Pirin Razlog Pirin Razlog 26 30 43 36
8 Spartak Varna Spartak 26 24 29 34
9 Rakovski 2011 Rakovski 26 28 35 32
10 Vitosha Bistritsa Vitosha 26 22 24 28
11 Kaliakra Kaliakra 26 23 34 28
12 Botev Galabovo Botev 26 20 31 28
13 Dunav Ruse Dunav Ruse 26 24 32 27
14 Akademik Svishtov Akademik 26 12 43 15
TEMPORADA 2012/2013
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Neftochimik Neftochimik 26 49 22 54
2 Lyubimets Lyubimets 26 44 28 51
3 Rakovski 2011 Rakovski 26 38 28 48
4 Svetkavitsa Svetkavitsa 26 34 20 47
5 Bansko Bansko 26 48 26 46
6 Spartak 1919 Pleven Spartak 1919 26 33 25 42
7 Spartak Varna Spartak 26 26 19 38
8 Chavdar Etropole Chavdar 26 31 32 37
9 Kaliakra Kaliakra 26 33 31 34
10 Pirin Razlog Pirin Razlog 26 33 28 33
11 Vidima-Rakovski Vidima-Rakov 26 33 31 29
12 Shumen 2010 Shumen 2010 26 32 52 29
13 Septemvri Simitli Septemvri 26 18 39 15
14 OFC Sliven 2000 Sliven 2000 26 4 75 0
TEMPORADA 2011/2012
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Etar Etar 27 31 14 53
2 Botev Plovdiv Botev 27 40 17 51
3 Neftochimik Neftochimik 27 46 28 49
4 Lyubimets Lyubimets 27 42 22 48
5 Chernomorets Pomorie Chernomorets 27 38 29 37
6 OFC Sliven 2000 Sliven 2000 27 29 23 36
7 Spartak Varna Spartak 27 27 35 36
8 Dobrudzha Dobrich Dobrudzha 27 22 28 32
9 Nesebar Nesebar 27 24 44 26
10 Dorostol Dorostol 27 6 65 2
TEMPORADA 2010/2011
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 30 91 20 76
2 Septemvri Tervel Septemvri 30 54 27 62
3 Dve Mogili Dve Mogili 30 58 29 59
4 Shumen 2010 Shumen 2010 30 65 31 56
5 Suvorovo Suvorovo 30 45 24 55
6 Rapid Rapid 30 39 40 44
7 Chernomorets Byala Chernomorets 30 49 50 43
8 Belitsa Belitsa 30 43 42 40
9 Chernolomets 1919 Chernolomets 30 42 45 38
10 Skrita Sila Skrita Sila 30 51 58 38
11 Benkovski Byala Benkovski 30 58 58 37
12 Topoli Topoli 29 34 54 32
13 Veliki Preslav Veliki 30 26 54 30
14 Himik Devnya Himik Devnya 30 21 52 25
15 Shabla Shabla 29 23 59 25
16 Botev Novi Pazar Botev Novi. 30 19 75 20
TEMPORADA 2009/2010
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Nesebar Nesebar 28 56 24 57
2 Kaliakra Kaliakra 28 44 20 57
3 Dunav Ruse Dunav Ruse 28 48 29 54
4 Spartak Plovdiv Spartak 28 36 24 47
5 Lyubimets Lyubimets 28 39 24 45
6 Brestnik Brestnik 28 42 29 45
7 Chernomorets Pomorie Chernomorets 28 46 36 43
8 Chernomorets Balchik Chernomorets 28 37 30 42
9 Spartak Varna Spartak 28 33 41 37
10 Panayot Volov Panayot 28 37 40 33
11 Svetkavitsa Svetkavitsa 28 28 31 32
12 Svilengrad Svilengrad 28 36 58 31
13 Minyor Radnevo Minyor 28 34 46 30
14 Dobrudzha Dobrich Dobrudzha 28 27 39 30
15 Rodopa Smolyan Rodopa 28 6 78 5
TEMPORADA 2008/2009
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 57 18 69
2 CSKA Sofia CSKA Sofia 30 54 22 68
3 Cherno More Varna Cherno More 30 48 19 60
4 Litex Lovech Litex Lovech 30 53 26 58
5 Lokomotiv Sofia Lokomotiv 30 52 29 54
6 Chernomoretz Burgas Chernomoretz 30 41 37 43
7 Lokomotiv Plovdiv Lokomotiv 30 40 43 43
8 Slavia Sofia Slavia Sofia 30 41 38 37
9 Lokomotiv Mezdra Lokomotiv 30 39 41 37
10 Pirin Blagoevgrad Pirin 30 35 50 35
11 FK Minyor Pernik Minyor 30 24 39 35
12 OFC Sliven 2000 Sliven 2000 30 32 40 32
13 Botev Plovdiv Botev 30 31 50 30
14 Vihren Vihren 30 29 50 26
15 Spartak Varna Spartak 30 19 46 25
16 Belasitsa Belasitsa 30 24 71 17
TEMPORADA 2007/2008
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 53 11 78
2 Levski Sofia Levski Sofia 30 56 19 62
3 Lokomotiv Sofia Lokomotiv 30 47 28 57
4 Litex Lovech Litex Lovech 30 51 26 56
5 Cherno More Varna Cherno More 30 39 28 48
6 Slavia Sofia Slavia Sofia 30 38 28 47
7 Chernomoretz Burgas Chernomoretz 30 39 32 47
8 Pirin Blagoevgrad Pirin 30 32 29 46
9 Lokomotiv Plovdiv Lokomotiv 30 37 28 43
10 Vihren Vihren 30 26 29 33
11 Spartak Varna Spartak 30 21 33 31
12 Botev Plovdiv Botev 30 36 54 30
13 Beroe Beroe 30 23 39 26
14 Belasitsa Belasitsa 30 23 43 26
15 Vidima-Rakovski Vidima-Rakov 30 17 61 18
16 Marek Marek 30 16 66 18
TEMPORADA 2006/2007
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 96 13 77
2 CSKA Sofia CSKA Sofia 30 68 13 72
3 Lokomotiv Sofia Lokomotiv 30 70 28 72
4 Litex Lovech Litex Lovech 30 65 29 62
5 Slavia Sofia Slavia Sofia 30 47 35 49
6 Cherno More Varna Cherno More 30 35 29 47
7 Lokomotiv Plovdiv Lokomotiv 30 48 43 43
8 Belasitsa Belasitsa 30 38 43 38
9 Botev Plovdiv Botev 30 41 45 37
10 Vihren Vihren 30 27 39 37
11 Beroe Beroe 30 34 33 36
12 Marek Marek 30 39 57 34
13 Spartak Varna Spartak 30 27 52 33
14 Rilski Sportist Rilski 30 31 53 30
15 Rodopa Smolyan Rodopa 30 22 52 19
16 Chernomorets Sofia Chernomorets 30 7 131 0
TEMPORADA 2005/2006
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 26 34 12 56
2 Maritsa Plovdiv Maritsa 26 41 21 49
3 FK Haskovo 2009 Haskovo 2009 26 37 19 48
4 Spartak Plovdiv Spartak 26 32 26 43
5 AKB Minyor AKB Minyor 26 30 32 39
6 Dunav Ruse Dunav Ruse 26 27 35 36
7 Dobrudzha Dobrich Dobrudzha 26 27 26 34
8 Nesebar Nesebar 26 37 37 34
9 Panayot Volov Panayot 26 32 33 34
10 Svetkavitsa Svetkavitsa 26 27 26 33
11 Kaliakra Kaliakra 26 27 36 32
12 Sliven Sliven 26 22 30 31
13 Pomorie Pomorie 26 22 38 24
14 Zagorets Zagorets 26 21 45 16

  USO DE MEMORIA  
7,252,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7473
Total Execution Time  0.7484
  CADENA URL  
/historico/Spartak-Varna
  GET DATOS  
$_GET['/historico/Spartak-Varna']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0139  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Spartak-Varna' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7476 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 237 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0126  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 (856187,808709,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0133  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '7476' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '7476' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '7476' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=7476 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73790,72088,71635,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71635 AND teamId = 7476
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 7476
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 7476
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7476
0.0137  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7476' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7476' and rp.type = 4
0.0129  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7476' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0194  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7476 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0207  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7476 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0210  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7476 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 7476 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72088 AND t.round = 31 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 `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 = 67855 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.0141  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 = 71635 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 63160 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.0145  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.0145  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 = 50137 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 44692 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 49733 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 39351 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 34146 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 4440 AND t.round = 30 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 `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 = 2454 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables2013` 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 = 2029 AND t.round = 26 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 `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 = 1737 AND t.round = 27 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 `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 = 24591 AND t.round = 34 ORDER BY team.conference 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 `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 = 14025 AND t.round = 30 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 = 8792 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2008` 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 = 8791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2007` 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 = 8789 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2006` 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 = 14028 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC