4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Iris Club de Croix
TEMPORADA 2023/2024
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Chantilly Chantilly 24 41 23 44
2 Lille II Lille II 24 43 27 43
3 Lens II Lens II 24 41 25 43
4 US Pays de Cassel Pays Cassel 24 41 30 41
5 Iris Club de Croix Iris Club C. 24 32 24 38
6 Sannois Gratien Sannois 24 31 27 36
7 Vimy Vimy 24 37 41 35
8 Le Pays du Valois Pays Valois 24 35 40 33
9 Drancy Drancy 24 30 26 31
10 Saint-Ouen-l'Aumône Saint-Ouen-l 24 27 31 29
11 Olympique Marcquois Olympique 24 33 45 28
12 Valenciennes II Valenciennes 24 33 42 25
13 Saint-Amand Saint-Amand 24 23 35 18
14 Compiègne Compiègne 24 25 56 17
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 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Bastia Bastia 21 37 15 53
2 CS Sedan CS Sedan 21 27 4 48
3 Bobigny Bobigny 21 35 12 45
4 Stade de Reims II Stade Reims 21 39 30 36
5 St Geneviève Geneviève 21 30 25 34
6 Épinal Épinal 21 22 15 30
7 Lens II Lens II 21 26 27 28
8 Maur Lusitanos Maur 21 22 23 24
9 Olympique St Quentin Olympique 21 23 27 23
10 FCSR Haguenau FCSR 21 21 29 23
11 Schiltigheim Schiltigheim 21 26 36 22
12 FC Mulhouse FC Mulhouse 21 17 27 20
13 Belfort Belfort 21 24 34 19
14 Lille II Lille II 21 12 21 18
15 Drancy Drancy 21 16 28 17
16 Iris Club de Croix Iris Club C. 21 17 41 16
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Creteil Creteil 30 55 21 59
2 Lille II Lille II 30 53 33 56
3 CS Sedan CS Sedan 30 39 29 47
4 Maur Lusitanos Maur 30 53 39 46
5 St Geneviève Geneviève 30 38 39 45
6 Iris Club de Croix Iris Club C. 30 38 44 43
7 Schiltigheim Schiltigheim 30 40 38 42
8 Épinal Épinal 30 33 37 42
9 Stade de Reims II Stade Reims 30 34 36 41
10 US Fleury-Merogis Fleury-Merog 30 48 50 39
11 Belfort Belfort 30 24 31 35
12 Bobigny Bobigny 30 33 44 35
13 Lens II Lens II 30 45 47 34
14 FCSR Haguenau FCSR 30 35 42 31
15 Feignies Feignies 30 33 43 31
16 Arras Arras 30 35 63 21
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Drancy Drancy 30 41 17 59
2 CS Sedan CS Sedan 30 52 30 56
3 St Geneviève Geneviève 30 41 31 54
4 US Fleury-Merogis Fleury-Merog 30 45 34 51
5 Arras Arras 30 46 37 48
6 Maur Lusitanos Maur 30 37 33 46
7 Bastia-Borgo Bastia-Borgo 30 33 24 44
8 Poissy Poissy 30 34 36 40
9 Iris Club de Croix Iris Club C. 30 26 32 36
10 Lille II Lille II 30 39 48 34
11 Lens II Lens II 30 46 48 34
12 Stade de Reims II Stade Reims 30 41 43 32
13 Furiani Agliani Furiani 30 31 48 32
14 Amiens AC Amiens AC 30 18 28 30
15 V.Châtillon V.Châtillon 30 28 50 29
16 Beauvais Oise Beauvais 30 31 50 24
TEMPORADA 2016/2017
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Sannois Gratien Sannois 30 52 20 58
2 US Fleury-Merogis Fleury-Merog 30 36 22 57
3 Maur Lusitanos Maur 30 36 20 54
4 Boulogne-Billancourt Boulogne-Bil 30 48 42 49
5 Arras Arras 30 47 34 46
6 Lens II Lens II 30 36 37 44
7 Drancy Drancy 30 28 22 39
8 Lille II Lille II 30 36 35 39
9 Iris Club de Croix Iris Club C. 30 34 36 38
10 V.Châtillon V.Châtillon 30 37 40 36
11 Le Havre II Le Havre II 30 36 43 36
12 Amiens AC Amiens AC 30 30 40 33
13 Poissy Poissy 30 37 44 32
14 Calais Calais 30 38 57 31
15 ES Wasquehal Wasquehal 30 23 36 29
16 Dieppe Dieppe 30 21 47 28
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 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 28 63 13 69
2 CS Sedan CS Sedan 26 52 19 58
3 Poissy Poissy 28 37 27 45
4 Feignies Feignies 27 42 33 36
5 ES Wasquehal Wasquehal 27 36 37 35
6 Olympique St Quentin Olympique 28 26 37 35
7 Sénart Moissy Sénart 28 36 41 33
8 Valenciennes II Valenciennes 28 33 39 33
9 Evry Evry 27 35 44 33
10 Paris II Paris II 27 41 44 32
11 Aulnoye Aulnoye 28 38 62 32
12 RC Épernay Champagne Épernay 27 18 32 29
13 Stade de Reims II Stade Reims 27 36 46 26
14 Compiègne Compiègne 28 16 61 12
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 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 9 13 3 20
2 ES Wasquehal Wasquehal 9 21 11 19
3 US Fleury-Merogis Fleury-Merog 9 15 12 17
4 Sedan II Sedan II 9 19 12 16
5 Roye-Noyon Roye-Noyon 9 14 10 16
6 Feignies Feignies 9 12 6 15
7 Stade de Reims II Stade Reims 9 10 8 15
8 Sézanne Sézanne 9 17 16 14
9 Troyes II Troyes II 9 16 14 13
10 Arras Arras 9 11 14 11
11 Racing Colombes 92 Racing 9 9 15 11
12 St Geneviève Geneviève 9 10 14 9
13 Fresnoy-Saint-Quentin Fresnoy-Sain 9 6 10 8
14 Paris II Paris II 9 9 16 8
15 Saint-Dizier Saint-Dizier 9 5 11 5
16 Créteil II Créteil II 9 7 22 2

  USO DE MEMORIA  
6,469,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1190
Total Execution Time  0.1207
  CADENA URL  
/historico/Iris-Club-Croix
  GET DATOS  
$_GET['/historico/Iris-Club-Croix']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6737 AND type_rel = 2
0.0030  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 = '6737' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '6737' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73250 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=6737 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74470,73250) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73250 AND teamId = 6737
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6737
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73250 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '6737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6737' and rp.type = 4
0.0026  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 = '6737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0062  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73250 WHERE rp.league_id = 73250 AND rp.teamId = 6737 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.0065  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73250 WHERE rp.league_id = 73250 AND rp.teamId = 6737 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73250 WHERE rp.league_id = 73250 AND rp.teamId = 6737 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 6737 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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.0035  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.0035  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.0036  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 = 50567 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 44575 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39110 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33906 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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.0026  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.0022  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 = 2541 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0022  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 = 1684 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC