4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
12 Oct 68 Tarsus Idman YurduTarsus 2 - 0 DiyarbakirsporDiyarbakirs ...
13 Oct 68 MKE KırıkkalesporKırıkkale 1 - 0 AltındağAltındağ ...
13 Oct 68 HataysporHatayspor 0 - 0 RizesporRizespor ...
13 Oct 68 Hacettepe SKHacettepe 1 - 1 Petrol Ofisi SKPetrol ...
13 Oct 68 ElazigsporElazigspor 2 - 1 CorumsporCorumspor ...
13 Oct 68 Ceyhanspor Adana	Ceyhanspor 0 - 1 İskenderunsporİskenderun ...
13 Oct 68 AmasyasporAmasyaspor 2 - 0 MalatyasporMalatyaspor ...
Jornada 2
26 Oct 68 Ceyhanspor Adana	Ceyhanspor 2 - 2 AmasyasporAmasyaspor ...
27 Oct 68 MalatyasporMalatyaspor 0 - 0 Tarsus Idman YurduTarsus ...
27 Oct 68 İskenderunsporİskenderun 1 - 0 ElazigsporElazigspor ...
27 Oct 68 Hacettepe SKHacettepe 0 - 1 MKE KırıkkalesporKırıkkale ...
27 Oct 68 DiyarbakirsporDiyarbakirs 2 - 0 AltındağAltındağ ...
27 Oct 68 CorumsporCorumspor 3 - 1 HataysporHatayspor ...
27 Oct 68 RizesporRizespor 2 - 1 Petrol Ofisi SKPetrol ...
Jornada 3
09 Nov 68 Tarsus Idman YurduTarsus 3 - 0 CorumsporCorumspor ...
09 Nov 68 MKE KırıkkalesporKırıkkale 2 - 0 Petrol Ofisi SKPetrol ...
09 Nov 68 HataysporHatayspor 1 - 1 DiyarbakirsporDiyarbakirs ...
09 Nov 68 Hacettepe SKHacettepe 2 - 1 Ceyhanspor Adana	Ceyhanspor ...
09 Nov 68 ElazigsporElazigspor 0 - 0 MalatyasporMalatyaspor ...
09 Nov 68 AmasyasporAmasyaspor 1 - 0 İskenderunsporİskenderun ...
09 Nov 68 AltındağAltındağ 0 - 1 RizesporRizespor ...
Jornada 4
23 Nov 68 Ceyhanspor Adana	Ceyhanspor 2 - 2 MalatyasporMalatyaspor ...
24 Nov 68 Petrol Ofisi SKPetrol 0 - 0 AltındağAltındağ ...
24 Nov 68 MKE KırıkkalesporKırıkkale 1 - 1 HataysporHatayspor ...
24 Nov 68 İskenderunsporİskenderun 2 - 0 Hacettepe SKHacettepe ...
24 Nov 68 DiyarbakirsporDiyarbakirs 2 - 1 ElazigsporElazigspor ...
24 Nov 68 CorumsporCorumspor 0 - 0 AmasyasporAmasyaspor ...
24 Nov 68 RizesporRizespor 0 - 0 Tarsus Idman YurduTarsus ...
Jornada 5
01 Dic 68 Tarsus Idman YurduTarsus 2 - 0 Ceyhanspor Adana	Ceyhanspor ...
01 Dic 68 MKE KırıkkalesporKırıkkale 1 - 0 DiyarbakirsporDiyarbakirs ...
01 Dic 68 MalatyasporMalatyaspor 2 - 0 AltındağAltındağ ...
01 Dic 68 İskenderunsporİskenderun 1 - 1 HataysporHatayspor ...
01 Dic 68 Hacettepe SKHacettepe 1 - 3 RizesporRizespor ...
01 Dic 68 CorumsporCorumspor 5 - 1 Petrol Ofisi SKPetrol ...
01 Dic 68 AmasyasporAmasyaspor 2 - 0 ElazigsporElazigspor ...
Jornada 6
22 Dic 68 Petrol Ofisi SKPetrol 2 - 1 İskenderunsporİskenderun ...
22 Dic 68 MKE KırıkkalesporKırıkkale 1 - 0 MalatyasporMalatyaspor ...
22 Dic 68 HataysporHatayspor 1 - 1 AmasyasporAmasyaspor ...
22 Dic 68 ElazigsporElazigspor 2 - 1 Tarsus Idman YurduTarsus ...
22 Dic 68 DiyarbakirsporDiyarbakirs 4 - 2 Hacettepe SKHacettepe ...
22 Dic 68 Ceyhanspor Adana	Ceyhanspor 2 - 1 AltındağAltındağ ...
28 Dic 68 Tarsus Idman YurduTarsus 2 - 1 HataysporHatayspor ...
Jornada 7
28 Dic 68 AltındağAltındağ 0 - 1 ElazigsporElazigspor ...
29 Dic 68 MKE KırıkkalesporKırıkkale 3 - 2 Ceyhanspor Adana	Ceyhanspor ...
29 Dic 68 MalatyasporMalatyaspor 1 - 0 DiyarbakirsporDiyarbakirs ...
29 Dic 68 İskenderunsporİskenderun 0 - 0 RizesporRizespor ...
29 Dic 68 Hacettepe SKHacettepe 0 - 1 CorumsporCorumspor ...
29 Dic 68 AmasyasporAmasyaspor 0 - 0 Petrol Ofisi SKPetrol ...
05 Ene 69 Petrol Ofisi SKPetrol 1 - 1 Tarsus Idman YurduTarsus ...
Jornada 8
05 Ene 69 HataysporHatayspor 3 - 0 AltındağAltındağ ...
05 Ene 69 Hacettepe SKHacettepe 1 - 3 MalatyasporMalatyaspor ...
05 Ene 69 ElazigsporElazigspor 0 - 1 MKE KırıkkalesporKırıkkale ...
05 Ene 69 CorumsporCorumspor 1 - 1 İskenderunsporİskenderun ...
05 Ene 69 RizesporRizespor 1 - 0 AmasyasporAmasyaspor ...
05 Ene 69 Ceyhanspor Adana	Ceyhanspor 1 - 3 DiyarbakirsporDiyarbakirs ...
12 Ene 69 MKE KırıkkalesporKırıkkale 1 - 0 RizesporRizespor ...
Jornada 9
12 Ene 69 MalatyasporMalatyaspor 3 - 0 HataysporHatayspor ...
12 Ene 69 İskenderunsporİskenderun 2 - 0 Tarsus Idman YurduTarsus ...
12 Ene 69 ElazigsporElazigspor 2 - 0 Ceyhanspor Adana	Ceyhanspor ...
12 Ene 69 DiyarbakirsporDiyarbakirs 1 - 1 Petrol Ofisi SKPetrol ...
12 Ene 69 AmasyasporAmasyaspor 3 - 1 Hacettepe SKHacettepe ...
12 Ene 69 AltındağAltındağ 0 - 2 CorumsporCorumspor ...
19 Ene 69 Tarsus Idman YurduTarsus 2 - 1 MKE KırıkkalesporKırıkkale ...
Jornada 10
19 Ene 69 MalatyasporMalatyaspor 2 - 0 İskenderunsporİskenderun ...
19 Ene 69 HataysporHatayspor 1 - 1 Petrol Ofisi SKPetrol ...
19 Ene 69 Hacettepe SKHacettepe 1 - 0 AltındağAltındağ ...
19 Ene 69 DiyarbakirsporDiyarbakirs 0 - 0 AmasyasporAmasyaspor ...
19 Ene 69 CorumsporCorumspor 1 - 0 Ceyhanspor Adana	Ceyhanspor ...
19 Ene 69 RizesporRizespor 4 - 2 ElazigsporElazigspor ...
26 Ene 69 RizesporRizespor 1 - 0 CorumsporCorumspor ...
Jornada 11
02 Feb 69 İskenderunsporİskenderun 2 - 0 MKE KırıkkalesporKırıkkale ...
02 Feb 69 Hacettepe SKHacettepe 1 - 2 Tarsus Idman YurduTarsus ...
02 Feb 69 ElazigsporElazigspor 1 - 0 HataysporHatayspor ...
02 Feb 69 CorumsporCorumspor 1 - 0 DiyarbakirsporDiyarbakirs ...
02 Feb 69 RizesporRizespor 0 - 1 MalatyasporMalatyaspor ...
02 Feb 69 Ceyhanspor Adana	Ceyhanspor 0 - 1 Petrol Ofisi SKPetrol ...
02 Feb 69 AmasyasporAmasyaspor 3 - 0 AltındağAltındağ ...
Jornada 12
15 Feb 69 Ceyhanspor Adana	Ceyhanspor 2 - 2 RizesporRizespor ...
16 Feb 69 Tarsus Idman YurduTarsus 2 - 0 AltındağAltındağ ...
16 Feb 69 Petrol Ofisi SKPetrol 1 - 0 ElazigsporElazigspor ...
16 Feb 69 MKE KırıkkalesporKırıkkale 2 - 1 AmasyasporAmasyaspor ...
16 Feb 69 MalatyasporMalatyaspor 2 - 0 CorumsporCorumspor ...
16 Feb 69 HataysporHatayspor 2 - 0 Hacettepe SKHacettepe ...
16 Feb 69 DiyarbakirsporDiyarbakirs 1 - 1 İskenderunsporİskenderun ...
Jornada 13
02 Mar 69 Petrol Ofisi SKPetrol 1 - 2 MalatyasporMalatyaspor ...
02 Mar 69 İskenderunsporİskenderun 3 - 1 AltındağAltındağ ...
02 Mar 69 HataysporHatayspor 2 - 1 Ceyhanspor Adana	Ceyhanspor ...
02 Mar 69 ElazigsporElazigspor 1 - 0 Hacettepe SKHacettepe ...
02 Mar 69 CorumsporCorumspor 2 - 1 MKE KırıkkalesporKırıkkale ...
02 Mar 69 RizesporRizespor 2 - 0 DiyarbakirsporDiyarbakirs ...
02 Mar 69 AmasyasporAmasyaspor 2 - 1 Tarsus Idman YurduTarsus ...
Jornada 14
30 Mar 69 Petrol Ofisi SKPetrol 0 - 1 Hacettepe SKHacettepe ...
30 Mar 69 MalatyasporMalatyaspor 2 - 0 AmasyasporAmasyaspor ...
30 Mar 69 İskenderunsporİskenderun 1 - 0 Ceyhanspor Adana	Ceyhanspor ...
30 Mar 69 DiyarbakirsporDiyarbakirs 1 - 1 Tarsus Idman YurduTarsus ...
30 Mar 69 CorumsporCorumspor 2 - 1 ElazigsporElazigspor ...
30 Mar 69 RizesporRizespor 3 - 0 HataysporHatayspor ...
30 Mar 69 AltındağAltındağ 0 - 1 MKE KırıkkalesporKırıkkale ...
Jornada 15
13 Abr 69 Tarsus Idman YurduTarsus 0 - 0 MalatyasporMalatyaspor ...
13 Abr 69 Petrol Ofisi SKPetrol 0 - 0 RizesporRizespor ...
13 Abr 69 MKE KırıkkalesporKırıkkale 1 - 0 Hacettepe SKHacettepe ...
13 Abr 69 HataysporHatayspor 1 - 0 CorumsporCorumspor ...
13 Abr 69 ElazigsporElazigspor 0 - 1 İskenderunsporİskenderun ...
13 Abr 69 AmasyasporAmasyaspor 5 - 2 Ceyhanspor Adana	Ceyhanspor ...
13 Abr 69 AltındağAltındağ 0 - 1 DiyarbakirsporDiyarbakirs ...
Jornada 16
20 Abr 69 Petrol Ofisi SKPetrol 0 - 0 MKE KırıkkalesporKırıkkale ...
20 Abr 69 MalatyasporMalatyaspor 4 - 1 ElazigsporElazigspor ...
20 Abr 69 İskenderunsporİskenderun 3 - 0 AmasyasporAmasyaspor ...
20 Abr 69 DiyarbakirsporDiyarbakirs 1 - 1 HataysporHatayspor ...
20 Abr 69 CorumsporCorumspor 2 - 2 Tarsus Idman YurduTarsus ...
20 Abr 69 RizesporRizespor 5 - 1 AltındağAltındağ ...
20 Abr 69 Ceyhanspor Adana	Ceyhanspor 0 - 0 Hacettepe SKHacettepe ...
Jornada 17
27 Abr 69 Tarsus Idman YurduTarsus 1 - 1 RizesporRizespor ...
27 Abr 69 MalatyasporMalatyaspor 3 - 1 Ceyhanspor Adana	Ceyhanspor ...
27 Abr 69 HataysporHatayspor 1 - 0 MKE KırıkkalesporKırıkkale ...
27 Abr 69 Hacettepe SKHacettepe 0 - 4 İskenderunsporİskenderun ...
27 Abr 69 ElazigsporElazigspor 3 - 1 DiyarbakirsporDiyarbakirs ...
27 Abr 69 AmasyasporAmasyaspor 1 - 0 CorumsporCorumspor ...
27 Abr 69 AltındağAltındağ 2 - 1 Petrol Ofisi SKPetrol ...
Jornada 18
03 May 69 Ceyhanspor Adana	Ceyhanspor 1 - 2 Tarsus Idman YurduTarsus ...
04 May 69 Petrol Ofisi SKPetrol 0 - 2 CorumsporCorumspor ...
04 May 69 HataysporHatayspor 2 - 1 İskenderunsporİskenderun ...
04 May 69 ElazigsporElazigspor 2 - 1 AmasyasporAmasyaspor ...
04 May 69 DiyarbakirsporDiyarbakirs 0 - 1 MKE KırıkkalesporKırıkkale ...
04 May 69 RizesporRizespor 3 - 0 Hacettepe SKHacettepe ...
04 May 69 AltındağAltındağ 0 - 0 MalatyasporMalatyaspor ...
Jornada 19
11 May 69 Tarsus Idman YurduTarsus 4 - 0 ElazigsporElazigspor ...
11 May 69 MalatyasporMalatyaspor 2 - 0 MKE KırıkkalesporKırıkkale ...
11 May 69 İskenderunsporİskenderun 4 - 0 Petrol Ofisi SKPetrol ...
11 May 69 Hacettepe SKHacettepe 1 - 0 DiyarbakirsporDiyarbakirs ...
11 May 69 CorumsporCorumspor 1 - 3 RizesporRizespor ...
11 May 69 AmasyasporAmasyaspor 1 - 1 HataysporHatayspor ...
11 May 69 AltındağAltındağ 0 - 1 Ceyhanspor Adana	Ceyhanspor ...
Jornada 20
18 May 69 Petrol Ofisi SKPetrol 4 - 2 AmasyasporAmasyaspor ...
18 May 69 HataysporHatayspor 0 - 0 Tarsus Idman YurduTarsus ...
18 May 69 ElazigsporElazigspor 3 - 1 AltındağAltındağ ...
18 May 69 DiyarbakirsporDiyarbakirs 2 - 1 MalatyasporMalatyaspor ...
18 May 69 CorumsporCorumspor 1 - 3 Hacettepe SKHacettepe ...
18 May 69 RizesporRizespor 2 - 0 İskenderunsporİskenderun ...
18 May 69 Ceyhanspor Adana	Ceyhanspor 0 - 1 MKE KırıkkalesporKırıkkale ...
Jornada 21
24 May 69 Tarsus Idman YurduTarsus 2 - 0 Petrol Ofisi SKPetrol ...
25 May 69 MKE KırıkkalesporKırıkkale 4 - 0 ElazigsporElazigspor ...
25 May 69 MalatyasporMalatyaspor 3 - 0 Hacettepe SKHacettepe ...
25 May 69 İskenderunsporİskenderun 3 - 0 CorumsporCorumspor ...
25 May 69 DiyarbakirsporDiyarbakirs 3 - 0 Ceyhanspor Adana	Ceyhanspor ...
25 May 69 AmasyasporAmasyaspor 0 - 1 RizesporRizespor ...
25 May 69 AltındağAltındağ 0 - 2 HataysporHatayspor ...
Jornada 22
01 Jun 69 Tarsus Idman YurduTarsus 2 - 1 İskenderunsporİskenderun ...
01 Jun 69 Petrol Ofisi SKPetrol 0 - 0 DiyarbakirsporDiyarbakirs ...
01 Jun 69 HataysporHatayspor 3 - 2 MalatyasporMalatyaspor ...
01 Jun 69 Hacettepe SKHacettepe 1 - 1 AmasyasporAmasyaspor ...
01 Jun 69 CorumsporCorumspor 4 - 0 AltındağAltındağ ...
01 Jun 69 RizesporRizespor 1 - 0 MKE KırıkkalesporKırıkkale ...
01 Jun 69 Ceyhanspor Adana	Ceyhanspor 4 - 2 ElazigsporElazigspor ...
Jornada 23
07 Jun 69 AltındağAltındağ 1 - 1 Hacettepe SKHacettepe ...
08 Jun 69 Petrol Ofisi SKPetrol 1 - 0 HataysporHatayspor ...
08 Jun 69 MKE KırıkkalesporKırıkkale 1 - 1 Tarsus Idman YurduTarsus ...
08 Jun 69 İskenderunsporİskenderun 1 - 0 MalatyasporMalatyaspor ...
08 Jun 69 ElazigsporElazigspor 3 - 0 RizesporRizespor ...
08 Jun 69 Ceyhanspor Adana	Ceyhanspor 0 - 1 CorumsporCorumspor ...
08 Jun 69 AmasyasporAmasyaspor 3 - 0 DiyarbakirsporDiyarbakirs ...
Jornada 24
15 Jun 69 Tarsus Idman YurduTarsus 3 - 1 Hacettepe SKHacettepe ...
15 Jun 69 Petrol Ofisi SKPetrol 0 - 0 Ceyhanspor Adana	Ceyhanspor ...
15 Jun 69 MKE KırıkkalesporKırıkkale 2 - 1 İskenderunsporİskenderun ...
15 Jun 69 MalatyasporMalatyaspor 2 - 0 RizesporRizespor ...
15 Jun 69 HataysporHatayspor 1 - 0 ElazigsporElazigspor ...
15 Jun 69 DiyarbakirsporDiyarbakirs 1 - 0 CorumsporCorumspor ...
15 Jun 69 AltındağAltındağ 1 - 1 AmasyasporAmasyaspor ...
Jornada 25
22 Jun 69 İskenderunsporİskenderun 2 - 0 DiyarbakirsporDiyarbakirs ...
22 Jun 69 CorumsporCorumspor 1 - 1 MalatyasporMalatyaspor ...
22 Jun 69 RizesporRizespor 3 - 0 Ceyhanspor Adana	Ceyhanspor ...
22 Jun 69 AltındağAltındağ 0 - 4 Tarsus Idman YurduTarsus ...
22 Jun 69 Hacettepe SKHacettepe 1 - 2 HataysporHatayspor ...
22 Jun 69 ElazigsporElazigspor 3 - 1 Petrol Ofisi SKPetrol ...
28 Jun 69 Hacettepe SKHacettepe 2 - 2 ElazigsporElazigspor ...
Jornada 26
29 Jun 69 Ceyhanspor Adana	Ceyhanspor 1 - 0 HataysporHatayspor ...
29 Jun 69 MalatyasporMalatyaspor 0 - 1 Petrol Ofisi SKPetrol ...
29 Jun 69 AltındağAltındağ 1 - 1 İskenderunsporİskenderun ...
29 Jun 69 Tarsus Idman YurduTarsus 2 - 0 AmasyasporAmasyaspor ...
29 Jun 69 DiyarbakirsporDiyarbakirs 0 - 0 RizesporRizespor ...
30 Jun 69 MKE KırıkkalesporKırıkkale 0 - 0 CorumsporCorumspor ...

Clasificación

Equipo PJ GF GC Puntos
1 Rizespor Rizespor 26 38 16 52
2 Tarsus Idman Yurdu Tarsus Idman 26 42 18 51
3 MKE Kırıkkalespor Kırıkkales 25 27 16 49
4 Malatyaspor Malatyaspor 26 38 17 48
5 İskenderunspor İskenderuns 26 38 18 47
6 Hatayspor Hatayspor 26 28 26 39
7 Corumspor Corumspor 26 31 28 38
8 Amasyaspor Amasyaspor 25 32 27 35
9 Elazigspor Elazigspor 26 32 39 35
10 Diyarbakirspor Diyarbakirsp 26 24 27 32
11 Petrol Ofisi SK Petrol Ofisi 26 19 32 28
12 Hacettepe SK Hacettepe 26 21 45 20
13 Ceyhanspor Adana	Ceyhanspor 26 23 45 17
14 Altındağ Altındağ 26 9 48 8

  USO DE MEMORIA  
6,034,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1176
Total Execution Time  0.1202
  CADENA URL  
/2_lig_turquia1969/grupo1/calendario
  GET DATOS  
$_GET['/2_lig_turquia1969/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = '2_lig_turquia1969'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 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 = 51019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  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 calendars1969 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51019 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-04-28 12:24:39' 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-04-28 12:24:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:24:39' 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-04-28 12:24:39' 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 = '2_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 AND (e.action = 4 or e.action = 5) 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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 51019 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC