4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Toulouse II
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Paulhan/Pézenas Paulhan/Péz 26 50 34 45
2 Montpellier II Montpellier 26 44 26 44
3 Anglet Genets Anglet 26 31 31 39
4 F.C. Marmande 47 F.C. 26 39 32 37
5 Toulouse II Toulouse II 26 38 40 36
6 Niort II Niort II 26 32 26 35
7 Castanet Castanet 26 35 38 35
8 Lège-Cap-Ferret Lège-Cap-Fe 26 38 44 34
9 Limoges Limoges 26 26 32 34
10 Balma Balma 26 30 29 33
11 Aurillac Arpajon Aurillac 26 28 34 33
12 Angouleme Angouleme 26 26 34 30
13 Blagnac Blagnac 26 33 41 28
14 Villenave Villenave 26 32 41 27
TEMPORADA 2014/2015
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Bergerac Bergerac 26 33 22 51
2 Bayonne Bayonne 26 34 19 46
3 Lège-Cap-Ferret Lège-Cap-Fe 26 35 30 44
4 Toulouse II Toulouse II 26 28 17 43
5 Blagnac Blagnac 26 31 23 43
6 Fabrègues Fabrègues 26 37 35 36
7 Aurillac Arpajon Aurillac 26 19 18 35
8 Angouleme Angouleme 26 26 26 34
9 Anglet Genets Anglet 26 31 32 34
10 Villenave Villenave 26 27 36 32
11 Balma Balma 26 17 19 29
12 Agde Agde 26 15 21 28
13 Rodéo FC Toulouse Rodéo 26 31 39 26
14 Bassin d'Arcachon Sud Bassin 26 16 43 15
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Montpellier II Montpellier 26 50 24 52
2 Limoges Limoges 26 41 27 48
3 Les Genêts d.A… Genêts 26 44 33 47
4 Toulouse II Toulouse II 26 36 30 44
5 Bergerac Bergerac 26 38 31 43
6 Aurillac Arpajon Aurillac 26 39 26 40
7 Rodéo FC Toulouse Rodéo 26 27 33 36
8 Lège-Cap-Ferret Lège-Cap-Fe 26 33 28 35
9 Angouleme Angouleme 26 44 44 31
10 Balma Balma 26 30 31 31
11 Chauray Chauray 26 27 30 31
12 Bayonne Bayonne 26 24 41 27
13 Albi Albi 26 31 47 17
14 Saint-Alban Saint-Alban 26 37 76 13
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Villenave Villenave 26 40 32 47
2 Balma Balma 26 32 20 44
3 Victoria Setebul Victoria 26 36 26 44
4 Aurillac Arpajon Aurillac 26 34 19 43
5 Les Genêts d.A… Genêts 26 36 22 43
6 Bergerac Bergerac 26 25 23 36
7 Toulouse II Toulouse II 26 35 29 34
8 Saint-Alban Saint-Alban 26 32 34 34
9 Montpellier II Montpellier 26 24 22 32
10 Narbonne Narbonne 26 39 37 31
11 AS Muretaine Muretaine 26 31 42 30
12 Nîmes II Nîmes II 26 25 34 29
13 Auch Football Auch 26 34 50 24
14 Lormont Lormont 26 25 58 19
TEMPORADA 2011/2012
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Les Genêts d.A… Genêts 9 14 6 18
2 Nîmes II Nîmes II 9 12 4 17
3 AS Muretaine Muretaine 9 9 4 17
4 Balma Balma 9 9 5 17
5 Montpellier II Montpellier 9 17 11 15
6 Stade Bordelais Stade 9 13 8 14
7 Narbonne Narbonne 9 8 8 14
8 Toulouse II Toulouse II 9 12 13 14
9 SA Mérignac Mérignac 9 6 9 13
10 F.C. Marmande 47 F.C. 9 12 10 11
11 Bergerac Bergerac 9 12 13 10
12 Saint-Alban Saint-Alban 9 7 13 8
13 Blagnac Blagnac 9 11 18 8
14 SU Agen SU Agen 9 9 14 7
15 Lormont Lormont 9 11 18 7
16 Aurillac Arpajon Aurillac 9 9 17 7
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Stade Montois Stade 32 45 22 62
2 Girondins Bordeaux II Girondins 32 51 31 61
3 Stade Bordelais Stade 32 51 29 60
4 Trelissac Trelissac 32 44 29 57
5 Toulouse II Toulouse II 32 60 32 55
6 Balma Balma 32 38 27 55
7 Bergerac Bergerac 32 54 42 46
8 SA Mérignac Mérignac 32 39 36 45
9 SU Agen SU Agen 32 40 38 41
10 Saint-Alban Saint-Alban 32 37 48 41
11 Lormont Lormont 32 47 56 38
12 Blagnac Blagnac 32 42 45 36
13 Langon-Castets Langon-Caste 32 35 51 34
14 Revel Revel 32 30 50 34
15 Brive Brive 32 33 48 33
16 FC Libourne FC Libourne 32 24 49 29
17 Toulouse Fontaines Toulouse 32 28 65 18
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Béziers Béziers 30 63 36 65
2 Tarbes Tarbes 30 53 33 58
3 Toulouse II Toulouse II 30 44 28 51
4 Trelissac Trelissac 30 51 38 49
5 Bergerac Bergerac 30 45 34 44
6 SU Agen SU Agen 30 33 27 43
7 Cognac Cognac 30 50 48 40
8 Stade Montois Stade 30 36 37 40
9 Stade Bordelais Stade 30 35 28 39
10 Blagnac Blagnac 30 42 41 39
11 SA Mérignac Mérignac 30 29 46 36
12 Saint-Alban Saint-Alban 30 37 49 35
13 Cugnaux Cugnaux 30 27 45 34
14 Tournefeuille Tournefeuill 30 35 51 30
15 Bayonne II Bayonne II 30 41 58 28
16 Bassin d'Arcachon Sud Bassin 30 38 60 24
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Toulouse Fontaines Toulouse 30 43 23 58
2 Rodéo FC Toulouse Rodéo 30 36 17 58
3 Toulouse II Toulouse II 30 46 22 55
4 Trelissac Trelissac 30 38 18 51
5 Blagnac Blagnac 30 36 32 41
6 Stade Montois Stade 30 38 34 40
7 Saint-Alban Saint-Alban 30 20 21 40
8 SU Agen SU Agen 30 35 30 39
9 Tarbes Tarbes 30 32 38 39
10 Bassin d'Arcachon Sud Bassin 30 23 33 38
11 Sète II Sète II 30 38 38 37
12 Brive Brive 30 31 33 34
13 Bayonne II Bayonne II 30 25 32 34
14 Pointe Courte Pointe 30 28 47 29
15 Libourne Saint Seurin II Libourne 30 19 40 29
16 Aurillac Arpajon II Aurillac 30 26 56 20
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Cassis-Carnoux Cassis-Carno 34 49 31 69
2 Gap Gap 34 58 28 63
3 Gazélec Ajaccio Gazélec 34 37 32 57
4 Monaco II Monaco II 34 47 33 52
5 Marignane Marignane 34 41 32 51
6 Albi Albi 34 45 32 50
7 Saint-Étienne II Saint-Étien 34 33 35 47
8 Hyères Hyères 34 33 26 46
9 Sporting Toulon Var Sporting 34 36 36 46
10 Fréjus St-Raphaël Fréjus 34 41 43 46
11 CA Bastia CA Bastia 34 35 48 44
12 Luzenac Luzenac 34 49 51 43
13 Andrézieux Andrézieux 34 31 33 41
14 Balma Balma 34 34 44 39
15 Montpellier II Montpellier 34 33 43 39
16 Nice II Nice II 34 36 41 37
17 Toulouse II Toulouse II 34 31 49 29
18 Manosque Manosque 34 33 65 28
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Rodez Rodez 34 47 23 66
2 Albi Albi 34 47 33 59
3 Bayonne Bayonne 34 38 30 56
4 Girondins Bordeaux II Girondins 34 40 28 54
5 Moulins Moulins 34 40 29 54
6 Orléans Orléans 34 45 35 53
7 Le Mans II Le Mans II 34 45 33 50
8 Aurillac Arpajon Aurillac 34 46 45 49
9 Anglet Genets Anglet 33 45 43 46
10 Montluçon Montluçon 34 37 33 45
11 Toulouse II Toulouse II 34 47 41 43
12 Luzenac Luzenac 34 40 43 42
13 Nantes II Nantes II 34 44 42 40
14 Stade Bordelais Stade 33 40 57 39
15 Balma Balma 34 29 49 37
16 Les Herbiers Herbiers 34 40 49 36
17 Saint-Georges Saint-George 34 22 46 32
18 Brive Brive 34 28 61 17
TEMPORADA 2005/2006
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Yzeure Yzeure 34 56 35 61
2 Rodez Rodez 34 58 46 59
3 Saint-Étienne II Saint-Étien 34 54 36 57
4 Toulouse II Toulouse II 34 48 30 57
5 Le Mans II Le Mans II 34 54 41 55
6 Brive Brive 34 40 30 47
7 Montluçon Montluçon 34 37 43 47
8 Albi Albi 34 49 41 45
9 Orléans Orléans 33 34 34 45
10 Aurillac Arpajon Aurillac 33 37 40 45
11 Nantes II Nantes II 34 46 48 43
12 Luzenac Luzenac 34 33 42 43
13 Girondins Bordeaux II Girondins 34 31 40 40
14 Balma Balma 34 34 64 40
15 Anglet Genets Anglet 34 40 38 39
16 Andrézieux Andrézieux 34 30 35 39
17 Stade Poitevin Stade 34 29 45 35
18 Blois Blois 34 38 60 28

  USO DE MEMORIA  
6,115,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5074
Total Execution Time  0.5088
  CADENA URL  
/historico/Toulouse-Ii/2016
  GET DATOS  
$_GET['/historico/Toulouse-Ii/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0170  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 = 'Toulouse-Ii' AND l.year = 2016 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.0133  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=6788 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=6788 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6788 AND type_rel = 2
0.0145  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 = '6788' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '6788' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '6788' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 15899 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=6788 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (34013) 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 = 34013 AND teamId = 6788
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 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 = 15899 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131  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 = '6788' 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 = '6788' and rp.type = 4
0.0127  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 = '6788' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143  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 events2016 e ON e.player_id = p.id AND e.league_id = 15899 WHERE rp.league_id = 15899 AND rp.teamId = 6788 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.0140  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 events2016 e ON e.player_id = p.id AND e.league_id = 15899 WHERE rp.league_id = 15899 AND rp.teamId = 6788 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events2016 e ON e.player_id = p.id AND e.league_id = 15899 WHERE rp.league_id = 15899 AND rp.teamId = 6788 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 6788 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 15899 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 4315 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 `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 = 2545 AND t.round = 26 ORDER BY team.conference 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 `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 = 2105 AND t.round = 26 ORDER BY team.conference 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 `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 = 1688 AND t.round = 9 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 `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 = 20000 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 20008 AND t.round = 30 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 `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 = 20017 AND t.round = 30 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 `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 = 19937 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 19941 AND t.round = 34 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 `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 = 19945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC