4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
22 May 16 Mancha RealMancha Real 3 - 1 ZamoraZamora 568
29 May 16 ZamoraZamora 0 - 2 Mancha RealMancha Real 533
29 May 16 ExtremaduraExtremadura 2 - 0 UB ConquenseConquense 236
22 May 16 UB ConquenseConquense 0 - 0 ExtremaduraExtremadura 220
22 May 16 BoiroBoiro 2 - 0 Caudal DeportivoCaudal 186
29 May 16 Caudal DeportivoCaudal 1 - 0 BoiroBoiro 87
21 May 16 Deportivo AragónDeportivo 0 - 0 Mallorca BMallorca B 56
29 May 16 Mallorca BMallorca B 2 - 0 Deportivo AragónDeportivo 68
29 May 16 UD SanseUD Sanse 3 - 1 Villa Santa BrígidaVilla Santa 99
22 May 16 Villa Santa BrígidaVilla Santa 1 - 0 UD SanseUD Sanse 56
29 May 16 CD CalahorraCalahorra 2 - 0 At. SaguntinoSaguntino 316
22 May 16 At. SaguntinoSaguntino 2 - 0 CD CalahorraCalahorra 115
28 May 16 CD LaredoCD Laredo 1 - 0 SD ZamudioSD Zamudio 76
21 May 16 SD ZamudioSD Zamudio 3 - 1 CD LaredoCD Laredo 80
29 May 16 Lorca DeportivaLorca 0 - 3 Córdoba CF BCórdoba 258
22 May 16 Córdoba CF BCórdoba 1 - 2 Lorca DeportivaLorca 219
29 May 16 Osasuna PromesasOsasuna 1 - 0 AE PratAE Prat 46
22 May 16 AE PratAE Prat 3 - 1 Osasuna PromesasOsasuna 48
29 May 16 CDA NavalcarneroNavalcarner 2 - 0 TeniscaTenisca 72
22 May 16 TeniscaTenisca 2 - 1 CDA NavalcarneroNavalcarner 55
29 May 16 Almagro CFAlmagro CF 0 - 0 Atlético BAtlético 38
22 May 16 Atlético BAtlético 0 - 2 Almagro CFAlmagro CF 96
22 May 16 IlicitanoIlicitano 2 - 0 LanzaroteLanzarote 65
29 May 16 LanzaroteLanzarote 1 - 1 IlicitanoIlicitano 57
28 May 16 Ontinyent CFOntinyent 1 - 0 CD TeruelCD Teruel 67
22 May 16 CD TeruelCD Teruel 0 - 2 Ontinyent CFOntinyent 119
29 May 16 CCD CercedaCerceda 2 - 1 CD VillaralboVillaralbo 35
22 May 16 CD VillaralboVillaralbo 1 - 1 CCD CercedaCerceda 66
29 May 16 CD BadajozCD Badajoz 2 - 2 ChocoChoco 520
22 May 16 ChocoChoco 2 - 1 CD BadajozCD Badajoz 432
22 May 16 ConstànciaConstància 1 - 2 SD LogroñésLogroñés 109
29 May 16 SD LogroñésLogroñés 1 - 1 ConstànciaConstància 64
22 May 16 Pvo. El EjidoPvo. Ejido 3 - 0 Club BermeoClub Bermeo 160
28 May 16 Club BermeoClub Bermeo 3 - 2 Pvo. El EjidoPvo. Ejido 107
29 May 16 Águilas FCÁguilas 2 - 1 Balmaseda FCBalmaseda 138
22 May 16 Balmaseda FCBalmaseda 1 - 1 Águilas FCÁguilas 159
21 May 16 MutilveraMutilvera 2 - 0 Gimnástica TorrelavegaGimnástica 33
29 May 16 Gimnástica TorrelavegaGimnástica 1 - 0 MutilveraMutilvera 17
21 May 16 Marino de LuancoMarino 1 - 1 CF GaváCF Gavá 69
28 May 16 CF GaváCF Gavá 3 - 2 Marino de LuancoMarino 102
28 May 16 CirboneroCirbonero 0 - 2 CayónCayón 41
21 May 16 CayónCayón 2 - 1 CirboneroCirbonero 44
22 May 16 CD AlcaláCD Alcalá 2 - 1 LangreoLangreo 310
29 May 16 LangreoLangreo 2 - 0 CD AlcaláCD Alcalá 297
29 May 16 At. MalagueñoMalagueño 2 - 0 FC VilafrancaVilafranca 103
22 May 16 FC VilafrancaVilafranca 0 - 0 At. MalagueñoMalagueño 76
29 May 16 Gimnástica SegovianaGimnástica 0 - 1 JerezJerez 95
22 May 16 JerezJerez 1 - 1 Gimnástica SegovianaGimnástica 140
22 May 16 Racing Cartagena Mar MenorRacing 0 - 1 SD FormenteraFormentera 111
29 May 16 SD FormenteraFormentera 0 - 2 Racing Cartagena Mar MenorRacing 79
29 May 16 At. SanluqueñoSanluqueño 1 - 0 NáxaraNáxara 111
21 May 16 NáxaraNáxara 0 - 0 At. SanluqueñoSanluqueño 101
22 May 16 UD AlmansaUD Almansa 0 - 0 AndorraAndorra 40
29 May 16 AndorraAndorra 0 - 0 UD AlmansaUD Almansa 67
29 May 16 El PalmarEl Palmar 1 - 1 Deportivo FabrilDeportivo 19
22 May 16 Deportivo FabrilDeportivo 4 - 0 El PalmarEl Palmar 93
29 May 16 ArroyoArroyo 2 - 1 CD AzuquecaAzuqueca 90
21 May 16 CD AzuquecaAzuqueca 1 - 0 ArroyoArroyo 110
29 May 16 LojaLoja 0 - 3 CD Palencia BalompiéPalencia 310
22 May 16 CD Palencia BalompiéPalencia 1 - 2 LojaLoja 358
29 May 16 CF PozueloCF Pozuelo 0 - 2 Haro DeportivoHaro 53
22 May 16 Haro DeportivoHaro 0 - 0 CF PozueloCF Pozuelo 48
29 May 16 SD TarazonaTarazona 1 - 0 AD San JuanJuan 27
21 May 16 AD San JuanJuan 0 - 0 SD TarazonaTarazona 39
29 May 16 CE EuropaCE Europa 2 - 3 San Fernando CDFernando 117
22 May 16 San Fernando CDFernando 1 - 1 CE EuropaCE Europa 106
22 May 16 CD Lagun OnakLagun Onak 1 - 0 Real Avilés IndustrialReal 69
29 May 16 Real Avilés IndustrialReal 1 - 0 CD Lagun OnakLagun Onak 140
22 May 16 CD CastellónCastellón 1 - 0 Peña DeportivaPeña 393
29 May 16 Peña DeportivaPeña 0 - 1 CD CastellónCastellón 366
22 May 16 Las Palmas At.Palmas 1 - 0 Rayo CantabriaRayo 77
28 May 16 Rayo CantabriaRayo 0 - 1 Las Palmas At.Palmas 58
Ver jornada
Jornada 2
12 Jun 16 ZamoraZamora 0 - 2 MutilveraMutilvera 289
04 Jun 16 MutilveraMutilvera 3 - 1 ZamoraZamora 339
05 Jun 16 Racing Cartagena Mar MenorRacing 0 - 0 Osasuna PromesasOsasuna 56
12 Jun 16 Osasuna PromesasOsasuna 1 - 0 Racing Cartagena Mar MenorRacing 80
05 Jun 16 Pvo. El EjidoPvo. Ejido 1 - 1 Lorca DeportivaLorca 275
12 Jun 16 Deportivo AragónDeportivo 2 - 0 ChocoChoco 60
05 Jun 16 ChocoChoco 1 - 2 Deportivo AragónDeportivo 67
12 Jun 16 Lorca DeportivaLorca 1 - 2 Pvo. El EjidoPvo. Ejido 415
12 Jun 16 UB ConquenseConquense 2 - 0 JerezJerez 235
04 Jun 16 JerezJerez 2 - 3 UB ConquenseConquense 216
12 Jun 16 Villa Santa BrígidaVilla Santa 2 - 0 IlicitanoIlicitano 88
05 Jun 16 IlicitanoIlicitano 3 - 0 Villa Santa BrígidaVilla Santa 80
04 Jun 16 CayónCayón 0 - 2 Caudal DeportivoCaudal 120
12 Jun 16 Caudal DeportivoCaudal 1 - 0 CayónCayón 60
11 Jun 16 CD LaredoCD Laredo 1 - 1 UD AlmansaUD Almansa 57
05 Jun 16 UD AlmansaUD Almansa 0 - 1 CD LaredoCD Laredo 55
05 Jun 16 San Fernando CDFernando 2 - 1 CD CalahorraCalahorra 125
12 Jun 16 CD CalahorraCalahorra 1 - 1 San Fernando CDFernando 168
11 Jun 16 At. SanluqueñoSanluqueño 2 - 0 Las Palmas At.Palmas 365
05 Jun 16 Las Palmas At.Palmas 3 - 1 At. SanluqueñoSanluqueño 223
12 Jun 16 At. MalagueñoMalagueño 0 - 0 CD CastellónCastellón 709
05 Jun 16 CD CastellónCastellón 2 - 1 At. MalagueñoMalagueño 464
05 Jun 16 Deportivo FabrilDeportivo 2 - 1 CDA NavalcarneroNavalcarner 98
12 Jun 16 CDA NavalcarneroNavalcarner 1 - 0 Deportivo FabrilDeportivo 134
05 Jun 16 SD TarazonaTarazona 1 - 0 Ontinyent CFOntinyent 129
12 Jun 16 Ontinyent CFOntinyent 3 - 2 SD TarazonaTarazona 224
11 Jun 16 CCD CercedaCerceda 2 - 0 CD AzuquecaAzuqueca 67
04 Jun 16 CD Lagun OnakLagun Onak 1 - 0 Águilas FCÁguilas 127
12 Jun 16 LangreoLangreo 2 - 2 Haro DeportivoHaro 403
05 Jun 16 Haro DeportivoHaro 1 - 1 LangreoLangreo 241
12 Jun 16 SD LogroñésLogroñés 1 - 3 CD Palencia BalompiéPalencia 301
05 Jun 16 CD Palencia BalompiéPalencia 0 - 1 SD LogroñésLogroñés 150
04 Jun 16 CF GaváCF Gavá 3 - 0 Almagro CFAlmagro CF 79
12 Jun 16 Almagro CFAlmagro CF 0 - 1 CF GaváCF Gavá 37
12 Jun 16 Águilas FCÁguilas 2 - 0 CD Lagun OnakLagun Onak 266
04 Jun 16 CD AzuquecaAzuqueca 1 - 1 CCD CercedaCerceda 54
Ver jornada
Jornada 3
25 Jun 16 CD LaredoCD Laredo 0 - 0 Pvo. El EjidoPvo. Ejido 250
18 Jun 16 Pvo. El EjidoPvo. Ejido 1 - 0 CD LaredoCD Laredo 181
18 Jun 16 MutilveraMutilvera 0 - 0 UB ConquenseConquense 157
25 Jun 16 UB ConquenseConquense 1 - 1 MutilveraMutilvera 377
19 Jun 16 IlicitanoIlicitano 2 - 1 Osasuna PromesasOsasuna 89
26 Jun 16 Osasuna PromesasOsasuna 4 - 2 IlicitanoIlicitano 134
25 Jun 16 Caudal DeportivoCaudal 1 - 0 Haro DeportivoHaro 174
19 Jun 16 Haro DeportivoHaro 0 - 2 Caudal DeportivoCaudal 274
25 Jun 16 Deportivo AragónDeportivo 0 - 1 CD Palencia BalompiéPalencia 174
26 Jun 16 CDA NavalcarneroNavalcarner 2 - 0 SD TarazonaTarazona 111
19 Jun 16 CD Palencia BalompiéPalencia 1 - 0 Deportivo AragónDeportivo 139
19 Jun 16 SD TarazonaTarazona 2 - 2 CDA NavalcarneroNavalcarner 126
26 Jun 16 Águilas FCÁguilas 1 - 1 San Fernando CDFernando 825
19 Jun 16 San Fernando CDFernando 3 - 1 Águilas FCÁguilas 429
19 Jun 16 CD CastellónCastellón 2 - 2 CF GaváCF Gavá 563
26 Jun 16 CF GaváCF Gavá 2 - 2 CD CastellónCastellón 1k
25 Jun 16 CCD CercedaCerceda 0 - 2 At. SanluqueñoSanluqueño 313
18 Jun 16 At. SanluqueñoSanluqueño 0 - 0 CCD CercedaCerceda 162

  USO DE MEMORIA  
5,245,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1067
Total Execution Time  0.1086
  CADENA URL  
/tercera_division_ascenso2016/grupo0/calendario
  GET DATOS  
$_GET['/tercera_division_ascenso2016/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'tercera_division_ascenso2016'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_division_ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=607 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 607 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (872805,871757,871546,871508,871153) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = 27283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 calendars2016 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 27283 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-05-05 05:18:17' 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-05 05:18:17' 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-05-05 05:18:17' 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-05-05 05:18:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2016
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (27283) 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.0031  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 (27283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (166697,29763,33917,36127,39248,40678,44522,102695,110006,116757) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2016
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (27283) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025  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 (27283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (36127,176427,195796,315504,32525,40895,42765,60599,73033,81658) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2016
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (27283) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0027  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 (27283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (34299,40895,180750,184621,195796,196962) ORDER BY rp.in_squad = 1 DESC