4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tourcoing
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 4
Equipo PJ GF GC Puntos
1 ES Wasquehal Wasquehal 26 29 16 48
2 Paris II Paris II 26 45 29 43
3 Valenciennes II Valenciennes 26 37 23 41
4 Grande-Synthe Grande-Synth 26 40 29 40
5 Feignies Feignies 26 33 31 40
6 Sénart Moissy Sénart 26 33 35 40
7 Olympique St Quentin Olympique 26 33 33 33
8 Noisy-le-Sec Noisy-le-Sec 26 26 26 33
9 Aulnoye Aulnoye 26 29 33 33
10 Tourcoing Tourcoing 26 35 34 32
11 UJA Maccabi UJA Maccabi 26 27 28 32
12 Marck Marck 26 23 31 30
13 Villemomble Sports Villemomble 26 25 34 29
14 Choisy au Bac Choisy 26 25 58 13

  USO DE MEMORIA  
5,216,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4623
Total Execution Time  0.4645
  CADENA URL  
/historico/Tourcoing
  GET DATOS  
$_GET['/historico/Tourcoing']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0256  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 = 44567
0.0170  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19783 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=221 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 221 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0132  SELECT /*53 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 (1115226,1099907,1026668,943823,937135) ORDER BY n.cover_points DESC, update_date DESC
0.0143  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 = '19783' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = '19783' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 44567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=19783 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (51675,44567) 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.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 44567 AND teamId = 19783
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 51675 AND teamId = 19783
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '19783' 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 = '19783' and rp.type = 4
0.0126  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 = '19783' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 events2019 e ON e.player_id = p.id AND e.league_id = 44567 WHERE rp.league_id = 44567 AND rp.teamId = 19783 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.0136  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 events2019 e ON e.player_id = p.id AND e.league_id = 44567 WHERE rp.league_id = 44567 AND rp.teamId = 19783 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events2019 e ON e.player_id = p.id AND e.league_id = 44567 WHERE rp.league_id = 44567 AND rp.teamId = 19783 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 19783 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0132  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.0133  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.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 = 4310 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC