4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 FK Bodo Glimt Bodo Glimt 5 12 2 13
2 Molde FK Molde FK 5 10 2 13
3 Stromsgodset IF Stromsgodset 5 7 7 10
4 Rosenborg BK Rosenborg 5 7 5 9
5 SK Brann SK Brann 5 7 5 8
6 Fredrikstad Fredrikstad 5 6 5 8
7 Kristiansund BK Kristiansund 5 7 7 8
8 Lillestrom SK Lillestrom 5 6 9 7
9 KFUM Oslo KFUM Oslo 5 5 5 6
10 Viking Stavanger Viking 5 3 3 6
11 Haugesund Haugesund 5 5 8 6
12 Odd Odd 5 4 6 5
13 Sarpsborg 08 Sarpsborg 5 5 6 4
14 HamKam HamKam 5 2 5 2
15 Sandefjord Sandefjord 4 2 6 1
16 Tromsø IL Tromsø IL 4 2 9 0
TEMPORADA 2022/2023
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 FK Bodo Glimt Bodo Glimt 30 78 38 70
2 SK Brann SK Brann 30 55 35 61
3 Tromsø IL Tromsø IL 30 48 33 61
4 Viking Stavanger Viking 30 61 48 58
5 Molde FK Molde FK 30 65 39 51
6 Lillestrom SK Lillestrom 30 49 49 43
7 Stromsgodset IF Stromsgodset 30 37 35 42
8 Sarpsborg 08 Sarpsborg 30 55 52 41
9 Rosenborg BK Rosenborg 30 46 50 39
10 Odd Odd 30 42 44 38
11 HamKam HamKam 30 39 59 34
12 Haugesund Haugesund 30 34 40 33
13 Sandefjord Sandefjord 30 47 55 31
14 Valerenga IF Valerenga 30 39 50 29
15 Stabæk Stabæk 30 30 48 29
16 Aalesunds FK Aalesunds 30 23 73 18
TEMPORADA 2021/2022
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Molde FK Molde FK 30 71 25 78
2 FK Bodo Glimt Bodo Glimt 30 86 41 60
3 Rosenborg BK Rosenborg 30 69 44 56
4 Lillestrom SK Lillestrom 30 49 34 53
5 Odd Odd 30 43 45 45
6 Valerenga IF Valerenga 30 52 49 44
7 Tromsø IL Tromsø IL 30 46 49 43
8 Sarpsborg 08 Sarpsborg 30 57 54 41
9 Aalesunds FK Aalesunds 30 32 45 39
10 Haugesund Haugesund 30 42 46 38
11 Viking Stavanger Viking 30 48 54 35
12 Stromsgodset IF Stromsgodset 30 44 55 33
13 HamKam HamKam 30 33 43 31
14 Sandefjord Sandefjord 30 42 68 24
15 Kristiansund BK Kristiansund 30 37 60 23
16 Jerv Jerv 30 30 69 20
TEMPORADA 2020/2021
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 HamKam HamKam 30 62 21 69
2 Aalesunds FK Aalesunds 30 68 43 58
3 Jerv Jerv 30 49 46 54
4 Fredrikstad Fredrikstad 30 60 42 52
5 KFUM Oslo KFUM Oslo 30 46 45 44
6 Sogndal Sogndal 30 40 35 42
7 Åsane Åsane 30 44 53 40
8 Sandnes Ulf Sandnes Ulf 30 43 49 39
9 IK Start IK Start 30 59 59 38
10 Bryne Bryne 30 44 48 37
11 Raufoss IL Raufoss IL 30 51 54 35
12 Ranheim Ranheim 30 56 62 34
13 Grorud IL Grorud IL 30 45 59 34
14 IL Stjørdals-Blink Stjørdals-B 30 32 50 31
15 Ull Kisa Ull Kisa 30 34 50 29
16 Strømmen IF Strømmen 30 32 49 24
TEMPORADA 2019/2020
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Tromsø IL Tromsø IL 30 60 29 63
2 Lillestrom SK Lillestrom 30 49 26 57
3 Sogndal Sogndal 30 57 36 51
4 Ranheim Ranheim 30 61 41 47
5 Åsane Åsane 30 60 48 45
6 Raufoss IL Raufoss IL 30 53 44 42
7 Sandnes Ulf Sandnes Ulf 30 46 55 41
8 KFUM Oslo KFUM Oslo 30 44 44 39
9 HamKam HamKam 30 49 52 39
10 Strømmen IF Strømmen 30 47 51 35
11 Jerv Jerv 30 41 57 35
12 Ull Kisa Ull Kisa 30 45 63 35
13 Grorud IL Grorud IL 30 45 56 34
14 IL Stjørdals-Blink Stjørdals-B 30 52 59 33
15 Kongsvinger Kongsvinger 30 35 53 28
16 Øygarden FK Øygarden 30 37 67 27
TEMPORADA 2018/2019
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Aalesunds FK Aalesunds 30 67 25 79
2 Sandefjord Sandefjord 30 53 30 65
3 IK Start IK Start 29 53 31 59
4 KFUM Oslo KFUM Oslo 30 58 42 48
5 Kongsvinger Kongsvinger 30 38 36 46
6 Sogndal Sogndal 29 51 38 45
7 Nest-Sotra Nest-Sotra 30 43 31 44
8 Ull Kisa Ull Kisa 30 47 47 39
9 Sandnes Ulf Sandnes Ulf 29 46 46 38
10 HamKam HamKam 30 43 47 38
11 Raufoss IL Raufoss IL 30 47 59 38
12 Jerv Jerv 30 34 54 33
13 Strømmen IF Strømmen 29 29 46 27
14 Notodden Notodden 30 35 53 25
15 Skeid Skeid 30 38 54 22
16 Tromsdalen Tromsdalen 30 36 79 13
TEMPORADA 2017/2018
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Viking Stavanger Viking 30 68 44 61
2 Mjøndalen IF Mjøndalen 30 49 24 60
3 Aalesunds FK Aalesunds 30 58 31 59
4 Sogndal Sogndal 30 47 31 51
5 Ull Kisa Ull Kisa 30 59 49 43
6 Nest-Sotra Nest-Sotra 30 43 41 43
7 Tromsdalen Tromsdalen 30 43 47 43
8 Kongsvinger Kongsvinger 30 59 49 42
9 HamKam HamKam 30 46 44 42
10 Sandnes Ulf Sandnes Ulf 30 43 47 42
11 Strømmen IF Strømmen 30 49 53 38
12 Notodden Notodden 30 36 40 36
13 Jerv Jerv 30 31 41 35
14 Åsane Åsane 30 38 57 33
15 Florø Florø 30 27 59 27
16 Levanger Levanger 30 32 71 15
TEMPORADA 2016/2017
TERCERA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 HamKam HamKam 26 56 18 65
2 Raufoss IL Raufoss IL 26 53 28 47
3 Asker Asker 26 50 36 47
4 Alta IF Alta IF 26 42 24 46
5 Skeid Skeid 26 42 27 44
6 Grorud IL Grorud IL 26 43 49 37
7 KFUM Oslo KFUM Oslo 26 43 39 34
8 Kjelsås Kjelsås 26 34 40 34
9 Bærum Bærum 26 46 44 33
10 Nybergsund IL-Trysil Nybergsund 26 40 46 31
11 Vålerenga II Vålerenga 26 28 52 27
12 Finnsnes Finnsnes 26 26 45 22
13 Brumunddal Brumunddal 26 21 46 22
14 Follo Follo 26 28 58 22
TEMPORADA 2015/2016
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Elverum Elverum 26 68 13 64
2 HamKam HamKam 26 63 27 56
3 Hønefoss Hønefoss 26 49 35 42
4 Brumunddal Brumunddal 26 32 34 41
5 Nybergsund IL-Trysil Nybergsund 26 52 45 40
6 Byåsen Byåsen 26 44 49 40
7 Nardo Nardo 26 28 36 39
8 Brattvåg Brattvåg 26 41 37 38
9 IL Stjørdals-Blink Stjørdals-B 26 53 41 37
10 Strindheim Strindheim 26 50 60 30
11 Gjøvik-Lyn Gjøvik-Lyn 26 27 44 28
12 Molde FK II Molde FK II 26 43 49 27
13 Rosenborg II Rosenborg 26 31 66 20
14 Tynset Tynset 26 20 65 9
TEMPORADA 2014/2015
TERCERA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Kongsvinger Kongsvinger 26 63 19 62
2 Elverum Elverum 26 47 35 42
3 Nardo Nardo 26 39 37 41
4 HamKam HamKam 26 51 44 40
5 Byåsen Byåsen 26 35 42 40
6 Florø Florø 26 44 32 39
7 IL Stjørdals-Blink Stjørdals-B 26 42 44 38
8 Brumunddal Brumunddal 26 33 36 37
9 Strindheim Strindheim 26 38 36 33
10 Förde Förde 26 47 48 33
11 Molde FK II Molde FK II 26 38 40 31
12 Aalesunds FK II Aalesunds 26 36 41 28
13 Rødde FK Rødde FK 26 32 55 21
14 Træff Træff 26 27 63 20
TEMPORADA 2013/2014
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Sandefjord Sandefjord 30 62 25 67
2 Tromsø IL Tromsø IL 30 67 27 59
3 Mjøndalen IF Mjøndalen 30 57 37 51
4 Bærum Bærum 30 52 52 50
5 Kristiansund BK Kristiansund 30 53 39 49
6 Fredrikstad Fredrikstad 30 35 26 48
7 Ranheim Ranheim 30 45 34 46
8 Hødd Hødd 30 48 49 43
9 Bryne Bryne 30 49 55 42
10 Strømmen IF Strømmen 30 59 54 41
11 Hønefoss Hønefoss 30 39 55 40
12 Nest-Sotra Nest-Sotra 30 49 51 37
13 Alta IF Alta IF 30 33 51 34
14 Tromsdalen Tromsdalen 30 44 56 31
15 Ull Kisa Ull Kisa 30 26 51 23
16 HamKam HamKam 30 22 78 7
TEMPORADA 2012/2013
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 FK Bodo Glimt Bodo Glimt 30 63 24 67
2 Stabæk Stabæk 30 51 46 52
3 Hødd Hødd 30 41 31 50
4 Ranheim Ranheim 30 49 38 49
5 HamKam HamKam 30 49 43 48
6 Mjøndalen IF Mjøndalen 30 37 40 47
7 Bryne Bryne 30 55 50 46
8 Sandefjord Sandefjord 30 39 39 43
9 Kristiansund BK Kristiansund 30 47 44 42
10 Fredrikstad Fredrikstad 30 44 41 41
11 Strømmen IF Strømmen 30 39 43 38
12 Ull Kisa Ull Kisa 30 46 48 34
13 Vard Vard 30 46 55 34
14 Kongsvinger Kongsvinger 30 37 54 31
15 Follo Follo 30 40 57 29
16 Elverum Elverum 30 37 67 15
TEMPORADA 2011/2012
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 IK Start IK Start 30 71 35 66
2 Sarpsborg 08 Sarpsborg 30 73 43 63
3 Sandefjord Sandefjord 30 44 29 55
4 Mjøndalen IF Mjøndalen 30 52 43 55
5 FK Bodo Glimt Bodo Glimt 30 59 36 48
6 Ull Kisa Ull Kisa 30 45 39 44
7 Ranheim Ranheim 30 55 40 43
8 HamKam HamKam 30 51 49 43
9 Kongsvinger Kongsvinger 30 44 48 39
10 Bryne Bryne 30 41 53 38
11 Strømmen IF Strømmen 30 39 51 37
12 Hødd Hødd 30 43 52 35
13 Tromsdalen Tromsdalen 30 51 62 35
14 Bærum Bærum 30 49 73 22
15 Notodden Notodden 30 38 71 22
16 Alta IF Alta IF 30 30 61 21
TEMPORADA 2010/2011
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Hønefoss Hønefoss 30 61 28 57
2 Sandnes Ulf Sandnes Ulf 30 58 32 56
3 Sandefjord Sandefjord 30 61 38 53
4 Ranheim Ranheim 30 61 39 52
5 FK Bodo Glimt Bodo Glimt 30 52 38 52
6 HamKam HamKam 30 52 40 51
7 Kongsvinger Kongsvinger 30 50 36 49
8 Hødd Hødd 30 54 42 46
9 Bryne Bryne 30 47 36 44
10 Mjøndalen IF Mjøndalen 30 42 51 40
11 Alta IF Alta IF 30 45 51 39
12 Strømmen IF Strømmen 30 43 58 34
13 Asker Asker 30 38 56 34
14 Nybergsund IL-Trysil Nybergsund 30 42 72 23
15 Randaberg IL Randaberg 30 37 87 17
16 Løv-Ham Fotball Løv-Ham 30 32 71 16
TEMPORADA 2009/2010
TERCERA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 HamKam HamKam 26 75 25 59
2 KFUM Oslo KFUM Oslo 26 69 30 57
3 Brumunddal Brumunddal 26 62 50 46
4 Raufoss IL Raufoss IL 26 41 38 42
5 Harstad Harstad 26 58 51 41
6 Tromso II Tromso II 26 51 50 37
7 Lorenskog IF Lorenskog 26 56 55 36
8 Senja Senja 26 48 52 35
9 Valdres FK Valdres FK 26 40 45 35
10 Ull Kisa Ull Kisa 26 43 56 32
11 Strømsgodset II Strømsgodse 26 63 70 31
12 Lillehammer Lillehammer 26 45 53 31
13 Eidsvold TF Eidsvold TF 26 41 58 26
14 Mo IL Mo IL 26 26 85 13
TEMPORADA 2008/2009
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Haugesund Haugesund 30 67 37 58
2 Hønefoss Hønefoss 30 61 32 56
3 Kongsvinger Kongsvinger 30 52 37 56
4 Sogndal Sogndal 30 46 29 54
5 Sarpsborg 08 Sarpsborg 30 47 38 47
6 Alta IF Alta IF 30 50 49 42
7 Moss Moss 30 47 53 41
8 Bryne Bryne 30 41 39 40
9 Nybergsund IL-Trysil Nybergsund 30 49 54 40
10 Løv-Ham Fotball Løv-Ham 30 44 50 40
11 Mjøndalen IF Mjøndalen 30 38 39 39
12 Tromsdalen Tromsdalen 30 38 54 39
13 HamKam HamKam 30 56 48 37
14 Notodden Notodden 30 38 55 29
15 Stavanger IF Stavanger 30 35 55 29
16 Skeid Skeid 30 26 66 18
TEMPORADA 2007/2008
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Stabæk Stabæk 26 58 24 54
2 Fredrikstad Fredrikstad 26 38 28 48
3 Tromsø IL Tromsø IL 26 36 23 44
4 FK Bodo Glimt Bodo Glimt 26 37 38 42
5 Rosenborg BK Rosenborg 26 40 34 39
6 Viking Stavanger Viking 26 38 32 39
7 Lyn 1896 FK Lyn 1896 FK 26 38 34 38
8 SK Brann SK Brann 26 36 36 33
9 Molde FK Molde FK 26 39 43 31
10 Valerenga IF Valerenga 26 31 37 30
11 Stromsgodset IF Stromsgodset 26 33 44 29
12 Lillestrom SK Lillestrom 26 30 40 28
13 Aalesunds FK Aalesunds 26 29 42 25
14 HamKam HamKam 26 22 50 21
TEMPORADA 2006/2007
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Molde FK Molde FK 30 62 28 69
2 HamKam HamKam 30 82 36 68
3 FK Bodo Glimt Bodo Glimt 30 66 39 55
4 Kongsvinger Kongsvinger 30 56 42 53
5 Moss Moss 30 46 37 53
6 Bryne Bryne 30 57 38 49
7 Sogndal Sogndal 30 48 44 44
8 Haugesund Haugesund 30 49 52 39
9 Notodden Notodden 30 49 54 36
10 Hønefoss Hønefoss 30 34 52 35
11 Raufoss IL Raufoss IL 30 37 61 35
12 Løv-Ham Fotball Løv-Ham 30 39 44 33
13 Sparta Sarpsborg Sparta 30 50 52 32
14 Tromsdalen Tromsdalen 30 37 56 29
15 Skeid Skeid 30 32 60 20
16 Mandalskameratene Mandalskamer 30 43 92 19
TEMPORADA 2005/2006
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Rosenborg BK Rosenborg 26 47 24 53
2 SK Brann SK Brann 26 39 36 46
3 Valerenga IF Valerenga 26 43 28 44
4 Lillestrom SK Lillestrom 26 44 33 44
5 Stabæk Stabæk 26 53 36 39
6 IK Start IK Start 26 29 32 37
7 Lyn 1896 FK Lyn 1896 FK 26 33 36 35
8 Fredrikstad Fredrikstad 26 38 46 32
9 Sandefjord Sandefjord 26 37 47 32
10 Tromsø IL Tromsø IL 26 33 39 29
11 Viking Stavanger Viking 26 31 37 29
12 Odd Odd 26 30 38 29
13 HamKam HamKam 26 35 39 28
14 Molde FK Molde FK 26 29 50 25
TEMPORADA 2004/2005
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Valerenga IF Valerenga 26 40 27 46
2 IK Start IK Start 26 47 35 45
3 Lyn 1896 FK Lyn 1896 FK 26 37 21 44
4 Lillestrom SK Lillestrom 26 37 31 42
5 Viking Stavanger Viking 26 37 32 41
6 SK Brann SK Brann 26 43 32 37
7 Rosenborg BK Rosenborg 26 50 42 34
8 Tromsø IL Tromsø IL 26 31 30 34
9 Odd Odd 26 28 51 33
10 HamKam HamKam 26 31 37 31
11 Fredrikstad Fredrikstad 26 35 44 31
12 Molde FK Molde FK 26 40 46 30
13 Aalesunds FK Aalesunds 26 30 42 27
14 FK Bodo Glimt Bodo Glimt 26 29 45 24

  USO DE MEMORIA  
7,564,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.7286
Total Execution Time  0.7308
  CADENA URL  
/historico/Hamkam
  GET DATOS  
$_GET['/historico/Hamkam']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0167  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 = 'Hamkam' 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.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17716 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17716 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=17716 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=17716 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17716 AND type_rel = 2
0.0151  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 = '17716' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 74846 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=17716 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75723,74846,71432) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 74846 AND teamId = 17716
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 75723 AND teamId = 17716
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17716
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 74846 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '17716' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17716' and rp.type = 4
0.0145  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 = '17716' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 events2024 e ON e.player_id = p.id AND e.league_id = 74846 WHERE rp.league_id = 74846 AND rp.teamId = 17716 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.0191  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 events2024 e ON e.player_id = p.id AND e.league_id = 74846 WHERE rp.league_id = 74846 AND rp.teamId = 17716 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 events2024 e ON e.player_id = p.id AND e.league_id = 74846 WHERE rp.league_id = 74846 AND rp.teamId = 17716 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0189  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 = 17716 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 70738 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 66468 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 61106 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 53586 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 48599 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 42251 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 37699 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 20368 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9135 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 3648 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2788 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10799 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10798 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,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 = 25041 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 71 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,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 = 10794 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 656 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC