4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kristiansund BK

Kristiansund BK

Entrenador: Amund Skiri

Temporada 2023/2024
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 Viking Stavanger Viking 5 6 6 6
10 KFUM Oslo KFUM Oslo 5 5 5 6
11 Haugesund Haugesund 5 5 8 6
12 Odd Odd 5 7 9 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
SEGUNDA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 30 50 23 64
2 KFUM Oslo KFUM Oslo 30 51 31 58
3 Kongsvinger Kongsvinger 30 53 39 52
4 Kristiansund BK Kristiansund 30 56 38 50
5 IK Start IK Start 30 49 36 46
6 Bryne Bryne 30 40 36 44
7 Sogndal Sogndal 30 45 45 43
8 Ranheim Ranheim 30 36 53 40
9 Raufoss IL Raufoss IL 30 35 36 38
10 Moss Moss 30 37 40 38
11 Sandnes Ulf Sandnes Ulf 30 42 45 37
12 Åsane Åsane 30 41 44 37
13 Mjøndalen IF Mjøndalen 30 39 42 37
14 Hødd Hødd 30 29 38 33
15 Jerv Jerv 30 40 59 31
16 Skeid Skeid 30 24 62 14
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
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 FK Bodo Glimt Bodo Glimt 30 59 25 63
2 Molde FK Molde FK 30 70 40 60
3 Viking Stavanger Viking 30 60 47 57
4 Lillestrom SK Lillestrom 30 49 40 49
5 Rosenborg BK Rosenborg 30 58 42 48
6 Kristiansund BK Kristiansund 30 41 46 46
7 Valerenga IF Valerenga 30 46 37 45
8 Sarpsborg 08 Sarpsborg 30 39 44 39
9 Stromsgodset IF Stromsgodset 30 43 43 36
10 Sandefjord Sandefjord 30 38 52 36
11 Haugesund Haugesund 30 46 45 35
12 Tromsø IL Tromsø IL 30 33 44 35
13 Odd Odd 30 44 58 33
14 SK Brann SK Brann 30 38 55 26
15 Stabæk Stabæk 30 35 62 25
16 Mjøndalen IF Mjøndalen 30 33 52 22
TEMPORADA 2019/2020
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 FK Bodo Glimt Bodo Glimt 30 103 32 81
2 Molde FK Molde FK 30 77 36 62
3 Valerenga IF Valerenga 30 51 33 55
4 Rosenborg BK Rosenborg 30 50 35 52
5 Kristiansund BK Kristiansund 30 57 45 48
6 Viking Stavanger Viking 30 54 52 44
7 Odd Odd 30 52 51 43
8 Stabæk Stabæk 30 41 45 39
9 Haugesund Haugesund 30 39 51 39
10 SK Brann SK Brann 30 40 49 36
11 Sandefjord Sandefjord 30 31 43 35
12 Sarpsborg 08 Sarpsborg 30 33 43 32
13 Stromsgodset IF Stromsgodset 30 41 57 31
14 Mjøndalen IF Mjøndalen 30 26 45 27
15 IK Start IK Start 30 33 56 27
16 Aalesunds FK Aalesunds 30 30 85 11
TEMPORADA 2018/2019
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Molde FK Molde FK 30 72 31 68
2 FK Bodo Glimt Bodo Glimt 30 64 44 54
3 Rosenborg BK Rosenborg 30 53 41 52
4 Odd Odd 30 45 40 52
5 Viking Stavanger Viking 30 55 42 47
6 Kristiansund BK Kristiansund 30 41 41 41
7 Haugesund Haugesund 30 44 37 40
8 Stabæk Stabæk 30 38 36 40
9 SK Brann SK Brann 30 32 37 40
10 Valerenga IF Valerenga 30 39 44 34
11 Stromsgodset IF Stromsgodset 30 41 54 32
12 Sarpsborg 08 Sarpsborg 30 30 40 30
13 Mjøndalen IF Mjøndalen 30 38 52 30
14 Lillestrom SK Lillestrom 30 32 47 30
15 Tromsø IL Tromsø IL 30 39 58 30
16 Ranheim Ranheim 30 36 55 27
TEMPORADA 2017/2018
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Rosenborg BK Rosenborg 30 51 24 64
2 Molde FK Molde FK 30 63 36 59
3 SK Brann SK Brann 30 45 31 58
4 Haugesund Haugesund 30 45 33 53
5 Kristiansund BK Kristiansund 30 46 41 46
6 Valerenga IF Valerenga 30 39 44 42
7 Ranheim Ranheim 30 43 50 42
8 Sarpsborg 08 Sarpsborg 30 46 39 41
9 Odd Odd 30 39 38 40
10 Tromsø IL Tromsø IL 30 41 48 36
11 FK Bodo Glimt Bodo Glimt 30 32 35 32
12 Lillestrom SK Lillestrom 30 34 44 32
13 Stromsgodset IF Stromsgodset 30 46 48 31
14 Stabæk Stabæk 30 37 50 29
15 IK Start IK Start 30 30 54 29
16 Sandefjord Sandefjord 30 35 57 23
TEMPORADA 2016/2017
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Rosenborg BK Rosenborg 30 57 20 61
2 Molde FK Molde FK 30 50 35 54
3 Sarpsborg 08 Sarpsborg 30 50 36 51
4 Stromsgodset IF Stromsgodset 30 45 37 50
5 SK Brann SK Brann 30 51 36 47
6 Odd Odd 30 27 39 42
7 Kristiansund BK Kristiansund 30 44 46 40
8 Valerenga IF Valerenga 30 48 46 39
9 Stabæk Stabæk 30 46 50 39
10 Haugesund Haugesund 30 35 39 39
11 Tromsø IL Tromsø IL 30 42 49 38
12 Lillestrom SK Lillestrom 30 40 43 37
13 Sandefjord Sandefjord 30 38 51 36
14 Sogndal Sogndal 30 38 48 32
15 Aalesunds FK Aalesunds 30 38 50 32
16 Viking Stavanger Viking 30 33 57 24
TEMPORADA 2015/2016
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Kristiansund BK Kristiansund 30 47 30 62
2 Sandefjord Sandefjord 30 54 35 59
3 Jerv Jerv 30 47 34 53
4 Sandnes Ulf Sandnes Ulf 30 55 28 51
5 Kongsvinger Kongsvinger 30 56 42 49
6 Mjøndalen IF Mjøndalen 30 49 38 49
7 Strømmen IF Strømmen 30 46 45 47
8 Levanger Levanger 30 52 46 45
9 Ranheim Ranheim 30 45 48 39
10 Åsane Åsane 30 36 37 38
11 Fredrikstad Fredrikstad 30 34 48 33
12 Ull Kisa Ull Kisa 30 47 50 32
13 Bryne Bryne 30 33 48 30
14 Hødd Hødd 30 31 57 30
15 KFUM Oslo KFUM Oslo 30 31 48 26
16 Raufoss IL Raufoss IL 30 33 62 21
TEMPORADA 2014/2015
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Sogndal Sogndal 30 59 31 62
2 SK Brann SK Brann 30 46 35 53
3 Kristiansund BK Kristiansund 30 37 30 49
4 Hødd Hødd 30 43 40 48
5 Jerv Jerv 30 47 28 47
6 Ranheim Ranheim 30 48 36 47
7 Sandnes Ulf Sandnes Ulf 30 49 40 47
8 Strømmen IF Strømmen 30 33 39 37
9 Levanger Levanger 30 48 53 36
10 Bryne Bryne 30 43 50 36
11 Åsane Åsane 30 46 46 35
12 Fredrikstad Fredrikstad 30 41 61 35
13 Follo Follo 30 42 43 33
14 Nest-Sotra Nest-Sotra 30 41 51 31
15 Bærum Bærum 30 44 67 31
16 Hønefoss Hønefoss 30 35 52 28
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
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Kristiansund BK Kristiansund 26 77 18 68
2 Nardo Nardo 26 58 42 50
3 Fyllingsdalen Fyllingsdale 26 51 37 47
4 Byåsen Byåsen 26 57 47 47
5 Kjelsås Kjelsås 26 58 48 44
6 Rosenborg II Rosenborg 26 63 50 38
7 KFUM Oslo KFUM Oslo 26 48 49 38
8 Levanger Levanger 26 53 48 34
9 Træff Træff 26 51 50 32
10 Molde FK II Molde FK II 26 65 67 32
11 Fana Fana 26 54 52 30
12 Skeid Skeid 26 42 55 26
13 Buvik Buvik 26 41 88 16
14 Aalesunds FK II Aalesunds 26 25 92 13
TEMPORADA 2010/2011
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Bærum Bærum 22 69 28 47
2 Kristiansund BK Kristiansund 22 50 27 44
3 Elverum Elverum 23 35 26 39
4 Raufoss IL Raufoss IL 22 46 39 36
5 Brumunddal Brumunddal 22 45 40 35
6 Frigg Frigg 23 45 39 34
7 Valdres FK Valdres FK 22 40 46 32
8 Lillehammer Lillehammer 22 36 47 29
9 Molde FK II Molde FK II 22 39 48 28
10 Follo Follo 22 46 46 25
11 Aalesunds FK II Aalesunds 22 34 56 25
12 Jevnaker Jevnaker 22 37 53 19
13 SK Herd SK Herd 22 30 57 16
TEMPORADA 2009/2010
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hødd Hødd 26 81 23 60
2 Kristiansund BK Kristiansund 26 60 35 55
3 Skeid Skeid 26 49 28 50
4 Rosenborg II Rosenborg 26 64 39 47
5 Aalesunds FK II Aalesunds 26 36 47 36
6 Nardo Nardo 26 44 46 34
7 Strindheim Strindheim 26 33 42 33
8 Molde FK II Molde FK II 26 47 57 32
9 Steinkjer Steinkjer 26 40 56 31
10 Byåsen Byåsen 26 40 60 31
11 Levanger Levanger 26 46 50 29
12 Skarbovik Skarbovik 26 34 39 28
13 Kolstad Kolstad 26 33 61 21
14 Oslo City Oslo City 26 37 61 19
TEMPORADA 2008/2009
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Follo Follo 26 59 25 60
2 Hødd Hødd 26 69 44 46
3 Kristiansund BK Kristiansund 26 54 37 46
4 Rosenborg II Rosenborg 26 63 48 46
5 Lorenskog IF Lorenskog 26 55 38 45
6 Byåsen Byåsen 26 52 38 40
7 Molde FK II Molde FK II 26 50 47 38
8 Skarbovik Skarbovik 26 45 45 34
9 Strindheim Strindheim 26 41 48 34
10 Nardo Nardo 26 37 39 33
11 Levanger Levanger 26 26 58 32
12 Steinkjer Steinkjer 26 47 70 29
13 Drøbak / Frogn Drøbak 26 45 64 20
14 Ullern Ullern 26 24 66 15
TEMPORADA 2007/2008
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Skeid Skeid 26 87 28 67
2 Ranheim Ranheim 26 74 31 53
3 Skarbovik Skarbovik 26 51 38 47
4 Kristiansund BK Kristiansund 26 56 32 44
5 Levanger Levanger 26 47 49 44
6 Lyn II Lyn II 26 61 50 38
7 Byåsen Byåsen 26 54 51 38
8 Strindheim Strindheim 26 49 44 37
9 Korsvoll IL Korsvoll IL 26 37 53 36
10 Kjelsås Kjelsås 26 32 41 33
11 Steinkjer Steinkjer 26 56 68 31
12 Vålerenga II Vålerenga 26 40 58 30
13 KIL / Hemne KIL / Hemne 26 33 81 12
14 Groruddalen BK Oslo Groruddalen 26 23 76 8
TEMPORADA 2006/2007
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hødd Hødd 26 77 30 57
2 Asker Asker 26 72 33 52
3 Ranheim Ranheim 26 58 28 49
4 Strindheim Strindheim 26 69 40 49
5 Kristiansund BK Kristiansund 26 57 35 48
6 Bærum Bærum 26 55 42 38
7 Vålerenga II Vålerenga 26 48 60 36
8 Byåsen Byåsen 26 47 41 35
9 Stabæk II Stabæk II 26 48 56 34
10 Levanger Levanger 26 44 61 30
11 Steinkjer Steinkjer 26 49 75 30
12 Lillestrom II Lillestrom 26 39 75 25
13 Nardo Nardo 26 32 66 20
14 Averøykameratene Averøykamer 26 24 77 13
TEMPORADA 2005/2006
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Skeid Skeid 26 67 23 63
2 Groruddalen BK Oslo Groruddalen 26 73 39 55
3 Ranheim Ranheim 26 63 40 45
4 Rosenborg II Rosenborg 26 60 47 42
5 Strindheim Strindheim 26 53 48 40
6 Byåsen Byåsen 26 65 48 38
7 Kristiansund BK Kristiansund 26 44 33 38
8 Korsvoll IL Korsvoll IL 26 58 59 36
9 Steinkjer Steinkjer 26 56 59 36
10 Kjelsås Kjelsås 26 36 55 33
11 Molde FK II Molde FK II 26 42 65 31
12 Levanger Levanger 26 48 50 29
13 Kolstad Kolstad 26 47 84 21
14 KIL / Hemne KIL / Hemne 26 29 91 12
TEMPORADA 1950/1951
LIGA NORUEGA
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 14 44 14 23
2 Valerenga IF Valerenga 14 35 21 19
3 Sandefjord Sandefjord 14 24 23 14
4 Viking Stavanger Viking 14 19 18 14
5 SK Brann SK Brann 14 24 30 13
6 Strømmen IF Strømmen 14 22 29 13
7 Lisleby FK Lisleby FK 14 21 35 9
8 Fram Fram 14 14 33 7
9 Odd Odd 14 31 13 20
10 Lyn 1896 FK Lyn 1896 FK 14 41 18 19
11 Sparta Sarpsborg Sparta 14 19 16 16
12 Skeid Skeid 14 29 28 16
13 Sarpsborg FK Sarpsborg 14 20 21 13
14 Ørn Horten Ørn Horten 14 23 25 13
15 Selbak Turn og IF Selbak Turn 14 22 25 11
16 Kristiansund BK Kristiansund 14 16 55 4

  USO DE MEMORIA  
7,544,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1476
Total Execution Time  0.1487
  CADENA URL  
/historico/Kristiansund-Bk
  GET DATOS  
$_GET['/historico/Kristiansund-Bk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0035  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 = 'Kristiansund-Bk' 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.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=12718 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=12718 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=12718 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=12718 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12718 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12718 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (681471,680903,681477,696729,979246) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '12718' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '12718' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  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=12718 AND l.year in (2023,2024,2025) 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 (75723,74846,74771,74565,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74846 AND teamId = 12718
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74565 AND teamId = 12718
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74771 AND teamId = 12718
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75723 AND teamId = 12718
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12718
0.0022  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 = '12718' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12718' 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 = '12718' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 12718 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.0031  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 = 12718 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 12718 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 12718 AND l.year <= 2024 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 `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 team.conference ASC,t.position 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 `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 = 70739 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.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 `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.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 = 61031 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.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 `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 = 53585 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.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 `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 = 48598 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 42098 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 `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 = 37670 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 `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 = 20366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9131 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 `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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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 = 25019 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 = 25029 AND t.round = 24 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 `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 = 25037 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 `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 = 25044 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 25054 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 `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 = 25063 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 `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 = 27751 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 `tables1951` 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 = 10843 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC