4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 GOAL FC GOAL FC 9 18 10 17
2 Aubagne Aubagne 9 15 10 17
3 Sporting Toulon Var Sporting 9 15 8 16
4 FC Martigues Martigues 8 15 9 16
5 Fréjus St-Raphaël Fréjus 8 9 2 15
6 Andrézieux Andrézieux 9 15 11 14
7 Hyères Hyères 9 10 12 13
8 Grasse Grasse 8 10 6 12
9 Saint-Priest Saint-Priest 9 14 14 12
10 Olympique Lyonnais II Olympique 9 12 14 10
11 Rumilly Vallières Rumilly 8 10 13 9
12 CS Louhans Cuiseaux Louhans 8 11 12 8
13 Monaco II Monaco II 9 9 18 8
14 Marignane Gignac Marignane 8 8 17 6
15 Olympique Marseille II Olympique 9 6 17 6
16 Jura Sud Jura Sud 5 6 10 2
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Sète Sète 21 33 15 49
2 Blois Blois 20 24 20 38
3 Les Herbiers Herbiers 20 29 19 35
4 Bergerac Bergerac 20 21 15 33
5 Colomiers Colomiers 20 28 19 31
6 Bourges Foot Bourges Foot 21 25 21 31
7 Saint-Pryve Saint-Pryve 21 25 26 31
8 Angouleme Angouleme 21 32 26 30
9 Nantes II Nantes II 21 23 19 28
10 Romorantin Romorantin 21 25 20 25
11 Andrézieux Andrézieux 21 26 25 23
12 Trelissac Trelissac 21 18 22 22
13 Montpellier II Montpellier 21 25 38 22
14 Chamalières Chamalières 19 18 25 21
15 Saint-Étienne II Saint-Étien 21 19 32 18
16 Stade Bordelais Stade 21 18 47 9
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 28 47 15 66
2 Le Puy Le Puy 28 40 15 57
3 Annecy Annecy 28 50 32 50
4 Olympique Lyonnais II Olympique 28 54 44 46
5 Jura Sud Jura Sud 28 44 38 44
6 Villefranche Villefranche 28 34 34 40
7 Stade de Reims II Stade Reims 28 43 41 36
8 Andrézieux Andrézieux 28 37 44 33
9 Raon-l'Etape Raon-l'Etape 28 37 49 32
10 GOAL FC GOAL FC 28 29 37 31
11 Saint-Louis Neuweg Saint-Louis 28 30 44 31
12 Yzeure Yzeure 28 28 38 29
13 Montceau Montceau 28 35 48 28
14 FC Mulhouse FC Mulhouse 28 30 43 26
15 Auxerre II Auxerre II 28 35 51 25
16 Evian Thonon Gaillard Evian Thonon 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Pau FC Pau FC 28 38 19 58
2 Monaco II Monaco II 28 55 35 48
3 Colomiers Colomiers 28 32 27 48
4 Nice II Nice II 28 42 36 45
5 Stade Montois Stade 28 33 30 43
6 FC Martigues Martigues 28 25 29 37
7 Marignane Marignane 28 32 39 37
8 Hyères Hyères 28 32 29 36
9 Olympique Marseille II Olympique 28 33 33 34
10 US Le Pontet Pontet 28 38 40 34
11 LAS Toulon LAS Toulon 28 27 34 34
12 Tarbes Tarbes 28 28 36 34
13 Rodez Rodez 28 25 27 31
14 Sète Sète 28 23 29 30
15 Bayonne Bayonne 28 23 43 20
16 Arles Arles 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Béziers Béziers 30 45 24 60
2 Grenoble Grenoble 30 43 19 59
3 Olympique Lyonnais II Olympique 30 44 28 52
4 FC Martigues Martigues 30 39 30 48
5 Marignane Marignane 30 35 25 45
6 Rodez Rodez 30 40 49 40
7 Villefranche Villefranche 30 30 40 40
8 Sète Sète 30 30 34 39
9 Nice II Nice II 30 39 46 37
10 Monaco II Monaco II 30 41 35 36
11 GOAL FC GOAL FC 30 27 40 34
12 Lyon-Duchère Lyon-Duchèr 30 35 35 33
13 US Le Pontet Pontet 30 36 40 33
14 Hyères Hyères 30 26 33 32
15 Montpellier II Montpellier 30 31 47 27
16 Saint-Priest Saint-Priest 30 25 41 26
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Athlético Marseille Athlético 29 48 26 50
2 Rodez Rodez 28 38 27 50
3 Grenoble Grenoble 28 41 26 46
4 Hyères Hyères 28 31 32 45
5 Pau FC Pau FC 29 33 27 44
6 Cannes Cannes 29 34 30 40
7 FC Martigues Martigues 28 30 29 37
8 Monaco II Monaco II 28 43 42 36
9 Béziers Béziers 28 35 32 35
10 Marignane Marignane 28 29 35 35
11 Nice II Nice II 29 34 41 34
12 US Le Pontet Pontet 28 23 36 33
13 Tarbes Tarbes 28 24 35 31
14 Valence Valence 28 26 34 30
15 Stade Montois Stade 28 29 46 24
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Colomiers Colomiers 34 42 17 65
2 Cannes Cannes 34 50 24 59
3 Hyères Hyères 34 39 27 57
4 FC Martigues Martigues 34 46 31 55
5 Olympique Lyonnais II Olympique 34 52 34 52
6 Marignane Marignane 34 40 34 49
7 Athlético Marseille Athlético 34 55 52 49
8 Rodez Rodez 34 38 50 48
9 Béziers Béziers 34 37 37 46
10 Monaco II Monaco II 34 46 40 45
11 US Le Pontet Pontet 34 46 47 44
12 Tarbes Tarbes 34 38 53 44
13 Valence Valence 34 35 44 42
14 Pau FC Pau FC 34 41 45 41
15 Albi Albi 34 41 57 35
16 Stade Montois Stade 34 42 61 35
17 Bayonne Bayonne 34 21 36 33
18 Saint-Étienne II Saint-Étien 34 24 44 25
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Uzès Pont du Gard Uzès Pont G. 34 55 29 70
2 Rodez Rodez 34 43 26 60
3 Monaco II Monaco II 34 56 46 56
4 Cannes Cannes 33 53 36 54
5 Colomiers Colomiers 34 45 30 53
6 Hyères Hyères 34 40 43 53
7 Saint-Étienne II Saint-Étien 34 57 35 52
8 Girondins Bordeaux II Girondins 34 34 32 49
9 Stade Montois Stade 34 39 35 46
10 Tarbes Tarbes 34 44 41 46
11 Agde Agde 34 38 35 44
12 Athlético Marseille Athlético 33 35 47 43
13 Pau FC Pau FC 34 33 35 42
14 Marignane Marignane 34 40 53 41
15 Béziers Béziers 34 39 50 40
16 US Le Pontet Pontet 34 45 57 36
17 Albi Albi 34 34 51 31
18 Gap Gap 34 22 71 10
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Gazélec Ajaccio Gazélec 34 51 32 68
2 FC Martigues Martigues 34 57 28 64
3 Pau FC Pau FC 34 56 33 61
4 Olympique Lyonnais II Olympique 34 53 41 53
5 Monaco II Monaco II 34 49 41 50
6 Sporting Toulon Var Sporting 34 41 40 49
7 Colomiers Colomiers 34 46 40 45
8 Saint-Étienne II Saint-Étien 34 50 49 45
9 Albi Albi 34 44 49 45
10 Hyères Hyères 34 47 47 44
11 US Le Pontet Pontet 34 61 63 44
12 Uzès Pont du Gard Uzès Pont G. 34 38 40 42
13 Agde Agde 34 37 46 41
14 Marignane Marignane 34 28 36 40
15 Tarbes Tarbes 34 38 42 39
16 Béziers Béziers 34 42 51 39
17 Aurillac Arpajon Aurillac 34 33 57 29
18 Anglet Genets Anglet 34 32 68 27
Ver
TEMPORADA 2009/2010
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
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Luzenac Luzenac 34 59 26 69
2 Moulins Moulins 34 56 41 62
3 Pau FC Pau FC 34 42 25 60
4 Fontenay Fontenay 34 37 32 57
5 Yzeure Yzeure 34 60 43 54
6 Girondins Bordeaux II Girondins 34 41 35 52
7 Romorantin Romorantin 34 49 49 49
8 Le Mans II Le Mans II 34 35 33 48
9 Luçon Luçon 34 39 37 47
10 Aurillac Arpajon Aurillac 34 48 44 44
11 Colomiers Colomiers 34 33 32 41
12 Montluçon Montluçon 34 43 54 39
13 Balma Balma 34 47 54 36
14 Albi Albi 34 27 42 36
15 Anglet Genets Anglet 34 35 53 35
16 Chatellerault Chatelleraul 34 50 66 34
17 Stade Bordelais Stade 34 27 47 32
18 Bergerac Bergerac 34 32 47 28
Ver
TEMPORADA 2007/2008
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
Ver
TEMPORADA 2006/2007
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
Ver
TEMPORADA 2005/2006
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  
7,188,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.5487
Total Execution Time  0.5514
  CADENA URL  
/ligue_cfa2021/grupo3/historico
  GET DATOS  
$_GET['/ligue_cfa2021/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57115 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 220 AND group_code = 3 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 57115 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.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 = 50569 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.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 `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.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 `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 = 33907 AND t.round = 30 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 `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 = 4379 AND t.round = 30 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 `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 = 2538 AND t.round = 30 ORDER BY team.conference 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 `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 = 2099 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 `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 = 1681 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 = 19925 AND t.round = 34 ORDER BY team.conference 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 `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 = 19933 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 `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.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 `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.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 = 19945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0198  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57115 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57115 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0380  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57115 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57115 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0171  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57115 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57115 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0172  SELECT *,(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 = 57115 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