4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
14 Sep 11 Foolad YazdFoolad Yazd 2 - 1 AboomoslemAboomoslem ...
14 Sep 11 Gostaresh FouladGostaresh 0 - 1 Shahrdari Bandar AbbasShahrdari ...
15 Sep 11 Sanat SariSanat Sari 0 - 3 Persepolis ShomalPersepolis ...
15 Sep 11 Steel AzinSteel Azin 0 - 0 Iranjavan FCIranjavan ...
15 Sep 11 Etka Gorgan FCEtka Gorgan 2 - 1 Shahrdari ArakShahrdari ...
15 Sep 11 Parseh Tehran FCParseh 1 - 2 PaykanPaykan ...
15 Sep 11 Mes RafsanjanRafsanjan 0 - 0 Payam MokhaberatPayam ...
Jornada 2
29 Sep 11 AboomoslemAboomoslem 1 - 0 Mes RafsanjanRafsanjan ...
29 Sep 11 Payam MokhaberatPayam 0 - 0 Persepolis ShomalPersepolis ...
29 Sep 11 Shahrdari ArakShahrdari 1 - 1 Gostaresh FouladGostaresh ...
29 Sep 11 PaykanPaykan 1 - 1 Foolad YazdFoolad Yazd ...
29 Sep 11 Shahrdari Bandar AbbasShahrdari 0 - 1 Parseh Tehran FCParseh ...
29 Sep 11 Iranjavan FCIranjavan 2 - 1 Etka Gorgan FCEtka Gorgan ...
27 Nov 11 Steel AzinSteel Azin 3 - 0 Sanat SariSanat Sari ...
Jornada 3
14 Oct 11 Etka Gorgan FCEtka Gorgan 1 - 2 Steel AzinSteel Azin ...
14 Oct 11 Mes RafsanjanRafsanjan 1 - 2 PaykanPaykan ...
14 Oct 11 Parseh Tehran FCParseh 0 - 1 Shahrdari ArakShahrdari ...
14 Oct 11 Foolad YazdFoolad Yazd 1 - 0 Shahrdari Bandar AbbasShahrdari ...
14 Oct 11 Gostaresh FouladGostaresh 0 - 0 Iranjavan FCIranjavan ...
14 Oct 11 Persepolis ShomalPersepolis 0 - 1 AboomoslemAboomoslem ...
14 Oct 11 Sanat SariSanat Sari 1 - 0 Payam MokhaberatPayam ...
Jornada 4
20 Oct 11 Steel AzinSteel Azin 4 - 2 Gostaresh FouladGostaresh ...
20 Oct 11 AboomoslemAboomoslem 0 - 0 Payam MokhaberatPayam ...
20 Oct 11 Etka Gorgan FCEtka Gorgan 2 - 1 Sanat SariSanat Sari ...
20 Oct 11 Shahrdari ArakShahrdari 1 - 0 Foolad YazdFoolad Yazd ...
20 Oct 11 PaykanPaykan 2 - 1 Persepolis ShomalPersepolis ...
20 Oct 11 Shahrdari Bandar AbbasShahrdari 3 - 1 Mes RafsanjanRafsanjan ...
20 Oct 11 Iranjavan FCIranjavan 0 - 2 Parseh Tehran FCParseh ...
Jornada 5
02 Nov 11 Foolad YazdFoolad Yazd 2 - 2 Iranjavan FCIranjavan ...
02 Nov 11 Gostaresh FouladGostaresh 1 - 1 Etka Gorgan FCEtka Gorgan ...
02 Nov 11 Persepolis ShomalPersepolis 1 - 1 Shahrdari Bandar AbbasShahrdari ...
02 Nov 11 Sanat SariSanat Sari 1 - 1 AboomoslemAboomoslem ...
03 Nov 11 Mes RafsanjanRafsanjan 1 - 2 Shahrdari ArakShahrdari ...
03 Nov 11 Parseh Tehran FCParseh 1 - 2 Steel AzinSteel Azin ...
03 Nov 11 Payam MokhaberatPayam 1 - 7 PaykanPaykan ...
Jornada 6
10 Nov 11 Steel AzinSteel Azin 0 - 0 Foolad YazdFoolad Yazd ...
10 Nov 11 Etka Gorgan FCEtka Gorgan 3 - 0 Parseh Tehran FCParseh ...
10 Nov 11 PaykanPaykan 1 - 0 AboomoslemAboomoslem ...
10 Nov 11 Shahrdari ArakShahrdari 1 - 1 Persepolis ShomalPersepolis ...
10 Nov 11 Shahrdari Bandar AbbasShahrdari 1 - 0 Payam MokhaberatPayam ...
10 Nov 11 Gostaresh FouladGostaresh 1 - 0 Sanat SariSanat Sari ...
11 Nov 11 Iranjavan FCIranjavan 4 - 0 Mes RafsanjanRafsanjan ...
Jornada 7
16 Nov 11 Payam MokhaberatPayam 0 - 1 Shahrdari ArakShahrdari ...
17 Nov 11 Parseh Tehran FCParseh 2 - 1 Gostaresh FouladGostaresh ...
17 Nov 11 Persepolis ShomalPersepolis 1 - 1 Iranjavan FCIranjavan ...
17 Nov 11 Mes RafsanjanRafsanjan 1 - 2 Steel AzinSteel Azin ...
17 Nov 11 Sanat SariSanat Sari 0 - 1 PaykanPaykan ...
17 Nov 11 Foolad YazdFoolad Yazd 2 - 0 Etka Gorgan FCEtka Gorgan ...
17 Nov 11 AboomoslemAboomoslem 0 - 1 Shahrdari Bandar AbbasShahrdari ...
Jornada 8
22 Nov 11 Parseh Tehran FCParseh 1 - 4 Sanat SariSanat Sari ...
22 Nov 11 Shahrdari ArakShahrdari 1 - 0 AboomoslemAboomoslem ...
22 Nov 11 Steel AzinSteel Azin 0 - 0 Persepolis ShomalPersepolis ...
23 Nov 11 Gostaresh FouladGostaresh 1 - 4 Foolad YazdFoolad Yazd ...
24 Nov 11 Etka Gorgan FCEtka Gorgan 0 - 1 Mes RafsanjanRafsanjan ...
24 Nov 11 Shahrdari Bandar AbbasShahrdari 2 - 3 PaykanPaykan ...
24 Nov 11 Iranjavan FCIranjavan 3 - 1 Payam MokhaberatPayam ...
Jornada 9
30 Nov 11 Foolad YazdFoolad Yazd 2 - 1 Parseh Tehran FCParseh ...
01 Dic 11 Persepolis ShomalPersepolis 1 - 0 Etka Gorgan FCEtka Gorgan ...
01 Dic 11 Mes RafsanjanRafsanjan 0 - 0 Gostaresh FouladGostaresh ...
01 Dic 11 PaykanPaykan 0 - 0 Shahrdari ArakShahrdari ...
02 Dic 11 Payam MokhaberatPayam 1 - 0 Steel AzinSteel Azin ...
02 Dic 11 Sanat SariSanat Sari 0 - 0 Shahrdari Bandar AbbasShahrdari ...
03 Dic 11 AboomoslemAboomoslem 0 - 0 Iranjavan FCIranjavan ...
Jornada 10
09 Dic 11 Iranjavan FCIranjavan 1 - 0 PaykanPaykan ...
09 Dic 11 Etka Gorgan FCEtka Gorgan 0 - 2 Payam MokhaberatPayam ...
09 Dic 11 Shahrdari ArakShahrdari 0 - 1 Shahrdari Bandar AbbasShahrdari ...
09 Dic 11 Steel AzinSteel Azin 0 - 2 AboomoslemAboomoslem ...
09 Dic 11 Parseh Tehran FCParseh 1 - 0 Mes RafsanjanRafsanjan ...
09 Dic 11 Foolad YazdFoolad Yazd 2 - 0 Sanat SariSanat Sari ...
10 Dic 11 Gostaresh FouladGostaresh 0 - 0 Persepolis ShomalPersepolis ...
Jornada 11
15 Dic 11 Sanat SariSanat Sari 1 - 0 Shahrdari ArakShahrdari ...
15 Dic 11 Mes RafsanjanRafsanjan 2 - 0 Foolad YazdFoolad Yazd ...
15 Dic 11 PaykanPaykan 2 - 1 Steel AzinSteel Azin ...
15 Dic 11 AboomoslemAboomoslem 0 - 2 Etka Gorgan FCEtka Gorgan ...
15 Dic 11 Shahrdari Bandar AbbasShahrdari 2 - 1 Iranjavan FCIranjavan ...
16 Dic 11 Persepolis ShomalPersepolis 2 - 0 Parseh Tehran FCParseh ...
16 Dic 11 Payam MokhaberatPayam 1 - 1 Gostaresh FouladGostaresh ...
Jornada 12
22 Dic 11 Mes RafsanjanRafsanjan 1 - 0 Sanat SariSanat Sari ...
22 Dic 11 Iranjavan FCIranjavan 0 - 0 Shahrdari ArakShahrdari ...
22 Dic 11 Foolad YazdFoolad Yazd 0 - 0 Persepolis ShomalPersepolis ...
22 Dic 11 Steel AzinSteel Azin 2 - 1 Shahrdari Bandar AbbasShahrdari ...
22 Dic 11 Parseh Tehran FCParseh 0 - 0 Payam MokhaberatPayam ...
22 Dic 11 Etka Gorgan FCEtka Gorgan 1 - 0 PaykanPaykan ...
22 Dic 11 Gostaresh FouladGostaresh 1 - 1 AboomoslemAboomoslem ...
Jornada 13
27 Dic 11 Sanat SariSanat Sari 1 - 3 Iranjavan FCIranjavan ...
27 Dic 11 Shahrdari ArakShahrdari 0 - 0 Steel AzinSteel Azin ...
27 Dic 11 Persepolis ShomalPersepolis 1 - 1 Mes RafsanjanRafsanjan ...
27 Dic 11 Payam MokhaberatPayam 1 - 1 Foolad YazdFoolad Yazd ...
27 Dic 11 Shahrdari Bandar AbbasShahrdari 0 - 0 Etka Gorgan FCEtka Gorgan ...
27 Dic 11 AboomoslemAboomoslem 1 - 0 Parseh Tehran FCParseh ...
27 Dic 11 PaykanPaykan 1 - 1 Gostaresh FouladGostaresh ...
Jornada 14
12 Ene 12 Iranjavan FCIranjavan 0 - 2 Steel AzinSteel Azin ...
12 Ene 12 Payam MokhaberatPayam 0 - 0 Mes RafsanjanRafsanjan ...
12 Ene 12 Shahrdari ArakShahrdari 0 - 1 Etka Gorgan FCEtka Gorgan ...
12 Ene 12 AboomoslemAboomoslem 1 - 0 Foolad YazdFoolad Yazd ...
12 Ene 12 Shahrdari Bandar AbbasShahrdari 4 - 3 Gostaresh FouladGostaresh ...
12 Ene 12 PaykanPaykan 1 - 0 Parseh Tehran FCParseh ...
16 Ene 12 Persepolis ShomalPersepolis 2 - 2 Sanat SariSanat Sari ...
Jornada 15
19 Ene 12 Mes RafsanjanRafsanjan 1 - 1 AboomoslemAboomoslem ...
19 Ene 12 Foolad YazdFoolad Yazd 1 - 1 PaykanPaykan ...
19 Ene 12 Parseh Tehran FCParseh 1 - 2 Shahrdari Bandar AbbasShahrdari ...
19 Ene 12 Etka Gorgan FCEtka Gorgan 0 - 1 Iranjavan FCIranjavan ...
20 Ene 12 Persepolis ShomalPersepolis 2 - 0 Payam MokhaberatPayam ...
21 Ene 12 Sanat SariSanat Sari 1 - 0 Steel AzinSteel Azin ...
21 Ene 12 Gostaresh FouladGostaresh 1 - 0 Shahrdari ArakShahrdari ...
Jornada 16
27 Ene 12 Payam MokhaberatPayam 1 - 0 Sanat SariSanat Sari ...
27 Ene 12 Steel AzinSteel Azin 1 - 0 Etka Gorgan FCEtka Gorgan ...
27 Ene 12 AboomoslemAboomoslem 0 - 1 Persepolis ShomalPersepolis ...
27 Ene 12 Iranjavan FCIranjavan 2 - 0 Gostaresh FouladGostaresh ...
27 Ene 12 PaykanPaykan 3 - 2 Mes RafsanjanRafsanjan ...
27 Ene 12 Shahrdari ArakShahrdari 2 - 1 Parseh Tehran FCParseh ...
27 Ene 12 Shahrdari Bandar AbbasShahrdari 2 - 1 Foolad YazdFoolad Yazd ...
Jornada 17
02 Feb 12 Gostaresh FouladGostaresh 2 - 0 Steel AzinSteel Azin ...
03 Feb 12 Sanat SariSanat Sari 1 - 2 Etka Gorgan FCEtka Gorgan ...
03 Feb 12 Payam MokhaberatPayam 0 - 1 AboomoslemAboomoslem ...
03 Feb 12 Persepolis ShomalPersepolis 2 - 1 PaykanPaykan ...
03 Feb 12 Parseh Tehran FCParseh 0 - 0 Iranjavan FCIranjavan ...
03 Feb 12 Foolad YazdFoolad Yazd 0 - 0 Shahrdari ArakShahrdari ...
03 Feb 12 Mes RafsanjanRafsanjan 0 - 0 Shahrdari Bandar AbbasShahrdari ...
Jornada 18
09 Feb 12 AboomoslemAboomoslem 3 - 0 Sanat SariSanat Sari ...
09 Feb 12 Etka Gorgan FCEtka Gorgan 0 - 0 Gostaresh FouladGostaresh ...
09 Feb 12 PaykanPaykan 1 - 0 Payam MokhaberatPayam ...
09 Feb 12 Steel AzinSteel Azin 0 - 1 Parseh Tehran FCParseh ...
09 Feb 12 Shahrdari Bandar AbbasShahrdari 2 - 1 Persepolis ShomalPersepolis ...
09 Feb 12 Iranjavan FCIranjavan 2 - 1 Foolad YazdFoolad Yazd ...
09 Feb 12 Shahrdari ArakShahrdari 1 - 0 Mes RafsanjanRafsanjan ...
Jornada 19
15 Feb 12 Sanat SariSanat Sari 1 - 2 Gostaresh FouladGostaresh ...
15 Feb 12 Payam MokhaberatPayam 0 - 0 Shahrdari Bandar AbbasShahrdari ...
15 Feb 12 Foolad YazdFoolad Yazd 0 - 0 Steel AzinSteel Azin ...
16 Feb 12 AboomoslemAboomoslem 1 - 2 PaykanPaykan ...
16 Feb 12 Parseh Tehran FCParseh 0 - 0 Etka Gorgan FCEtka Gorgan ...
16 Feb 12 Mes RafsanjanRafsanjan 1 - 2 Iranjavan FCIranjavan ...
16 Feb 12 Persepolis ShomalPersepolis 2 - 1 Shahrdari ArakShahrdari ...
Jornada 20
23 Feb 12 PaykanPaykan 4 - 2 Sanat SariSanat Sari ...
23 Feb 12 Gostaresh FouladGostaresh 1 - 0 Parseh Tehran FCParseh ...
23 Feb 12 Etka Gorgan FCEtka Gorgan 0 - 1 Foolad YazdFoolad Yazd ...
23 Feb 12 Shahrdari ArakShahrdari 0 - 1 Payam MokhaberatPayam ...
23 Feb 12 Steel AzinSteel Azin 0 - 0 Mes RafsanjanRafsanjan ...
23 Feb 12 Shahrdari Bandar AbbasShahrdari 1 - 1 AboomoslemAboomoslem ...
23 Feb 12 Iranjavan FCIranjavan 2 - 0 Persepolis ShomalPersepolis ...
Jornada 21
28 Feb 12 Persepolis ShomalPersepolis 1 - 2 Steel AzinSteel Azin ...
29 Feb 12 AboomoslemAboomoslem 0 - 0 Shahrdari ArakShahrdari ...
29 Feb 12 PaykanPaykan 4 - 1 Shahrdari Bandar AbbasShahrdari ...
29 Feb 12 Sanat SariSanat Sari 1 - 0 Parseh Tehran FCParseh ...
29 Feb 12 Foolad YazdFoolad Yazd 0 - 0 Gostaresh FouladGostaresh ...
29 Feb 12 Mes RafsanjanRafsanjan 0 - 0 Etka Gorgan FCEtka Gorgan ...
29 Feb 12 Payam MokhaberatPayam 0 - 0 Iranjavan FCIranjavan ...
Jornada 22
08 Mar 12 Parseh Tehran FCParseh 3 - 0 Foolad YazdFoolad Yazd ...
08 Mar 12 Shahrdari ArakShahrdari 2 - 2 PaykanPaykan ...
08 Mar 12 Gostaresh FouladGostaresh 1 - 2 Mes RafsanjanRafsanjan ...
08 Mar 12 Etka Gorgan FCEtka Gorgan 1 - 0 Persepolis ShomalPersepolis ...
08 Mar 12 Steel AzinSteel Azin 3 - 1 Payam MokhaberatPayam ...
08 Mar 12 Shahrdari Bandar AbbasShahrdari 0 - 0 Sanat SariSanat Sari ...
08 Mar 12 Iranjavan FCIranjavan 1 - 0 AboomoslemAboomoslem ...
Jornada 23
15 Mar 12 Sanat SariSanat Sari 1 - 0 Foolad YazdFoolad Yazd ...
16 Mar 12 Mes RafsanjanRafsanjan 2 - 0 Parseh Tehran FCParseh ...
16 Mar 12 PaykanPaykan 0 - 0 Iranjavan FCIranjavan ...
16 Mar 12 AboomoslemAboomoslem 2 - 2 Steel AzinSteel Azin ...
16 Mar 12 Payam MokhaberatPayam 2 - 1 Etka Gorgan FCEtka Gorgan ...
16 Mar 12 Persepolis ShomalPersepolis 0 - 1 Gostaresh FouladGostaresh ...
16 Mar 12 Shahrdari Bandar AbbasShahrdari 0 - 1 Shahrdari ArakShahrdari ...
Jornada 24
05 Abr 12 Shahrdari ArakShahrdari 0 - 0 Sanat SariSanat Sari ...
05 Abr 12 Foolad YazdFoolad Yazd 1 - 0 Mes RafsanjanRafsanjan ...
05 Abr 12 Parseh Tehran FCParseh 2 - 1 Persepolis ShomalPersepolis ...
05 Abr 12 Steel AzinSteel Azin 1 - 1 PaykanPaykan ...
05 Abr 12 Gostaresh FouladGostaresh 1 - 1 Payam MokhaberatPayam ...
05 Abr 12 Etka Gorgan FCEtka Gorgan 0 - 0 AboomoslemAboomoslem ...
05 Abr 12 Iranjavan FCIranjavan 2 - 0 Shahrdari Bandar AbbasShahrdari ...
Jornada 25
12 Abr 12 Sanat SariSanat Sari 2 - 1 Mes RafsanjanRafsanjan ...
12 Abr 12 Shahrdari ArakShahrdari 2 - 1 Iranjavan FCIranjavan ...
12 Abr 12 Payam MokhaberatPayam 1 - 2 Parseh Tehran FCParseh ...
12 Abr 12 Shahrdari Bandar AbbasShahrdari 1 - 1 Steel AzinSteel Azin ...
12 Abr 12 Persepolis ShomalPersepolis 2 - 1 Foolad YazdFoolad Yazd ...
12 Abr 12 AboomoslemAboomoslem 3 - 1 Gostaresh FouladGostaresh ...
12 Abr 12 PaykanPaykan 1 - 1 Etka Gorgan FCEtka Gorgan ...
Jornada 26
18 Abr 12 Iranjavan FCIranjavan 1 - 0 Sanat SariSanat Sari ...
18 Abr 12 Mes RafsanjanRafsanjan 4 - 1 Persepolis ShomalPersepolis ...
18 Abr 12 Steel AzinSteel Azin 1 - 1 Shahrdari ArakShahrdari ...
18 Abr 12 Foolad YazdFoolad Yazd 2 - 1 Payam MokhaberatPayam ...
18 Abr 12 Etka Gorgan FCEtka Gorgan 2 - 0 Shahrdari Bandar AbbasShahrdari ...
18 Abr 12 Parseh Tehran FCParseh 0 - 0 AboomoslemAboomoslem ...
18 Abr 12 Gostaresh FouladGostaresh 2 - 1 PaykanPaykan ...

Clasificación

Equipo PJ GF GC Puntos
1 Paykan Paykan 26 44 26 50
2 Iranjavan FC Iranjavan 26 31 16 48
3 Steel Azin Steel Azin 26 29 22 40
4 Shahrdari Bandar Abbas Shahrdari 26 26 27 38
5 Shahrdari Arak Shahrdari 26 19 17 37
6 Foolad Yazd Foolad Yazd 26 25 23 36
7 Aboomoslem Aboomoslem 26 21 18 34
8 Etka Gorgan FC Etka Gorgan 26 21 20 34
9 Persepolis Shomal Persepolis 26 26 26 33
10 Gostaresh Foulad Gostaresh 26 25 30 32
11 Parseh Tehran FC Parseh 26 20 29 28
12 Mes Rafsanjan Rafsanjan 26 22 28 26
13 Sanat Sari Sanat Sari 26 20 34 26
14 Payam Mokhaberat Payam 26 15 28 25

  USO DE MEMORIA  
6,037,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1646
Total Execution Time  0.1665
  CADENA URL  
/premier_league_azadegan2012/grupo1/calendario
  GET DATOS  
$_GET['/premier_league_azadegan2012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_azadegan2012'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azadegan' 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.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=404 ORDER BY order_id ASC
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 = 16153 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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 = 16153 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 15:32:45' 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-04 15:32:45' 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=4 AND last_update > '2024-05-04 15:32:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 15:32:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azadegan' 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.0020  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 = 16153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16153 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.0019  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 = 16153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16153 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 = 16153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16153 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 16153 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC