4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2015/2016
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Akademisk Boldklub Akademisk 16 40 11 38
2 Nykøbing FC Nykøbing 16 37 21 31
3 Fremad Amager Fremad 16 29 19 30
4 Brønshøj Brønshøj 16 30 24 26
5 Frem 1886 Frem 1886 16 19 16 23
6 Aarhus Fremad Aarhus 16 16 24 23
7 Thisted Thisted 16 28 27 21
8 Brabrand Brabrand 16 24 21 20
9 Hvidovre IF Hvidovre IF 16 21 20 18
10 Marienlyst Marienlyst 16 22 39 17
11 Hellerup IK Hellerup IK 16 13 33 15
12 Middelfart Middelfart 16 12 36 7
TEMPORADA 2014/2015
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 30 59 22 71
2 Frem 1886 Frem 1886 30 58 28 61
3 Hvidovre IF Hvidovre IF 30 67 38 57
4 Fremad Amager Fremad 30 55 35 56
5 Nykøbing FC Nykøbing 30 69 34 55
6 HIK HIK 30 61 36 48
7 B93 B93 30 36 35 43
8 Avarta Avarta 30 57 48 42
9 Holbæk Holbæk 30 41 44 41
10 B 1908 B 1908 30 42 36 37
11 Rishøj Rishøj 30 31 40 36
12 Avedøre Avedøre 30 33 46 36
13 GVI GVI 30 28 57 26
14 BSV Søllerød Søllerød 30 30 62 21
15 Herlev Herlev 30 29 78 14
16 Svebølle Svebølle 30 20 77 10
TEMPORADA 2013/2014
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 67 38 66
2 Hobro Hobro 33 58 36 65
3 Lyngby BK Lyngby BK 33 58 41 57
4 Brønshøj Brønshøj 33 47 39 53
5 AC Horsens AC Horsens 33 60 48 52
6 HB Køge HB Køge 33 39 31 49
7 Vejle BK Vejle BK 33 49 38 47
8 Fredericia Fredericia 33 47 45 43
9 Vendsyssel Vendsyssel 33 35 59 38
10 Akademisk Boldklub Akademisk 33 42 57 36
11 Hvidovre IF Hvidovre IF 33 43 63 36
12 Marienlyst Marienlyst 33 28 78 15
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 30 84 31 69
2 FC Helsingør Helsingør 30 79 38 64
3 Rishøj Rishøj 30 50 29 60
4 Næstved Næstved 30 64 32 59
5 HIK HIK 30 58 45 51
6 B 1908 B 1908 30 46 41 51
7 Frem 1886 Frem 1886 30 45 40 48
8 Roskilde Roskilde 30 52 41 46
9 Nordvest Nordvest 30 51 49 44
10 Nykøbing FC Nykøbing 30 48 59 36
11 Avarta Avarta 30 39 47 33
12 Svebølle Svebølle 30 37 61 31
13 Skjold Birkerød Skjold 30 44 65 29
14 Fremad Amager Fremad 30 39 59 23
15 Herlev Herlev 30 27 67 21
16 NB Bornholm NB Bornholm 30 14 73 6
TEMPORADA 2011/2012
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 HIK HIK 30 69 44 71
2 Hvidovre IF Hvidovre IF 30 79 36 66
3 Herlev Herlev 30 56 42 48
4 Rishøj Rishøj 30 48 42 44
5 Fremad Amager Fremad 30 50 47 44
6 Svebølle Svebølle 30 54 55 43
7 Elite 3 Elite 3 30 49 51 43
8 BSV Søllerød Søllerød 30 40 41 42
9 Skjold Birkerød Skjold 30 43 45 42
10 Nordvest Nordvest 30 46 41 41
11 Avarta Avarta 30 38 36 38
12 Vanløse Vanløse 30 41 48 35
13 B93 B93 30 37 44 33
14 SC Egedal SC Egedal 30 47 50 32
15 BGA BGA 30 21 94 5
TEMPORADA 2010/2011
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 AGF Aarhus AGF Aarhus 30 66 25 72
2 Køge BK Køge BK 30 58 35 61
3 Vejle BK Vejle BK 30 49 32 52
4 Skive Skive 30 55 47 47
5 Brønshøj Brønshøj 30 38 38 46
6 Fredericia Fredericia 30 53 41 45
7 Vestsjælland Vestsjællan 30 58 57 42
8 Roskilde Roskilde 30 45 45 42
9 Akademisk Boldklub Akademisk 30 48 49 37
10 Næstved Næstved 30 43 44 33
11 Viborg FF Viborg FF 30 37 43 33
12 Hobro Hobro 30 41 55 33
13 Vendsyssel Vendsyssel 30 40 57 33
14 Kolding FC Kolding FC 30 38 53 30
15 Fyn Fyn 30 45 60 26
16 Hvidovre IF Hvidovre IF 30 36 69 23
TEMPORADA 2009/2010
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 AC Horsens AC Horsens 30 67 27 66
2 Lyngby BK Lyngby BK 30 59 39 62
3 Fredericia Fredericia 30 56 22 59
4 Akademisk Boldklub Akademisk 30 47 30 54
5 Vestsjælland Vestsjællan 30 54 46 50
6 Næstved Næstved 30 44 34 44
7 Viborg FF Viborg FF 30 30 26 44
8 Fyn Fyn 30 42 51 42
9 Skive Skive 30 44 50 41
10 Vejle BK Vejle BK 30 33 34 33
11 Roskilde Roskilde 30 37 51 33
12 Hvidovre IF Hvidovre IF 30 37 43 32
13 Kolding FC Kolding FC 30 41 59 31
14 Thisted Thisted 30 33 57 30
15 Frem 1886 Frem 1886 30 38 59 28
16 Brabrand Brabrand 30 18 52 13
TEMPORADA 2008/2009
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Herfølge BK Herfølge 30 77 27 71
2 Silkeborg IF Silkeborg 30 68 27 69
3 Akademisk Boldklub Akademisk 30 56 30 61
4 Viborg FF Viborg FF 30 59 40 54
5 Næstved Næstved 30 55 34 52
6 Lyngby BK Lyngby BK 30 50 26 50
7 Fredericia Fredericia 30 58 43 47
8 Hvidovre IF Hvidovre IF 30 51 46 40
9 Thisted Thisted 30 54 49 39
10 Roskilde Roskilde 30 45 53 39
11 Frem 1886 Frem 1886 30 41 53 36
12 Kolding IF Kolding IF 30 45 59 36
13 Skive Skive 30 49 57 34
14 Nykøbing FC Nykøbing 30 25 66 12
15 FC Amager FC Amager 29 24 72 11
16 Køge BK Køge BK 29 11 86 7
TEMPORADA 2007/2008
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 30 80 24 78
2 SonderjyskE SonderjyskE 30 55 32 61
3 Silkeborg IF Silkeborg 30 60 33 57
4 Herfølge BK Herfølge 30 55 43 51
5 Fredericia Fredericia 30 49 36 44
6 Akademisk Boldklub Akademisk 30 38 36 41
7 Kolding IF Kolding IF 30 53 47 40
8 Næstved Næstved 30 36 39 40
9 Frem 1886 Frem 1886 30 46 54 39
10 Hvidovre IF Hvidovre IF 30 31 33 37
11 Skive Skive 30 36 52 34
12 Nykøbing FC Nykøbing 30 28 41 33
13 Køge BK Køge BK 30 36 51 33
14 Hellerup IK Hellerup IK 30 36 56 31
15 Aarhus Fremad Aarhus 30 22 43 28
16 Ølstykke FC Ølstykke 30 20 61 18
TEMPORADA 2006/2007
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Nykøbing FC Nykøbing 26 61 31 55
2 Brøndby IF II Brøndby 26 52 33 52
3 Hvidovre IF Hvidovre IF 26 46 22 51
4 Roskilde Roskilde 26 42 36 46
5 Copenhague II Copenhague 26 59 41 44
6 B93 B93 26 63 37 42
7 Slagelse Slagelse 26 50 45 38
8 Nordvest Nordvest 26 45 40 38
9 Greve IF Greve IF 26 40 50 28
10 Skovlunde IF Skovlunde 26 32 46 26
11 Brønshøj Brønshøj 26 44 56 25
12 BGA BGA 26 25 50 23
13 Stenløse BK Stenløse 26 27 59 22
14 AB 70 AB 70 26 31 71 18
TEMPORADA 2005/2006
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Næstved Næstved 26 64 22 57
2 Nordvest Nordvest 26 62 35 55
3 Hvidovre IF Hvidovre IF 26 60 31 51
4 Brøndby IF II Brøndby 26 44 20 48
5 Copenhague II Copenhague 26 55 39 45
6 BSV Søllerød Søllerød 26 45 46 40
7 BGA BGA 26 49 41 37
8 B93 B93 26 39 49 30
9 AB 70 AB 70 26 30 47 30
10 Slagelse Slagelse 26 49 46 29
11 Roskilde Roskilde 25 36 48 27
12 Stenløse BK Stenløse 26 33 65 27
13 Værløse Værløse 26 26 56 21
14 Avarta Avarta 25 24 71 13
TEMPORADA 2003/2004
SEGUNDA DINAMARCA
Equipo PJ GF GC Puntos
1 Hellerup IK Hellerup IK 30 68 43 61
2 Dalum Dalum 30 68 44 54
3 Næstved Næstved 30 60 34 53
4 Kolding IF Kolding IF 29 54 40 52
5 Nordvest Nordvest 30 62 42 51
6 Boldklubben 1909 Boldklubben 30 55 48 44
7 Slagelse Slagelse 30 54 47 40
8 Brabrand Brabrand 30 51 47 39
9 Vendsyssel Vendsyssel 30 46 74 39
10 BGA BGA 30 53 57 38
11 Lyngby BK Lyngby BK 30 51 62 37
12 Jammerbugt Jammerbugt 30 39 59 36
13 Kalundborg Kalundborg 29 56 64 31
14 Holstebro Holstebro 30 48 62 31
15 Skive Skive 30 49 61 28
16 Hvidovre IF Hvidovre IF 30 32 62 25
TEMPORADA 2002/2003
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Herfølge BK Herfølge 30 74 38 69
2 Frem 1886 Frem 1886 30 64 43 58
3 Fredericia Fredericia 30 50 29 51
4 Randers Randers 30 65 49 51
5 Vejle BK Vejle BK 30 65 58 49
6 SonderjyskE SonderjyskE 30 64 54 47
7 Skjold Skjold 29 50 36 46
8 Aarhus Fremad Aarhus 30 53 56 40
9 Brønshøj Brønshøj 30 48 53 39
10 Ølstykke FC Ølstykke 29 63 61 38
11 AC Horsens AC Horsens 30 45 49 36
12 B93 B93 30 44 52 36
13 B 1913 B 1913 30 37 60 30
14 Hvidovre IF Hvidovre IF 30 34 57 29
15 Boldklubben 1909 Boldklubben 30 52 75 28
16 Hellerup IK Hellerup IK 30 37 75 21
TEMPORADA 2001/2002
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Køge BK Køge BK 30 62 33 67
2 Farum Farum 30 69 33 66
3 SonderjyskE SonderjyskE 30 61 50 55
4 Frem 1886 Frem 1886 30 54 37 54
5 Herfølge BK Herfølge 30 58 36 53
6 Randers Randers 30 62 38 51
7 AC Horsens AC Horsens 30 39 31 44
8 B 1913 B 1913 30 42 49 43
9 Aarhus Fremad Aarhus 30 42 42 42
10 Hvidovre IF Hvidovre IF 30 43 52 32
11 Fredericia Fredericia 30 45 46 30
12 Boldklubben 1909 Boldklubben 30 46 67 29
13 Brønshøj Brønshøj 30 42 63 28
14 B93 B93 30 37 59 28
15 Kolding FC Kolding FC 30 45 65 27
16 Skive Skive 30 36 82 15
TEMPORADA 2000/2001
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Esbjerg Esbjerg 30 79 29 65
2 Vejle BK Vejle BK 30 73 37 59
3 Køge BK Køge BK 30 62 40 56
4 Frem 1886 Frem 1886 30 64 34 55
5 Farum Farum 30 62 49 50
6 B93 B93 30 52 46 44
7 AC Horsens AC Horsens 30 41 37 43
8 B 1913 B 1913 30 42 46 42
9 Brønshøj Brønshøj 30 54 57 41
10 Hvidovre IF Hvidovre IF 30 54 55 38
11 Randers Randers 30 47 59 33
12 Aarhus Fremad Aarhus 30 42 65 33
13 Skive Skive 30 52 73 32
14 Fremad Amager Fremad 30 43 64 31
15 Ølstykke FC Ølstykke 30 38 76 30
16 Skjold Birkerød Skjold 30 42 80 13
TEMPORADA 1999/2000
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 30 78 17 76
2 SonderjyskE SonderjyskE 30 67 42 62
3 B93 B93 30 69 39 61
4 Køge BK Køge BK 30 64 40 53
5 AC Horsens AC Horsens 30 57 31 50
6 Randers Randers 30 57 49 49
7 Frem 1886 Frem 1886 30 56 49 45
8 Farum Farum 30 48 58 42
9 Hvidovre IF Hvidovre IF 30 55 52 40
10 Ølstykke FC Ølstykke 30 42 60 36
11 Fremad Amager Fremad 30 43 48 35
12 Aarhus Fremad Aarhus 30 38 43 35
13 Dalum Dalum 30 35 57 32
14 Svendborg Svendborg 30 28 57 20
15 Fredericia Fredericia 30 24 61 17
16 Boldklubben 1909 Boldklubben 30 32 90 14
TEMPORADA 1998/1999
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Odense BK Odense BK 30 80 24 74
2 Esbjerg Esbjerg 30 69 33 64
3 Ikast FS Ikast FS 30 73 43 62
4 Herning Fremad Herning 30 61 40 49
5 SonderjyskE SonderjyskE 30 76 58 47
6 AC Horsens AC Horsens 30 47 44 44
7 Fremad Amager Fremad 30 48 48 42
8 Køge BK Køge BK 30 49 56 42
9 Frem 1886 Frem 1886 30 45 63 41
10 Svendborg Svendborg 30 39 43 38
11 Hvidovre IF Hvidovre IF 30 36 53 37
12 Boldklubben 1909 Boldklubben 30 52 58 34
13 BGA BGA 30 48 59 33
14 Holstebro Holstebro 30 41 66 25
15 Næstved Næstved 30 44 82 25
16 Brønshøj Brønshøj 30 41 79 18
TEMPORADA 1997/1998
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Viborg FF Viborg FF 30 72 29 67
2 B93 B93 30 73 41 67
3 Herning Fremad Herning 30 72 31 65
4 Køge BK Køge BK 30 41 29 47
5 AC Horsens AC Horsens 30 49 44 44
6 Esbjerg Esbjerg 30 46 49 44
7 Svendborg Svendborg 30 49 46 40
8 Hvidovre IF Hvidovre IF 30 52 52 40
9 Frem 1886 Frem 1886 30 46 47 40
10 Fremad Amager Fremad 30 42 50 37
11 Næstved Næstved 30 35 57 37
12 BGA BGA 30 40 49 36
13 Roskilde Roskilde 30 35 48 35
14 Aalborg Chang Aalborg 30 42 60 35
15 B 1913 B 1913 30 33 71 22
16 Ølstykke FC Ølstykke 30 37 61 21
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

  USO DE MEMORIA  
7,285,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7668
Total Execution Time  0.7681
  CADENA URL  
/historico/Hvidovre/2016
  GET DATOS  
$_GET['/historico/Hvidovre/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0138  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 = 'Hvidovre' AND l.year = 2016 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=7442 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=7442 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=7442 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=7442 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 16250
0.0134  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 = 20328
0.0133  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 = 16622
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7442 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=234 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 234 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1082955,1034242,808298,717751) 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 = '7442' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0145  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 = '7442' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 16622 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 = 20328 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=7442 AND l.year in (2015,2016,2017) 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 (38476,33399,30386) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 38476 AND teamId = 7442
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 33399 AND teamId = 7442
0.0181  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 7442
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 FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16250 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '7442' 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 = '7442' and rp.type = 4
0.0126  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 = '7442' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 events2016 e ON e.player_id = p.id AND e.league_id = 16250 WHERE rp.league_id = 16250 AND rp.teamId = 7442 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.0133  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 events2016 e ON e.player_id = p.id AND e.league_id = 16250 WHERE rp.league_id = 16250 AND rp.teamId = 7442 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2016 e ON e.player_id = p.id AND e.league_id = 16250 WHERE rp.league_id = 16250 AND rp.teamId = 7442 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 7442 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16250 AND t.round = 14 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 `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 20328 AND t.round = 16 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 `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 = 4158 AND t.round = 30 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 `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 = 2474 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 `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 = 2022 AND t.round = 30 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 `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 = 1734 AND t.round = 30 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 `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 = 1156 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 10297 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 = 10296 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 10295 AND t.round = 30 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 `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 = 24403 AND t.round = 26 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 `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 = 24399 AND t.round = 26 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 `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 = 24388 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 `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 = 14171 AND t.round = 30 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 `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 = 14172 AND t.round = 30 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 `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 = 14173 AND t.round = 30 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 `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 = 14174 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 `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 = 14175 AND t.round = 30 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 `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 = 14176 AND t.round = 30 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 `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.0126  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 = 16250 ORDER BY nameShow LIMIT 100