4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 May 10 Rayo Vallecano BRayo 0 - 0 L´HospitaletL´Hospital ...
15 May 10 CF GandiaCF Gandia 2 - 1 La Roda CFLa Roda CF 61
16 May 10 Real Sociedad BReal 3 - 0 OyonesaOyonesa 10
16 May 10 Atlético BalearesAtlético 1 - 0 TudelanoTudelano 4
15 May 10 NojaNoja 1 - 1 CD TeruelCD Teruel 7
15 May 10 Mancha RealMancha Real 2 - 1 CD BadajozCD Badajoz 60
15 May 10 BurgosBurgos 0 - 0 Deportivo FabrilDeportivo 38
16 May 10 CorralejoCorralejo 2 - 0 Murallas de CeutaMurallas 23
16 May 10 Caudal DeportivoCaudal 2 - 0 JumillaJumilla 39
16 May 10 Costa CalidaCosta 1 - 3 CCD CercedaCerceda 13
16 May 10 Villarreal CVillarreal 1 - 1 JerezJerez 20
16 May 10 CD BezanaCD Bezana 0 - 1 Motril CFMotril CF 14
16 May 10 Almería BAlmería B 2 - 1 Peña DeportivaPeña 9
16 May 10 Real ÁvilaReal Ávila 1 - 1 UM EscobedoEscobedo 15
15 May 10 UD MarinaledaMarinaleda 1 - 2 Las Palmas At.Palmas 9
16 May 10 CoruxoCoruxo 3 - 0 AD ParlaAD Parla 15
16 May 10 AnguianoAnguiano 0 - 2 PortugaletePortugalete 6
15 May 10 FerriolenseFerriolense 0 - 0 MairenaMairena 13
16 May 10 Talavera CFTalavera 1 - 0 Reus DeportiuReus 22
16 May 10 ArroyoArroyo 3 - 1 CD AlfaroCD Alfaro 28
15 May 10 CD ElgoibarElgoibar 0 - 1 Marino de LuancoMarino 16
16 May 10 Trival ValderasTrival 2 - 0 Yeclano DeportivoYeclano 35
16 May 10 AE PratAE Prat 0 - 1 Peña SportPeña Sport 32
16 May 10 LlanesLlanes 1 - 2 Real Valladolid PromesasReal 4
16 May 10 MarinoMarino 0 - 2 La MuelaLa Muela 18
15 May 10 EjeaEjea 1 - 1 UD AlziraUD Alzira 10
16 May 10 ExtremaduraExtremadura 0 - 0 Novelda CFNovelda CF 28
16 May 10 ExtremaduraExtremadura 0 - 0 Novelda CFNovelda CF 28
16 May 10 ExtremaduraExtremadura 0 - 0 Novelda CFNovelda CF 28
16 May 10 CD OurenseCD Ourense 1 - 0 ConstànciaConstància 6
16 May 10 TropezónTropezón 2 - 1 Pájara Playas JandíaPájara 10
16 May 10 Lorca DeportivaLorca 1 - 1 Haro DeportivoHaro 33
16 May 10 SD AmorebietaAmorebieta 3 - 0 El Palo FCEl Palo FC 10
15 May 10 SantboiàSantboià 1 - 0 ArandinaArandina 38
15 May 10 AyamonteAyamonte 5 - 1 CirboneroCirbonero 37
16 May 10 Getafe BGetafe B 2 - 0 Deportivo AragónDeportivo 7
15 May 10 CD AzuquecaAzuqueca 1 - 1 Oviedo VetustaOviedo 35
23 May 10 L´HospitaletL´Hospital 1 - 1 Rayo Vallecano BRayo ...
22 May 10 La Roda CFLa Roda CF 1 - 1 CF GandiaCF Gandia 61
23 May 10 OyonesaOyonesa 0 - 1 Real Sociedad BReal 12
23 May 10 TudelanoTudelano 2 - 1 Atlético BalearesAtlético 5
23 May 10 CD TeruelCD Teruel 2 - 1 NojaNoja 10
23 May 10 CD BadajozCD Badajoz 1 - 0 Mancha RealMancha Real 133
22 May 10 Deportivo FabrilDeportivo 0 - 0 BurgosBurgos 256
23 May 10 Murallas de CeutaMurallas 3 - 0 CorralejoCorralejo 60
23 May 10 JumillaJumilla 1 - 1 Caudal DeportivoCaudal 33
23 May 10 CCD CercedaCerceda 1 - 0 Costa CalidaCosta 10
23 May 10 JerezJerez 0 - 0 Villarreal CVillarreal 11
23 May 10 Motril CFMotril CF 1 - 1 CD BezanaCD Bezana 31
23 May 10 Peña DeportivaPeña 2 - 2 Almería BAlmería B 12
22 May 10 UM EscobedoEscobedo 1 - 2 Real ÁvilaReal Ávila 43
23 May 10 Las Palmas At.Palmas 2 - 0 UD MarinaledaMarinaleda 13
23 May 10 AD ParlaAD Parla 3 - 2 CoruxoCoruxo 14
23 May 10 PortugaletePortugalete 0 - 0 AnguianoAnguiano 4
23 May 10 MairenaMairena 2 - 0 FerriolenseFerriolense 6
23 May 10 Reus DeportiuReus 2 - 0 Talavera CFTalavera 28
23 May 10 CD AlfaroCD Alfaro 4 - 0 ArroyoArroyo 18
22 May 10 Marino de LuancoMarino 2 - 0 CD ElgoibarElgoibar 16
23 May 10 Yeclano DeportivoYeclano 5 - 1 Trival ValderasTrival 137
23 May 10 Peña SportPeña Sport 1 - 0 AE PratAE Prat 20
23 May 10 Real Valladolid PromesasReal 1 - 3 LlanesLlanes 6
23 May 10 La MuelaLa Muela 1 - 0 MarinoMarino 3
22 May 10 UD AlziraUD Alzira 0 - 0 EjeaEjea 7
23 May 10 Novelda CFNovelda CF 1 - 1 ExtremaduraExtremadura 67
23 May 10 Novelda CFNovelda CF 1 - 1 ExtremaduraExtremadura 67
23 May 10 Novelda CFNovelda CF 1 - 1 ExtremaduraExtremadura 67
23 May 10 ConstànciaConstància 2 - 0 CD OurenseCD Ourense 22
22 May 10 Pájara Playas JandíaPájara 3 - 0 TropezónTropezón 23
22 May 10 Haro DeportivoHaro 2 - 1 Lorca DeportivaLorca 40
23 May 10 El Palo FCEl Palo FC 2 - 1 SD AmorebietaAmorebieta 9
22 May 10 ArandinaArandina 1 - 1 SantboiàSantboià 50
22 May 10 CirboneroCirbonero 2 - 1 AyamonteAyamonte 92
23 May 10 Deportivo AragónDeportivo 1 - 1 Getafe BGetafe B 15
23 May 10 Oviedo VetustaOviedo 0 - 1 CD AzuquecaAzuqueca 21
Ver jornada
Jornada 2
30 May 10 CoruxoCoruxo 2 - 1 OyonesaOyonesa 27
06 Jun 10 OyonesaOyonesa 1 - 1 CoruxoCoruxo 23
30 May 10 Almería BAlmería B 0 - 0 BurgosBurgos 64
06 Jun 10 BurgosBurgos 1 - 2 Almería BAlmería B 43
30 May 10 Real ÁvilaReal Ávila 0 - 0 Mancha RealMancha Real 64
06 Jun 10 Mancha RealMancha Real 2 - 0 Real ÁvilaReal Ávila 62
30 May 10 LlanesLlanes 2 - 2 TudelanoTudelano 19
06 Jun 10 TudelanoTudelano 6 - 0 LlanesLlanes 24
29 May 10 CD AzuquecaAzuqueca 1 - 0 L´HospitaletL´Hospital ...
05 Jun 10 L´HospitaletL´Hospital 3 - 1 CD AzuquecaAzuqueca ...
30 May 10 Getafe BGetafe B 0 - 0 JumillaJumilla 29
06 Jun 10 JumillaJumilla 1 - 2 Getafe BGetafe B 47
29 May 10 SD AmorebietaAmorebieta 1 - 1 La Roda CFLa Roda CF 61
06 Jun 10 La Roda CFLa Roda CF 2 - 1 SD AmorebietaAmorebieta 56
30 May 10 SantboiàSantboià 0 - 0 CorralejoCorralejo 31
06 Jun 10 CorralejoCorralejo 1 - 1 SantboiàSantboià 96
30 May 10 Haro DeportivoHaro 1 - 1 NojaNoja 18
06 Jun 10 NojaNoja 1 - 1 Haro DeportivoHaro 44
30 May 10 Pájara Playas JandíaPájara 1 - 0 Yeclano DeportivoYeclano 36
05 Jun 10 Yeclano DeportivoYeclano 2 - 0 Pájara Playas JandíaPájara 76
30 May 10 ExtremaduraExtremadura 0 - 0 MairenaMairena 51
06 Jun 10 MairenaMairena 2 - 2 ExtremaduraExtremadura 78
29 May 10 AyamonteAyamonte 0 - 0 UD AlziraUD Alzira 64
05 Jun 10 UD AlziraUD Alzira 1 - 0 AyamonteAyamonte 130
30 May 10 ConstànciaConstància 0 - 1 La MuelaLa Muela 13
06 Jun 10 La MuelaLa Muela 1 - 1 ConstànciaConstància 26
30 May 10 CD AlfaroCD Alfaro 1 - 0 CCD CercedaCerceda 28
06 Jun 10 CCD CercedaCerceda 3 - 0 CD AlfaroCD Alfaro 17
30 May 10 MarinoMarino 1 - 3 Las Palmas At.Palmas ...
06 Jun 10 Las Palmas At.Palmas 3 - 2 MarinoMarino ...
30 May 10 Reus DeportiuReus 2 - 1 JerezJerez 45
06 Jun 10 JerezJerez 1 - 0 Reus DeportiuReus 59
30 May 10 Peña SportPeña Sport 1 - 1 Motril CFMotril CF 23
06 Jun 10 Motril CFMotril CF 2 - 2 Peña SportPeña Sport 39
30 May 10 CD IllescasIllescas 0 - 0 PortugaletePortugalete 35
06 Jun 10 PortugaletePortugalete 2 - 1 CD IllescasIllescas 72
Ver jornada
Jornada 3
13 Jun 10 Almería BAlmería B 1 - 1 L´HospitaletL´Hospital ...
20 Jun 10 L´HospitaletL´Hospital 0 - 0 Almería BAlmería B ...
13 Jun 10 CoruxoCoruxo 2 - 0 La Roda CFLa Roda CF 46
13 Jun 10 CoruxoCoruxo 2 - 0 La Roda CFLa Roda CF 46
19 Jun 10 La Roda CFLa Roda CF 1 - 1 CoruxoCoruxo 75
13 Jun 10 ExtremaduraExtremadura 4 - 2 Mancha RealMancha Real 118
20 Jun 10 Mancha RealMancha Real 0 - 0 ExtremaduraExtremadura 95
13 Jun 10 SantboiàSantboià 2 - 1 TudelanoTudelano 35
20 Jun 10 TudelanoTudelano 2 - 1 SantboiàSantboià 59
12 Jun 10 Haro DeportivoHaro 0 - 1 Yeclano DeportivoYeclano 94
19 Jun 10 Yeclano DeportivoYeclano 0 - 1 Haro DeportivoHaro 139
13 Jun 10 Getafe BGetafe B 1 - 0 PortugaletePortugalete 13
19 Jun 10 PortugaletePortugalete 2 - 2 Getafe BGetafe B 34
13 Jun 10 UD AlziraUD Alzira 3 - 0 JerezJerez 38
20 Jun 10 JerezJerez 2 - 3 UD AlziraUD Alzira 47
13 Jun 10 Las Palmas At.Palmas 1 - 1 Peña SportPeña Sport 24
20 Jun 10 Peña SportPeña Sport 2 - 1 Las Palmas At.Palmas 58
13 Jun 10 CCD CercedaCerceda 2 - 2 La MuelaLa Muela 9
20 Jun 10 La MuelaLa Muela 1 - 0 CCD CercedaCerceda 26

  USO DE MEMORIA  
5,226,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4443
Total Execution Time  0.4462
  CADENA URL  
/tercera_division_ascenso2010/grupo0/calendario
  GET DATOS  
$_GET['/tercera_division_ascenso2010/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0146  SELECT type FROM routes WHERE alias = 'tercera_division_ascenso2010'
0.0299  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 = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=607 AND type_rel = 3
0.0156  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.0147  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.0149  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 = 1000 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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 calendars2010 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1000 ORDER BY round ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 08:27:33' 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-09 08:27:33' 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=4 AND last_update > '2024-05-09 08:27:33' 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=3 AND last_update > '2024-05-09 08:27:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2010
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (1000) 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.0150  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 (1000) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (71286,74756,27575,31800,32016,39715,59205,60930,67945,269199) ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2010
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (1000) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0148  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 (1000) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (40447,61967,64083,114135,31326,35771,36110,57822,63607,63620) ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2010
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (1000) 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 (1000) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (32187,36991,40447,57822,61899,64041,64083,114135,179392) ORDER BY rp.in_squad = 1 DESC