4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
18 Jul 20 VillanovenseVillanovens 2 - 0 Extremadura BExtremadura 161
19 Jul 20 CD CoriaCD Coria 0 - 1 CP CacereñoCacereño 136
18 Jul 20 SD CompostelaCompostela 3 - 1 BarcoBarco 114
19 Jul 20 Ourense CFOurense CF 2 - 1 ArosaArosa 27
18 Jul 20 Lealtad VillaviciosaLealtad 0 - 1 Caudal DeportivoCaudal 116
19 Jul 20 UD LlaneraUD Llanera 2 - 3 CD CovadongaCovadonga 88
18 Jul 20 CD LaredoCD Laredo 3 - 1 TropezónTropezón 69
19 Jul 20 Gimnástica TorrelavegaGimnástica 1 - 1 Rayo CantabriaRayo 84
18 Jul 20 PortugaletePortugalete 1 - 0 CD BasconiaBasconia 230
19 Jul 20 Sestao RiverSestao 0 - 0 CD VitoriaCD Vitoria 73
18 Jul 20 L´HospitaletL´Hospital 0 - 0 UE Sant AndreuSant Andreu 217
19 Jul 20 Terrassa FCTerrassa 1 - 0 CE EuropaCE Europa 150
18 Jul 20 AlcoyanoAlcoyano 0 - 0 CF IntercityIntercity 105
19 Jul 20 UD AlziraUD Alzira 1 - 3 AtzenetaAtzeneta 37
18 Jul 20 CDA NavalcarneroNavalcarner 1 - 1 RSD AlcaláAlcalá 63
19 Jul 20 Unión AdarveUnión 1 - 3 Alcorcón BAlcorcón 63
18 Jul 20 ZamoraZamora 2 - 1 Numancia BNumancia B 207
19 Jul 20 Gimnástica SegovianaGimnástica 0 - 0 ArandinaArandina 78
18 Jul 20 Linares DeportivoLinares 0 - 1 Real JaénReal Jaén 950
19 Jul 20 Pvo. El EjidoPvo. Ejido 3 - 2 CF MotrilCF Motril 149
19 Jul 20 Ciudad de LucenaCiudad 1 - 1 Xerez DeportivoXerez 285
18 Jul 20 Betis DeportivoBetis 3 - 1 UtreraUtrera 121
18 Jul 20 PoblensePoblense 1 - 1 FelanitxFelanitx 25
19 Jul 20 Ibiza I. PitiusasIbiza 0 - 1 Mallorca BMallorca B 50
18 Jul 20 MarinoMarino 0 - 1 TamaraceiteTamaraceite 110
19 Jul 20 TeniscaTenisca 0 - 4 UD San FernandoFernando 92
18 Jul 20 Lorca DeportivaLorca 0 - 0 Mazarrón FCMazarrón 56
19 Jul 20 At. PulpileñoPulpileño 0 - 0 Racing Cartagena Mar MenorRacing 20
18 Jul 20 MutilveraMutilvera 0 - 0 CD PamplonaPamplona 14
19 Jul 20 AD San JuanJuan 2 - 4 Beti KozkorBeti Kozkor 13
18 Jul 20 SD LogroñésLogroñés 2 - 0 ArnedoArnedo 80
19 Jul 20 CD VareaCD Varea 1 - 0 CasalarreinaCasalarrein 36
18 Jul 20 SD TarazonaTarazona 1 - 0 Deportivo AragónDeportivo 61
19 Jul 20 CD TeruelCD Teruel 1 - 2 BreaBrea 135
18 Jul 20 UD Yugo SocuéllamosYugo 1 - 0 CD ToledoCD Toledo 477
19 Jul 20 CD Quintanar del ReyQuintanar 1 - 2 CD GuadalajaraGuadalajara 256
Ver jornada
Jornada 2
25 Jul 20 UD San FernandoFernando 1 - 2 TamaraceiteTamaraceite 121
25 Jul 20 CD LaredoCD Laredo 2 - 0 Gimnástica TorrelavegaGimnástica 134
25 Jul 20 SD CompostelaCompostela 1 - 1 Ourense CFOurense CF 204
25 Jul 20 CD CovadongaCovadonga 2 - 0 Caudal DeportivoCaudal 179
08 Ago 20 PortugaletePortugalete 1 - 0 Sestao RiverSestao 694
25 Jul 20 L´HospitaletL´Hospital 1 - 1 Terrassa FCTerrassa 322
25 Jul 20 AlcoyanoAlcoyano 0 - 1 AtzenetaAtzeneta 201
25 Jul 20 CDA NavalcarneroNavalcarner 1 - 1 Alcorcón BAlcorcón 108
25 Jul 20 ZamoraZamora 2 - 1 Gimnástica SegovianaGimnástica 321
25 Jul 20 Pvo. El EjidoPvo. Ejido 1 - 1 Real JaénReal Jaén 587
25 Jul 20 PoblensePoblense 2 - 1 Mallorca BMallorca B 90
25 Jul 20 Lorca DeportivaLorca 1 - 1 At. PulpileñoPulpileño 131
25 Jul 20 MutilveraMutilvera 1 - 0 Beti KozkorBeti Kozkor 59
25 Jul 20 SD LogroñésLogroñés 1 - 1 CD VareaCD Varea 232
25 Jul 20 SD TarazonaTarazona 3 - 0 BreaBrea 108
25 Jul 20 UD Yugo SocuéllamosYugo 0 - 0 CD GuadalajaraGuadalajara 391
25 Jul 20 VillanovenseVillanovens 1 - 1 CP CacereñoCacereño 419
25 Jul 20 Betis DeportivoBetis 4 - 1 Ciudad de LucenaCiudad 269
01 Ago 20 Lealtad VillaviciosaLealtad Apl AlcoyanoAlcoyano 192
02 Ago 20 MarinoMarino Apl Linares DeportivoLinares 466

  USO DE MEMORIA  
4,725,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0834
Total Execution Time  0.0853
  CADENA URL  
/tercera_division_ascenso2020/grupo0/calendario
  GET DATOS  
$_GET['/tercera_division_ascenso2020/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'tercera_division_ascenso2020'
0.0041  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 = 2020 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.0031  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.0023  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.0025  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 = 56536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 56536 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-04-27 09:42:02' 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-27 09:42:02' 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-27 09:42:02' 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-27 09:42:02' 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 = 2020
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (56536) 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.0026  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 (56536) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (423702,29024,34747,44522,115584,124317,170108,181117,274059,22359) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2020
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (56536) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (56536) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (29526,30830,32117,34656,40492,68212,71493,83802,90939,105531) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 607 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (56536) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024  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 (56536) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (29867,32117,34656,40492,42885,71493,87129,105531,130666,149622) ORDER BY rp.in_squad = 1 DESC