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

Cruce de partidos KNVB Beker - Todos los partidos de la temporada

IdaVuelta
 AZ Alkmaar Groningen Utrecht Sparta Rotterdam NAC Breda ADO Den Haag Heerenveen MVV Maastricht Go Ahead Eagles NEC Nijmegen Willem II FC Volendam VVV Venlo PEC Zwolle De Graafschap Den Bosch Excelsior RKC Waalwijk SC Telstar Fortuna Sittard Heracles Cambuur FC Eindhoven Helmond Sport Dordrecht Emmen TOP Oss De Treffers Lisse GVVV HFC Haarlem HSC 21 Katwijk SC Veendam VV Noordwijk Scheveningen Genemuiden Baronie RBC Roosendaal VVOG Quick '20 Hollandia Drachtster Boys SHO EHC Hoensbroek Jong PSV SC Feyenoord Babberich Jong Utrecht BVV Den Bosch
AZ Alkmaar AZ Alkmaar
Groningen Groningen
Utrecht Utrecht
Sparta Rotterdam Sparta Rotterdam
NAC Breda NAC Breda
ADO Den Haag ADO Den Haag
Heerenveen Heerenveen
MVV Maastricht MVV Maastricht
Go Ahead Eagles Go Ahead Eagles
NEC Nijmegen NEC Nijmegen
Willem II Willem II
FC Volendam FC Volendam
VVV Venlo VVV Venlo
PEC Zwolle PEC Zwolle
De Graafschap De Graafschap
Den Bosch Den Bosch
Excelsior Excelsior
RKC Waalwijk RKC Waalwijk
SC Telstar SC Telstar
Fortuna Sittard Fortuna Sittard
Heracles Heracles
Cambuur Cambuur
FC Eindhoven FC Eindhoven
Helmond Sport Helmond Sport
Dordrecht Dordrecht
Emmen Emmen
TOP Oss TOP Oss
De Treffers De Treffers
Lisse Lisse
GVVV GVVV
HFC Haarlem HFC Haarlem
HSC 21 HSC 21
Katwijk Katwijk
SC Veendam SC Veendam
VV Noordwijk VV Noordwijk
Scheveningen Scheveningen
Genemuiden Genemuiden
Baronie Baronie
RBC Roosendaal RBC Roosendaal
VVOG VVOG
Quick '20 Quick '20
Hollandia Hollandia
Drachtster Boys Drachtster Boys
SHO SHO
EHC Hoensbroek EHC Hoensbroek
Jong PSV Jong PSV
SC Feyenoord SC Feyenoord
Babberich Babberich
Jong Utrecht Jong Utrecht
BVV Den Bosch BVV Den Bosch

  USO DE MEMORIA  
7,974,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4377
Total Execution Time  0.4397
  CADENA URL  
/knvb_beker1998/grupo1/cruces
  GET DATOS  
$_GET['/knvb_beker1998/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0127  SELECT type FROM routes WHERE alias = 'knvb_beker1998'
0.0264  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'knvb_beker' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=524 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 524 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1311979,1311942,1311780,1297792,1295192) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=524 ORDER BY order_id ASC
0.0129  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 = 74913 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars1998 AS c WHERE c.league_id='74913' ORDER BY c.id ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 04:37:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 04:37:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 04:37:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 04:37:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'knvb_beker' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 524 AND l.year = 1998
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (74913,74914) 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, e.player_id ASC LIMIT 10
0.0129  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 (74913,74914) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (445640,5987,258276,5891,258205,265705,257942,324236,1578,30091) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 524 AND l.year = 1998
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (74913,74914) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (74913,74914) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (30091,5891,355067,459071,1474,1633,5518,5922,5987,7909) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 524 AND l.year = 1998
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (74913,74914) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (74913,74914) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1211,30091,355067) ORDER BY rp.in_squad = 1 DESC
0.0265  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 74913 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC