4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
01 Jul 37 LensLens 4 - 3 Olympique MarseilleOlympique ...
01 Jul 37 SèteSète 2 - 2 Racing ParisRacing ...
01 Jul 37 CannesCannes 2 - 3 StrasbourgStrasbourg ...
01 Jul 37 ValenciennesValencienne 0 - 0 SochauxSochaux ...
01 Jul 37 Fives LilleFives Lille 3 - 1 AntibesAntibes ...
01 Jul 37 Red StarRed Star 2 - 2 Excelsior RoubaixExcelsior ...
01 Jul 37 MetzMetz 1 - 0 Olympique LilloisOlympique ...
01 Jul 37 RC RoubaixRC Roubaix 0 - 3 FC Rouen 1899Rouen 1899 ...
Jornada 2
01 Jul 37 Olympique MarseilleOlympique 2 - 2 CannesCannes ...
01 Jul 37 FC Rouen 1899Rouen 1899 4 - 0 Red StarRed Star ...
01 Jul 37 MetzMetz 4 - 0 StrasbourgStrasbourg ...
01 Jul 37 Excelsior RoubaixExcelsior 1 - 1 LensLens ...
01 Jul 37 SochauxSochaux 6 - 2 Fives LilleFives Lille ...
01 Jul 37 Racing ParisRacing 2 - 1 RC RoubaixRC Roubaix ...
01 Jul 37 Olympique LilloisOlympique 0 - 1 ValenciennesValencienne ...
01 Jul 37 AntibesAntibes 1 - 1 SèteSète ...
Jornada 3
01 Jul 37 LensLens 2 - 2 CannesCannes ...
01 Jul 37 StrasbourgStrasbourg 2 - 2 Olympique MarseilleOlympique ...
01 Jul 37 Red StarRed Star 2 - 2 MetzMetz ...
01 Jul 37 SochauxSochaux 5 - 0 FC Rouen 1899Rouen 1899 ...
01 Jul 37 SèteSète 1 - 0 Fives LilleFives Lille ...
01 Jul 37 AntibesAntibes 2 - 2 Racing ParisRacing ...
01 Jul 37 RC RoubaixRC Roubaix 3 - 2 ValenciennesValencienne ...
01 Jul 37 Olympique LilloisOlympique 1 - 1 Excelsior RoubaixExcelsior ...
Jornada 4
01 Jul 37 CannesCannes 5 - 5 Red StarRed Star ...
01 Jul 37 ValenciennesValencienne 0 - 0 SèteSète ...
01 Jul 37 Racing ParisRacing 0 - 3 StrasbourgStrasbourg ...
01 Jul 37 FC Rouen 1899Rouen 1899 2 - 0 AntibesAntibes ...
01 Jul 37 Olympique MarseilleOlympique 4 - 0 Olympique LilloisOlympique ...
01 Jul 37 MetzMetz 1 - 1 RC RoubaixRC Roubaix ...
01 Jul 37 Fives LilleFives Lille 2 - 1 LensLens ...
01 Jul 37 Excelsior RoubaixExcelsior 1 - 2 SochauxSochaux ...
Jornada 5
01 Jul 37 SèteSète 4 - 1 MetzMetz ...
01 Jul 37 StrasbourgStrasbourg 3 - 3 FC Rouen 1899Rouen 1899 ...
01 Jul 37 LensLens 2 - 1 ValenciennesValencienne ...
01 Jul 37 SochauxSochaux 1 - 2 Olympique MarseilleOlympique ...
01 Jul 37 AntibesAntibes 4 - 2 Excelsior RoubaixExcelsior ...
01 Jul 37 Red StarRed Star 3 - 2 Fives LilleFives Lille ...
01 Jul 37 Olympique LilloisOlympique 0 - 1 Racing ParisRacing ...
01 Jul 37 RC RoubaixRC Roubaix 4 - 1 CannesCannes ...
Jornada 6
01 Jul 37 Red StarRed Star 2 - 0 ValenciennesValencienne ...
01 Jul 37 MetzMetz 1 - 1 LensLens ...
01 Jul 37 SochauxSochaux 4 - 0 Racing ParisRacing ...
01 Jul 37 CannesCannes 3 - 4 SèteSète ...
01 Jul 37 Olympique MarseilleOlympique 1 - 0 AntibesAntibes ...
01 Jul 37 FC Rouen 1899Rouen 1899 0 - 0 Olympique LilloisOlympique ...
01 Jul 37 Fives LilleFives Lille 3 - 0 RC RoubaixRC Roubaix ...
01 Jul 37 Excelsior RoubaixExcelsior 3 - 2 StrasbourgStrasbourg ...
Jornada 7
01 Jul 37 ValenciennesValencienne 5 - 2 MetzMetz ...
01 Jul 37 StrasbourgStrasbourg 1 - 6 SochauxSochaux ...
01 Jul 37 LensLens 0 - 2 SèteSète ...
01 Jul 37 FC Rouen 1899Rouen 1899 2 - 2 Olympique MarseilleOlympique ...
01 Jul 37 Fives LilleFives Lille 1 - 1 CannesCannes ...
01 Jul 37 Racing ParisRacing 5 - 1 Excelsior RoubaixExcelsior ...
01 Jul 37 AntibesAntibes 0 - 0 Olympique LilloisOlympique ...
01 Jul 37 RC RoubaixRC Roubaix 0 - 0 Red StarRed Star ...
Jornada 8
01 Jul 37 ValenciennesValencienne 0 - 1 CannesCannes ...
01 Jul 37 Racing ParisRacing 3 - 3 Olympique MarseilleOlympique ...
01 Jul 37 SèteSète 3 - 1 Red StarRed Star ...
01 Jul 37 MetzMetz 0 - 0 Fives LilleFives Lille ...
01 Jul 37 Olympique LilloisOlympique 0 - 0 SochauxSochaux ...
01 Jul 37 AntibesAntibes 1 - 2 StrasbourgStrasbourg ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 0 FC Rouen 1899Rouen 1899 ...
01 Jul 37 LensLens 2 - 1 RC RoubaixRC Roubaix ...
Jornada 9
01 Jul 37 CannesCannes 4 - 0 MetzMetz ...
01 Jul 37 Red StarRed Star 0 - 1 LensLens ...
01 Jul 37 FC Rouen 1899Rouen 1899 3 - 1 Racing ParisRacing ...
01 Jul 37 Olympique MarseilleOlympique 1 - 1 Excelsior RoubaixExcelsior ...
01 Jul 37 SochauxSochaux 1 - 0 AntibesAntibes ...
01 Jul 37 StrasbourgStrasbourg 0 - 0 Olympique LilloisOlympique ...
01 Jul 37 Fives LilleFives Lille 2 - 2 ValenciennesValencienne ...
01 Jul 37 RC RoubaixRC Roubaix 1 - 1 SèteSète ...
Jornada 10
01 Jul 37 SèteSète 3 - 0 StrasbourgStrasbourg ...
01 Jul 37 Red StarRed Star 0 - 1 SochauxSochaux ...
01 Jul 37 CannesCannes 2 - 2 Racing ParisRacing ...
01 Jul 37 MetzMetz 1 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 LensLens 2 - 4 AntibesAntibes ...
01 Jul 37 ValenciennesValencienne 1 - 1 Excelsior RoubaixExcelsior ...
01 Jul 37 RC RoubaixRC Roubaix 3 - 0 Olympique LilloisOlympique ...
01 Jul 37 Fives LilleFives Lille 2 - 1 Olympique MarseilleOlympique ...
Jornada 11
01 Jul 37 Olympique MarseilleOlympique 1 - 0 Red StarRed Star ...
01 Jul 37 FC Rouen 1899Rouen 1899 3 - 1 SèteSète ...
01 Jul 37 SochauxSochaux 3 - 2 MetzMetz ...
01 Jul 37 StrasbourgStrasbourg 2 - 2 LensLens ...
01 Jul 37 Olympique LilloisOlympique 0 - 0 CannesCannes ...
01 Jul 37 Racing ParisRacing 1 - 1 Fives LilleFives Lille ...
01 Jul 37 AntibesAntibes 0 - 0 ValenciennesValencienne ...
01 Jul 37 Excelsior RoubaixExcelsior 0 - 1 RC RoubaixRC Roubaix ...
Jornada 12
01 Jul 37 Olympique MarseilleOlympique 1 - 1 ValenciennesValencienne ...
01 Jul 37 FC Rouen 1899Rouen 1899 1 - 0 CannesCannes ...
01 Jul 37 Racing ParisRacing 1 - 3 LensLens ...
01 Jul 37 StrasbourgStrasbourg 2 - 0 Fives LilleFives Lille ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 4 MetzMetz ...
01 Jul 37 Olympique LilloisOlympique 2 - 1 SèteSète ...
01 Jul 37 SochauxSochaux 3 - 0 RC RoubaixRC Roubaix ...
01 Jul 37 AntibesAntibes 4 - 1 Red StarRed Star ...
Jornada 13
01 Jul 37 LensLens 1 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 ValenciennesValencienne 1 - 2 StrasbourgStrasbourg ...
01 Jul 37 Red StarRed Star 2 - 2 Racing ParisRacing ...
01 Jul 37 MetzMetz 1 - 2 Olympique MarseilleOlympique ...
01 Jul 37 SèteSète 0 - 1 SochauxSochaux ...
01 Jul 37 RC RoubaixRC Roubaix 2 - 1 AntibesAntibes ...
01 Jul 37 Fives LilleFives Lille 0 - 1 Olympique LilloisOlympique ...
01 Jul 37 CannesCannes 2 - 1 Excelsior RoubaixExcelsior ...
Jornada 14
01 Jul 37 SochauxSochaux 4 - 0 LensLens ...
01 Jul 37 FC Rouen 1899Rouen 1899 4 - 1 ValenciennesValencienne ...
01 Jul 37 Racing ParisRacing 2 - 2 MetzMetz ...
01 Jul 37 AntibesAntibes 2 - 0 CannesCannes ...
01 Jul 37 Excelsior RoubaixExcelsior 3 - 2 Fives LilleFives Lille ...
01 Jul 37 StrasbourgStrasbourg 4 - 0 RC RoubaixRC Roubaix ...
01 Jul 37 Olympique LilloisOlympique 4 - 1 Red StarRed Star ...
01 Jul 37 Olympique MarseilleOlympique 3 - 0 SèteSète ...
Jornada 15
01 Jul 37 CannesCannes 0 - 1 SochauxSochaux ...
01 Jul 37 Red StarRed Star 2 - 2 StrasbourgStrasbourg ...
01 Jul 37 ValenciennesValencienne 1 - 3 Racing ParisRacing ...
01 Jul 37 MetzMetz 1 - 1 AntibesAntibes ...
01 Jul 37 LensLens 2 - 1 Olympique LilloisOlympique ...
01 Jul 37 SèteSète 3 - 0 Excelsior RoubaixExcelsior ...
01 Jul 37 RC RoubaixRC Roubaix 1 - 3 Olympique MarseilleOlympique ...
01 Jul 37 Fives LilleFives Lille 0 - 1 FC Rouen 1899Rouen 1899 ...
Jornada 16
01 Jul 37 StrasbourgStrasbourg 1 - 0 CannesCannes ...
01 Jul 37 Racing ParisRacing 0 - 2 SèteSète ...
01 Jul 37 SochauxSochaux 6 - 1 ValenciennesValencienne ...
01 Jul 37 Olympique MarseilleOlympique 2 - 2 LensLens ...
01 Jul 37 AntibesAntibes 1 - 1 Fives LilleFives Lille ...
01 Jul 37 Excelsior RoubaixExcelsior 3 - 1 Red StarRed Star ...
01 Jul 37 Olympique LilloisOlympique 3 - 1 MetzMetz ...
01 Jul 37 FC Rouen 1899Rouen 1899 2 - 0 RC RoubaixRC Roubaix ...
Jornada 17
01 Jul 37 CannesCannes 1 - 1 Olympique MarseilleOlympique ...
01 Jul 37 StrasbourgStrasbourg 1 - 1 MetzMetz ...
01 Jul 37 Red StarRed Star 2 - 2 FC Rouen 1899Rouen 1899 ...
01 Jul 37 LensLens 2 - 2 Excelsior RoubaixExcelsior ...
01 Jul 37 ValenciennesValencienne 0 - 4 Olympique LilloisOlympique ...
01 Jul 37 Fives LilleFives Lille 1 - 1 SochauxSochaux ...
01 Jul 37 SèteSète 0 - 0 AntibesAntibes ...
01 Jul 37 RC RoubaixRC Roubaix 2 - 1 Racing ParisRacing ...
Jornada 18
01 Jul 37 CannesCannes 5 - 0 LensLens ...
01 Jul 37 Olympique MarseilleOlympique 2 - 1 StrasbourgStrasbourg ...
01 Jul 37 FC Rouen 1899Rouen 1899 1 - 3 SochauxSochaux ...
01 Jul 37 MetzMetz 3 - 0 Red StarRed Star ...
01 Jul 37 ValenciennesValencienne 2 - 4 RC RoubaixRC Roubaix ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 2 Olympique LilloisOlympique ...
01 Jul 37 Fives LilleFives Lille 1 - 2 SèteSète ...
01 Jul 37 Racing ParisRacing 1 - 2 AntibesAntibes ...
Jornada 19
01 Jul 37 Red StarRed Star 2 - 1 CannesCannes ...
01 Jul 37 SèteSète 3 - 0 ValenciennesValencienne ...
01 Jul 37 StrasbourgStrasbourg 1 - 3 Racing ParisRacing ...
01 Jul 37 AntibesAntibes 0 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 Olympique LilloisOlympique 1 - 1 Olympique MarseilleOlympique ...
01 Jul 37 RC RoubaixRC Roubaix 2 - 3 MetzMetz ...
01 Jul 37 SochauxSochaux 1 - 1 Excelsior RoubaixExcelsior ...
01 Jul 37 LensLens 3 - 2 Fives LilleFives Lille ...
Jornada 20
01 Jul 37 ValenciennesValencienne 1 - 3 LensLens ...
01 Jul 37 FC Rouen 1899Rouen 1899 3 - 0 StrasbourgStrasbourg ...
01 Jul 37 MetzMetz 1 - 1 SèteSète ...
01 Jul 37 Olympique MarseilleOlympique 2 - 0 SochauxSochaux ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 1 AntibesAntibes ...
01 Jul 37 Fives LilleFives Lille 3 - 0 Red StarRed Star ...
01 Jul 37 Racing ParisRacing 1 - 0 Olympique LilloisOlympique ...
01 Jul 37 CannesCannes 2 - 3 RC RoubaixRC Roubaix ...
Jornada 21
01 Jul 37 SèteSète 1 - 1 CannesCannes ...
01 Jul 37 LensLens 2 - 3 MetzMetz ...
01 Jul 37 Racing ParisRacing 0 - 4 SochauxSochaux ...
01 Jul 37 ValenciennesValencienne 3 - 2 Red StarRed Star ...
01 Jul 37 Olympique LilloisOlympique 4 - 0 FC Rouen 1899Rouen 1899 ...
01 Jul 37 AntibesAntibes 0 - 3 Olympique MarseilleOlympique ...
01 Jul 37 StrasbourgStrasbourg 3 - 3 Excelsior RoubaixExcelsior ...
01 Jul 37 RC RoubaixRC Roubaix 0 - 0 Fives LilleFives Lille ...
Jornada 22
01 Jul 37 SèteSète 3 - 1 LensLens ...
01 Jul 37 Olympique MarseilleOlympique 1 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 SochauxSochaux 3 - 3 StrasbourgStrasbourg ...
01 Jul 37 MetzMetz 1 - 0 ValenciennesValencienne ...
01 Jul 37 Olympique LilloisOlympique 4 - 0 AntibesAntibes ...
01 Jul 37 Excelsior RoubaixExcelsior 3 - 2 Racing ParisRacing ...
01 Jul 37 CannesCannes 1 - 1 Fives LilleFives Lille ...
01 Jul 37 Red StarRed Star 7 - 0 RC RoubaixRC Roubaix ...
Jornada 23
01 Jul 37 CannesCannes 5 - 0 ValenciennesValencienne ...
01 Jul 37 Red StarRed Star 1 - 4 SèteSète ...
01 Jul 37 Olympique MarseilleOlympique 2 - 1 Racing ParisRacing ...
01 Jul 37 FC Rouen 1899Rouen 1899 1 - 3 Excelsior RoubaixExcelsior ...
01 Jul 37 Fives LilleFives Lille 3 - 0 MetzMetz ...
01 Jul 37 SochauxSochaux 2 - 0 Olympique LilloisOlympique ...
01 Jul 37 StrasbourgStrasbourg 3 - 0 AntibesAntibes ...
01 Jul 37 RC RoubaixRC Roubaix 3 - 1 LensLens ...
Jornada 24
01 Jul 37 MetzMetz 1 - 0 CannesCannes ...
01 Jul 37 Racing ParisRacing 2 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 LensLens 1 - 3 Red StarRed Star ...
01 Jul 37 Excelsior RoubaixExcelsior 4 - 2 Olympique MarseilleOlympique ...
01 Jul 37 Olympique LilloisOlympique 2 - 0 StrasbourgStrasbourg ...
01 Jul 37 SèteSète 0 - 1 RC RoubaixRC Roubaix ...
01 Jul 37 AntibesAntibes 2 - 1 SochauxSochaux ...
01 Jul 37 ValenciennesValencienne 1 - 0 Fives LilleFives Lille ...
Jornada 25
01 Jul 37 Racing ParisRacing 3 - 1 CannesCannes ...
01 Jul 37 StrasbourgStrasbourg 0 - 2 SèteSète ...
01 Jul 37 FC Rouen 1899Rouen 1899 2 - 1 MetzMetz ...
01 Jul 37 SochauxSochaux 3 - 1 Red StarRed Star ...
01 Jul 37 Olympique MarseilleOlympique 1 - 1 Fives LilleFives Lille ...
01 Jul 37 AntibesAntibes 1 - 1 LensLens ...
01 Jul 37 Olympique LilloisOlympique 1 - 1 RC RoubaixRC Roubaix ...
01 Jul 37 Excelsior RoubaixExcelsior 4 - 0 ValenciennesValencienne ...
Jornada 26
01 Jul 37 Red StarRed Star 0 - 1 Olympique MarseilleOlympique ...
01 Jul 37 LensLens 2 - 3 StrasbourgStrasbourg ...
01 Jul 37 MetzMetz 2 - 2 SochauxSochaux ...
01 Jul 37 SèteSète 1 - 0 FC Rouen 1899Rouen 1899 ...
01 Jul 37 RC RoubaixRC Roubaix 2 - 1 Excelsior RoubaixExcelsior ...
01 Jul 37 Fives LilleFives Lille 1 - 0 Racing ParisRacing ...
01 Jul 37 ValenciennesValencienne 1 - 1 AntibesAntibes ...
01 Jul 37 CannesCannes 3 - 1 Olympique LilloisOlympique ...
Jornada 27
01 Jul 37 CannesCannes 6 - 1 FC Rouen 1899Rouen 1899 ...
01 Jul 37 ValenciennesValencienne 1 - 2 Olympique MarseilleOlympique ...
01 Jul 37 LensLens 2 - 1 Racing ParisRacing ...
01 Jul 37 MetzMetz 1 - 2 Excelsior RoubaixExcelsior ...
01 Jul 37 Fives LilleFives Lille 1 - 1 StrasbourgStrasbourg ...
01 Jul 37 RC RoubaixRC Roubaix 2 - 2 SochauxSochaux ...
01 Jul 37 SèteSète 3 - 1 Olympique LilloisOlympique ...
01 Jul 37 Red StarRed Star 0 - 1 AntibesAntibes ...
Jornada 28
01 Jul 37 Olympique MarseilleOlympique 4 - 0 MetzMetz ...
01 Jul 37 StrasbourgStrasbourg 10 - 0 ValenciennesValencienne ...
01 Jul 37 FC Rouen 1899Rouen 1899 3 - 1 LensLens ...
01 Jul 37 Racing ParisRacing 2 - 1 Red StarRed Star ...
01 Jul 37 SochauxSochaux 0 - 1 SèteSète ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 2 CannesCannes ...
01 Jul 37 AntibesAntibes 5 - 0 RC RoubaixRC Roubaix ...
01 Jul 37 Olympique LilloisOlympique 2 - 1 Fives LilleFives Lille ...
Jornada 29
01 Jul 37 MetzMetz 4 - 4 Racing ParisRacing ...
01 Jul 37 LensLens 0 - 2 SochauxSochaux ...
01 Jul 37 SèteSète 1 - 1 Olympique MarseilleOlympique ...
01 Jul 37 ValenciennesValencienne 1 - 9 FC Rouen 1899Rouen 1899 ...
01 Jul 37 Fives LilleFives Lille 4 - 4 Excelsior RoubaixExcelsior ...
01 Jul 37 RC RoubaixRC Roubaix 0 - 2 StrasbourgStrasbourg ...
01 Jul 37 CannesCannes 2 - 1 AntibesAntibes ...
01 Jul 37 Red StarRed Star 3 - 2 Olympique LilloisOlympique ...
Jornada 30
01 Jul 37 SochauxSochaux 1 - 1 CannesCannes ...
01 Jul 37 Racing ParisRacing 0 - 3 ValenciennesValencienne ...
01 Jul 37 StrasbourgStrasbourg 9 - 3 Red StarRed Star ...
01 Jul 37 Olympique LilloisOlympique 3 - 0 LensLens ...
01 Jul 37 AntibesAntibes 2 - 0 MetzMetz ...
01 Jul 37 Excelsior RoubaixExcelsior 2 - 2 SèteSète ...
01 Jul 37 FC Rouen 1899Rouen 1899 2 - 2 Fives LilleFives Lille ...
01 Jul 37 Olympique MarseilleOlympique 5 - 1 RC RoubaixRC Roubaix ...

Clasificación

Equipo PJ GF GC Puntos
1 Sochaux Sochaux 30 69 26 44
2 Olympique Marseille Olympique 30 61 35 42
3 Sète Sète 30 52 28 41
4 FC Rouen 1899 Rouen 1899 30 57 44 36
5 Strasbourg Strasbourg 30 66 54 33
6 Excelsior Roubaix Excelsior 30 59 57 32
7 Olympique Lillois Olympique 30 39 33 29
8 RC Roubaix RC Roubaix 30 39 60 28
9 Cannes Cannes 30 56 47 27
10 Antibes Antibes 30 38 40 27
11 Metz Metz 30 45 56 27
12 Fives Lille Fives Lille 30 42 43 26
13 Racing Paris Racing Paris 30 48 59 26
14 Lens Lens 30 45 63 26
15 Red Star Red Star 30 47 71 19
16 Valenciennes Valenciennes 30 30 77 17

  USO DE MEMORIA  
6,570,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.2086
Total Execution Time  0.2120
  CADENA URL  
/ligue_11938/grupo1/calendario
  GET DATOS  
$_GET['/ligue_11938/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT type FROM routes WHERE alias = 'ligue_11938'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_1' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1938 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  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 = 9807 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars1938 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 9807 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 12:01:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 12:01:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0042  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 12:01:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 12:01:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_1' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1938 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 events1938 e ON e.player_id = p.id AND e.league_id = 9807 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9807 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.0021  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 events1938 e ON e.player_id = p.id AND e.league_id = 9807 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9807 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events1938 e ON e.player_id = p.id AND e.league_id = 9807 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9807 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0060  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1938` 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 = 9807 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC