4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Thun Sub 18
TEMPORADA 2022/2023
LIGA SUIZA ELITE SUB 18 GRUPO 3
Equipo PJ GF GC Puntos
1 FC St. Gallen Sub 18 Gallen 5 21 6 15
2 Neuchâtel Xamax Sub 18 Neuchâtel 5 12 8 10
3 Team Ticino Sub 18 Team Ticino 5 8 11 6
4 FC Thun Sub 18 Thun 5 7 10 5
5 Grasshopper Zürich Sub 18 Grasshopper 5 9 11 4
6 FC Sion Sub 18 Sion 5 4 15 2
TEMPORADA 2021/2022
LIGA SUIZA ELITE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 18 Young Boys 26 84 37 63
2 FC Zürich Sub 18 Zürich 26 78 41 52
3 FC Basel Sub 18 Basel 26 76 45 49
4 Servette FC Sub 18 Servette 26 75 57 43
5 FC St. Gallen Sub 18 Gallen 26 58 47 42
6 FC Luzern-SC Kriens Sub 18 Luzern-SC 26 71 53 41
7 Grasshopper Zürich Sub 18 Grasshopper 26 54 60 36
8 Aarau Sub 18 Aarau 26 62 75 35
9 Winterthur Sub 18 Winterthur 26 52 64 34
10 FC Sion Sub 18 Sion 26 46 58 29
11 Neuchâtel Xamax Sub 18 Neuchâtel 26 37 53 28
12 Team Ticino Sub 18 Team Ticino 26 41 67 23
13 Team Vaud Sub 18 Team Vaud 26 43 72 19
14 FC Thun Sub 18 Thun 26 41 89 15
TEMPORADA 2020/2021
LIGA SUIZA ELITE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 18 Young Boys 13 49 22 34
2 FC Basel Sub 18 Basel 13 41 12 32
3 FC Luzern-SC Kriens Sub 18 Luzern-SC 13 47 21 27
4 Team Aargau Sub 18 Team Aargau 13 35 31 22
5 Team Ticino Sub 18 Team Ticino 13 23 25 22
6 FC Zürich Sub 18 Zürich 13 25 19 20
7 Servette FC Sub 18 Servette 13 38 39 19
8 FC Sion Sub 18 Sion 13 36 27 18
9 Grasshopper Zürich Sub 18 Grasshopper 13 31 40 16
10 FC St. Gallen Sub 18 Gallen 13 42 39 15
11 Winterthur Sub 18 Winterthur 13 33 47 15
12 FC Thun Sub 18 Thun 13 32 57 11
13 Lausanne Sub 18 Lausanne 13 24 51 8
14 Neuchâtel Xamax Sub 18 Neuchâtel 13 15 41 3
TEMPORADA 2019/2020
LIGA SUIZA ELITE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 FC Basel Sub 18 Basel 13 43 12 33
2 FC Zürich Sub 18 Zürich 13 24 9 24
3 FC Luzern-SC Kriens Sub 18 Luzern-SC 13 35 25 22
4 Aarau Sub 18 Aarau 13 29 32 22
5 BSC Young Boys Sub 18 Young Boys 13 33 25 21
6 FC Sion Sub 18 Sion 13 31 23 21
7 Grasshopper Zürich Sub 18 Grasshopper 13 26 27 21
8 Servette FC Sub 18 Servette 13 18 19 18
9 Team Vaud Sub 18 Team Vaud 13 16 22 18
10 FC St. Gallen Sub 18 Gallen 13 32 29 16
11 Neuchâtel Xamax Sub 18 Neuchâtel 13 19 25 15
12 Team Ticino Sub 18 Team Ticino 13 14 30 15
13 Winterthur Sub 18 Winterthur 13 24 30 13
14 FC Thun Sub 18 Thun 13 10 46 2
TEMPORADA 2018/2019
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 Grasshopper Zürich Sub 18 Grasshopper 24 54 29 51
2 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 44 35 44
3 FC Zürich Sub 18 Zürich 24 48 26 42
4 Team BEJUNE Sub 18 Team BEJUNE 24 37 22 41
5 BSC Young Boys Sub 18 Young Boys 24 42 33 41
6 FC Basel Sub 18 Basel 24 56 29 40
7 Team Vaud Sub 18 Team Vaud 24 31 33 37
8 Aarau Sub 18 Aarau 27 40 49 36
9 Servette FC Sub 18 Servette 24 41 41 34
10 FC Sion Sub 18 Sion 27 47 61 28
11 Winterthur Sub 18 Winterthur 27 39 59 23
12 FC Thun Sub 18 Thun 27 40 70 21
13 FC St. Gallen Sub 18 Gallen 13 16 29 8
14 Team Ticino Sub 18 Team Ticino 13 11 30 7
TEMPORADA 2017/2018
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 Grasshopper Zürich Sub 18 Grasshopper 24 72 30 54
2 BSC Young Boys Sub 18 Young Boys 24 60 27 53
3 FC Basel Sub 18 Basel 24 59 25 48
4 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 60 42 43
5 FC Zürich Sub 18 Zürich 24 60 39 41
6 Servette FC Sub 18 Servette 24 42 33 35
7 Team Vaud Sub 18 Team Vaud 24 46 47 34
8 FC St. Gallen Sub 18 Gallen 24 47 58 31
9 FC Sion Sub 18 Sion 24 36 53 28
10 Winterthur Sub 18 Winterthur 24 38 64 22
11 Team Ticino Sub 18 Team Ticino 24 29 55 20
12 Aarau Sub 18 Aarau 24 24 51 17
13 FC Thun Sub 18 Thun 13 15 32 9
14 Team BEJUNE Sub 18 Team BEJUNE 13 20 52 4
TEMPORADA 2016/2017
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 FC Basel Sub 18 Basel 24 71 26 60
2 BSC Young Boys Sub 18 Young Boys 24 71 34 50
3 Grasshopper Zürich Sub 18 Grasshopper 24 49 28 47
4 FC St. Gallen Sub 18 Gallen 24 58 47 47
5 Servette FC Sub 18 Servette 24 43 40 38
6 FC Zürich Sub 18 Zürich 24 51 49 38
7 FC Sion Sub 18 Sion 24 53 51 35
8 Winterthur Sub 18 Winterthur 24 39 48 30
9 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 37 52 26
10 FC Thun Sub 18 Thun 24 35 44 25
11 Team BEJUNE Sub 18 Team BEJUNE 24 31 57 21
12 Team Ticino Sub 18 Team Ticino 24 25 48 17
13 Team Vaud Sub 18 Team Vaud 13 15 30 7
14 Aarau Sub 18 Aarau 13 12 36 5
TEMPORADA 2015/2016
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 FC Basel Sub 18 Basel 24 59 30 49
2 Grasshopper Zürich Sub 18 Grasshopper 24 54 37 44
3 BSC Young Boys Sub 18 Young Boys 24 73 47 43
4 Servette FC Sub 18 Servette 24 47 32 42
5 FC Zürich Sub 18 Zürich 24 56 42 38
6 FC St. Gallen Sub 18 Gallen 24 47 46 37
7 Aarau Sub 18 Aarau 24 41 40 37
8 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 44 45 36
9 Team Vaud Sub 18 Team Vaud 24 31 41 28
10 Team Ticino Sub 18 Team Ticino 24 27 50 27
11 FC Sion Sub 18 Sion 24 29 43 23
12 Winterthur Sub 18 Winterthur 24 32 52 18
13 Team BEJUNE Sub 18 Team BEJUNE 13 21 41 11
14 FC Thun Sub 18 Thun 13 11 26 6
TEMPORADA 2014/2015
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 18 Young Boys 24 65 27 54
2 Grasshopper Zürich Sub 18 Grasshopper 24 52 31 51
3 Servette FC Sub 18 Servette 24 54 35 45
4 FC Basel Sub 18 Basel 24 49 32 45
5 Aarau Sub 18 Aarau 24 42 32 38
6 FC St. Gallen Sub 18 Gallen 24 49 43 38
7 Team Vaud Sub 18 Team Vaud 24 35 37 33
8 FC Zürich Sub 18 Zürich 24 41 45 29
9 Winterthur Sub 18 Winterthur 24 43 53 27
10 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 43 50 26
11 FC Thun Sub 18 Thun 24 26 52 25
12 FC Sion Sub 18 Sion 24 26 44 23
13 Team Ticino Sub 18 Team Ticino 13 18 32 9
14 Team BEJUNE Sub 18 Team BEJUNE 13 12 42 2
TEMPORADA 2007/2008
LIGA SUIZA ELITE SUB 18
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 18 Young Boys 24 52 25 57
2 Team Vaud Sub 18 Team Vaud 24 42 33 43
3 FC Basel Sub 18 Basel 24 60 30 41
4 FC Zürich Sub 18 Zürich 24 56 43 41
5 Winterthur Sub 18 Winterthur 24 45 44 39
6 Servette FC Sub 18 Servette 24 34 37 32
7 FC Thun Sub 18 Thun 24 47 63 30
8 Grasshopper Zürich Sub 18 Grasshopper 24 45 44 29
9 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 41 34 28
10 Team Ticino Sub 18 Team Ticino 24 35 44 27
11 FC Sion Sub 18 Sion 24 38 52 26
12 FC St. Gallen Sub 18 Gallen 24 38 55 26
13 Team Aargau Sub 18 Team Aargau 24 31 60 16

  USO DE MEMORIA  
6,024,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  1.0577
Total Execution Time  1.0591
  CADENA URL  
/historico/Fc-Thun-Sub-18
  GET DATOS  
$_GET['/historico/Fc-Thun-Sub-18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (63)  
0.0151  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 = 'Fc-Thun-Sub-18' 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.0166  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 = 'Fc-Thun-Sub-18' 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 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=111543 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=111543 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=111543 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=111543 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=111543 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=111543 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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 = 68071
0.0152  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 = 71750
0.0150  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 = 70608
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111543 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2067 AND type_rel = 3
0.0150  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 = '111543' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '111543' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '111543' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 70608 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 68071 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=111543 AND l.year in (2022,2023,2024) 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 (71750,70608) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71750 AND teamId = 111543
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 70608 AND teamId = 111543
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68071 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '111543' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111543' and rp.type = 4
0.0146  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 = '111543' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 events2023 e ON e.player_id = p.id AND e.league_id = 68071 WHERE rp.league_id = 68071 AND rp.teamId = 111543 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.0155  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 events2023 e ON e.player_id = p.id AND e.league_id = 68071 WHERE rp.league_id = 68071 AND rp.teamId = 111543 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 events2023 e ON e.player_id = p.id AND e.league_id = 68071 WHERE rp.league_id = 68071 AND rp.teamId = 111543 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 111543 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0156  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 = 68071 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.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 `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 = 71750 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.0158  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 = 67940 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.0173  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 = 56988 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.0161  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 = 61872 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.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 `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 = 51561 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.0149  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 = 48417 AND t.round = 27 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 `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 = 44119 AND t.round = 24 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 `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 = 44121 AND t.round = 24 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 `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 = 44122 AND t.round = 24 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 `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 = 44123 AND t.round = 24 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 = 63183 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 68071 ORDER BY nameShow LIMIT 100