4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
01 Oct 11 SirocoSiroco 2 - 1 AS RC De Basse TerreBasse Terre ...
29 Oct 11 Stade LamentinoisStade 0 - 0 Amical ClubAmical Club ...
29 Oct 11 Etoile du CarmelEtoile 3 - 1 USR Sainte-RoseSainte-Rose ...
29 Oct 11 AJS SaintoiseSaintoise 2 - 6 Vieux-HabitantsVieux-Habit ...
29 Oct 11 Phare du CanalPhare Canal 2 - 1 Juventus SAJuventus ...
12 Ene 12 Etoile de Morne-à-l'EauEtoile 1 - 0 CS MoulienCS Moulien ...
12 Ene 12 AS GosierAS Gosier 1 - 1 Evolucas LamentinEvolucas ...
Jornada 2
15 Ene 12 Amical ClubAmical Club 1 - 1 Etoile du CarmelEtoile ...
15 Ene 12 Juventus SAJuventus 2 - 0 Etoile de Morne-à-l'EauEtoile ...
15 Ene 12 USR Sainte-RoseSainte-Rose 0 - 3 AS GosierAS Gosier ...
15 Ene 12 Vieux-HabitantsVieux-Habit 1 - 2 Phare du CanalPhare Canal ...
15 Ene 12 Evolucas LamentinEvolucas 1 - 1 AJS SaintoiseSaintoise ...
15 Ene 12 CS MoulienCS Moulien 1 - 1 SirocoSiroco ...
11 Feb 12 AS RC De Basse TerreBasse Terre 0 - 0 Stade LamentinoisStade ...
Jornada 3
25 Sep 11 SirocoSiroco 0 - 0 Juventus SAJuventus ...
25 Sep 11 Phare du CanalPhare Canal 0 - 0 Evolucas LamentinEvolucas ...
25 Sep 11 AS GosierAS Gosier 1 - 1 Amical ClubAmical Club ...
25 Sep 11 AS RC De Basse TerreBasse Terre 1 - 2 CS MoulienCS Moulien ...
25 Sep 11 Etoile de Morne-à-l'EauEtoile 1 - 0 Vieux-HabitantsVieux-Habit ...
25 Sep 11 Stade LamentinoisStade 1 - 2 Etoile du CarmelEtoile ...
13 Nov 11 AJS SaintoiseSaintoise 1 - 0 USR Sainte-RoseSainte-Rose ...
Jornada 4
16 Oct 11 Evolucas LamentinEvolucas 1 - 1 Etoile de Morne-à-l'EauEtoile ...
16 Oct 11 Vieux-HabitantsVieux-Habit 1 - 1 SirocoSiroco ...
16 Oct 11 Juventus SAJuventus 0 - 0 AS RC De Basse TerreBasse Terre ...
16 Oct 11 USR Sainte-RoseSainte-Rose 1 - 0 Phare du CanalPhare Canal ...
16 Oct 11 Etoile du CarmelEtoile 4 - 3 AS GosierAS Gosier ...
16 Oct 11 Amical ClubAmical Club 1 - 2 AJS SaintoiseSaintoise ...
16 Oct 11 CS MoulienCS Moulien 1 - 0 Stade LamentinoisStade ...
Jornada 5
23 Oct 11 CS MoulienCS Moulien 0 - 1 Juventus SAJuventus ...
23 Oct 11 AS RC De Basse TerreBasse Terre 0 - 2 Vieux-HabitantsVieux-Habit ...
23 Oct 11 Phare du CanalPhare Canal 0 - 1 Amical ClubAmical Club ...
23 Oct 11 Stade LamentinoisStade 1 - 1 AS GosierAS Gosier ...
23 Oct 11 SirocoSiroco 1 - 1 Evolucas LamentinEvolucas ...
23 Oct 11 AJS SaintoiseSaintoise 1 - 0 Etoile du CarmelEtoile ...
23 Oct 11 Etoile de Morne-à-l'EauEtoile 2 - 1 USR Sainte-RoseSainte-Rose ...
Jornada 6
10 Nov 11 AS GosierAS Gosier 2 - 2 AJS SaintoiseSaintoise ...
10 Nov 11 Vieux-HabitantsVieux-Habit 0 - 1 CS MoulienCS Moulien ...
10 Nov 11 Amical ClubAmical Club 3 - 1 Etoile de Morne-à-l'EauEtoile ...
10 Nov 11 Juventus SAJuventus 1 - 1 Stade LamentinoisStade ...
10 Nov 11 Evolucas LamentinEvolucas 1 - 2 AS RC De Basse TerreBasse Terre ...
10 Nov 11 Etoile du CarmelEtoile 2 - 1 Phare du CanalPhare Canal ...
10 Nov 11 USR Sainte-RoseSainte-Rose 1 - 0 SirocoSiroco ...
Jornada 7
27 Nov 11 SirocoSiroco 0 - 0 Amical ClubAmical Club ...
27 Nov 11 Etoile de Morne-à-l'EauEtoile 3 - 2 Etoile du CarmelEtoile ...
27 Nov 11 CS MoulienCS Moulien 0 - 2 Evolucas LamentinEvolucas ...
27 Nov 11 AS RC De Basse TerreBasse Terre 0 - 1 USR Sainte-RoseSainte-Rose ...
27 Nov 11 Juventus SAJuventus 1 - 1 Vieux-HabitantsVieux-Habit ...
27 Nov 11 Phare du CanalPhare Canal 2 - 2 AS GosierAS Gosier ...
19 Ene 12 Stade LamentinoisStade 1 - 5 AJS SaintoiseSaintoise ...
Jornada 8
04 Dic 11 AJS SaintoiseSaintoise 1 - 1 Phare du CanalPhare Canal ...
04 Dic 11 AS GosierAS Gosier 1 - 0 Etoile de Morne-à-l'EauEtoile ...
04 Dic 11 Vieux-HabitantsVieux-Habit 0 - 0 Stade LamentinoisStade ...
04 Dic 11 USR Sainte-RoseSainte-Rose 2 - 2 CS MoulienCS Moulien ...
04 Dic 11 Evolucas LamentinEvolucas 2 - 1 Juventus SAJuventus ...
12 Ene 12 Etoile du CarmelEtoile 0 - 0 SirocoSiroco ...
12 Ene 12 Amical ClubAmical Club 0 - 0 AS RC De Basse TerreBasse Terre ...
Jornada 9
08 Dic 11 AS RC De Basse TerreBasse Terre 1 - 0 Etoile du CarmelEtoile ...
11 Dic 11 Vieux-HabitantsVieux-Habit 1 - 1 Evolucas LamentinEvolucas ...
11 Dic 11 Juventus SAJuventus 1 - 0 USR Sainte-RoseSainte-Rose ...
11 Dic 11 CS MoulienCS Moulien 1 - 2 Amical ClubAmical Club ...
11 Dic 11 Stade LamentinoisStade 1 - 2 Phare du CanalPhare Canal ...
11 Dic 11 SirocoSiroco 1 - 2 AS GosierAS Gosier ...
11 Dic 11 Etoile de Morne-à-l'EauEtoile 2 - 0 AJS SaintoiseSaintoise ...
Jornada 10
18 Dic 11 Evolucas LamentinEvolucas 1 - 0 Stade LamentinoisStade ...
18 Dic 11 Phare du CanalPhare Canal 1 - 0 Etoile de Morne-à-l'EauEtoile ...
18 Dic 11 AJS SaintoiseSaintoise 0 - 1 SirocoSiroco ...
18 Dic 11 USR Sainte-RoseSainte-Rose 2 - 1 Vieux-HabitantsVieux-Habit ...
18 Dic 11 Etoile du CarmelEtoile 0 - 0 CS MoulienCS Moulien ...
18 Dic 11 Amical ClubAmical Club 1 - 2 Juventus SAJuventus ...
18 Dic 11 AS GosierAS Gosier 1 - 0 AS RC De Basse TerreBasse Terre ...
Jornada 11
08 Ene 12 Evolucas LamentinEvolucas 0 - 0 USR Sainte-RoseSainte-Rose ...
08 Ene 12 AS RC De Basse TerreBasse Terre 1 - 2 AJS SaintoiseSaintoise ...
08 Ene 12 SirocoSiroco 2 - 1 Phare du CanalPhare Canal ...
08 Ene 12 CS MoulienCS Moulien 2 - 0 AS GosierAS Gosier ...
08 Ene 12 Juventus SAJuventus 1 - 0 Etoile du CarmelEtoile ...
08 Ene 12 Vieux-HabitantsVieux-Habit 0 - 0 Amical ClubAmical Club ...
14 Mar 12 Stade LamentinoisStade 0 - 2 Etoile de Morne-à-l'EauEtoile ...
Jornada 12
22 Ene 12 Amical ClubAmical Club 1 - 2 Evolucas LamentinEvolucas ...
22 Ene 12 Stade LamentinoisStade 1 - 0 USR Sainte-RoseSainte-Rose ...
22 Ene 12 Etoile de Morne-à-l'EauEtoile 1 - 1 SirocoSiroco ...
22 Ene 12 Etoile du CarmelEtoile 1 - 0 Vieux-HabitantsVieux-Habit ...
22 Ene 12 Phare du CanalPhare Canal 1 - 0 AS RC De Basse TerreBasse Terre ...
22 Ene 12 AJS SaintoiseSaintoise 2 - 1 CS MoulienCS Moulien ...
22 Ene 12 AS GosierAS Gosier 0 - 1 Juventus SAJuventus ...
Jornada 13
29 Ene 12 USR Sainte-RoseSainte-Rose 1 - 0 Amical ClubAmical Club ...
29 Ene 12 CS MoulienCS Moulien 1 - 1 Phare du CanalPhare Canal ...
29 Ene 12 Vieux-HabitantsVieux-Habit 1 - 1 AS GosierAS Gosier ...
29 Ene 12 Juventus SAJuventus 0 - 0 AJS SaintoiseSaintoise ...
29 Ene 12 AS RC De Basse TerreBasse Terre 2 - 1 Etoile de Morne-à-l'EauEtoile ...
29 Ene 12 Evolucas LamentinEvolucas 3 - 1 Etoile du CarmelEtoile ...
29 Ene 12 SirocoSiroco 2 - 1 Stade LamentinoisStade ...
Jornada 14
05 Feb 12 Juventus SAJuventus 1 - 0 Phare du CanalPhare Canal ...
05 Feb 12 Vieux-HabitantsVieux-Habit 1 - 2 AJS SaintoiseSaintoise ...
05 Feb 12 Evolucas LamentinEvolucas 1 - 1 AS GosierAS Gosier ...
05 Feb 12 CS MoulienCS Moulien 3 - 1 Etoile de Morne-à-l'EauEtoile ...
05 Feb 12 Amical ClubAmical Club 0 - 1 Stade LamentinoisStade ...
05 Feb 12 AS RC De Basse TerreBasse Terre 1 - 2 SirocoSiroco ...
05 Feb 12 USR Sainte-RoseSainte-Rose 1 - 0 Etoile du CarmelEtoile ...
Jornada 15
18 Feb 12 Etoile du CarmelEtoile 1 - 1 Amical ClubAmical Club ...
18 Feb 12 SirocoSiroco 1 - 2 CS MoulienCS Moulien ...
18 Feb 12 Etoile de Morne-à-l'EauEtoile 1 - 0 Juventus SAJuventus ...
18 Feb 12 AJS SaintoiseSaintoise 3 - 1 Evolucas LamentinEvolucas ...
18 Feb 12 AS GosierAS Gosier 0 - 2 USR Sainte-RoseSainte-Rose ...
18 Feb 12 Stade LamentinoisStade 1 - 0 AS RC De Basse TerreBasse Terre ...
18 Feb 12 Phare du CanalPhare Canal 1 - 1 Vieux-HabitantsVieux-Habit ...
Jornada 16
26 Feb 12 USR Sainte-RoseSainte-Rose 1 - 1 AJS SaintoiseSaintoise ...
26 Feb 12 Juventus SAJuventus 1 - 1 SirocoSiroco ...
26 Feb 12 Vieux-HabitantsVieux-Habit 1 - 1 Etoile de Morne-à-l'EauEtoile ...
26 Feb 12 Amical ClubAmical Club 1 - 0 AS GosierAS Gosier ...
26 Feb 12 Etoile du CarmelEtoile 0 - 0 Stade LamentinoisStade ...
26 Feb 12 Evolucas LamentinEvolucas 0 - 0 Phare du CanalPhare Canal ...
14 Mar 12 CS MoulienCS Moulien 1 - 1 AS RC De Basse TerreBasse Terre ...
Jornada 17
01 Mar 12 AJS SaintoiseSaintoise 3 - 1 Amical ClubAmical Club ...
01 Mar 12 Stade LamentinoisStade 2 - 1 CS MoulienCS Moulien ...
01 Mar 12 Phare du CanalPhare Canal 2 - 0 USR Sainte-RoseSainte-Rose ...
01 Mar 12 AS RC De Basse TerreBasse Terre 1 - 0 Juventus SAJuventus ...
01 Mar 12 AS GosierAS Gosier 0 - 1 Etoile du CarmelEtoile ...
01 Mar 12 Etoile de Morne-à-l'EauEtoile 0 - 0 Evolucas LamentinEvolucas ...
03 Mar 12 SirocoSiroco 1 - 2 Vieux-HabitantsVieux-Habit ...
Jornada 18
11 Mar 12 AS GosierAS Gosier 1 - 1 Stade LamentinoisStade ...
11 Mar 12 Vieux-HabitantsVieux-Habit 1 - 0 AS RC De Basse TerreBasse Terre ...
11 Mar 12 Juventus SAJuventus 1 - 1 CS MoulienCS Moulien ...
11 Mar 12 Etoile du CarmelEtoile 0 - 1 AJS SaintoiseSaintoise ...
11 Mar 12 USR Sainte-RoseSainte-Rose 1 - 1 Etoile de Morne-à-l'EauEtoile ...
11 Mar 12 Amical ClubAmical Club 3 - 0 Phare du CanalPhare Canal ...
11 Mar 12 Evolucas LamentinEvolucas 1 - 0 SirocoSiroco ...
Jornada 19
18 Mar 12 CS MoulienCS Moulien 2 - 2 Vieux-HabitantsVieux-Habit ...
18 Mar 12 AJS SaintoiseSaintoise 1 - 0 AS GosierAS Gosier ...
18 Mar 12 Phare du CanalPhare Canal 0 - 0 Etoile du CarmelEtoile ...
18 Mar 12 Stade LamentinoisStade 2 - 1 Juventus SAJuventus ...
18 Mar 12 SirocoSiroco 0 - 1 USR Sainte-RoseSainte-Rose ...
18 Mar 12 AS RC De Basse TerreBasse Terre 0 - 1 Evolucas LamentinEvolucas ...
18 Mar 12 Etoile de Morne-à-l'EauEtoile 2 - 0 Amical ClubAmical Club ...
Jornada 20
25 Mar 12 Evolucas LamentinEvolucas 0 - 0 CS MoulienCS Moulien ...
25 Mar 12 AJS SaintoiseSaintoise 3 - 1 Stade LamentinoisStade ...
25 Mar 12 Etoile du CarmelEtoile 1 - 1 Etoile de Morne-à-l'EauEtoile ...
25 Mar 12 AS GosierAS Gosier 1 - 0 Phare du CanalPhare Canal ...
25 Mar 12 Vieux-HabitantsVieux-Habit 1 - 0 Juventus SAJuventus ...
25 Mar 12 USR Sainte-RoseSainte-Rose 1 - 0 AS RC De Basse TerreBasse Terre ...
26 Mar 12 Amical ClubAmical Club 0 - 1 SirocoSiroco ...
Jornada 21
01 Abr 12 Phare du CanalPhare Canal 2 - 1 AJS SaintoiseSaintoise ...
01 Abr 12 Etoile de Morne-à-l'EauEtoile 2 - 0 AS GosierAS Gosier ...
01 Abr 12 SirocoSiroco 1 - 0 Etoile du CarmelEtoile ...
01 Abr 12 CS MoulienCS Moulien 3 - 0 USR Sainte-RoseSainte-Rose ...
01 Abr 12 Juventus SAJuventus 0 - 1 Evolucas LamentinEvolucas ...
01 Abr 12 Stade LamentinoisStade 0 - 1 Vieux-HabitantsVieux-Habit ...
01 Abr 12 AS RC De Basse TerreBasse Terre 3 - 1 Amical ClubAmical Club ...
Jornada 22
14 Abr 12 Amical ClubAmical Club 0 - 0 CS MoulienCS Moulien ...
15 Abr 12 Etoile du CarmelEtoile 0 - 3 AS RC De Basse TerreBasse Terre ...
15 Abr 12 Phare du CanalPhare Canal 2 - 0 Stade LamentinoisStade ...
15 Abr 12 AS GosierAS Gosier 1 - 0 SirocoSiroco ...
15 Abr 12 AJS SaintoiseSaintoise 1 - 1 Etoile de Morne-à-l'EauEtoile ...
15 Abr 12 Evolucas LamentinEvolucas 0 - 0 Vieux-HabitantsVieux-Habit ...
15 Abr 12 USR Sainte-RoseSainte-Rose 1 - 0 Juventus SAJuventus ...
Jornada 23
29 Abr 12 Etoile de Morne-à-l'EauEtoile 1 - 0 Phare du CanalPhare Canal ...
29 Abr 12 SirocoSiroco 2 - 1 AJS SaintoiseSaintoise ...
29 Abr 12 Juventus SAJuventus 0 - 0 Amical ClubAmical Club ...
29 Abr 12 Stade LamentinoisStade 1 - 0 Evolucas LamentinEvolucas ...
29 Abr 12 CS MoulienCS Moulien 0 - 0 Etoile du CarmelEtoile ...
29 Abr 12 Vieux-HabitantsVieux-Habit 0 - 1 USR Sainte-RoseSainte-Rose ...
29 Abr 12 AS RC De Basse TerreBasse Terre 1 - 1 AS GosierAS Gosier ...
Jornada 24
07 May 12 Phare du CanalPhare Canal 1 - 1 SirocoSiroco ...
07 May 12 Etoile du CarmelEtoile 1 - 1 Juventus SAJuventus ...
08 May 12 AJS SaintoiseSaintoise 0 - 0 AS RC De Basse TerreBasse Terre ...
10 May 12 USR Sainte-RoseSainte-Rose 0 - 0 Evolucas LamentinEvolucas ...
10 May 12 Amical ClubAmical Club 0 - 0 Vieux-HabitantsVieux-Habit ...
10 May 12 AS GosierAS Gosier 2 - 2 CS MoulienCS Moulien ...
11 May 12 Etoile de Morne-à-l'EauEtoile 1 - 0 Stade LamentinoisStade ...
Jornada 25
12 May 12 Evolucas LamentinEvolucas 0 - 1 Amical ClubAmical Club ...
13 May 12 AS RC De Basse TerreBasse Terre 1 - 2 Phare du CanalPhare Canal ...
13 May 12 Vieux-HabitantsVieux-Habit 1 - 1 Etoile du CarmelEtoile ...
13 May 12 Juventus SAJuventus 0 - 1 AS GosierAS Gosier ...
14 May 12 SirocoSiroco 0 - 1 Etoile de Morne-à-l'EauEtoile ...
14 May 12 USR Sainte-RoseSainte-Rose 0 - 3 Stade LamentinoisStade ...
14 May 12 CS MoulienCS Moulien 1 - 4 AJS SaintoiseSaintoise ...
Jornada 26
19 May 12 AJS SaintoiseSaintoise 1 - 1 Juventus SAJuventus ...
19 May 12 Phare du CanalPhare Canal 3 - 1 CS MoulienCS Moulien ...
19 May 12 Etoile de Morne-à-l'EauEtoile 4 - 0 AS RC De Basse TerreBasse Terre ...
19 May 12 Stade LamentinoisStade 3 - 1 SirocoSiroco ...
19 May 12 Amical ClubAmical Club 1 - 1 USR Sainte-RoseSainte-Rose ...
19 May 12 Etoile du CarmelEtoile 1 - 1 Evolucas LamentinEvolucas ...
19 May 12 AS GosierAS Gosier 0 - 0 Vieux-HabitantsVieux-Habit ...

Clasificación

Equipo PJ GF GC Puntos
1 AJS Saintoise Saintoise 26 41 29 47
2 Etoile de Morne-à-l'Eau Etoile 26 32 21 46
3 USR Sainte-Rose Sainte-Rose 26 20 25 39
4 Evolucas Lamentin Evolucas 26 22 17 38
5 Phare du Canal Phare Canal 26 27 24 38
6 Siroco Siroco 26 23 25 33
7 CS Moulien CS Moulien 26 29 30 32
8 AS Gosier AS Gosier 26 26 28 32
9 Vieux-Habitants Vieux-Habita 26 25 22 31
10 Juventus SA Juventus SA 26 18 19 31
11 Stade Lamentinois Stade 26 22 28 31
12 Amical Club Amical Club 26 20 23 29
13 Etoile du Carmel Etoile 26 22 27 29
14 AS RC De Basse Terre Basse Terre 26 19 28 24

  USO DE MEMORIA  
6,000,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3594
Total Execution Time  0.3613
  CADENA URL  
/1_th_guadalupe2012/grupo1/calendario
  GET DATOS  
$_GET['/1_th_guadalupe2012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0126  SELECT type FROM routes WHERE alias = '1_th_guadalupe2012'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_th_guadalupe' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=426 AND type_rel = 3
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=426 ORDER BY order_id ASC
0.0172  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 = 24839 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0177  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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 24839 ORDER BY round ASC
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:23:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:23:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:23:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:23:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_th_guadalupe' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  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 events2012 e ON e.player_id = p.id AND e.league_id = 24839 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24839 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.0128  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 events2012 e ON e.player_id = p.id AND e.league_id = 24839 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24839 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events2012 e ON e.player_id = p.id AND e.league_id = 24839 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24839 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 24839 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC