4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2014/2015
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 17 10 63
2 Beroe Beroe 10 12 9 55
3 Lokomotiv Sofia Lokomotiv 10 10 7 55
4 Litex Lovech Litex Lovech 10 12 12 54
5 CSKA Sofia CSKA Sofia 10 6 12 52
6 Botev Plovdiv Botev 10 6 13 42
TEMPORADA 2013/2014
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beroe Beroe 12 26 4 70
2 Slavia Sofia Slavia Sofia 12 22 8 55
3 Lokomotiv Sofia Lokomotiv 12 16 8 54
4 Chernomoretz Burgas Chernomoretz 12 26 16 44
5 Neftochimik Neftochimik 12 11 26 25
6 Pirin Gotse Delchev Pirin Gotse 12 12 20 22
7 Lyubimets Lyubimets 12 7 38 21
TEMPORADA 2012/2013
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 58 13 72
2 Levski Sofia Levski Sofia 30 59 20 71
3 CSKA Sofia CSKA Sofia 30 54 20 63
4 Botev Plovdiv Botev 30 51 21 60
5 Litex Lovech Litex Lovech 30 56 24 50
6 Chernomoretz Burgas Chernomoretz 30 32 29 47
7 Beroe Beroe 30 36 38 45
8 Slavia Sofia Slavia Sofia 30 40 35 42
9 Lokomotiv Plovdiv Lokomotiv 30 37 34 39
10 Cherno More Varna Cherno More 30 33 39 35
11 Pirin Gotse Delchev Pirin Gotse 30 27 57 34
12 Lokomotiv Sofia Lokomotiv 30 27 38 31
13 Botev Vratsa Botev Vratsa 30 23 51 31
14 FK Minyor Pernik Minyor 30 20 49 20
15 Montana Montana 30 27 57 16
16 Etar Etar 30 20 75 13
TEMPORADA 2011/2012
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 73 16 70
2 CSKA Sofia CSKA Sofia 30 60 19 69
3 Levski Sofia Levski Sofia 30 61 28 62
4 Chernomoretz Burgas Chernomoretz 30 57 23 60
5 Litex Lovech Litex Lovech 30 57 28 59
6 Lokomotiv Plovdiv Lokomotiv 30 44 39 57
7 Cherno More Varna Cherno More 30 46 25 52
8 Slavia Sofia Slavia Sofia 30 42 36 51
9 FK Minyor Pernik Minyor 30 35 40 36
10 Beroe Beroe 30 30 37 35
11 Montana Montana 30 29 51 31
12 Botev Vratsa Botev Vratsa 30 30 44 29
13 Lokomotiv Sofia Lokomotiv 30 26 50 24
14 Vidima-Rakovski Vidima-Rakov 30 19 59 15
15 Kaliakra Kaliakra 30 26 77 11
16 Svetkavitsa Svetkavitsa 30 8 71 8
TEMPORADA 2010/2011
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 56 13 75
2 Levski Sofia Levski Sofia 30 67 24 72
3 CSKA Sofia CSKA Sofia 30 53 26 61
4 Lokomotiv Plovdiv Lokomotiv 30 54 28 52
5 Lokomotiv Sofia Lokomotiv 30 47 33 52
6 Cherno More Varna Cherno More 30 36 28 51
7 Beroe Beroe 30 33 34 46
8 Chernomoretz Burgas Chernomoretz 30 19 28 37
9 FK Minyor Pernik Minyor 30 33 45 36
10 Slavia Sofia Slavia Sofia 30 34 38 32
11 Montana Montana 30 30 46 32
12 Kaliakra Kaliakra 30 19 40 30
13 Pirin Blagoevgrad Pirin 30 32 39 27
14 Vidima-Rakovski Vidima-Rakov 30 26 52 25
15 Akademik Sofia Akademik 30 16 51 20
16 OFC Sliven 2000 Sliven 2000 30 22 52 19
TEMPORADA 2009/2010
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 59 17 70
2 CSKA Sofia CSKA Sofia 30 51 22 58
3 Levski Sofia Levski Sofia 30 57 26 57
4 Lokomotiv Sofia Lokomotiv 30 47 33 52
5 Chernomoretz Burgas Chernomoretz 30 44 29 51
6 Slavia Sofia Slavia Sofia 30 34 28 50
7 Cherno More Varna Cherno More 30 40 28 48
8 FK Minyor Pernik Minyor 30 38 26 45
9 Pirin Blagoevgrad Pirin 30 34 32 43
10 Beroe Beroe 30 30 36 38
11 Montana Montana 30 30 37 36
12 Lokomotiv Plovdiv Lokomotiv 30 36 52 33
13 OFC Sliven 2000 Sliven 2000 30 29 40 32
14 Lokomotiv Mezdra Lokomotiv 30 27 48 27
15 Sportist Svoge Sportist 30 23 59 19
16 Botev Plovdiv Botev 30 12 78 1
TEMPORADA 2008/2009
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Beroe Beroe 28 48 19 66
2 Chernomorets Pomorie Chernomorets 28 59 21 61
3 Kaliakra Kaliakra 28 39 28 48
4 Spartak Plovdiv Spartak 28 30 33 41
5 Dunav Ruse Dunav Ruse 28 35 34 39
6 Nesebar Nesebar 28 36 32 38
7 Lyubimets Lyubimets 28 30 29 38
8 Svetkavitsa Svetkavitsa 28 37 40 35
9 Svilengrad Svilengrad 28 32 40 34
10 Minyor Radnevo Minyor 28 35 47 33
11 Lokomotiv Stara Zagora Lokomotiv 28 31 36 32
12 Chernomorets Balchik Chernomorets 28 30 39 31
13 Rodopa Smolyan Rodopa 28 33 48 31
14 Panayot Volov Panayot 28 22 34 30
15 Maritsa Plovdiv Maritsa 28 21 38 29
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
LIGA BULGARIA
Equipo PJ GF GC Puntos
TEMPORADA 2004/2005
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 81 16 79
2 Levski Sofia Levski Sofia 30 76 19 76
3 Lokomotiv Plovdiv Lokomotiv 30 65 34 58
4 Litex Lovech Litex Lovech 30 45 27 52
5 Slavia Sofia Slavia Sofia 30 43 33 48
6 Lokomotiv Sofia Lokomotiv 30 43 35 46
7 Beroe Beroe 30 32 36 35
8 Cherno More Varna Cherno More 30 30 38 35
9 Marek Marek 30 34 44 35
10 Neftochimik Neftochimik 30 24 38 35
11 Belasitsa Belasitsa 30 25 47 34
12 Pirin Blagoevgrad Pirin 30 31 40 33
13 Rodopa Smolyan Rodopa 30 33 43 33
14 Vidima-Rakovski Vidima-Rakov 30 32 51 32
15 Nesebar Nesebar 30 25 63 20
16 Spartak Varna Spartak 30 18 73 18
TEMPORADA 2003/2004
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Beroe Beroe 26 45 13 58
2 Pirin Blagoevgrad Pirin 26 44 19 49
3 Nesebar Nesebar 26 37 30 46
4 Dobrudzha Dobrich Dobrudzha 26 45 27 44
5 Svetkavitsa Svetkavitsa 26 32 28 42
6 Vihren Vihren 26 34 38 34
7 Rilski Sportist Rilski 26 31 35 34
8 Spartak Pleven Spartak 26 30 36 34
9 Etar Etar 26 31 34 32
10 Panayot Volov Panayot 26 25 32 31
11 Chernomoretz Burgas Chernomoretz 26 30 35 30
12 Akademik Svishtov Akademik 26 25 36 24
13 Belite Orli Belite Orli 26 25 47 21
14 Septemvri Sofia Septemvri 26 18 42 18
TEMPORADA 2002/2003
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Rodopa Smolyan Rodopa 30 75 26 70
2 Makedonska Sl Makedonska 30 65 19 69
3 Vidima-Rakovski Vidima-Rakov 30 60 24 60
4 Belasitsa Belasitsa 30 60 32 58
5 Pirin Blagoevgrad Pirin 30 56 32 58
6 Svetkavitsa Svetkavitsa 30 45 36 56
7 Beroe Beroe 30 36 30 48
8 Sokol 96 Sokol 96 30 39 44 40
9 Yantra Gabrovo Yantra 30 42 53 40
10 Olimpik Teteven Olimpik 30 47 54 38
11 Akademik Svishtov Akademik 30 34 38 33
12 Belite Orli Belite Orli 30 29 51 28
13 Chernomoretz Burgas Chernomoretz 30 41 61 27
14 Spartak Pleven Spartak 30 32 57 26
15 Dunav Ruse Dunav Ruse 30 19 56 18
16 Botev Vratsa Botev Vratsa 30 14 81 4
TEMPORADA 2001/2002
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 26 58 21 65
2 Litex Lovech Litex Lovech 26 50 27 55
3 Lokomotiv Plovdiv Lokomotiv 26 42 23 53
4 CSKA Sofia CSKA Sofia 26 48 17 52
5 Chernomorets Pomorie Chernomorets 26 35 25 42
6 Slavia Sofia Slavia Sofia 26 30 32 37
7 Spartak Pleven Spartak 26 40 44 33
8 Lokomotiv Sofia Lokomotiv 26 33 32 29
9 Spartak Varna Spartak 26 29 39 26
10 Chernomoretz Burgas Chernomoretz 26 24 54 26
11 Cherno More Varna Cherno More 26 28 36 24
12 Marek Marek 26 22 42 24
13 Belasitsa Belasitsa 26 21 35 23
14 Beroe Beroe 26 13 46 14
TEMPORADA 2000/2001
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 26 63 13 69
2 CSKA Sofia CSKA Sofia 26 65 16 62
3 Velbazhd Velbazhd 26 48 29 57
4 Litex Lovech Litex Lovech 26 70 23 55
5 Neftochimik Neftochimik 26 47 34 42
6 Slavia Sofia Slavia Sofia 26 35 35 35
7 Spartak Varna Spartak 26 38 40 34
8 Lokomotiv Sofia Lokomotiv 26 37 37 33
9 Hebar Pazardzhik Hebar 26 39 55 26
10 Cherno More Varna Cherno More 26 20 49 26
11 Chernomoretz Burgas Chernomoretz 26 22 48 22
12 Beroe Beroe 26 21 47 22
13 Botev Plovdiv Botev 26 28 55 20
14 FK Minyor Pernik Minyor 26 19 71 13
TEMPORADA 1999/2000
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 66 17 74
2 CSKA Sofia CSKA Sofia 30 60 26 64
3 Velbazhd Velbazhd 30 52 32 55
4 Neftochimik Neftochimik 30 42 21 53
5 Litex Lovech Litex Lovech 30 61 34 49
6 Slavia Sofia Slavia Sofia 30 38 40 45
7 Spartak Varna Spartak 30 42 51 41
8 Botev Plovdiv Botev 30 43 42 40
9 Lokomotiv Sofia Lokomotiv 30 54 37 39
10 Chernomoretz Burgas Chernomoretz 30 31 40 37
11 FK Minyor Pernik Minyor 30 44 58 36
12 Dobrudzha Dobrich Dobrudzha 30 30 43 35
13 Beroe Beroe 30 28 47 34
14 Pirin Blagoevgrad Pirin 30 31 50 33
15 Belasitsa Belasitsa 30 28 57 33
16 Panayot Volov Panayot 30 13 68 11
TEMPORADA 1994/1995
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 84 15 79
2 Lokomotiv Sofia Lokomotiv 30 59 30 68
3 Botev Plovdiv Botev 30 66 31 60
4 Slavia Sofia Slavia Sofia 30 63 35 53
5 CSKA Sofia CSKA Sofia 30 51 46 46
6 Spartak Plovdiv Spartak 30 33 34 43
7 Lokomotiv Plovdiv Lokomotiv 30 48 38 42
8 Neftochimik Neftochimik 30 41 50 39
9 Shumen 2010 Shumen 2010 30 33 50 36
10 Litex Lovech Litex Lovech 30 25 46 36
11 Etar Etar 30 31 54 36
12 Dobrudzha Dobrich Dobrudzha 30 32 43 35
13 Montana Montana 30 31 41 34
14 Gorna Lokomotiv Oryahovitsa Gorna 30 35 53 33
15 Pirin Blagoevgrad Pirin 30 30 46 30
16 Beroe Beroe 30 27 77 12
TEMPORADA 1993/1994
LIGA BULGARIA
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
7,054,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2062
Total Execution Time  0.2074
  CADENA URL  
/historico/Beroe/2015
  GET DATOS  
$_GET['/historico/Beroe/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0090  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 = 'Beroe' AND l.year = 2015 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.0024  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=6320 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=6320 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=6320 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=6320 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=6320 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048  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 = 3815
0.0048  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 = 11703
0.0049  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 = 5516
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6320 AND type_rel = 2
0.0044  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6320 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0035  SELECT /*35 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 (68575,125821,903380,1193443) ORDER BY n.cover_points DESC, update_date DESC
0.0095  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 = '6320' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0065  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 = '6320' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 3815 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 5516 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=6320 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (41746,20920,15434,3804,2463) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 15434 AND teamId = 6320
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 41746 AND teamId = 6320
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 20920 AND teamId = 6320
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 2463 AND teamId = 6320
0.0066  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 6320
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 3815 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '6320' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6320' and rp.type = 4
0.0022  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 = '6320' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045  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 events2015 e ON e.player_id = p.id AND e.league_id = 3815 WHERE rp.league_id = 3815 AND rp.teamId = 6320 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.0041  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 events2015 e ON e.player_id = p.id AND e.league_id = 3815 WHERE rp.league_id = 3815 AND rp.teamId = 6320 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 events2015 e ON e.player_id = p.id AND e.league_id = 3815 WHERE rp.league_id = 3815 AND rp.teamId = 6320 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 6320 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 3815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 11703 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 2453 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10193 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 1934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 1621 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 8796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 8795 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 14024 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.0019  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 = 8788 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2005` 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 = 8786 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2004` 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 = 14042 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2003` 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 = 14041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2002` 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 = 8781 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 8780 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2000` 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 = 8779 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1995` 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 = 26175 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1994` 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 = 26177 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 3815 ORDER BY nameShow LIMIT 100