4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sydvest
TEMPORADA 2021/2022
SERIES DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 SfB-Oure SfB-Oure 27 74 33 64
2 Odense Kammeraternes SK Odense 27 59 46 48
3 Marienlyst Marienlyst 27 50 43 43
4 Aarhus Fremad II Aarhus 27 51 45 41
5 B 1913 B 1913 27 40 38 39
6 Boldklubben 1909 Boldklubben 27 42 50 34
7 Tarup-Paarup Tarup-Paarup 27 42 43 32
8 Hedensted Hedensted 27 34 37 32
9 Varde IF Elite Varde Elite 27 23 45 22
10 Sydvest Sydvest 27 34 69 15
TEMPORADA 2020/2021
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Jammerbugt Jammerbugt 26 53 24 60
2 B93 B93 26 48 29 53
3 Aarhus Fremad Aarhus 26 53 35 46
4 Middelfart Middelfart 26 47 36 43
5 Thisted Thisted 26 34 25 43
6 Brabrand Brabrand 26 39 29 41
7 VSK Aarhus VSK Aarhus 26 33 26 39
8 Frem 1886 Frem 1886 26 36 31 39
9 Dalum Dalum 26 33 40 33
10 Næsby BK Næsby BK 26 35 44 32
11 Holbæk Holbæk 26 35 47 28
12 Sydvest Sydvest 26 30 45 24
13 SfB-Oure SfB-Oure 26 34 72 15
14 Holstebro Holstebro 26 27 54 11
TEMPORADA 2019/2020
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Aarhus Fremad Aarhus 17 33 10 38
2 Brabrand Brabrand 17 32 23 29
3 Middelfart Middelfart 16 26 19 28
4 Thisted Thisted 17 30 25 28
5 Akademisk Boldklub Akademisk 17 33 25 27
6 Jammerbugt Jammerbugt 16 22 16 23
7 VSK Aarhus VSK Aarhus 17 23 25 23
8 Dalum Dalum 17 29 27 22
9 Næsby BK Næsby BK 17 20 27 18
10 Sydvest Sydvest 17 22 34 18
11 Ringkøbing Ringkøbing 17 21 37 12
12 Vejgaard B Vejgaard B 17 19 42 11
TEMPORADA 2018/2019
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Frem 1886 Frem 1886 11 26 16 55
2 Hillerød Hillerød 11 18 14 49
3 Avarta Avarta 11 25 15 45
4 Slagelse B&I Slagelse 11 15 13 44
5 Vejgaard B Vejgaard B 11 17 13 43
6 Dalum Dalum 11 21 20 37
7 Sydvest Sydvest 11 19 17 36
8 Skovshoved Skovshoved 11 16 15 36
9 Odder Odder 11 20 18 35
10 Tarup-Paarup Tarup-Paarup 11 16 14 29
11 Kjellerup Kjellerup 11 14 31 19
12 Marienlyst Marienlyst 11 7 28 16
TEMPORADA 2017/2018
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 16 42 14 54
2 Næstved Næstved 16 34 11 46
3 Jammerbugt Jammerbugt 16 25 16 38
4 Kjellerup Kjellerup 16 23 30 34
5 Kolding IF Kolding IF 16 20 19 33
6 Middelfart Middelfart 16 29 25 30
7 Marienlyst Marienlyst 16 19 36 27
8 Skovshoved Skovshoved 16 24 19 26
9 Frem 1886 Frem 1886 16 23 19 25
10 Ringkøbing Ringkøbing 16 22 34 22
11 Avarta Avarta 16 20 32 21
12 Sydvest Sydvest 16 12 38 14
TEMPORADA 2016/2017
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 16 30 12 51
2 Frem 1886 Frem 1886 16 17 20 36
3 Næsby BK Næsby BK 16 21 22 35
4 Sydvest Sydvest 16 24 17 34
5 VSK Aarhus VSK Aarhus 16 24 20 33
6 Odder Odder 16 27 22 30
7 Jammerbugt Jammerbugt 16 24 21 29
8 Hellerup IK Hellerup IK 16 22 22 29
9 Holbæk Holbæk 16 25 21 25
10 Svendborg Svendborg 16 17 26 23
11 Vejgaard Vejgaard 16 15 27 17
12 Fredensborg BI Fredensborg 16 10 26 16
TEMPORADA 2015/2016
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Sydvest Sydvest 26 71 35 62
2 Greve IF Greve IF 26 67 35 58
3 KFUM Roskilde KFUM 26 80 41 57
4 Sønderborg Sønderborg 26 57 52 41
5 Tarup-Paarup Tarup-Paarup 26 54 44 36
6 Rishøj Rishøj 26 40 47 36
7 Varde IF Elite Varde Elite 26 39 47 36
8 Kolding BK B Kolding 26 49 51 33
9 Ouere Skolrne Ouere 26 47 52 31
10 Kalundborg Kalundborg 26 44 58 31
11 Taastrup FC Taastrup FC 26 40 56 31
12 Boldklubben 1909 Boldklubben 26 25 44 26
13 Tuse IF Tuse IF 26 34 55 24
14 Marstal/Rise Marstal/Rise 26 27 57 20
TEMPORADA 2014/2015
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Næstved Næstved 30 66 30 67
2 Marienlyst Marienlyst 30 73 39 58
3 Jammerbugt Jammerbugt 30 58 42 54
4 Thisted Thisted 30 61 49 52
5 VSK Aarhus VSK Aarhus 30 50 48 51
6 Kolding IF Kolding IF 30 66 46 48
7 Næsby BK Næsby BK 30 62 49 44
8 Svendborg Svendborg 30 45 40 39
9 Odder Odder 30 49 45 39
10 Brabrand Brabrand 30 44 47 39
11 Middelfart Middelfart 30 50 56 39
12 Ringkøbing Ringkøbing 30 41 51 39
13 Sydvest Sydvest 30 45 62 35
14 Varde IF Elite Varde Elite 30 36 63 27
15 Kjellerup Kjellerup 30 47 74 20
16 Kolding BK B Kolding 30 42 94 20
TEMPORADA 2013/2014
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Skive Skive 30 78 28 77
2 HIK HIK 30 51 39 55
3 Rishøj Rishøj 30 57 40 53
4 Jammerbugt Jammerbugt 30 55 42 52
5 Thisted Thisted 30 46 41 46
6 Ringkøbing Ringkøbing 30 55 50 44
7 Brabrand Brabrand 30 51 46 42
8 VSK Aarhus VSK Aarhus 30 49 50 42
9 Middelfart Middelfart 30 44 50 38
10 Svendborg Svendborg 30 41 39 37
11 Næsby BK Næsby BK 30 49 52 36
12 Odder Odder 30 38 44 36
13 Sydvest Sydvest 30 51 70 33
14 Aarhus Fremad Aarhus 30 29 42 32
15 Skanderborg Skanderborg 30 51 65 31
16 Djursland Djursland 30 23 70 7
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Marienlyst Marienlyst 30 81 45 68
2 Aarhus Fremad Aarhus 30 63 17 61
3 Brabrand Brabrand 30 47 36 52
4 Jammerbugt Jammerbugt 30 53 42 48
5 Svendborg Svendborg 30 54 45 48
6 Næsby BK Næsby BK 30 60 49 47
7 Middelfart Middelfart 30 45 38 41
8 Thisted Thisted 30 51 49 41
9 Skanderborg Skanderborg 30 58 60 39
10 VSK Aarhus VSK Aarhus 30 45 51 37
11 BSV Søllerød Søllerød 30 49 58 36
12 Sydvest Sydvest 30 44 59 33
13 Ringkøbing Ringkøbing 30 47 61 31
14 Kjellerup Kjellerup 30 39 60 30
15 Otterup Otterup 30 47 73 29
16 Varde Varde 30 33 73 17
TEMPORADA 2011/2012
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 26 89 33 59
2 Sydvest Sydvest 26 75 28 58
3 Næstved II Næstved II 26 62 40 51
4 Ringsted Ringsted 26 60 35 48
5 Kolding IF Kolding IF 26 62 41 43
6 Næsby BK II Næsby 26 62 55 43
7 Frem Sakskøbing Frem 26 44 38 39
8 Odense Kammeraternes SK Odense 26 47 48 33
9 Døllefjelde-Musse Døllefjelde 26 60 71 33
10 Herlufsholm Herlufsholm 26 48 56 32
11 Haderslev Haderslev 26 48 63 32
12 Sønderborg Sønderborg 26 38 67 27
13 Fjordager Fjordager 26 28 77 12
14 Korup Korup 26 21 92 7
TEMPORADA 2010/2011
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Marienlyst Marienlyst 26 84 38 62
2 Aarup Aarup 26 75 47 54
3 Frem Sakskøbing Frem 26 62 47 50
4 Sydvest Sydvest 26 62 37 49
5 Næstved II Næstved II 26 74 44 46
6 Odense Kammeraternes SK Odense 26 46 39 46
7 Haderslev Haderslev 26 71 57 41
8 Ringsted Ringsted 26 59 50 34
9 Næsby BK II Næsby 26 52 58 32
10 Kolding IF Kolding IF 26 39 59 25
11 Fjordager Fjordager 26 40 55 24
12 Tarup-Paarup Tarup-Paarup 26 37 72 21
13 B 1921 B 1921 26 35 73 15
14 B 1913 B 1913 26 23 83 10

  USO DE MEMORIA  
6,064,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1893
Total Execution Time  0.1905
  CADENA URL  
/historico/Sydvest
  GET DATOS  
$_GET['/historico/Sydvest']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (70)  
0.0023  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 = 'Sydvest' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0056  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 = 'Sydvest' 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.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 63285
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9807 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0030  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 = '9807' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '9807' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '9807' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '9807' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 63285 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=9807 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (63370,63285,58309,56547) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 58309 AND teamId = 9807
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 63285 AND teamId = 9807
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 63370 AND teamId = 9807
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 9807
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63285 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '9807' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9807' and rp.type = 4
0.0020  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 = '9807' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2022 e ON e.player_id = p.id AND e.league_id = 63285 WHERE rp.league_id = 63285 AND rp.teamId = 9807 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.0024  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 events2022 e ON e.player_id = p.id AND e.league_id = 63285 WHERE rp.league_id = 63285 AND rp.teamId = 9807 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 63285 WHERE rp.league_id = 63285 AND rp.teamId = 9807 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 9807 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63285 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58309 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 56777 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50400 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44272 AND t.round = 22 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 `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49554 AND t.round = 11 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 `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38876 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43168 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33544 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38477 AND t.round = 16 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 `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 = 15860 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 `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 = 4160 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 `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 = 2479 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 `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 = 2021 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 24323 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 24327 AND t.round = 26 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 = 63285 ORDER BY nameShow LIMIT 100