4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Ligue 1 2011

La temporada finalizó el Domingo, 29 Mayo 2011.
 
29 May 11
21:00 Finalizado
Arles Arles 1-3 Sochaux Sochaux más información Jugadas destacadas 2
0-1 18' R. Boudebouz
28' Rémy Cabella 1-1
1-2 50' V. Nogueira
1-3 83' M. Maïga
 
29 May 11
21:00 Finalizado
Girondins Bordeaux Girondins Bordeaux 2-0 Montpellier Montpellier más información Jugadas destacadas 2
15' C. Diabaté 1-0
37' Wendel 2-0
74' C. Jeunechamp
86' J. Marveaux
 
29 May 11
21:00 Finalizado
Stade Brestois Stade Brestois 0-2 Toulouse Toulouse más información Jugadas destacadas ...
0-1 3' X. Pentecôte
0-2 63' X. Pentecôte
 
29 May 11
21:00 Finalizado
Caen Caen 2-2 Olympique Marseille Olympique Marseille más información Jugadas destacadas 4
7' Y. Mollo 1-0
45' M'baye Niang 2-0
2-1 68' L. Rémy
2-2 90' L. Rémy
 
29 May 11
21:00 Finalizado
Lille Lille 3-2 Stade Rennais Stade Rennais más información Jugadas destacadas 5
27' A. Chedjou
35' M. Sow 2-0
56' M. Sow 3-0
77' M. Sow 4-0
4-1 82' V. Montaño
 
29 May 11
21:00 Finalizado
Lorient Lorient 1-2 Auxerre Auxerre más información Jugadas destacadas 2
20' Kévin Gameiro 1-0
25' B. Écuélé Manga
2-1 49' V. Birsa
 
29 May 11
21:00 Finalizado
Monaco Monaco 0-2 Olympique Lyonnais Olympique Lyonnais más información Jugadas destacadas 10
0-1 67' P. Diakhate
0-2 83' L. López
 
29 May 11
21:00 Finalizado
Nancy Nancy 4-0 Lens Lens más información Jugadas destacadas 2
30' P. Berenguer 1-0
45' A. Toure
48' P. Berenguer 3-0
90' M. Vahirua 4-0
 
29 May 11
21:00 Finalizado
Saint-Étienne Saint-Étienne 1-1 PSG PSG más información Jugadas destacadas 2
70' J. Guilavogui 1-0
1-1 90' M. Bodmer
 
29 May 11
21:00 Finalizado
Valenciennes Valenciennes 2-1 Nice Nice más información Jugadas destacadas 1
47' G. Pujol 1-0
69' G. Pujol 2-0
2-1 88' E. Mouloungui
Equipos Puntos J. G. E. P. F. C. Forma
1 Lille Lille 76 38 21 13 4 68 36
  • VICTORIA
  • Nancy 0
  • Lille 1
  • VICTORIA
  • Saint-Étienne 1
  • Lille 2
  • VICTORIA
  • Lille 1
  • Sochaux 0
  • EMPATE
  • PSG 2
  • Lille 2
  • VICTORIA
  • Lille 3
  • Stade Rennais 2
2 Olympique Marseille Olympique 68 38 18 14 6 62 39
  • DERROTA
  • Olympique Lyonnais 3
  • Olympique Marseill. 2
  • VICTORIA
  • Olympique Marseill. 3
  • Stade Brestois 0
  • EMPATE
  • Lorient 2
  • Olympique Marseill. 2
  • EMPATE
  • Olympique Marseill. 2
  • Valenciennes 2
  • EMPATE
  • Caen 2
  • Olympique Marseill. 2
3 Olympique Lyonnais Olympique 64 38 17 13 8 61 40
  • VICTORIA
  • Olympique Lyonnais 3
  • Olympique Marseill. 2
  • DERROTA
  • Auxerre 4
  • Olympique Lyonnais 0
  • EMPATE
  • Stade Brestois 1
  • Olympique Lyonnais 1
  • EMPATE
  • Olympique Lyonnais 0
  • Caen 0
  • VICTORIA
  • Monaco 0
  • Olympique Lyonnais 2
4 PSG PSG 60 38 15 15 8 56 41
  • EMPATE
  • Monaco 1
  • PSG 1
  • EMPATE
  • PSG 2
  • Nancy 2
  • DERROTA
  • Girondins Bordeaux 1
  • PSG 0
  • EMPATE
  • PSG 2
  • Lille 2
  • EMPATE
  • Saint-Étienne 1
  • PSG 1
5 Sochaux Sochaux 58 38 17 7 14 60 43
  • VICTORIA
  • Girondins Bordeaux 0
  • Sochaux 4
  • VICTORIA
  • Sochaux 3
  • Monaco 0
  • DERROTA
  • Lille 1
  • Sochaux 0
  • VICTORIA
  • Sochaux 2
  • Saint-Étienne 1
  • VICTORIA
  • Arles 1
  • Sochaux 3
6 Stade Rennais Stade Rennais 56 38 15 11 12 38 35
  • DERROTA
  • Valenciennes 2
  • Stade Rennais 0
  • EMPATE
  • Stade Rennais 1
  • Caen 1
  • VICTORIA
  • Saint-Étienne 1
  • Stade Rennais 2
  • DERROTA
  • Stade Rennais 0
  • Nancy 2
  • DERROTA
  • Lille 3
  • Stade Rennais 2
7 Girondins Bordeaux Girondins 51 38 12 15 11 43 42
  • DERROTA
  • Girondins Bordeaux 0
  • Sochaux 4
  • DERROTA
  • Lens 1
  • Girondins Bordeaux 0
  • VICTORIA
  • Girondins Bordeaux 1
  • PSG 0
  • DERROTA
  • Toulouse 2
  • Girondins Bordeaux 0
  • VICTORIA
  • Girondins Bordeaux 2
  • Montpellier 0
8 Toulouse Toulouse 50 38 14 8 16 38 36
  • EMPATE
  • Lorient 0
  • Toulouse 0
  • EMPATE
  • Toulouse 0
  • Valenciennes 0
  • DERROTA
  • Arles 1
  • Toulouse 0
  • VICTORIA
  • Toulouse 2
  • Girondins Bordeaux 0
  • VICTORIA
  • Stade Brestois 0
  • Toulouse 2
9 Auxerre Auxerre 49 38 10 19 9 45 41
  • VICTORIA
  • Auxerre 1
  • Montpellier 0
  • VICTORIA
  • Auxerre 4
  • Olympique Lyonnais 0
  • EMPATE
  • Valenciennes 1
  • Auxerre 1
  • DERROTA
  • Auxerre 0
  • Stade Brestois 1
  • VICTORIA
  • Lorient 1
  • Auxerre 2
10 Saint-Étienne Saint-Étienne 49 38 12 13 13 46 47
  • VICTORIA
  • Arles 0
  • Saint-Étienne 1
  • DERROTA
  • Saint-Étienne 1
  • Lille 2
  • DERROTA
  • Saint-Étienne 1
  • Stade Rennais 2
  • DERROTA
  • Sochaux 2
  • Saint-Étienne 1
  • EMPATE
  • Saint-Étienne 1
  • PSG 1
11 Lorient Lorient 49 38 12 13 13 46 48
  • EMPATE
  • Lorient 0
  • Toulouse 0
  • DERROTA
  • Montpellier 3
  • Lorient 1
  • EMPATE
  • Lorient 2
  • Olympique Marseill. 2
  • DERROTA
  • Nice 2
  • Lorient 0
  • DERROTA
  • Lorient 1
  • Auxerre 2
12 Valenciennes Valenciennes 48 38 10 18 10 45 41
  • VICTORIA
  • Valenciennes 2
  • Stade Rennais 0
  • EMPATE
  • Toulouse 0
  • Valenciennes 0
  • EMPATE
  • Valenciennes 1
  • Auxerre 1
  • EMPATE
  • Olympique Marseill. 2
  • Valenciennes 2
  • VICTORIA
  • Valenciennes 2
  • Nice 1
13 Nancy Nancy 48 38 13 9 16 43 48
  • DERROTA
  • Nancy 0
  • Lille 1
  • EMPATE
  • PSG 2
  • Nancy 2
  • VICTORIA
  • Nancy 3
  • Nice 0
  • VICTORIA
  • Stade Rennais 0
  • Nancy 2
  • VICTORIA
  • Nancy 4
  • Lens 0
14 Montpellier Montpellier 47 38 12 11 15 32 43
  • DERROTA
  • Auxerre 1
  • Montpellier 0
  • VICTORIA
  • Montpellier 3
  • Lorient 1
  • DERROTA
  • Caen 2
  • Montpellier 0
  • DERROTA
  • Montpellier 0
  • Monaco 1
  • DERROTA
  • Girondins Bordeaux 2
  • Montpellier 0
15 Caen Caen 46 38 11 13 14 46 51
  • EMPATE
  • Caen 1
  • Lens 1
  • EMPATE
  • Stade Rennais 1
  • Caen 1
  • VICTORIA
  • Caen 2
  • Montpellier 0
  • EMPATE
  • Olympique Lyonnais 0
  • Caen 0
  • EMPATE
  • Caen 2
  • Olympique Marseill. 2
16 Stade Brestois Stade Brestois 46 38 11 13 14 36 43
  • EMPATE
  • Stade Brestois 0
  • Nice 0
  • DERROTA
  • Olympique Marseill. 3
  • Stade Brestois 0
  • EMPATE
  • Stade Brestois 1
  • Olympique Lyonnais 1
  • VICTORIA
  • Auxerre 0
  • Stade Brestois 1
  • DERROTA
  • Stade Brestois 0
  • Toulouse 2
17 Nice Nice 46 38 11 13 14 33 48
  • EMPATE
  • Stade Brestois 0
  • Nice 0
  • VICTORIA
  • Nice 3
  • Arles 2
  • DERROTA
  • Nancy 3
  • Nice 0
  • VICTORIA
  • Nice 2
  • Lorient 0
  • DERROTA
  • Valenciennes 2
  • Nice 1
18 Monaco Monaco 44 38 9 17 12 36 40
  • EMPATE
  • Monaco 1
  • PSG 1
  • DERROTA
  • Sochaux 3
  • Monaco 0
  • EMPATE
  • Monaco 1
  • Lens 1
  • VICTORIA
  • Montpellier 0
  • Monaco 1
  • DERROTA
  • Monaco 0
  • Olympique Lyonnais 2
19 Lens Lens 35 38 7 14 17 35 58
  • EMPATE
  • Caen 1
  • Lens 1
  • VICTORIA
  • Lens 1
  • Girondins Bordeaux 0
  • EMPATE
  • Monaco 1
  • Lens 1
  • DERROTA
  • Lens 0
  • Arles 1
  • DERROTA
  • Nancy 4
  • Lens 0
20 Arles Arles 20 38 3 11 24 21 70
  • DERROTA
  • Arles 0
  • Saint-Étienne 1
  • DERROTA
  • Nice 3
  • Arles 2
  • VICTORIA
  • Arles 1
  • Toulouse 0
  • VICTORIA
  • Lens 0
  • Arles 1
  • DERROTA
  • Arles 1
  • Sochaux 3
Champions League: Lille, Olympique, Olympique
Previa de Champions: PSG
Europa League: Sochaux
Descenso: Monaco, Lens, Arles
RK Nombre Goles Posición Equipo
1 sn M. Sow 25 DEL Lille
2 fr Kévin Gameiro 22 DEL Lorient
3 fr G. Pujol 17 DEL Valenciennes
4 ar L. López 17 DEL Olympique Lyonnais
5 ma Y. El-Arabi 17 DEL Caen
6 fr L. Rémy 16 DEL Nice
7 ml M. Maïga 15 DEL Sochaux
8 ci Y. Gervinho 15 DEL Lille
9 ng Ideye 15 DEL Sochaux
10 br Nenê 14 MED PSG
11 fr D. Payet 13 MED Saint-Étienne
12 fr O. Giroud 12 DEL Montpellier
13 kr Chu-Young Park 12 DEL Monaco
14 gh A. Ayew 11 DEL Olympique Marseille
15 fr B. Gomis 10 DEL Olympique Lyonnais
16 fr A. Modeste 10 DEL Girondins Bordeaux
17 fr G. Hoarau 9 DEL PSG
18 fr G. Danic 9 DEL Valenciennes
19 fr B. Grougi 9 MED Stade Brestois
20 co V. Montaño 9 DEL Stade Rennais

La Ligue 1 u oficialmente, por motivos de patrocinio, Ligue 1 Orange es la máxima categoría del fútbol francés.


Está organizada por la Ligue de Football Professionnel

TOP colaboradores para esta liga
¿Quieres ser colaborador? haz click aquí
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,527,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5421
Total Execution Time  0.5440
  CADENA URL  
/ligue_12011
  GET DATOS  
$_GET['/ligue_12011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0105  SELECT type FROM routes WHERE alias = 'ligue_12011'
0.0213  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16 AND type_rel = 3
0.0438  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 16 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1308398,1308354,1308233,1308209,1308206) ORDER BY n.cover_points DESC, update_date DESC
0.0107  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=16 ORDER BY l.group_code ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 16 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 09:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 09:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 09:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 09:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0117  SELECT e.action, count(e.action) as total, e.player_id FROM events2011 e WHERE e.league_id IN (1072) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (1072) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3422,3354,719,39930,44193,96894,3241,21307,67859,30766,718,24691,30772,52426,712,3391,3365,8457,8876,8954) ORDER BY rp.in_squad = 1 DESC
0.0122  SELECT e.action, count(e.action) as total, e.player_id FROM events2011 e WHERE e.league_id IN (1072) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0109  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (1072) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3402,8908,638,27687,3047,3100,3168,24764,30740,107252,692,3142,3144,3164,8399,8443,651,3150,3298,8448) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2011 e WHERE e.league_id IN (1072) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0109  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (1072) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (638,3047,3168,21253,27687,31747,67060,107252,629,651,682,2910,2915,2922,2990,3063,3075,3093,3095,3100) ORDER BY rp.in_squad = 1 DESC
0.0114  SELECT e.action, count(e.action) as total, e.player_id FROM events2011 e WHERE e.league_id IN (1072) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0115  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (1072) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (21181,3271,8443,21359,30766,21292,21307,1062,3144,3157,8457,21178,38671,672,3365,6329,8876,21172,21282,28838) ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT rp.lineup 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1072 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0109  SELECT rp.events 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1072 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0107  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=1072 AND rel.round=38
0.0107  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 1072 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0115  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 1072 AND esl.points > 0
0.0105  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 1072 ORDER BY creation_date DESC LIMIT 0, 10
0.0111  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 1072
0.0113  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2011` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 1072 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0140  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2011 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2011 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 1072 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (2447,2448,2449,2450,2451,2452,2453,2454,2455,2456) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0109  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2011` e INNER JOIN calendars2011 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 38 AND e.real_date IS NOT NULL AND e.league_id = 1072 ORDER BY total DESC LIMIT 40
0.0117  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 = 1072 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(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 = 1072 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT distinct(shedule), round FROM `calendars2011` as c WHERE c.`league_id` = 1072 AND shedule >= '2011/05/01' AND shedule < '2011/06/01' ORDER BY shedule ASC
0.0104  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 1072 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=16
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=16 AND year=2011