4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2010/2011
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 77 29 81
2 Odense BK Odense BK 33 55 41 55
3 Brøndby IF Brøndby IF 33 52 39 51
4 Midtjylland Midtjylland 33 50 42 49
5 Silkeborg IF Silkeborg 33 43 49 43
6 Nordsjaelland Nordsjaellan 33 38 50 39
7 SonderjyskE SonderjyskE 33 32 46 39
8 Lyngby BK Lyngby BK 33 42 52 38
9 AC Horsens AC Horsens 33 29 40 37
10 Aalborg BK Aalborg BK 33 38 48 35
11 Randers Randers 33 41 48 34
12 Esbjerg Esbjerg 33 36 49 33
TEMPORADA 2009/2010
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 61 22 68
2 Odense BK Odense BK 33 46 34 59
3 Brøndby IF Brøndby IF 33 57 50 52
4 Esbjerg Esbjerg 33 48 43 50
5 Aalborg BK Aalborg BK 33 36 30 48
6 Midtjylland Midtjylland 33 45 48 47
7 Nordsjaelland Nordsjaellan 33 40 41 43
8 Silkeborg IF Silkeborg 33 47 51 43
9 SonderjyskE SonderjyskE 33 32 37 41
10 Randers Randers 33 37 43 40
11 AGF Aarhus AGF Aarhus 33 36 47 38
12 Køge BK Køge BK 33 30 69 19
TEMPORADA 2008/2009
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 67 26 74
2 Odense BK Odense BK 33 65 31 69
3 Brøndby IF Brøndby IF 33 55 31 68
4 Midtjylland Midtjylland 33 55 46 55
5 Randers Randers 33 52 50 46
6 AGF Aarhus AGF Aarhus 33 39 44 45
7 Aalborg BK Aalborg BK 33 40 49 39
8 Nordsjaelland Nordsjaellan 33 44 53 35
9 Esbjerg Esbjerg 33 32 41 32
10 SonderjyskE SonderjyskE 33 30 56 28
11 Vejle BK Vejle BK 33 30 59 25
12 AC Horsens AC Horsens 33 35 58 24
TEMPORADA 2007/2008
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 60 38 71
2 Midtjylland Midtjylland 33 53 36 62
3 Kobenhavn Kobenhavn 33 51 29 60
4 Odense BK Odense BK 33 46 27 52
5 AC Horsens AC Horsens 33 47 43 52
6 Randers Randers 33 41 33 47
7 Esbjerg Esbjerg 33 59 54 45
8 Brøndby IF Brøndby IF 33 44 44 43
9 Nordsjaelland Nordsjaellan 33 47 51 43
10 AGF Aarhus AGF Aarhus 33 33 51 29
11 Viborg FF Viborg FF 33 29 68 20
12 Lyngby BK Lyngby BK 33 33 69 18
TEMPORADA 2006/2007
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 60 23 76
2 Midtjylland Midtjylland 33 58 39 63
3 Aalborg BK Aalborg BK 33 55 35 61
4 Odense BK Odense BK 33 46 36 58
5 Nordsjaelland Nordsjaellan 33 67 39 57
6 Brøndby IF Brøndby IF 33 50 38 49
7 Esbjerg Esbjerg 33 47 50 40
8 Randers Randers 33 41 53 38
9 Viborg FF Viborg FF 33 34 64 29
10 AC Horsens AC Horsens 33 29 53 28
11 Vejle BK Vejle BK 33 35 64 25
12 Silkeborg IF Silkeborg 33 33 61 22
TEMPORADA 2005/2006
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 27 73
2 Brøndby IF Brøndby IF 33 60 34 67
3 Odense BK Odense BK 33 49 28 58
4 Viborg FF Viborg FF 33 62 43 54
5 Aalborg BK Aalborg BK 33 48 44 45
6 Esbjerg Esbjerg 33 43 45 42
7 Midtjylland Midtjylland 33 42 52 41
8 Silkeborg IF Silkeborg 33 33 50 39
9 Nordsjaelland Nordsjaellan 33 49 55 38
10 AC Horsens AC Horsens 33 29 41 37
11 SonderjyskE SonderjyskE 33 41 72 26
12 AGF Aarhus AGF Aarhus 33 36 63 22
TEMPORADA 2004/2005
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 61 23 69
2 Kobenhavn Kobenhavn 33 53 39 57
3 Midtjylland Midtjylland 33 49 40 57
4 Aalborg BK Aalborg BK 33 59 45 53
5 Esbjerg Esbjerg 33 61 47 49
6 Odense BK Odense BK 33 61 41 48
7 Viborg FF Viborg FF 33 43 45 48
8 Silkeborg IF Silkeborg 33 50 52 47
9 AGF Aarhus AGF Aarhus 33 47 53 39
10 Nordsjaelland Nordsjaellan 33 36 59 30
11 Herfølge BK Herfølge 33 29 71 25
12 Randers Randers 33 30 64 24
TEMPORADA 2003/2004
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 56 27 68
2 Brøndby IF Brøndby IF 33 55 29 67
3 Esbjerg Esbjerg 33 71 44 62
4 Odense BK Odense BK 33 66 46 57
5 Aalborg BK Aalborg BK 33 55 41 57
6 Midtjylland Midtjylland 33 65 51 48
7 Viborg FF Viborg FF 33 47 44 42
8 AGF Aarhus AGF Aarhus 33 45 67 36
9 Nordsjaelland Nordsjaellan 33 35 59 32
10 Herfølge BK Herfølge 33 34 57 31
11 BK Frem 1886 Frem 1886 33 40 65 27
12 Akademisk Boldklub Akademisk 33 31 70 26
TEMPORADA 2002/2003
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 51 32 61
2 Brøndby IF Brøndby IF 33 61 35 56
3 Nordsjaelland Nordsjaellan 33 49 58 51
4 Odense BK Odense BK 33 55 50 48
5 Esbjerg Esbjerg 33 65 57 47
6 Aalborg BK Aalborg BK 33 42 45 46
7 Midtjylland Midtjylland 33 49 45 44
8 Viborg FF Viborg FF 33 58 55 43
9 Akademisk Boldklub Akademisk 33 44 48 42
10 AGF Aarhus AGF Aarhus 33 49 59 40
11 Silkeborg IF Silkeborg 33 52 54 36
12 Køge BK Køge BK 33 45 82 27
TEMPORADA 2001/2002
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 74 28 69
2 Kobenhavn Kobenhavn 33 62 25 69
3 Midtjylland Midtjylland 33 47 27 57
4 Aalborg BK Aalborg BK 33 52 45 54
5 Akademisk Boldklub Akademisk 33 48 38 50
6 Odense BK Odense BK 33 56 51 49
7 Esbjerg Esbjerg 33 42 44 45
8 Viborg FF Viborg FF 33 46 45 41
9 Silkeborg IF Silkeborg 33 41 50 32
10 AGF Aarhus AGF Aarhus 33 42 56 31
11 Vejle BK Vejle BK 33 38 72 28
12 Lyngby BK Lyngby BK 33 25 92 15
TEMPORADA 2000/2001
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 55 27 63
2 Brøndby IF Brøndby IF 33 71 42 58
3 Silkeborg IF Silkeborg 33 49 36 56
4 Midtjylland Midtjylland 33 54 43 53
5 Aalborg BK Aalborg BK 33 51 49 49
6 Viborg FF Viborg FF 33 52 42 46
7 Odense BK Odense BK 33 49 45 46
8 AGF Aarhus AGF Aarhus 33 54 58 44
9 Lyngby BK Lyngby BK 33 40 53 44
10 Akademisk Boldklub Akademisk 33 43 41 39
11 Herfølge BK Herfølge 33 41 65 30
12 HFK Sonderjyl Sonderjyl 33 30 88 11
TEMPORADA 1999/2000
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Herfølge BK Herfølge 33 52 49 56
2 Brøndby IF Brøndby IF 33 56 37 54
3 Akademisk Boldklub Akademisk 33 52 35 52
4 Viborg FF Viborg FF 33 56 50 52
5 Aalborg BK Aalborg BK 33 57 40 49
6 Silkeborg IF Silkeborg 33 49 33 49
7 Lyngby BK Lyngby BK 33 51 55 47
8 Kobenhavn Kobenhavn 33 44 37 44
9 Odense BK Odense BK 33 42 44 43
10 AGF Aarhus AGF Aarhus 33 36 55 36
11 Vejle BK Vejle BK 33 38 68 32
12 Esbjerg Esbjerg 33 40 70 28
TEMPORADA 1998/1999
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 65 37 64
2 Brøndby IF Brøndby IF 33 73 37 61
3 Akademisk Boldklub Akademisk 33 49 36 56
4 Lyngby BK Lyngby BK 33 55 60 52
5 Herfølge BK Herfølge 33 44 36 47
6 Vejle BK Vejle BK 33 54 48 47
7 Kobenhavn Kobenhavn 33 55 52 46
8 Viborg FF Viborg FF 33 61 59 44
9 Silkeborg IF Silkeborg 33 52 53 44
10 AGF Aarhus AGF Aarhus 33 45 55 43
11 Aarhus Fremad Aarhus 33 51 73 29
12 B93 B93 33 22 80 12
TEMPORADA 1997/1998
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 81 33 76
2 Silkeborg IF Silkeborg 33 55 31 63
3 Kobenhavn Kobenhavn 33 66 48 61
4 Vejle BK Vejle BK 33 53 51 52
5 Akademisk Boldklub Akademisk 33 61 52 47
6 Lyngby BK Lyngby BK 33 53 62 45
7 Aalborg BK Aalborg BK 33 54 48 44
8 AGF Aarhus AGF Aarhus 33 53 52 43
9 Herfølge BK Herfølge 33 44 69 34
10 Aarhus Fremad Aarhus 33 51 73 33
11 Ikast FS Ikast FS 33 51 86 29
12 Odense BK Odense BK 33 40 57 25
TEMPORADA 1996/1997
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 64 39 68
2 Vejle BK Vejle BK 33 57 38 54
3 AGF Aarhus AGF Aarhus 33 75 51 52
4 Herfølge BK Herfølge 33 46 42 52
5 Aalborg BK Aalborg BK 33 46 40 47
6 Silkeborg IF Silkeborg 33 51 55 45
7 Odense BK Odense BK 33 59 61 41
8 Kobenhavn Kobenhavn 33 35 43 41
9 Lyngby BK Lyngby BK 33 50 61 40
10 Akademisk Boldklub Akademisk 33 56 62 36
11 Viborg FF Viborg FF 33 31 58 29
12 Hvidovre IF Hvidovre IF 33 39 59 26
TEMPORADA 1995/1996
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 71 32 67
2 AGF Aarhus AGF Aarhus 33 61 28 66
3 Odense BK Odense BK 33 57 33 60
4 Lyngby BK Lyngby BK 33 61 35 53
5 Aalborg BK Aalborg BK 33 57 38 51
6 Silkeborg IF Silkeborg 33 44 42 49
7 Kobenhavn Kobenhavn 33 48 49 48
8 Viborg FF Viborg FF 33 48 67 38
9 Vejle BK Vejle BK 33 34 50 33
10 Herfølge BK Herfølge 33 41 62 27
11 Ikast FS Ikast FS 33 28 63 25
12 Næstved Næstved 33 29 80 23
TEMPORADA 1994/1995
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 0 0 0 0
2 AGF Aarhus AGF Aarhus 0 0 0 0
3 Brøndby IF Brøndby IF 0 0 0 0
4 Kobenhavn Kobenhavn 0 0 0 0
5 Lyngby BK Lyngby BK 0 0 0 0
6 Næstved Næstved 0 0 0 0
7 Odense BK Odense BK 0 0 0 0
8 Silkeborg IF Silkeborg 0 0 0 0
TEMPORADA 1993/1994
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 0 0 0 0
2 AGF Aarhus AGF Aarhus 0 0 0 0
3 Brøndby IF Brøndby IF 0 0 0 0
4 Ikast FS Ikast FS 0 0 0 0
5 Kobenhavn Kobenhavn 0 0 0 0
6 Lyngby BK Lyngby BK 0 0 0 0
7 Odense BK Odense BK 0 0 0 0
8 Silkeborg IF Silkeborg 0 0 0 0

  USO DE MEMORIA  
7,321,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.9031
Total Execution Time  0.9045
  CADENA URL  
/historico/Brondby-If/2011
  GET DATOS  
$_GET['/historico/Brondby-If/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0199  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 = 'Brondby-If' AND l.year = 2011 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.0125  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=553 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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=553 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=553 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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0138  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 = 1079
0.0143  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 = 42044
0.0156  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 = 42898
0.0157  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 = 20879
0.0147  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 = 27568
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=553 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 553 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1370,3940,4530,14595,49449) ORDER BY n.cover_points DESC, update_date DESC
0.0142  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 = '553' AND l.year = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '553' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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 = 20879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 42044 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 1079 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=553 AND l.year in (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (42906,27568,20880,1360,1323) 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 = 1360 AND teamId = 553
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 42906 AND teamId = 553
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 20880 AND teamId = 553
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 553
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 27568 AND teamId = 553
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 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 = 1079 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '553' 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 = '553' and rp.type = 4
0.0128  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 = '553' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  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 events2011 e ON e.player_id = p.id AND e.league_id = 1079 WHERE rp.league_id = 1079 AND rp.teamId = 553 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.0139  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 events2011 e ON e.player_id = p.id AND e.league_id = 1079 WHERE rp.league_id = 1079 AND rp.teamId = 553 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2011 e ON e.player_id = p.id AND e.league_id = 1079 WHERE rp.league_id = 1079 AND rp.teamId = 553 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 553 AND l.year <= 2011 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 = 1079 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 1038 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 319 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 69 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 368 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 369 AND t.round = 33 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 `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 = 370 AND t.round = 33 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 `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 = 371 AND t.round = 33 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 `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 = 372 AND t.round = 33 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 `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 = 373 AND t.round = 33 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 `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 = 374 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 375 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1999` 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 = 376 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables1998` 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 = 377 AND t.round = 33 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 `tables1997` 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 = 378 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1996` 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 = 10285 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10289 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 10293 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10288 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 10292 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 1079 ORDER BY nameShow LIMIT 100
0.0135  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 13 AND l.year = 2011 ORDER BY l.group_code ASC