4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Follo
TEMPORADA 2023/2024
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Skeid Skeid 4 7 2 10
2 Strømmen IF Strømmen 4 10 6 9
3 Eidsvold TF Eidsvold TF 4 8 6 9
4 Grorud IL Grorud IL 4 11 7 7
5 IL Stjørdals-Blink Stjørdals-B 3 8 4 7
6 Kjelsås Kjelsås 4 8 6 7
7 Strindheim Strindheim 3 4 4 6
8 Tromsdalen Tromsdalen 3 6 6 4
9 Follo Follo 4 6 7 3
10 Ull Kisa Ull Kisa 4 5 6 3
11 Junkeren Junkeren 3 5 9 3
12 Alta IF Alta IF 3 3 7 2
13 Vålerenga II Vålerenga 3 3 8 0
14 Gjøvik-Lyn Gjøvik-Lyn 4 1 7 0
TEMPORADA 2022/2023
CUARTA NORUEGA GRUPO 6
Equipo PJ GF GC Puntos
1 Follo Follo 26 80 22 69
2 Lorenskog IF Lorenskog 26 75 30 55
3 Nordstrand Nordstrand 26 68 29 46
4 Asker Asker 26 58 41 43
5 Oppsal Oppsal 26 49 48 40
6 Skjervøy Skjervøy 26 57 57 40
7 KFUM Oslo II KFUM Oslo 26 49 50 40
8 Mjølner Mjølner 26 51 49 38
9 Skeid II Skeid II 26 60 54 36
10 Fløya Fløya 26 45 45 33
11 Sarpsborg 08 II Sarpsborg 26 37 55 29
12 Tromso II Tromso II 26 44 67 26
13 Skånland Skånland 26 41 59 25
14 Hammerfest IF Stein Hammerfest 26 10 118 3
TEMPORADA 2021/2022
CUARTA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Fram Fram 26 60 20 61
2 Follo Follo 26 63 31 58
3 Pors Grenland Pors 26 67 39 52
4 Eik Tønsberg Tønsberg 26 54 31 49
5 Fredrikstad II Fredrikstad 26 64 49 39
6 Sprint-Jeløy Sprint-Jelø 26 50 53 35
7 Sarpsborg 08 II Sarpsborg 26 46 58 33
8 Randesund Randesund 26 40 51 32
9 Halsen Halsen 26 46 65 31
10 Vindbjart Vindbjart 26 53 48 29
11 Mandalskameratene Mandalskamer 26 52 59 27
12 IK Start II IK Start II 26 44 57 26
13 Express Express 26 33 66 19
14 Urædd Urædd 26 27 72 15
TEMPORADA 2020/2021
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Ørn Horten Ørn Horten 13 32 12 29
2 Eik Tønsberg Tønsberg 13 29 14 27
3 Pors Grenland Pors 13 33 13 25
4 Hønefoss Hønefoss 13 28 18 25
5 Fredrikstad II Fredrikstad 13 32 24 19
6 Oppsal Oppsal 13 17 20 19
7 Strømsgodset II Strømsgodse 13 34 29 18
8 Sarpsborg 08 II Sarpsborg 13 26 28 18
9 Halsen Halsen 13 20 33 16
10 Follo Follo 13 18 14 15
11 Mjøndalen IF II Mjøndalen 13 23 20 15
12 Flint Flint 13 21 26 15
13 Kråkerøy Kråkerøy 13 16 32 10
14 Åssiden IF Åssiden IF 13 13 59 0
TEMPORADA 2019/2020
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Åssiden IF Åssiden IF 0 0 0 0
2 FK Tønsberg Tønsberg 0 0 0 0
3 Flint Flint 0 0 0 0
4 Follo Follo 0 0 0 0
5 Fredrikstad II Fredrikstad 0 0 0 0
6 Halsen Halsen 0 0 0 0
7 Hønefoss Hønefoss 0 0 0 0
8 Kråkerøy Kråkerøy 0 0 0 0
9 Mjøndalen IF II Mjøndalen 0 0 0 0
10 Oppsal Oppsal 0 0 0 0
11 Pors Grenland Pors 0 0 0 0
12 Sarpsborg 08 II Sarpsborg 0 0 0 0
13 Strømsgodset II Strømsgodse 0 0 0 0
14 Ørn Horten Ørn Horten 0 0 0 0
TEMPORADA 2018/2019
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Vålerenga II Vålerenga 26 88 27 64
2 FK Tønsberg Tønsberg 26 56 25 52
3 Follo Follo 26 44 27 51
4 Ullern Ullern 26 61 33 50
5 Ørn Horten Ørn Horten 26 57 29 50
6 Lyn 1896 FK Lyn 1896 FK 26 57 48 37
7 IF Ready IF Ready 26 37 41 35
8 Frigg Frigg 26 38 55 34
9 Lokomotiv Oslo Lokomotiv 26 40 38 29
10 Mjøndalen IF II Mjøndalen 26 47 48 29
11 Halsen Halsen 26 44 72 29
12 SF Grei SF Grei 26 30 45 28
13 Norild Norild 26 37 92 14
14 Drøbak / Frogn Drøbak 26 23 79 13
TEMPORADA 2017/2018
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Oppsal Oppsal 26 85 17 67
2 Træff Træff 26 65 37 53
3 Molde FK II Molde FK II 26 66 42 53
4 Spjelkavik Spjelkavik 26 55 46 40
5 Lokomotiv Oslo Lokomotiv 26 42 35 40
6 Follo Follo 26 39 47 35
7 SK Herd SK Herd 26 46 48 34
8 Drøbak / Frogn Drøbak 26 48 62 34
9 Ullern Ullern 26 58 54 33
10 IF Ready IF Ready 26 43 53 32
11 Rilindja Rilindja 26 42 65 31
12 Kristiansund II Kristiansund 26 48 67 24
13 KFUM Oslo II KFUM Oslo 26 41 60 24
14 Hødd II Hødd II 26 34 79 14
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 1
Equipo PJ GF GC Puntos
1 Tromsdalen Tromsdalen 26 71 19 67
2 Finnsnes Finnsnes 26 52 22 56
3 Skeid Skeid 26 57 29 52
4 Grorud IL Grorud IL 26 63 39 51
5 Follo Follo 26 48 39 41
6 Kjelsås Kjelsås 26 38 34 41
7 Alta IF Alta IF 26 58 44 40
8 Harstad Harstad 26 45 51 31
9 Senja Senja 26 34 41 29
10 Oppsal Oppsal 26 36 53 29
11 Stabæk II Stabæk II 26 37 54 25
12 Ullern Ullern 26 28 51 18
13 Tromso II Tromso II 26 40 68 18
14 Mo IL Mo IL 26 31 94 10
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
TERCERA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Follo Follo 26 97 16 66
2 Kjelsås Kjelsås 26 76 28 58
3 Moss Moss 26 69 24 53
4 Eidsvold TF Eidsvold TF 26 59 34 45
5 KFUM Oslo KFUM Oslo 26 44 31 45
6 Finnsnes Finnsnes 26 45 42 43
7 Skeid Skeid 26 54 42 42
8 Harstad Harstad 26 46 33 39
9 Vålerenga II Vålerenga 26 51 51 36
10 Kvik Halden Kvik Halden 26 37 51 31
11 Lorenskog IF Lorenskog 26 36 64 26
12 Drøbak / Frogn Drøbak 26 37 92 15
13 Mo IL Mo IL 26 23 88 13
14 Medkila Medkila 26 13 91 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 4
Equipo PJ GF GC Puntos
1 Follo Follo 26 58 28 56
2 Lorenskog IF Lorenskog 26 51 39 51
3 Senja Senja 26 54 44 50
4 Asker Asker 26 54 36 47
5 Kvik Halden Kvik Halden 26 53 40 39
6 Østsiden Østsiden 26 45 44 39
7 Nesodden Nesodden 26 40 47 34
8 Frigg Frigg 26 53 58 32
9 Mo IL Mo IL 26 41 49 31
10 Moss Moss 26 43 46 30
11 Tromso II Tromso II 26 35 48 27
12 Mjølner Mjølner 26 26 41 27
13 Finnsnes Finnsnes 26 35 51 27
14 Stabæk II Stabæk II 26 36 53 26
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
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Sogndal Sogndal 28 51 28 56
2 Sarpsborg 08 Sarpsborg 28 54 36 54
3 Fredrikstad Fredrikstad 28 53 36 52
4 Løv-Ham Fotball Løv-Ham 28 46 38 43
5 Ranheim Ranheim 28 37 38 43
6 FK Bodo Glimt Bodo Glimt 28 41 28 42
7 Strømmen IF Strømmen 28 43 42 40
8 Alta IF Alta IF 28 41 51 36
9 Mjøndalen IF Mjøndalen 28 41 49 35
10 Nybergsund IL-Trysil Nybergsund 28 38 47 35
11 Bryne Bryne 28 56 52 34
12 Follo Follo 28 35 43 32
13 Sandnes Ulf Sandnes Ulf 28 33 40 31
14 Tromsdalen Tromsdalen 28 33 50 28
15 Moss Moss 28 32 56 26
16 Lyn 1896 FK Lyn 1896 FK 0 0 0 0
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 1
Equipo PJ GF GC Puntos
1 Mjøndalen IF Mjøndalen 26 64 34 55
2 Lorenskog IF Lorenskog 26 48 27 51
3 Stabæk II Stabæk II 26 48 34 44
4 Raufoss IL Raufoss IL 26 55 37 43
5 Drøbak / Frogn Drøbak 26 51 40 41
6 Follo Follo 25 42 33 36
7 Strømsgodset II Strømsgodse 25 54 66 33
8 Manglerud Star Manglerud 26 48 43 32
9 Valdres FK Valdres FK 26 40 48 32
10 Fredrikstad II Fredrikstad 26 36 48 32
11 Strømmen IF Strømmen 26 31 49 29
12 Modum Modum 26 34 57 26
13 Østsiden Østsiden 26 30 52 25
14 Sprint-Jeløy Sprint-Jelø 26 28 41 24
TEMPORADA 2006/2007
TERCERA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Alta IF Alta IF 26 72 37 52
2 Mjøndalen IF Mjøndalen 26 62 34 49
3 Drøbak / Frogn Drøbak 26 68 36 48
4 Lorenskog IF Lorenskog 26 58 33 46
5 Follo Follo 26 48 30 46
6 Tromso II Tromso II 26 46 55 38
7 Amot IF Amot IF 26 50 61 38
8 Mo IL Mo IL 26 38 43 37
9 Sprint-Jeløy Sprint-Jelø 26 41 48 36
10 Rosenborg II Rosenborg 26 54 55 30
11 Skarp Skarp 26 46 70 29
12 Harstad Harstad 26 35 45 24
13 Mjølner Mjølner 26 37 61 24
14 Hammerfest Hammerfest 26 23 70 22
TEMPORADA 2005/2006
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Stromsgodset IF Stromsgodset 30 68 36 65
2 Aalesunds FK Aalesunds 30 71 35 60
3 Bryne Bryne 30 52 44 52
4 Hønefoss Hønefoss 30 64 47 51
5 FK Bodo Glimt Bodo Glimt 30 65 49 49
6 Sogndal Sogndal 30 43 41 44
7 Kongsvinger Kongsvinger 30 39 42 43
8 Moss Moss 30 61 46 40
9 Haugesund Haugesund 30 40 37 38
10 Sparta Sarpsborg Sparta 30 44 56 37
11 Løv-Ham Fotball Løv-Ham 30 38 40 35
12 Tromsdalen Tromsdalen 30 48 52 35
13 Pors Grenland Pors 30 51 65 35
14 Manglerud Star Manglerud 30 47 79 28
15 Follo Follo 30 46 76 25
16 Hødd Hødd 30 29 61 19
TEMPORADA 2004/2005
SEGUNDA NORUEGA
Equipo PJ GF GC Puntos
1 Stabæk Stabæk 30 63 23 67
2 Sandefjord Sandefjord 30 58 37 62
3 Moss Moss 30 54 30 58
4 Hønefoss Hønefoss 30 52 41 56
5 Bryne Bryne 30 55 33 50
6 Pors Grenland Pors 30 47 45 50
7 Sogndal Sogndal 30 47 51 41
8 Stromsgodset IF Stromsgodset 30 46 45 40
9 Hødd Hødd 30 53 54 37
10 Kongsvinger Kongsvinger 30 41 48 37
11 Follo Follo 30 40 47 34
12 Løv-Ham Fotball Løv-Ham 30 31 47 31
13 Mandalskameratene Mandalskamer 30 41 54 29
14 Skeid Skeid 30 39 58 29
15 FK Tønsberg Tønsberg 30 36 56 25
16 Alta IF Alta IF 30 28 62 20

  USO DE MEMORIA  
7,316,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7238
Total Execution Time  0.7251
  CADENA URL  
/historico/Follo
  GET DATOS  
$_GET['/historico/Follo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0162  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 = 'Follo' 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.0127  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=12719 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=12719 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=12719 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12719 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0264  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 = 75723
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12719 AND type_rel = 2
0.0141  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 = '12719' ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '12719' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '12719' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0158  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 = 75723 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=12719 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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,74961,71432,70825) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 74961 AND teamId = 12719
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 70825 AND teamId = 12719
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75723 AND teamId = 12719
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12719
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 = '12719' 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 = '12719' 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 = '12719' 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 events2024 e ON e.player_id = p.id AND e.league_id = 74961 WHERE rp.league_id = 74961 AND rp.teamId = 12719 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.0135  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74961 WHERE rp.league_id = 74961 AND rp.teamId = 12719 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 74961 WHERE rp.league_id = 74961 AND rp.teamId = 12719 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 12719 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138  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 = 74961 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 70825 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.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 66287 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.0138  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 = 63570 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 53746 AND t.round = 13 ORDER BY team.conference ASC,t.position 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 `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 = 48607 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 `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 = 42432 AND t.round = 26 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 `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.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 20367 AND t.round = 26 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 `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.0137  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 = 3645 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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.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 `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 = 25024 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0143  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 = 10797 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 `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.0143  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 = 25053 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 25069 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10793 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 `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 = 10792 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC