4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del PSG II
TEMPORADA 2022/2023
NATIONAL 3 GRUPO 10
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 26 45 40 44
2 Linas-Montlhery Linas-Montlh 26 34 33 42
3 Drancy Drancy 26 46 34 41
4 Vitry Vitry 26 39 36 37
5 Les Mureaux Les Mureaux 26 45 45 35
6 Montrouge Montrouge 26 38 41 35
7 Brétigny Foot Brétigny 26 28 32 35
8 Sannois Gratien Sannois 26 27 25 34
9 Ivry Ivry 26 27 29 34
10 Les Ulis Les Ulis 26 33 28 33
11 Paris II Paris II 26 45 44 32
12 PSG II PSG II 26 31 30 30
13 Blanc Mesnil Blanc Mesnil 26 27 38 29
14 Le Mée Le Mée 26 28 38 28
TEMPORADA 2021/2022
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Racing Paris Racing Paris 25 62 20 60
2 Paris II Paris II 26 47 31 49
3 Blanc Mesnil Blanc Mesnil 26 38 30 42
4 Aubervilliers Aubervillier 26 31 32 39
5 Brétigny Foot Brétigny 26 37 39 39
6 PSG II PSG II 26 35 36 37
7 Linas-Montlhery Linas-Montlh 26 35 38 36
8 Drancy Drancy 25 31 28 33
9 Ivry Ivry 26 37 44 30
10 Les Mureaux Les Mureaux 26 26 35 29
11 Les Ulis Les Ulis 26 25 42 27
12 Créteil II Créteil II 26 26 31 26
13 Mantes Mantes 26 26 31 23
14 Meaux Academy Meaux 26 16 35 21
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 0 0 0 0
2 Créteil II Créteil II 0 0 0 0
3 Linas-Montlhery Linas-Montlh 0 0 0 0
4 Meaux Academy Meaux 0 0 0 0
5 Drancy Drancy 0 0 0 0
6 Racing Paris Racing Paris 0 0 0 0
7 Les Ulis Les Ulis 0 0 0 0
8 Les Mureaux Les Mureaux 0 0 0 0
9 Brétigny Foot Brétigny 0 0 0 0
10 Ivry Ivry 0 0 0 0
11 Blanc Mesnil Blanc Mesnil 0 0 0 0
12 Paris II Paris II 0 0 0 0
13 Mantes Mantes 0 0 0 0
14 PSG II PSG II 0 0 0 0
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Versailles Versailles 18 35 7 42
2 Ivry Ivry 18 25 9 40
3 Créteil II Créteil II 17 20 14 28
4 Paris II Paris II 17 23 19 27
5 Racing Colombes 92 Racing 17 25 15 26
6 Blanc Mesnil Blanc Mesnil 16 14 15 25
7 Les Ulis Les Ulis 17 27 24 24
8 Les Mureaux Les Mureaux 17 17 18 21
9 Aubervilliers Aubervillier 17 17 20 21
10 PSG II PSG II 17 21 24 20
11 Noisy Le Grand Noisy Grand 18 13 29 16
12 US Torcy US Torcy 16 15 24 14
13 Saint-Leu Saint-Leu 18 11 26 14
14 Boulogne-Billancourt Boulogne-Bil 17 8 27 12
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Nantes II Nantes II 30 45 24 55
2 Bastia-Borgo Bastia-Borgo 30 57 35 54
3 Chartres Chartres 30 50 38 52
4 Stade Briochin Stade 30 53 33 50
5 Lorient II Lorient II 30 38 24 47
6 Oissel Oissel 30 39 37 41
7 Vannes Vannes 30 47 49 40
8 Poissy Poissy 30 35 36 39
9 Mantes Mantes 30 29 39 39
10 Granville Granville 30 47 58 38
11 Saint-Malo Saint-Malo 30 40 42 37
12 Vitré Vitré 30 34 45 36
13 PSG II PSG II 30 39 47 33
14 Furiani Agliani Furiani 30 31 43 33
15 Boulogne-Billancourt Boulogne-Bil 30 36 51 29
16 Le Havre II Le Havre II 30 29 48 29
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Villefranche Villefranche 30 50 32 58
2 Annecy Annecy 30 51 33 57
3 Andrézieux Andrézieux 30 48 36 52
4 Jura Sud Jura Sud 30 49 41 51
5 Schiltigheim Schiltigheim 30 47 35 50
6 Yzeure Yzeure 30 33 29 46
7 Épinal Épinal 30 42 36 41
8 PSG II PSG II 30 42 39 40
9 Belfort Belfort 30 43 42 39
10 Le Puy Le Puy 30 35 35 39
11 Olympique Lyonnais II Olympique 30 42 45 37
12 GOAL FC GOAL FC 30 34 39 37
13 Saint-Priest Saint-Priest 30 35 43 35
14 Saint-Louis Neuweg Saint-Louis 30 28 43 34
15 Montceau Montceau 30 34 44 33
16 Raon-l'Etape Raon-l'Etape 30 23 64 13
TEMPORADA 2016/2017
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Stade Rennais II Stade 30 44 34 56
2 Cholet Cholet 30 46 32 52
3 Bergerac Bergerac 30 35 34 49
4 Granville Granville 30 40 41 47
5 Trelissac Trelissac 30 44 31 46
6 Vitré Vitré 30 36 34 45
7 Romorantin Romorantin 30 35 31 44
8 PSG II PSG II 30 44 36 42
9 Saint-Malo Saint-Malo 30 32 32 42
10 Fontenay Fontenay 30 47 49 42
11 Lorient II Lorient II 30 41 35 39
12 Chartres Chartres 30 33 41 33
13 Plabennec Plabennec 30 30 37 29
14 Mantes Mantes 30 23 41 29
15 Nantes II Nantes II 30 40 40 28
16 Voltigeurs Châteaubriant Voltigeurs 30 26 48 26
TEMPORADA 2015/2016
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 QRM QRM 30 50 22 62
2 Iris Club de Croix Iris Club C. 30 55 37 55
3 Poissy Poissy 30 55 42 52
4 Sannois Gratien Sannois 30 46 39 46
5 ES Wasquehal Wasquehal 30 44 41 46
6 Arras Arras 30 43 43 41
7 Amiens AC Amiens AC 30 35 34 40
8 PSG II PSG II 30 35 40 40
9 Mantes Mantes 30 31 38 39
10 Boulogne-Billancourt Boulogne-Bil 30 43 40 38
11 Calais Calais 30 32 37 38
12 Dieppe Dieppe 30 31 24 37
13 Troyes II Troyes II 30 41 47 36
14 Lens II Lens II 30 37 45 36
15 Aubervilliers Aubervillier 30 27 47 24
16 Roye-Noyon Roye-Noyon 30 38 67 22
TEMPORADA 2014/2015
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CS Sedan CS Sedan 30 61 25 75
2 QRM QRM 30 41 32 48
3 Iris Club de Croix Iris Club C. 30 37 32 43
4 PSG II PSG II 30 35 36 43
5 Dieppe Dieppe 30 33 29 41
6 Calais Calais 30 26 35 39
7 Amiens AC Amiens AC 30 34 26 38
8 Romorantin Romorantin 30 29 35 38
9 Sannois Gratien Sannois 30 29 29 37
10 Roye-Noyon Roye-Noyon 30 24 29 37
11 Lens II Lens II 30 35 37 36
12 Arras Arras 30 37 44 36
13 Mantes Mantes 30 31 45 36
14 Lille II Lille II 30 33 36 35
15 Beauvais Oise Beauvais 30 26 28 34
16 Ivry Ivry 30 31 44 34
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Chambly Chambly 28 38 19 51
2 Lille II Lille II 28 46 26 50
3 Aubervilliers Aubervillier 29 37 35 48
4 Beauvais Oise Beauvais 28 33 27 45
5 Roye-Noyon Roye-Noyon 28 31 24 43
6 Sannois Gratien Sannois 28 34 28 41
7 Ivry Ivry 28 37 37 41
8 QRM QRM 28 32 28 38
9 Amiens AC Amiens AC 28 29 28 38
10 PSG II PSG II 28 34 35 38
11 Lens II Lens II 28 33 33 37
12 Dieppe Dieppe 28 30 32 36
13 Mantes Mantes 28 24 30 36
14 Drancy Drancy 29 20 41 22
15 Villemomble Sports Villemomble 28 16 51 14
16 Le Mans Le Mans 0 0 0 0
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 34 63 30 62
2 Raon-l'Etape Raon-l'Etape 34 53 31 62
3 Strasbourg Strasbourg 34 47 29 62
4 Lyon-Duchère Lyon-Duchèr 34 49 39 55
5 Moulins Moulins 34 51 36 54
6 FC Mulhouse FC Mulhouse 34 46 39 53
7 Villefranche Villefranche 34 44 42 47
8 PSG II PSG II 34 44 49 44
9 Yzeure Yzeure 34 37 35 43
10 Jura Sud Jura Sud 34 31 38 43
11 Sochaux II Sochaux II 34 30 34 40
12 Sarre-Union Sarre-Union 34 28 52 40
13 Belfort Belfort 34 31 37 38
14 Montceau Montceau 34 30 43 38
15 GOAL FC GOAL FC 34 37 47 37
16 Auxerre II Auxerre II 34 29 52 37
17 UJA Maccabi UJA Maccabi 34 25 33 35
18 Nancy II Nancy II 34 42 51 33
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CA Bastia CA Bastia 34 53 33 67
2 Aubervilliers Aubervillier 34 53 34 64
3 Dunkerque Dunkerque 34 50 31 63
4 Auxerre II Auxerre II 34 60 36 62
5 Drancy Drancy 34 35 32 55
6 Lens II Lens II 34 48 39 50
7 FC Calvi FC Calvi 34 58 51 50
8 Amiens AC Amiens AC 34 41 40 50
9 Ivry Ivry 34 50 40 49
10 Lille II Lille II 34 44 42 48
11 Compiègne Compiègne 34 44 52 43
12 Poissy Poissy 34 43 47 38
13 Valenciennes II Valenciennes 34 44 52 38
14 PSG II PSG II 34 32 38 35
15 Alfortville Alfortville 34 36 55 32
16 Sénart Moissy Sénart 34 22 45 31
17 Villemomble Sports Villemomble 34 24 47 30
18 Avion Avion 34 34 57 25
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Besancon RC Besancon RC 32 41 22 64
2 Épinal Épinal 32 51 22 61
3 Ivry Ivry 32 53 31 56
4 Sochaux II Sochaux II 32 49 36 53
5 Villefranche Villefranche 32 45 34 50
6 Amnéville Amnéville 32 50 45 49
7 Bourg-Péronnas Bourg-Péron 32 50 48 47
8 PSG II PSG II 32 55 41 46
9 Auxerre II Auxerre II 32 41 32 44
10 Jura Sud Jura Sud 32 35 42 44
11 Nancy II Nancy II 32 48 40 43
12 FC Mulhouse FC Mulhouse 32 45 44 41
13 Belfort Belfort 32 35 35 38
14 Raon-l'Etape Raon-l'Etape 32 39 49 37
15 Lyon-Duchère Lyon-Duchèr 32 40 51 35
16 GOAL FC GOAL FC 32 34 68 22
17 CS Louhans Cuiseaux Louhans 32 13 84 7
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Niort Niort 34 53 23 65
2 Yzeure Yzeure 34 39 29 58
3 Luçon Luçon 34 45 39 56
4 PSG II PSG II 34 37 28 54
5 Albi Albi 34 42 40 54
6 Montluçon Montluçon 34 45 36 52
7 Les Herbiers Herbiers 34 48 44 49
8 Colomiers Colomiers 34 33 29 48
9 Le Mans II Le Mans II 34 42 35 44
10 FC Libourne FC Libourne 34 35 31 44
11 Red Star Red Star 34 38 44 42
12 Pau FC Pau FC 34 30 35 39
13 Girondins Bordeaux II Girondins 34 23 32 38
14 Aurillac Arpajon Aurillac 34 26 40 38
15 Fontenay Fontenay 34 31 41 36
16 Anglet Genets Anglet 34 29 42 36
17 Balma Balma 34 28 42 30
18 Toulouse Fontaines Toulouse 34 25 39 28
TEMPORADA 2008/2009
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 FC Rouen 1899 Rouen 1899 34 56 27 65
2 Plabennec Plabennec 34 41 31 60
3 QRM QRM 34 53 31 57
4 Orléans Orléans 34 48 35 56
5 Villemomble Sports Villemomble 34 31 29 51
6 La Vitréenne Vitréenne 34 36 28 49
7 Stade Rennais II Stade 34 40 39 47
8 Racing Colombes 92 Racing 34 36 34 46
9 Caen II Caen II 34 41 43 44
10 V.Châtillon V.Châtillon 34 43 49 44
11 PSG II PSG II 34 38 44 43
12 UJA Maccabi UJA Maccabi 34 40 43 40
13 Le Havre II Le Havre II 34 39 43 39
14 Red Star Red Star 34 28 36 39
15 Quimper Cornouaille Quimper 34 28 41 39
16 Pontivy Pontivy 34 31 45 38
17 Guingamp II Guingamp II 34 35 41 37
18 Vitré Vitré 34 25 50 28
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Girondins Bordeaux II Girondins 34 56 28 63
2 Bayonne Bayonne 34 47 30 58
3 Fontenay Fontenay 34 40 33 54
4 Moulins Moulins 34 44 34 53
5 Orléans Orléans 34 44 35 50
6 Le Mans II Le Mans II 34 55 49 50
7 Anglet Genets Anglet 34 42 37 48
8 PSG II PSG II 34 28 26 48
9 St Geneviève Geneviève 34 43 50 46
10 Chatellerault Chatelleraul 33 43 49 45
11 Montluçon Montluçon 34 44 37 42
12 Stade Bordelais Stade 34 40 48 41
13 Yzeure Yzeure 33 35 44 41
14 Sénart Moissy Sénart 34 43 54 38
15 Aurillac Arpajon Aurillac 34 34 46 35
16 Nantes II Nantes II 34 27 41 35
17 Les Sables D`olonne Sables 34 29 45 34
18 Poissy Poissy 34 40 48 32
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Villemomble Sports Villemomble 34 41 29 63
2 Stade Rennais II Stade 34 57 36 57
3 Auxerre II Auxerre II 34 48 37 54
4 Guingamp II Guingamp II 34 41 38 52
5 FUSC Bois Guillaume FUSC Bois G. 34 38 27 51
6 Poissy Poissy 34 47 43 50
7 FC Rouen 1899 Rouen 1899 34 32 29 50
8 St Geneviève Geneviève 34 48 38 49
9 Pacy Vallée-d.Eure Pacy 34 35 28 49
10 Red Star Red Star 34 39 33 47
11 Sénart Moissy Sénart 34 34 29 45
12 QRM QRM 34 47 48 41
13 PSG II PSG II 33 40 42 41
14 Vitré Vitré 33 35 37 39
15 Plabennec Plabennec 34 30 38 37
16 Pontivy Pontivy 34 35 64 34
17 Dieppe Dieppe 33 27 47 28
18 Concarneau Concarneau 33 25 56 21
TEMPORADA 2005/2006
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Paris FC Paris FC 34 43 23 65
2 Stade Rennais II Stade 34 53 34 60
3 Guingamp II Guingamp II 34 46 30 54
4 FC Rouen 1899 Rouen 1899 33 44 33 52
5 Vitré Vitré 33 41 27 50
6 Villemomble Sports Villemomble 34 49 38 49
7 FUSC Bois Guillaume FUSC Bois G. 34 35 28 48
8 PSG II PSG II 33 46 43 48
9 Poissy Poissy 34 44 30 46
10 Sénart Moissy Sénart 34 36 36 43
11 Dieppe Dieppe 33 28 38 41
12 Pontivy Pontivy 34 39 51 41
13 Pacy Vallée-d.Eure Pacy 34 31 45 41
14 QRM QRM 34 35 43 39
15 St Geneviève Geneviève 34 37 44 37
16 Noisy-le-Sec Noisy-le-Sec 34 22 29 34
17 Mantes Mantes 34 24 46 28
18 Mondeville Mondeville 34 25 60 23

  USO DE MEMORIA  
7,136,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9988
Total Execution Time  1.0000
  CADENA URL  
/historico/Psg-Ii
  GET DATOS  
$_GET['/historico/Psg-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (58)  
0.0160  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 = 'Psg-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.0208  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 = 'Psg-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.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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 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=11249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=11249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=11249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=11249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=11249 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 = 68304
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11249 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11249 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (82745,237268,288292,290766,290239) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '11249' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '11249' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '11249' 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 = 68304 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=11249 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 (68304) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 68304 AND teamId = 11249
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 = 68304 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 = '11249' 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 = '11249' and rp.type = 4
0.0151  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 = '11249' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0173  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 = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 11249 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.0170  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 = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 11249 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 11249 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 11249 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68304 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.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 `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 = 63493 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.0147  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 = 57388 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.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 `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 = 50964 AND t.round = 18 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 = 44574 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 39109 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 33905 AND t.round = 30 ORDER BY team.conference 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 `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 = 15745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 4044 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 2098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 1679 AND t.round = 34 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 `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 = 19924 AND t.round = 34 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 `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 = 19929 AND t.round = 34 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 `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 = 19934 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 19938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 19942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 19946 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 68304 ORDER BY nameShow LIMIT 100