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 Ene 49 EspañaEspaña 1 - 1 BélgicaBélgica ...
Ver jornada
Jornada 2
27 Feb 49 ItaliaItalia 4 - 1 PortugalPortugal ...
Ver jornada
Jornada 3
09 Mar 49 Irlanda del NorteIrlanda 0 - 2 GalesGales ...
13 Mar 49 Países BajosPaíses 3 - 3 BélgicaBélgica ...
20 Mar 49 PortugalPortugal 1 - 1 EspañaEspaña ...
20 Mar 49 AustriaAustria 1 - 0 TurquíaTurquía ...
27 Mar 49 EspañaEspaña 1 - 3 ItaliaItalia ...
23 Mar 49 ChecoslovaquiaChecoslovaq 2 - 2 LuxemburgoLuxemburgo ...
Ver jornada
Jornada 4
03 Abr 49 SuizaSuiza 1 - 2 AustriaAustria ...
09 Abr 49 InglaterraInglaterra 1 - 3 EscociaEscocia ...
10 Abr 49 ChecoslovaquiaChecoslovaq 5 - 2 HungríaHungría ...
24 Abr 49 IrlandaIrlanda 0 - 2 BélgicaBélgica ...
27 Abr 49 EscociaEscocia 2 - 0 FranciaFrancia ...
23 Abr 49 Países BajosPaíses 4 - 1 FranciaFrancia ...
Ver jornada
Jornada 5
08 May 49 HungríaHungría 6 - 1 AustriaAustria ...
08 May 49 RumaníaRumanía 2 - 1 PoloniaPolonia ...
12 May 49 TurquíaTurquía 3 - 2 EgiptoEgipto ...
13 May 49 SueciaSuecia 3 - 1 InglaterraInglaterra ...
15 May 49 PortugalPortugal 3 - 2 GalesGales ...
16 May 49 GreciaGrecia 1 - 2 TurquíaTurquía ...
18 May 49 NoruegaNoruega 1 - 4 InglaterraInglaterra ...
18 May 49 GreciaGrecia 1 - 3 EgiptoEgipto ...
22 May 49 ItaliaItalia 3 - 1 AustriaAustria ...
22 May 49 FranciaFrancia 1 - 3 InglaterraInglaterra ...
22 May 49 BélgicaBélgica 3 - 1 GalesGales ...
22 May 49 IrlandaIrlanda 1 - 0 PortugalPortugal ...
26 May 49 SuizaSuiza 4 - 0 GalesGales ...
22 May 49 ChecoslovaquiaChecoslovaq 3 - 2 RumaníaRumanía ...
Ver jornada
Jornada 6
04 Jun 49 FranciaFrancia 4 - 2 SuizaSuiza ...
12 Jun 49 IrlandaIrlanda 1 - 4 EspañaEspaña ...
12 Jun 49 DinamarcaDinamarca 1 - 2 Países BajosPaíses ...
12 Jun 49 HungríaHungría 1 - 1 ItaliaItalia ...
16 Jun 49 FinlandiaFinlandia 1 - 4 Países BajosPaíses ...
19 Jun 49 FranciaFrancia 1 - 5 EspañaEspaña ...
19 Jun 49 SueciaSuecia 2 - 2 HungríaHungría ...
19 Jun 49 PoloniaPolonia 1 - 2 DinamarcaDinamarca ...
19 Jun 49 NoruegaNoruega 1 - 3 YugoslaviaYugoslavia ...
06 Nov 49 Países BajosPaíses 0 - 1 BélgicaBélgica ...
Ver jornada
Jornada 7
08 Jul 49 FinlandiaFinlandia 1 - 1 NoruegaNoruega ...
10 Jul 49 HungríaHungría 8 - 2 PoloniaPolonia ...
30 Jul 49 IsraelIsrael 3 - 1 ChipreChipre ...
Ver jornada
Jornada 8
02 Ago 49 El SalvadorSalvador 3 - 1 PanamáPanamá ...
04 Ago 49 El SalvadorSalvador 2 - 3 PanamáPanamá ...
07 Ago 49 DinamarcaDinamarca 5 - 1 IslandiaIslandia ...
Ver jornada
Jornada 9
11 Sep 49 NoruegaNoruega 0 - 2 DinamarcaDinamarca ...
11 Sep 49 DinamarcaDinamarca 0 - 2 FinlandiaFinlandia ...
21 Sep 49 InglaterraInglaterra 0 - 2 IrlandaIrlanda ...
25 Sep 49 AustriaAustria 3 - 1 ChecoslovaquiaChecoslovaq ...
04 Sep 49 ChecoslovaquiaChecoslovaq 1 - 3 BulgariaBulgaria ...
Ver jornada
Jornada 10
30 Oct 49 ChecoslovaquiaChecoslovaq 2 - 0 PoloniaPolonia ...
02 Oct 49 BélgicaBélgica 3 - 0 SuizaSuiza ...
02 Oct 49 SueciaSuecia 3 - 3 NoruegaNoruega ...
02 Oct 49 PoloniaPolonia 3 - 2 BulgariaBulgaria ...
16 Oct 49 AustriaAustria 3 - 4 HungríaHungría ...
23 Oct 49 RumaníaRumanía 1 - 1 AlbaniaAlbania ...
23 Oct 49 DinamarcaDinamarca 3 - 2 SueciaSuecia ...
30 Oct 49 HungríaHungría 5 - 0 BulgariaBulgaria ...
Ver jornada
Jornada 11
06 Nov 49 PoloniaPolonia 2 - 1 AlbaniaAlbania ...
13 Nov 49 YugoslaviaYugoslavia 2 - 5 AustriaAustria ...
17 Nov 49 BulgariaBulgaria 0 - 0 AlbaniaAlbania ...
20 Nov 49 HungríaHungría 5 - 0 SueciaSuecia ...
23 Nov 49 GalesGales 5 - 1 BélgicaBélgica ...
25 Nov 49 GreciaGrecia 8 - 0 SiriaSiria ...
29 Nov 49 AlbaniaAlbania 1 - 4 RumaníaRumanía ...
30 Nov 49 InglaterraInglaterra 2 - 0 ItaliaItalia ...
Ver jornada
Jornada 12
11 Dic 49 Países BajosPaíses 0 - 1 DinamarcaDinamarca ...

  USO DE MEMORIA  
4,792,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3999
Total Execution Time  0.4017
  CADENA URL  
/amistosos_selecciones1949/grupo1/calendario
  GET DATOS  
$_GET['/amistosos_selecciones1949/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0147  SELECT type FROM routes WHERE alias = 'amistosos_selecciones1949'
0.0301  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1949 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT id,name,alias,stepParent FROM categories WHERE parentId=307 ORDER BY order_id ASC
0.0176  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 = 39481 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 calendars1949 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 39481 ORDER BY round ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 14:05:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 14:05:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 14:05:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 14:05:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1949 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1949
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (39481) 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.0147  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 (39481) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (254662,408638,408547,408799,254664,253609,383117,389300,408687,408741) ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1949
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (39481) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1949
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (39481) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  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 (39481) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (408638) ORDER BY rp.in_squad = 1 DESC