4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
02 Sep 07 WestlandiaWestlandia 0 - 1 HollandiaHollandia ...
02 Sep 07 Türkiyemspor AmsterdamTürkiyemsp 2 - 1 SV Argon SV Argon ...
02 Sep 07 VVSBVVSB 2 - 2 HaaglandiaHaaglandia ...
02 Sep 07 VUCVUC 2 - 3 Amsterdamsche FCAmsterdamsc ...
02 Sep 07 ElinkwijkElinkwijk 4 - 1 Amsterdam FC DWSAmsterdam ...
02 Sep 07 DCVDCV 1 - 4 Almere City AmateursAlmere City ...
02 Sep 07 DWVDWV 1 - 2 ADO 20ADO 20 ...
Ver jornada
Jornada 2
09 Sep 07 ADO 20ADO 20 2 - 2 WestlandiaWestlandia ...
09 Sep 07 HollandiaHollandia 3 - 2 Türkiyemspor AmsterdamTürkiyemsp ...
09 Sep 07 SV Argon SV Argon 2 - 1 VVSBVVSB ...
09 Sep 07 ElinkwijkElinkwijk 2 - 1 Amsterdamsche FCAmsterdamsc ...
09 Sep 07 Amsterdam FC DWSAmsterdam 1 - 1 DCVDCV ...
09 Sep 07 Almere City AmateursAlmere City 1 - 1 DWVDWV ...
16 Sep 07 Türkiyemspor AmsterdamTürkiyemsp 3 - 1 WestlandiaWestlandia ...
Ver jornada
Jornada 3
16 Sep 07 VVSBVVSB 3 - 0 HollandiaHollandia ...
16 Sep 07 VUCVUC 1 - 1 SV Argon SV Argon ...
16 Sep 07 ElinkwijkElinkwijk 0 - 0 HaaglandiaHaaglandia ...
16 Sep 07 DCVDCV 1 - 0 Amsterdamsche FCAmsterdamsc ...
16 Sep 07 DWVDWV 1 - 0 Amsterdam FC DWSAmsterdam ...
16 Sep 07 Almere City AmateursAlmere City 3 - 0 ADO 20ADO 20 ...
23 Sep 07 ADO 20ADO 20 0 - 0 Türkiyemspor AmsterdamTürkiyemsp ...
Ver jornada
Jornada 4
23 Sep 07 WestlandiaWestlandia 0 - 2 VVSBVVSB ...
23 Sep 07 HollandiaHollandia 2 - 0 VUCVUC ...
23 Sep 07 SV Argon SV Argon 3 - 0 ElinkwijkElinkwijk ...
23 Sep 07 HaaglandiaHaaglandia 3 - 1 DCVDCV ...
23 Sep 07 Amsterdamsche FCAmsterdamsc 2 - 1 DWVDWV ...
23 Sep 07 Amsterdam FC DWSAmsterdam 2 - 2 Almere City AmateursAlmere City ...
30 Sep 07 VVSBVVSB 0 - 4 Türkiyemspor AmsterdamTürkiyemsp ...
Ver jornada
Jornada 5
30 Sep 07 VUCVUC 2 - 2 WestlandiaWestlandia ...
30 Sep 07 ElinkwijkElinkwijk 0 - 2 HollandiaHollandia ...
30 Sep 07 DCVDCV 1 - 4 SV Argon SV Argon ...
30 Sep 07 DWVDWV 1 - 0 HaaglandiaHaaglandia ...
30 Sep 07 Almere City AmateursAlmere City 0 - 2 Amsterdamsche FCAmsterdamsc ...
30 Sep 07 Amsterdam FC DWSAmsterdam 1 - 2 ADO 20ADO 20 ...
07 Oct 07 ADO 20ADO 20 1 - 1 VVSBVVSB ...
Ver jornada
Jornada 6
07 Oct 07 Türkiyemspor AmsterdamTürkiyemsp 3 - 3 VUCVUC ...
07 Oct 07 WestlandiaWestlandia 0 - 0 ElinkwijkElinkwijk ...
07 Oct 07 HollandiaHollandia 1 - 0 DCVDCV ...
07 Oct 07 SV Argon SV Argon 1 - 0 DWVDWV ...
07 Oct 07 HaaglandiaHaaglandia 2 - 1 Almere City AmateursAlmere City ...
07 Oct 07 Amsterdamsche FCAmsterdamsc 0 - 0 Amsterdam FC DWSAmsterdam ...
14 Oct 07 VUCVUC 2 - 3 VVSBVVSB ...
Ver jornada
Jornada 7
14 Oct 07 ElinkwijkElinkwijk 1 - 2 Türkiyemspor AmsterdamTürkiyemsp ...
14 Oct 07 DCVDCV 1 - 3 WestlandiaWestlandia ...
14 Oct 07 DWVDWV 0 - 1 HollandiaHollandia ...
14 Oct 07 Almere City AmateursAlmere City 2 - 0 SV Argon SV Argon ...
14 Oct 07 Amsterdamsche FCAmsterdamsc 3 - 1 ADO 20ADO 20 ...
21 Oct 07 HaaglandiaHaaglandia 5 - 2 VUCVUC ...
28 Oct 07 ADO 20ADO 20 2 - 0 VUCVUC ...
Ver jornada
Jornada 8
28 Oct 07 VVSBVVSB 2 - 0 ElinkwijkElinkwijk ...
28 Oct 07 Türkiyemspor AmsterdamTürkiyemsp 6 - 2 DCVDCV ...
28 Oct 07 WestlandiaWestlandia 2 - 2 DWVDWV ...
28 Oct 07 HollandiaHollandia 2 - 0 Almere City AmateursAlmere City ...
28 Oct 07 SV Argon SV Argon 2 - 1 Amsterdam FC DWSAmsterdam ...
28 Oct 07 HaaglandiaHaaglandia 2 - 6 Amsterdamsche FCAmsterdamsc ...
04 Nov 07 ElinkwijkElinkwijk 2 - 1 VUCVUC ...
Ver jornada
Jornada 9
04 Nov 07 DCVDCV 0 - 2 VVSBVVSB ...
04 Nov 07 DWVDWV 0 - 3 Türkiyemspor AmsterdamTürkiyemsp ...
04 Nov 07 Almere City AmateursAlmere City 1 - 1 WestlandiaWestlandia ...
04 Nov 07 Amsterdam FC DWSAmsterdam 0 - 2 HollandiaHollandia ...
04 Nov 07 Amsterdamsche FCAmsterdamsc 0 - 1 SV Argon SV Argon ...
04 Nov 07 HaaglandiaHaaglandia 5 - 2 ADO 20ADO 20 ...
11 Nov 07 VUCVUC 2 - 1 DCVDCV ...
Ver jornada
Jornada 10
11 Nov 07 VVSBVVSB 0 - 3 DWVDWV ...
11 Nov 07 WestlandiaWestlandia 3 - 1 Amsterdam FC DWSAmsterdam ...
11 Nov 07 SV Argon SV Argon 0 - 2 HaaglandiaHaaglandia ...
11 Nov 07 Türkiyemspor AmsterdamTürkiyemsp 1 - 3 Almere City AmateursAlmere City ...
18 Nov 07 DCVDCV 0 - 2 ElinkwijkElinkwijk ...
18 Nov 07 DWVDWV 0 - 1 VUCVUC ...
18 Nov 07 Almere City AmateursAlmere City 1 - 0 VVSBVVSB ...
Ver jornada
Jornada 11
18 Nov 07 Amsterdam FC DWSAmsterdam 1 - 1 Türkiyemspor AmsterdamTürkiyemsp ...
18 Nov 07 Amsterdamsche FCAmsterdamsc 4 - 2 WestlandiaWestlandia ...
18 Nov 07 HaaglandiaHaaglandia 3 - 1 HollandiaHollandia ...
18 Nov 07 SV Argon SV Argon 0 - 0 ADO 20ADO 20 ...
25 Nov 07 ADO 20ADO 20 1 - 1 ElinkwijkElinkwijk ...
25 Nov 07 Amsterdam FC DWSAmsterdam 0 - 1 HaaglandiaHaaglandia ...
02 Dic 07 ElinkwijkElinkwijk 2 - 0 DWVDWV ...
Ver jornada
Jornada 12
09 Dic 07 Almere City AmateursAlmere City 2 - 3 ElinkwijkElinkwijk ...
09 Dic 07 Amsterdamsche FCAmsterdamsc 0 - 3 VVSBVVSB ...
09 Dic 07 HaaglandiaHaaglandia 4 - 3 Türkiyemspor AmsterdamTürkiyemsp ...
16 Dic 07 HollandiaHollandia 3 - 1 WestlandiaWestlandia ...
16 Dic 07 SV Argon SV Argon 1 - 0 Türkiyemspor AmsterdamTürkiyemsp ...
16 Dic 07 HaaglandiaHaaglandia 0 - 0 VVSBVVSB ...
16 Dic 07 Amsterdam FC DWSAmsterdam 0 - 1 ElinkwijkElinkwijk ...
Ver jornada
Jornada 13
16 Dic 07 Almere City AmateursAlmere City 4 - 1 DCVDCV ...
20 Ene 08 DCVDCV 1 - 1 ADO 20ADO 20 ...
20 Ene 08 VUCVUC 4 - 0 Almere City AmateursAlmere City ...
20 Ene 08 WestlandiaWestlandia 0 - 1 HaaglandiaHaaglandia ...
27 Ene 08 WestlandiaWestlandia 0 - 2 ADO 20ADO 20 ...
27 Ene 08 VVSBVVSB 1 - 1 SV Argon SV Argon ...
27 Ene 08 VUCVUC 2 - 1 HaaglandiaHaaglandia ...
Ver jornada
Jornada 14
27 Ene 08 DCVDCV 0 - 0 Amsterdam FC DWSAmsterdam ...
27 Ene 08 DWVDWV 0 - 2 Almere City AmateursAlmere City ...
27 Ene 08 Türkiyemspor AmsterdamTürkiyemsp 0 - 5 HollandiaHollandia ...
27 Ene 08 ElinkwijkElinkwijk 0 - 1 Amsterdamsche FCAmsterdamsc ...
03 Feb 08 DWVDWV 1 - 0 DCVDCV ...
03 Feb 08 Amsterdam FC DWSAmsterdam 0 - 2 VUCVUC ...
03 Feb 08 HollandiaHollandia 0 - 2 SV Argon SV Argon ...
Ver jornada
Jornada 15
03 Feb 08 Türkiyemspor AmsterdamTürkiyemsp 1 - 1 Amsterdamsche FCAmsterdamsc ...
10 Feb 08 WestlandiaWestlandia 1 - 1 Türkiyemspor AmsterdamTürkiyemsp ...
10 Feb 08 HollandiaHollandia 1 - 1 VVSBVVSB ...
10 Feb 08 SV Argon SV Argon 2 - 1 VUCVUC ...
10 Feb 08 HaaglandiaHaaglandia 3 - 1 ElinkwijkElinkwijk ...
10 Feb 08 Amsterdam FC DWSAmsterdam 2 - 3 DWVDWV ...
10 Feb 08 Amsterdamsche FCAmsterdamsc 1 - 0 DCVDCV ...
Ver jornada
Jornada 16
10 Feb 08 ADO 20ADO 20 1 - 0 Almere City AmateursAlmere City ...
17 Feb 08 VVSBVVSB 1 - 2 WestlandiaWestlandia ...
17 Feb 08 VUCVUC 0 - 3 HollandiaHollandia ...
17 Feb 08 DCVDCV 1 - 2 HaaglandiaHaaglandia ...
17 Feb 08 DWVDWV 2 - 1 Amsterdamsche FCAmsterdamsc ...
17 Feb 08 Almere City AmateursAlmere City 0 - 0 Amsterdam FC DWSAmsterdam ...
17 Feb 08 Türkiyemspor AmsterdamTürkiyemsp 2 - 2 ADO 20ADO 20 ...
Ver jornada
Jornada 17
24 Feb 08 SV Argon SV Argon 2 - 1 WestlandiaWestlandia ...
24 Feb 08 VVSBVVSB 3 - 0 Amsterdam FC DWSAmsterdam ...
24 Feb 08 Amsterdamsche FCAmsterdamsc 2 - 3 VUCVUC ...
24 Feb 08 ADO 20ADO 20 0 - 3 HollandiaHollandia ...
02 Mar 08 WestlandiaWestlandia 3 - 1 VUCVUC ...
02 Mar 08 HollandiaHollandia 2 - 0 ElinkwijkElinkwijk ...
02 Mar 08 SV Argon SV Argon 1 - 0 DCVDCV ...
Ver jornada
Jornada 18
02 Mar 08 HaaglandiaHaaglandia 4 - 0 DWVDWV ...
02 Mar 08 Türkiyemspor AmsterdamTürkiyemsp 3 - 1 VVSBVVSB ...
02 Mar 08 Amsterdamsche FCAmsterdamsc 3 - 1 Almere City AmateursAlmere City ...
02 Mar 08 ADO 20ADO 20 2 - 1 Amsterdam FC DWSAmsterdam ...
09 Mar 08 VVSBVVSB 1 - 0 ADO 20ADO 20 ...
09 Mar 08 VUCVUC 2 - 1 Türkiyemspor AmsterdamTürkiyemsp ...
09 Mar 08 ElinkwijkElinkwijk 2 - 4 WestlandiaWestlandia ...
Ver jornada
Jornada 19
09 Mar 08 DCVDCV 0 - 2 HollandiaHollandia ...
09 Mar 08 Almere City AmateursAlmere City 1 - 1 HaaglandiaHaaglandia ...
16 Mar 08 WestlandiaWestlandia 2 - 0 DCVDCV ...
16 Mar 08 HaaglandiaHaaglandia 2 - 3 Amsterdam FC DWSAmsterdam ...
22 Mar 08 Türkiyemspor AmsterdamTürkiyemsp 1 - 1 ElinkwijkElinkwijk ...
22 Mar 08 Amsterdam FC DWSAmsterdam 1 - 0 Amsterdamsche FCAmsterdamsc ...
22 Mar 08 DWVDWV 2 - 2 SV Argon SV Argon ...
Ver jornada
Jornada 20
24 Mar 08 VVSBVVSB 2 - 1 VUCVUC ...
27 Mar 08 ElinkwijkElinkwijk 3 - 2 SV Argon SV Argon ...
27 Mar 08 ADO 20ADO 20 0 - 0 DWVDWV ...
27 Mar 08 HollandiaHollandia 2 - 0 Amsterdamsche FCAmsterdamsc ...
30 Mar 08 ElinkwijkElinkwijk 1 - 2 VVSBVVSB ...
30 Mar 08 DCVDCV 4 - 0 Türkiyemspor AmsterdamTürkiyemsp ...
30 Mar 08 DWVDWV 1 - 1 WestlandiaWestlandia ...
Ver jornada
Jornada 21
30 Mar 08 Almere City AmateursAlmere City 0 - 3 HollandiaHollandia ...
30 Mar 08 Amsterdam FC DWSAmsterdam 2 - 1 SV Argon SV Argon ...
30 Mar 08 Amsterdamsche FCAmsterdamsc 2 - 2 HaaglandiaHaaglandia ...
06 Abr 08 VUCVUC 0 - 0 ElinkwijkElinkwijk ...
06 Abr 08 VVSBVVSB 1 - 0 DCVDCV ...
06 Abr 08 WestlandiaWestlandia 2 - 1 Almere City AmateursAlmere City ...
06 Abr 08 HollandiaHollandia 1 - 0 Amsterdam FC DWSAmsterdam ...
Ver jornada
Jornada 22
06 Abr 08 SV Argon SV Argon 1 - 1 Amsterdamsche FCAmsterdamsc ...
06 Abr 08 Türkiyemspor AmsterdamTürkiyemsp 2 - 4 DWVDWV ...
06 Abr 08 ADO 20ADO 20 4 - 0 HaaglandiaHaaglandia ...
10 Abr 08 ADO 20ADO 20 2 - 2 Amsterdamsche FCAmsterdamsc ...
13 Abr 08 SV Argon SV Argon 2 - 2 Almere City AmateursAlmere City ...
13 Abr 08 VUCVUC 1 - 1 ADO 20ADO 20 ...
13 Abr 08 HollandiaHollandia 1 - 1 DWVDWV ...
Ver jornada
Jornada 23
20 Abr 08 DWVDWV 0 - 2 VVSBVVSB ...
20 Abr 08 Almere City AmateursAlmere City 4 - 0 Türkiyemspor AmsterdamTürkiyemsp ...
20 Abr 08 DCVDCV 0 - 3 VUCVUC ...
20 Abr 08 ElinkwijkElinkwijk 3 - 0 ADO 20ADO 20 ...
20 Abr 08 Amsterdam FC DWSAmsterdam 0 - 1 WestlandiaWestlandia ...
20 Abr 08 HaaglandiaHaaglandia 1 - 3 SV Argon SV Argon ...
20 Abr 08 Amsterdamsche FCAmsterdamsc 2 - 1 HollandiaHollandia ...
Ver jornada
Jornada 24
27 Abr 08 HollandiaHollandia 2 - 2 HaaglandiaHaaglandia ...
27 Abr 08 VUCVUC 1 - 0 DWVDWV ...
27 Abr 08 VVSBVVSB 1 - 4 Almere City AmateursAlmere City ...
27 Abr 08 ElinkwijkElinkwijk 4 - 0 DCVDCV ...
27 Abr 08 WestlandiaWestlandia 1 - 2 Amsterdamsche FCAmsterdamsc ...
27 Abr 08 ADO 20ADO 20 1 - 3 SV Argon SV Argon ...
27 Abr 08 Türkiyemspor AmsterdamTürkiyemsp 2 - 0 Amsterdam FC DWSAmsterdam ...
Ver jornada
Jornada 25
04 May 08 Amsterdamsche FCAmsterdamsc 3 - 3 Türkiyemspor AmsterdamTürkiyemsp ...
04 May 08 DWVDWV 4 - 3 ElinkwijkElinkwijk ...
04 May 08 Amsterdam FC DWSAmsterdam 0 - 2 VVSBVVSB ...
04 May 08 HaaglandiaHaaglandia 1 - 1 WestlandiaWestlandia ...
04 May 08 SV Argon SV Argon 2 - 0 HollandiaHollandia ...
04 May 08 Almere City AmateursAlmere City 1 - 1 VUCVUC ...
04 May 08 ADO 20ADO 20 1 - 0 DCVDCV ...
Ver jornada
Jornada 26
12 May 08 VUCVUC 2 - 0 Amsterdam FC DWSAmsterdam ...
12 May 08 HollandiaHollandia 0 - 1 ADO 20ADO 20 ...
12 May 08 Türkiyemspor AmsterdamTürkiyemsp 4 - 0 HaaglandiaHaaglandia ...
12 May 08 DCVDCV 0 - 1 DWVDWV ...
12 May 08 ElinkwijkElinkwijk 2 - 3 Almere City AmateursAlmere City ...
12 May 08 VVSBVVSB 1 - 1 Amsterdamsche FCAmsterdamsc ...
12 May 08 WestlandiaWestlandia 3 - 0 SV Argon SV Argon ...

Clasificación

Equipo PJ GF GC Puntos
1 Hollandia Hollandia 26 44 20 54
2 SV Argon SV Argon 26 40 28 48
3 VVSB VVSB 26 38 29 45
4 Haaglandia Haaglandia 26 49 43 43
5 Amsterdamsche FC Amsterdamsch 26 43 36 40
6 Almere City Amateurs Almere City 26 43 36 37
7 ADO 20 ADO 20 26 31 34 37
8 VUC VUC 26 40 40 36
9 Türkiyemspor Amsterdam Türkiyemspo 26 50 48 35
10 Westlandia Westlandia 26 39 37 35
11 Elinkwijk Elinkwijk 26 38 37 35
12 DWV DWV 26 29 36 33
13 Amsterdam FC DWS Amsterdam 26 17 41 15
14 DCV DCV 26 16 52 9

  USO DE MEMORIA  
5,960,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1317
Total Execution Time  0.1337
  CADENA URL  
/hoofdklasse_zondag_liga_holanda2008/grupo1/calendario
  GET DATOS  
$_GET['/hoofdklasse_zondag_liga_holanda2008/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'hoofdklasse_zondag_liga_holanda2008'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hoofdklasse_zondag_liga_holanda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=227 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 227 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  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 (711277) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=227 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 227 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=227 GROUP BY l.year ORDER BY l.year DESC
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 = 20409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 calendars2008 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20409 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-04-28 18:00:54' 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 18:00:54' 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-04-28 18:00:54' 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=3 AND last_update > '2024-04-28 18:00:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hoofdklasse_zondag_liga_holanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 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 events2008 e ON e.player_id = p.id AND e.league_id = 20409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 20409 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.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 events2008 e ON e.player_id = p.id AND e.league_id = 20409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 20409 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 events2008 e ON e.player_id = p.id AND e.league_id = 20409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 20409 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 20409 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC