4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Amiens SC II
TEMPORADA 2022/2023
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Feignies Feignies 26 60 29 60
2 Lens II Lens II 26 64 30 47
3 Valenciennes II Valenciennes 26 45 29 47
4 Olympique Marcquois Olympique 26 41 29 44
5 Iris Club de Croix Iris Club C. 26 37 29 41
6 Lille II Lille II 26 41 30 40
7 Compiègne Compiègne 26 39 40 39
8 Vimy Vimy 26 34 40 39
9 Chantilly Chantilly 26 48 46 38
10 US Maubeuge US Maubeuge 26 40 44 37
11 Amiens SC II Amiens 26 43 46 32
12 Amiens AC Amiens AC 26 30 52 19
13 ES Lambres ES Lambres 26 19 61 18
14 Longueau Longueau 26 18 54 12
TEMPORADA 2021/2022
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 ES Wasquehal Wasquehal 26 46 23 53
2 Feignies Feignies 26 37 21 51
3 Olympique Marcquois Olympique 26 42 27 43
4 Lille II Lille II 26 43 29 42
5 Amiens AC Amiens AC 26 32 25 40
6 US Maubeuge US Maubeuge 26 40 32 39
7 Valenciennes II Valenciennes 26 39 40 36
8 Amiens SC II Amiens 26 39 40 35
9 Iris Club de Croix Iris Club C. 26 34 37 31
10 Vimy Vimy 26 33 38 31
11 Chantilly Chantilly 26 29 44 30
12 Saint-Omer Saint-Omer 26 20 33 29
13 US Boulogne II Boulogne 26 17 37 23
14 Touquet Touquet 26 31 56 22
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 5
Equipo PJ GF GC Puntos
1 Valenciennes II Valenciennes 0 0 0 0
2 Amiens AC Amiens AC 0 0 0 0
3 Amiens SC II Amiens 0 0 0 0
4 Olympique Marcquois Olympique 0 0 0 0
5 US Boulogne II Boulogne 0 0 0 0
6 Chantilly Chantilly 0 0 0 0
7 US Maubeuge US Maubeuge 0 0 0 0
8 ES Wasquehal Wasquehal 0 0 0 0
9 Lille II Lille II 0 0 0 0
10 Vimy Vimy 0 0 0 0
11 Touquet Touquet 0 0 0 0
12 Feignies Feignies 0 0 0 0
13 Iris Club de Croix Iris Club C. 0 0 0 0
14 Saint-Omer Saint-Omer 0 0 0 0
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 16 30 16 30
2 Feignies Feignies 17 20 10 28
3 US Maubeuge US Maubeuge 17 26 16 27
4 Olympique Marcquois Olympique 16 19 12 26
5 Vimy Vimy 15 17 16 25
6 Valenciennes II Valenciennes 17 21 21 23
7 Amiens AC Amiens AC 16 23 22 22
8 Touquet Touquet 16 14 21 22
9 Amiens SC II Amiens 16 22 24 19
10 US Boulogne II Boulogne 16 18 26 19
11 Grande-Synthe Grande-Synth 16 19 22 16
12 Portelois Portelois 15 21 28 15
13 Chambly II Chambly II 16 13 21 14
14 Arras Arras 15 12 20 14
TEMPORADA 2018/2019
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Olympique St Quentin Olympique 26 48 20 54
2 Beauvais Oise Beauvais 26 47 23 51
3 Amiens AC Amiens AC 26 34 20 47
4 Grande-Synthe Grande-Synth 26 42 36 40
5 Amiens SC II Amiens 26 39 31 39
6 Chambly II Chambly II 26 33 27 39
7 US Boulogne II Boulogne 26 32 31 36
8 US Maubeuge US Maubeuge 26 24 21 34
9 Touquet Touquet 26 30 40 34
10 Olympique Marcquois Olympique 26 32 39 32
11 Senlis Senlis 26 28 41 30
12 Dunkerque II Dunkerque 26 33 42 28
13 Tourcoing Tourcoing 26 29 37 26
14 Chantilly Chantilly 26 25 68 8
TEMPORADA 2017/2018
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Feignies Feignies 26 41 15 62
2 Grande-Synthe Grande-Synth 26 30 19 48
3 Olympique St Quentin Olympique 26 45 26 45
4 Senlis Senlis 26 28 26 39
5 Dunkerque II Dunkerque 26 32 31 38
6 Amiens SC II Amiens 26 37 33 36
7 Tourcoing Tourcoing 26 38 34 34
8 Chambly II Chambly II 26 26 34 32
9 US Maubeuge US Maubeuge 26 24 31 31
10 US Boulogne II Boulogne 26 25 33 31
11 ES Wasquehal Wasquehal 26 29 30 30
12 Saint-Amand Saint-Amand 26 24 31 30
13 Roye-Noyon Roye-Noyon 26 24 41 21
14 Ailly Sur Somme Ailly Somme 26 20 39 17
TEMPORADA 2016/2017
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 26 39 21 48
2 Saint-Ouen-l'Aumône Saint-Ouen-l 26 31 17 47
3 Amiens SC II Amiens 26 34 30 44
4 Feignies Feignies 26 36 28 42
5 Olympique St Quentin Olympique 26 35 29 39
6 Tourcoing Tourcoing 26 25 24 38
7 Grande-Synthe Grande-Synth 26 32 32 38
8 US Maubeuge US Maubeuge 26 36 32 35
9 US Boulogne II Boulogne 26 35 41 33
10 Roye-Noyon Roye-Noyon 26 25 26 32
11 Ailly Sur Somme Ailly Somme 26 30 36 28
12 Paris II Paris II 26 34 44 27
13 Marck Marck 26 24 38 25
14 Senlis Senlis 26 23 41 25
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Lille II Lille II 26 45 26 50
2 Maur Lusitanos Maur 26 45 28 50
3 Grande-Synthe Grande-Synth 26 45 31 47
4 Noisy-le-Sec Noisy-le-Sec 26 45 36 45
5 Ivry Ivry 26 33 27 40
6 US Boulogne II Boulogne 26 42 34 38
7 Ailly Sur Somme Ailly Somme 26 27 29 37
8 Feignies Feignies 26 33 37 34
9 Amiens SC II Amiens 26 31 38 31
10 Olympique St Quentin Olympique 26 37 44 29
11 Marck Marck 26 25 31 28
12 Tourcoing Tourcoing 26 36 54 26
13 Aulnoye Aulnoye 26 39 46 23
14 Valenciennes II Valenciennes 26 26 48 16
TEMPORADA 2014/2015
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Boulogne-Billancourt Boulogne-Bil 26 51 39 47
2 Poissy Poissy 26 36 25 46
3 Chartres Chartres 26 36 20 45
4 Le Havre II Le Havre II 26 40 23 42
5 Gonfreville Gonfreville 26 33 28 41
6 St Geneviève Geneviève 26 26 27 37
7 Oissel Oissel 26 38 40 34
8 Bastia II Bastia II 26 37 39 33
9 Caen II Caen II 26 37 35 32
10 Saint-Ouen-l'Aumône Saint-Ouen-l 26 33 34 30
11 Amiens SC II Amiens 26 32 37 30
12 QRM II QRM II 26 41 47 29
13 Furiani Agliani Furiani 26 25 44 22
14 Evry Evry 26 26 53 17
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Arras Arras 26 59 33 54
2 Calais Calais 26 32 19 51
3 Oissel Oissel 26 44 28 49
4 Le Havre II Le Havre II 26 33 32 35
5 Saint-Ouen-l'Aumône Saint-Ouen-l 26 36 36 35
6 Bastia II Bastia II 26 38 40 35
7 Grande-Synthe Grande-Synth 26 27 27 32
8 UJA Maccabi UJA Maccabi 26 27 29 31
9 QRM II QRM II 26 40 47 31
10 Caen II Caen II 26 31 32 30
11 Amiens SC II Amiens 26 28 33 29
12 Noisy-le-Sec Noisy-le-Sec 26 24 36 27
13 Marck Marck 26 26 41 26
14 Gravelines Gravelines 26 23 35 22
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Dieppe Dieppe 26 67 18 65
2 Sedan II Sedan II 26 39 26 48
3 Grande-Synthe Grande-Synth 26 31 29 45
4 Iris Club de Croix Iris Club C. 26 35 18 44
5 Arras Arras 26 40 25 41
6 Calais Calais 26 37 30 39
7 Feignies Feignies 26 31 29 37
8 Amiens SC II Amiens 26 37 36 36
9 ES Wasquehal Wasquehal 26 32 43 32
10 Aulnoye Aulnoye 26 35 41 31
11 Gravelines Gravelines 26 33 44 30
12 Avion Avion 26 27 41 25
13 US Boulogne II Boulogne 26 22 54 19
14 Ailly Sur Somme Ailly Somme 26 20 52 14
TEMPORADA 2011/2012
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Chambly Chambly 9 15 9 20
2 Sannois Gratien Sannois 9 13 7 16
3 Calais Calais 9 14 11 16
4 Dieppe Dieppe 9 15 10 15
5 US Boulogne II Boulogne 9 18 10 14
6 Amiens SC II Amiens 9 11 10 14
7 Beauvais II Beauvais II 9 12 14 12
8 Saint-Omer Saint-Omer 9 17 19 11
9 Oissel Oissel 9 10 14 11
10 FC Rouen 1899 II Rouen 1899 9 12 17 11
11 Gravelines Gravelines 9 15 14 10
12 Noisy-le-Sec Noisy-le-Sec 9 14 14 10
13 Grande-Synthe Grande-Synth 9 12 11 9
14 Olympique Marcquois Olympique 9 12 17 9
15 FC EU FC EU 9 10 16 9
16 Issy Issy 9 11 18 8
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Calais Calais 30 46 21 56
2 Oissel Oissel 30 41 35 52
3 Evreux 27 Evreux 27 31 32 33 50
4 Poissy Poissy 30 48 35 49
5 Dieppe Dieppe 30 43 36 44
6 Hazebrouck Hazebrouck 31 41 36 44
7 Saint-Omer Saint-Omer 30 35 34 44
8 ES Wasquehal Wasquehal 30 32 28 41
9 Bastia II Bastia II 30 40 33 40
10 Gravelines Gravelines 30 36 36 40
11 Amiens AC Amiens AC 30 39 38 39
12 Drouais Drouais 30 31 30 38
13 Pacy Vallée-d'Eure II Pacy 29 30 32 38
14 Amiens SC II Amiens 30 25 38 30
15 Gonfreville Gonfreville 30 25 49 29
16 Entente S.S.G. II Entente 29 25 55 19
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Marck Marck 32 45 26 59
2 Mantes Mantes 32 43 28 56
3 Hazebrouck Hazebrouck 32 52 37 54
4 Poissy Poissy 32 40 30 51
5 Amiens AC Amiens AC 32 53 36 50
6 Oissel Oissel 32 40 35 50
7 Dieppe Dieppe 32 45 42 47
8 Créteil II Créteil II 32 46 43 46
9 Entente S.S.G. II Entente 32 29 25 44
10 ES Wasquehal Wasquehal 32 38 32 42
11 Gravelines Gravelines 32 28 34 42
12 Amiens SC II Amiens 32 44 38 41
13 Drouais Drouais 31 23 31 41
14 Pacy Vallée-d'Eure II Pacy 32 38 47 39
15 Trouville Deauville Trouville 31 45 54 31
16 JA Armentières Armentières 32 23 38 30
17 AS Ifs AS Ifs 32 30 86 9
TEMPORADA 2007/2008
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Noisy-le-Sec Noisy-le-Sec 30 55 23 60
2 Sedan II Sedan II 30 39 25 51
3 Amiens AC Amiens AC 30 47 39 51
4 Marck Marck 30 46 28 50
5 Feignies Feignies 29 43 30 50
6 Les Lilas Les Lilas 30 44 34 49
7 JA Armentières Armentières 30 29 24 49
8 Hazebrouck Hazebrouck 30 35 38 46
9 Amiens SC II Amiens 30 49 39 44
10 Arras Arras 30 37 38 39
11 Stade de Reims II Stade Reims 30 39 38 38
12 Roye-Noyon Roye-Noyon 30 32 40 36
13 Olympique St Quentin Olympique 29 31 38 31
14 SC Abbeville Abbeville 30 42 54 27
15 US Laon US Laon 30 25 44 27
16 Taissy Taissy 30 20 81 8

  USO DE MEMORIA  
6,455,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8073
Total Execution Time  0.8085
  CADENA URL  
/historico/Amiens-Sc-Ii
  GET DATOS  
$_GET['/historico/Amiens-Sc-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.4149  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 = 'Amiens-Sc-Ii' 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.0228  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 = 'Amiens-Sc-Ii' 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=6714 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=6714 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=6714 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=6714 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=6714 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=6714 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=6714 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=6714 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=6714 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=6714 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6714 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6714 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=6714 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=6714 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=6714 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=6714 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0030  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 = 68300
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6714 AND type_rel = 2
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6714 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (773894) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '6714' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0069  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 = '6714' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0105  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 = '6714' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0042  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 = 68300 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0096  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=6714 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (68300) 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.0199  SELECT count(id) as num_players from rel_players WHERE league_id = 68300 AND teamId = 6714
0.0100  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 = 68300 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0033  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 = '6714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0028  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6714' and rp.type = 4
0.0021  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 = '6714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0289  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 = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6714 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.0362  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 = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6714 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6714 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0061  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 = 6714 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0057  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 = 68300 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.0088  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 = 63489 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.0089  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 = 57386 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.0051  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 = 50961 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  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 = 44567 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0056  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 = 39134 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  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 = 34009 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060  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 = 15904 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0078  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 = 4307 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0101  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 = 2540 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0066  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 = 2101 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0081  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 = 1683 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 20003 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0081  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 = 20012 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0073  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 = 20020 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC