4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Haskovo 2009
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
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Botev Galabovo Botev 34 56 17 73
2 FK Haskovo 2009 Haskovo 2009 34 62 25 69
3 Master Burgas Master 34 53 25 67
4 Svilengrad Svilengrad 34 62 34 63
5 Vereya Vereya 34 47 29 60
6 Nesebar Nesebar 34 58 31 58
7 Asenovets Asenovets 34 58 45 55
8 Spartak Plovdiv Spartak 34 45 37 52
9 Sozopol Sozopol 34 51 32 51
10 Tundzha Yambol Tundzha 34 60 56 50
11 Levski Karlovo Levski 34 52 53 50
12 Gigant Saedinenie Gigant 34 42 39 45
13 Rozova dolina Rozova 34 34 51 42
14 Dimitrovgrad Dimitrovgrad 34 36 47 41
15 Zagorets Zagorets 34 30 41 38
16 Brestnik Brestnik 34 35 92 27
17 Hebros Hebros 34 20 76 16
18 Arda Kardzhali Arda 34 10 81 9
TEMPORADA 2009/2010
TERCERA BULGARIA V AFG GRUPO 3
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
TEMPORADA 2008/2009
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Brestnik Brestnik 36 82 24 85
2 Tundzha Yagoda Tundzha 36 76 39 81
3 Pomorie Pomorie 35 73 19 73
4 Chernomorec Chernomorec 36 79 27 69
5 Stambolovo Stambolovo 36 68 42 64
6 Rozova dolina Rozova 36 64 49 54
7 Botev Galabovo Botev 36 49 37 53
8 Levski Karlovo Levski 36 54 58 53
9 Sozopol Sozopol 36 47 51 51
10 Gigant Saedinenie Gigant 36 55 56 50
11 FK Gorubso Rudozem Gorubso 36 46 47 48
12 Arda Kardzhali Arda 36 51 61 45
13 FK Kosmos Burgas Kosmos 36 51 63 44
14 Asenovets Asenovets 36 49 61 44
15 Hebros Hebros 36 28 39 40
16 Metalik Metalik 36 36 87 37
17 FK Haskovo 2009 Haskovo 2009 35 36 78 35
18 Tundzha Yambol Tundzha 36 38 89 28
19 Strandzha-Metalurg Strandzha-Me 36 25 80 23
TEMPORADA 2007/2008
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Sliven Sliven 26 63 23 60
2 Kaliakra Kaliakra 26 49 17 54
3 Rodopa Smolyan Rodopa 26 44 18 53
4 Nesebar Nesebar 26 43 29 50
5 Dunav Ruse Dunav Ruse 26 35 28 42
6 Spartak Plovdiv Spartak 26 28 34 35
7 Maritsa Plovdiv Maritsa 26 34 41 35
8 Chernomorets Pomorie Chernomorets 26 40 35 34
9 Panayot Volov Panayot 26 23 35 31
10 Svetkavitsa Svetkavitsa 26 26 46 28
11 Minyor Radnevo Minyor 26 32 50 26
12 Svilengrad Svilengrad 26 30 43 25
13 Benkovski Byala Benkovski 26 26 41 22
14 FK Haskovo 2009 Haskovo 2009 26 24 57 21
TEMPORADA 2006/2007
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomoretz Burgas Chernomoretz 26 57 20 63
2 Chernomorets Pomorie Chernomorets 26 51 10 60
3 FK Haskovo 2009 Haskovo 2009 26 38 27 43
4 Nesebar Nesebar 26 40 32 40
5 Dunav Ruse Dunav Ruse 26 46 35 39
6 Spartak Plovdiv Spartak 26 32 28 38
7 Panayot Volov Panayot 26 29 36 37
8 Kaliakra Kaliakra 26 25 31 36
9 Svetkavitsa Svetkavitsa 26 36 41 34
10 Maritsa Plovdiv Maritsa 26 35 36 32
11 Minyor Radnevo Minyor 26 34 45 25
12 Sliven Sliven 26 32 52 23
13 Dobrudzha Dobrich Dobrudzha 26 25 51 20
14 Lokomotiv Stara Zagora Lokomotiv 26 22 58 13
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
TEMPORADA 2000/2001
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 32 92 25 81
2 Marek Marek 32 54 17 68
3 Pirin Blagoevgrad Pirin 32 48 21 61
4 Lokomotiv Plovdiv Lokomotiv 32 55 39 58
5 Dobrudzha Dobrich Dobrudzha 32 52 37 57
6 Nesebar Nesebar 32 51 36 54
7 Svetkavitsa Svetkavitsa 32 47 36 54
8 Vidima-Rakovski Vidima-Rakov 32 53 36 52
9 Botev Vratsa Botev Vratsa 32 56 57 46
10 Belasitsa Belasitsa 32 37 31 44
11 Dunav Ruse Dunav Ruse 32 35 38 41
12 Akademik Svishtov Akademik 32 37 37 38
13 Septemvri Sofia Septemvri 32 39 47 37
14 Metalurg Pernik Metalurg 32 36 51 36
15 FK Haskovo 2009 Haskovo 2009 32 32 60 33
16 Bdin Bdin 31 18 96 10
17 Dorostol Dorostol 31 10 88 1
18 Panayot Volov Panayot 0 0 0 0
TEMPORADA 1992/1993
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 76 27 72
2 CSKA Sofia CSKA Sofia 30 66 31 59
3 Botev Plovdiv Botev 30 55 33 54
4 Lokomotiv Plovdiv Lokomotiv 30 57 29 53
5 Etar Etar 30 37 36 48
6 Lokomotiv Sofia Lokomotiv 30 52 39 46
7 Pirin Blagoevgrad Pirin 30 33 32 46
8 Chernomoretz Burgas Chernomoretz 30 33 31 41
9 Gorna Lokomotiv Oryahovitsa Gorna 30 31 37 39
10 Beroe Beroe 30 29 35 38
11 Yantra Gabrovo Yantra 30 38 52 36
12 Spartak Varna Spartak 30 30 48 32
13 Dobrudzha Dobrich Dobrudzha 30 32 57 31
14 Slavia Sofia Slavia Sofia 30 39 56 29
15 FK Haskovo 2009 Haskovo 2009 30 32 66 23
16 Sliven Sliven 30 27 58 19
TEMPORADA 1990/1991
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Etar Etar 30 49 21 62
2 CSKA Sofia CSKA Sofia 30 51 28 51
3 Slavia Sofia Slavia Sofia 30 48 29 51
4 Lokomotiv Sofia Lokomotiv 30 50 36 49
5 Botev Plovdiv Botev 30 49 41 49
6 Levski Sofia Levski Sofia 30 51 38 45
7 Gorna Lokomotiv Oryahovitsa Gorna 30 42 39 42
8 Chernomoretz Burgas Chernomoretz 30 41 50 41
9 Pirin Blagoevgrad Pirin 30 38 40 37
10 Beroe Beroe 30 38 41 37
11 FK Minyor Pernik Minyor 30 36 44 37
12 Lokomotiv Plovdiv Lokomotiv 30 34 42 36
13 Sliven Sliven 30 39 49 35
14 Yantra Gabrovo Yantra 30 31 44 35
15 Dunav Ruse Dunav Ruse 30 23 42 30
16 FK Haskovo 2009 Haskovo 2009 30 27 63 24
TEMPORADA 1983/1984
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 64 29 66
2 FK Haskovo 2009 Haskovo 2009 60 65 109 64
3 CSKA Sofia CSKA Sofia 30 72 24 63
4 Spartak Varna Spartak 30 41 37 44
5 Chernomoretz Burgas Chernomoretz 30 43 47 43
6 Beroe Beroe 30 38 40 42
7 Lokomotiv Sofia Lokomotiv 30 35 29 41
8 Etar Etar 30 47 48 41
9 Botev Plovdiv Botev 30 64 58 40
10 Botev Vratsa Botev Vratsa 30 32 31 40
11 Sliven Sliven 30 38 38 40
12 Belasitsa Belasitsa 30 25 49 38
13 Slavia Sofia Slavia Sofia 30 40 38 35
14 Cherno More Varna Cherno More 30 36 43 35
15 Lokomotiv Plovdiv Lokomotiv 30 43 63 34
TEMPORADA 1982/1983
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 52 26 63
2 Levski Sofia Levski Sofia 30 50 21 60
3 Botev Plovdiv Botev 30 62 40 54
4 Spartak Pleven Spartak 30 46 40 44
5 Lokomotiv Sofia Lokomotiv 30 39 40 44
6 Botev Vratsa Botev Vratsa 30 38 35 43
7 Sliven Sliven 30 46 45 43
8 Etar Etar 30 38 41 42
9 Spartak Varna Spartak 30 36 38 41
10 Belasitsa Belasitsa 30 43 54 41
11 Chernomoretz Burgas Chernomoretz 30 41 47 40
12 Slavia Sofia Slavia Sofia 30 35 37 39
13 Cherno More Varna Cherno More 30 24 28 38
14 FK Haskovo 2009 Haskovo 2009 30 34 41 31
15 Rozova dolina Rozova 30 30 53 26
16 Pirin Blagoevgrad Pirin 30 26 54 26
TEMPORADA 1981/1982
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 73 27 69
2 Levski Sofia Levski Sofia 30 71 32 66
3 Slavia Sofia Slavia Sofia 30 35 33 50
4 Cherno More Varna Cherno More 30 41 37 47
5 Chernomoretz Burgas Chernomoretz 30 48 44 46
6 Lokomotiv Sofia Lokomotiv 30 41 37 45
7 Botev Plovdiv Botev 30 46 42 43
8 Spartak Pleven Spartak 30 40 40 42
9 FK Haskovo 2009 Haskovo 2009 30 34 37 42
10 Belasitsa Belasitsa 30 32 43 38
11 Etar Etar 30 46 48 37
12 Sliven Sliven 30 38 40 37
13 Marek Marek 30 23 40 35
14 Botev Vratsa Botev Vratsa 30 23 41 29
15 Beroe Beroe 30 33 51 26
16 Akademik Sofia Akademik 30 23 55 23
TEMPORADA 1978/1979
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 54 29 61
2 CSKA Sofia CSKA Sofia 30 49 26 54
3 Slavia Sofia Slavia Sofia 30 52 33 52
4 Lokomotiv Sofia Lokomotiv 30 35 22 51
5 Chernomoretz Burgas Chernomoretz 30 45 43 47
6 Beroe Beroe 30 45 47 47
7 Marek Marek 30 42 39 46
8 Botev Plovdiv Botev 30 45 45 38
9 Pirin Blagoevgrad Pirin 30 37 39 38
10 Spartak Pleven Spartak 30 25 27 34
11 Botev Vratsa Botev Vratsa 30 36 42 34
12 Lokomotiv Plovdiv Lokomotiv 30 35 43 34
13 Cherno More Varna Cherno More 30 29 40 34
14 Sliven Sliven 30 35 42 33
15 Akademik Sofia Akademik 30 27 50 28
16 FK Haskovo 2009 Haskovo 2009 30 35 59 26

  USO DE MEMORIA  
6,660,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8292
Total Execution Time  0.8304
  CADENA URL  
/historico/Fk-Haskovo-2009/2014
  GET DATOS  
$_GET['/historico/Fk-Haskovo-2009/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0156  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 = 'Fk-Haskovo-2009' AND l.year = 2014 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.0145  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=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 20920
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12275 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0152  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.0147  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.0150  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 = '12275' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '12275' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '12275' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0167  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 = '12275' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0165  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 20920 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 2454 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0171  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=12275 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0157  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 (24555,20920,11704,3804,2454) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 11704 AND teamId = 12275
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 2454 AND teamId = 12275
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 24555 AND teamId = 12275
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 20920 AND teamId = 12275
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 12275
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '12275' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12275' and rp.type = 4
0.0157  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 = '12275' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0192  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 events2014 e ON e.player_id = p.id AND e.league_id = 2454 WHERE rp.league_id = 2454 AND rp.teamId = 12275 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.0164  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 events2014 e ON e.player_id = p.id AND e.league_id = 2454 WHERE rp.league_id = 2454 AND rp.teamId = 12275 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 events2014 e ON e.player_id = p.id AND e.league_id = 2454 WHERE rp.league_id = 2454 AND rp.teamId = 12275 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 12275 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0153  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 = 24555 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.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 `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 = 24631 AND t.round = 38 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 `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 = 14023 AND t.round = 26 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 `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 = 14022 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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
0.0158  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 `tables2001` 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 = 14039 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables1993` 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 = 26181 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables1991` 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 = 26189 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1984` 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 = 26244 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 `tables1983` 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 = 26245 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables1982` 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 = 26247 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1979` 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 = 26259 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2454 ORDER BY nameShow LIMIT 100