4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Caen II
TEMPORADA 2023/2024
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Villers Houlgate CF Villers 23 42 31 46
2 Alençon Alençon 24 43 31 44
3 Chatou Chatou 24 38 27 41
4 Saint-Lô Manche Saint-Lô 24 37 32 38
5 Caen PTT Caen PTT 24 30 24 35
6 Dives Dives 24 32 32 35
7 Dieppe Dieppe 24 30 30 34
8 Caen II Caen II 24 41 34 33
9 FC Flérien FC Flérien 24 37 44 30
10 AG Caennaise Caennaise 24 34 46 29
11 Le Havre II Le Havre II 24 29 36 26
12 Oissel Oissel 24 26 32 25
13 Les Mureaux Les Mureaux 23 23 30 22
14 QRM II QRM II 24 24 37 22
TEMPORADA 2022/2023
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 FC Rouen 1899 Rouen 1899 30 58 29 69
2 Chambly Chambly 30 52 25 57
3 Racing Paris Racing Paris 29 64 29 56
4 Voltigeurs Châteaubriant Voltigeurs 30 33 29 48
5 Saint-Malo Saint-Malo 30 41 37 43
6 Poissy Poissy 29 43 37 41
7 Blois Blois 30 46 42 39
8 Beauvais Oise Beauvais 30 41 37 39
9 Saint-Pryve Saint-Pryve 29 28 31 39
10 Granville Granville 30 42 47 37
11 Guingamp II Guingamp II 29 34 47 34
12 Evreux 27 Evreux 27 29 46 56 31
13 Stade Rennais II Stade 29 37 63 25
14 Vannes Vannes 30 47 58 24
15 Caen II Caen II 30 37 62 24
16 Chartres Chartres 30 33 53 23
TEMPORADA 2021/2022
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Versailles Versailles 30 47 16 64
2 Lorient II Lorient II 30 49 22 56
3 Chartres Chartres 30 53 49 50
4 FC Rouen 1899 Rouen 1899 30 38 28 47
5 Blois Blois 30 52 56 43
6 Saint-Pryve Saint-Pryve 30 37 38 42
7 Vannes Vannes 30 42 43 39
8 Voltigeurs Châteaubriant Voltigeurs 30 29 33 38
9 Granville Granville 30 38 32 38
10 Guingamp II Guingamp II 30 41 48 38
11 Saint-Malo Saint-Malo 30 33 38 36
12 Poissy Poissy 30 33 40 36
13 Romorantin Romorantin 30 37 40 35
14 Caen II Caen II 30 29 41 35
15 Plabennec Plabennec 30 29 45 27
16 Vitré Vitré 30 35 53 25
TEMPORADA 2020/2021
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Saint-Pryve Saint-Pryve 8 12 3 20
2 Voltigeurs Châteaubriant Voltigeurs 9 12 8 16
3 St Geneviève Geneviève 9 10 6 16
4 Caen II Caen II 9 10 7 15
5 Granville Granville 9 8 6 15
6 US Fleury-Merogis Fleury-Merog 9 7 6 13
7 Chartres Chartres 9 13 11 12
8 Plabennec Plabennec 9 11 13 12
9 FC Rouen 1899 Rouen 1899 8 4 4 10
10 Versailles Versailles 9 11 13 10
11 Guingamp II Guingamp II 9 7 9 9
12 Lorient II Lorient II 9 5 8 9
13 Vannes Vannes 8 9 10 8
14 Saint-Malo Saint-Malo 9 8 10 8
15 Blois Blois 8 11 15 8
16 Poissy Poissy 9 6 15 2
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 9
Equipo PJ GF GC Puntos
1 Caen II Caen II 18 31 20 39
2 Evreux 27 Evreux 27 17 25 18 30
3 Saint-Lô Manche Saint-Lô 16 37 23 29
4 Cherbourg Cherbourg 16 31 20 29
5 Le Havre II Le Havre II 16 28 15 28
6 AG Caennaise Caennaise 17 24 25 26
7 Alençon Alençon 16 33 26 23
8 Avranches II Avranches 17 29 38 22
9 Dieppe Dieppe 16 23 26 21
10 AF Virois AF Virois 14 23 22 20
11 QRM II QRM II 17 23 36 17
12 Grand-Quevilly Grand-Quevil 17 28 36 15
13 Pacy Ménilles Pacy 17 22 41 13
14 Gonfreville Gonfreville 16 19 30 7
TEMPORADA 2018/2019
NATIONAL 3 GRUPO 9
Equipo PJ GF GC Puntos
1 FC Rouen 1899 Rouen 1899 26 42 10 60
2 Evreux 27 Evreux 27 25 48 24 50
3 Alençon Alençon 26 43 35 44
4 Caen II Caen II 26 42 36 39
5 Saint-Lô Manche Saint-Lô 26 42 36 39
6 Gonfreville Gonfreville 26 43 39 37
7 Dieppe Dieppe 26 33 36 37
8 Avranches II Avranches 25 42 39 32
9 QRM II QRM II 26 35 37 30
10 Caen PTT Caen PTT 26 44 50 29
11 Cherbourg Cherbourg 26 35 46 28
12 Pacy Ménilles Pacy 26 31 51 28
13 Bayeux Bayeux 26 27 44 24
14 Amicale Laïque Amicale 26 26 50 22
TEMPORADA 2017/2018
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Oissel Oissel 26 52 26 59
2 Mondeville Mondeville 26 46 19 56
3 Evreux 27 Evreux 27 26 51 27 46
4 Saint-Lô Manche Saint-Lô 26 43 26 43
5 Caen II Caen II 26 44 35 38
6 QRM II QRM II 26 42 38 37
7 Avranches II Avranches 26 37 41 36
8 Gonfreville Gonfreville 26 33 41 35
9 Pacy Ménilles Pacy 26 27 35 33
10 Alençon Alençon 26 39 39 31
11 Dieppe Dieppe 26 38 46 28
12 FC Rouen 1899 II Rouen 1899 26 25 35 28
13 Bayeux Bayeux 26 41 62 27
14 Dives Dives 26 24 72 12
TEMPORADA 2016/2017
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Saint-Pryve Saint-Pryve 26 54 24 55
2 Le Mans Le Mans 26 47 23 51
3 Avoine OCC Avoine OCC 26 33 25 46
4 Oissel Oissel 26 44 36 42
5 Tours II Tours II 26 49 42 40
6 Aubervilliers Aubervillier 26 39 35 37
7 Caen II Caen II 26 40 46 36
8 Blois Blois 26 38 35 35
9 Evreux 27 Evreux 27 26 23 35 29
10 Drouais Drouais 26 28 42 29
11 Bourges 18 Bourges 18 26 31 39 27
12 Avranches II Avranches 26 36 49 25
13 QRM II QRM II 26 26 39 25
14 UJA Maccabi UJA Maccabi 26 26 44 24
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Le Havre II Le Havre II 26 52 25 53
2 Saint-Ouen-l'Aumône Saint-Ouen-l 26 28 16 43
3 Beauvais Oise Beauvais 26 26 23 41
4 Evreux 27 Evreux 27 26 31 28 39
5 Caen II Caen II 26 44 42 39
6 St Geneviève Geneviève 26 39 27 37
7 Drouais Drouais 26 35 34 36
8 Oissel Oissel 26 37 37 35
9 Sénart Moissy Sénart 26 28 34 35
10 Ajaccio II Ajaccio II 26 49 39 34
11 Paris II Paris II 26 27 33 33
12 UJA Maccabi UJA Maccabi 26 30 38 32
13 Caen PTT Caen PTT 26 31 44 28
14 Gonfreville Gonfreville 26 19 56 9
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 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Luçon Luçon 34 68 45 63
2 Trelissac Trelissac 34 58 39 61
3 Les Herbiers Herbiers 34 51 30 57
4 Saint-Malo Saint-Malo 34 50 31 54
5 Romorantin Romorantin 34 39 31 52
6 Girondins Bordeaux II Girondins 34 51 44 52
7 Avranches Avranches 34 50 35 51
8 Pontivy Pontivy 34 40 36 50
9 Concarneau Concarneau 34 44 44 49
10 Fontenay Fontenay 34 41 38 48
11 Le Mans II Le Mans II 34 44 53 44
12 V.Châtillon V.Châtillon 34 36 51 44
13 Stade Bordelais Stade 34 49 53 42
14 Plabennec Plabennec 34 37 46 42
15 Caen II Caen II 34 45 51 41
16 Lorient II Lorient II 34 40 57 37
17 Le Havre II Le Havre II 34 31 47 34
18 Saumur Saumur 34 33 76 19
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Carquefou Carquefou 34 53 23 71
2 Luçon Luçon 34 63 38 71
3 Avranches Avranches 34 53 33 63
4 Plabennec Plabennec 34 55 40 56
5 Romorantin Romorantin 34 58 33 55
6 Les Herbiers Herbiers 34 39 40 51
7 Concarneau Concarneau 34 49 44 46
8 Mantes Mantes 34 45 45 45
9 Saumur Saumur 34 39 43 43
10 Le Havre II Le Havre II 34 46 55 43
11 V.Châtillon V.Châtillon 34 43 45 41
12 Le Mans II Le Mans II 34 41 47 41
13 Fontenay Fontenay 34 30 43 39
14 Pacy Vallée-d.Eure Pacy 34 34 50 39
15 Caen II Caen II 34 34 42 38
16 Pontivy Pontivy 34 29 37 37
17 Lorient II Lorient II 34 38 55 36
18 La Vitréenne Vitréenne 34 24 60 24
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Le Poiré-sur-Vie Poiré-sur-V 32 47 24 59
2 Cherbourg Cherbourg 32 42 37 49
3 La Vitréenne Vitréenne 32 39 26 48
4 Les Herbiers Herbiers 32 48 36 46
5 Carquefou Carquefou 32 42 36 46
6 Yzeure Yzeure 32 30 26 44
7 Moulins Moulins 32 42 43 44
8 Le Mans II Le Mans II 32 44 38 42
9 Avranches Avranches 32 32 31 42
10 V.Châtillon V.Châtillon 32 36 39 42
11 Romorantin Romorantin 32 43 44 41
12 Luçon Luçon 32 36 43 40
13 Lorient II Lorient II 32 39 42 39
14 Fontenay Fontenay 32 34 43 39
15 Caen II Caen II 32 40 55 38
16 Saint-Pryve Saint-Pryve 32 40 53 36
17 Stade Rennais II Stade 32 27 45 29
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Orléans Orléans 34 43 21 69
2 La Vitréenne Vitréenne 34 49 33 61
3 Le Havre II Le Havre II 34 59 39 59
4 Cherbourg Cherbourg 34 45 33 59
5 Racing Colombes 92 Racing 34 46 36 50
6 QRM QRM 34 52 46 48
7 Romorantin Romorantin 34 59 57 47
8 V.Châtillon V.Châtillon 34 50 58 47
9 Ivry Ivry 34 40 37 46
10 Sénart Moissy Sénart 34 49 47 45
11 Carquefou Carquefou 34 37 42 45
12 Auxerre II Auxerre II 34 47 44 44
13 Stade Rennais II Stade 34 33 41 42
14 Avranches Avranches 34 37 44 41
15 Caen II Caen II 34 46 45 39
16 Mantes Mantes 34 35 49 37
17 Pontivy Pontivy 34 36 57 25
18 Quimper Cornouaille Quimper 34 23 57 25
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 1
Equipo PJ GF GC Puntos
1 Pacy Vallée-d.Eure Pacy 34 51 31 62
2 FC Rouen 1899 Rouen 1899 34 43 26 60
3 QRM QRM 34 49 38 56
4 Dunkerque Dunkerque 34 55 42 55
5 Lille II Lille II 34 48 37 52
6 Racing Colombes 92 Racing 34 42 45 49
7 Caen II Caen II 34 41 41 48
8 Vitré Vitré 34 37 47 48
9 La Vitréenne Vitréenne 34 29 28 47
10 Guingamp II Guingamp II 34 46 38 46
11 Compiègne Compiègne 34 39 42 46
12 Lens II Lens II 34 47 48 45
13 Stade Rennais II Stade 34 40 39 44
14 Le Havre II Le Havre II 34 43 41 42
15 Plabennec Plabennec 34 30 44 40
16 Lesquin Lesquin 34 43 46 39
17 ES Wasquehal Wasquehal 34 32 43 35
18 Valenciennes II Valenciennes 34 29 68 17

  USO DE MEMORIA  
6,907,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6562
Total Execution Time  0.6576
  CADENA URL  
/historico/Caen-Ii
  GET DATOS  
$_GET['/historico/Caen-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0135  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 = 'Caen-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.0125  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=6701 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6701 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73249
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6701 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6701 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  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 (593117,622910) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '6701' ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '6701' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0145  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 = '6701' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 73249 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=6701 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (73249,68291) 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.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 68291 AND teamId = 6701
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73249 AND teamId = 6701
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 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 = 73249 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '6701' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6701' and rp.type = 4
0.0128  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 = '6701' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 = 73249 WHERE rp.league_id = 73249 AND rp.teamId = 6701 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.0137  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 = 73249 WHERE rp.league_id = 73249 AND rp.teamId = 6701 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 73249 WHERE rp.league_id = 73249 AND rp.teamId = 6701 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 6701 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 `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 = 73249 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 68291 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 63479 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 57113 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 50962 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.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 `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 = 44568 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 39135 AND t.round = 26 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 `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 = 34008 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 15905 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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.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 `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.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 `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 = 2100 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 `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 = 1682 AND t.round = 34 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 `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 = 19926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 19930 AND t.round = 34 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 `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.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 `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 = 19935 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC