4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
11 Jul 19 BreidablikBreidablik 0 - 0 FC VaduzFC Vaduz 33
18 Jul 19 FC VaduzFC Vaduz 2 - 1 BreidablikBreidablik 15
09 Jul 19 Gzira UnitedGzira 0 - 2 HNK Hajduk SplitHajduk 15
18 Jul 19 HNK Hajduk SplitHajduk 1 - 3 Gzira UnitedGzira 8
10 Jul 19 Jeunesse d'EschJeunesse 0 - 0 Tobol KostanayTobol 8
18 Jul 19 Tobol KostanayTobol 1 - 1 Jeunesse d'EschJeunesse 110
11 Jul 19 Radnik BijeljinaRadnik 2 - 0 Spartak TrnavaSpartak 4
18 Jul 19 Spartak TrnavaSpartak 2 - 0 Radnik BijeljinaRadnik 6
11 Jul 19 Kauno ŽalgirisKauno 0 - 2 Apollon LimassolApollon 7
18 Jul 19 Apollon LimassolApollon 4 - 0 Kauno ŽalgirisKauno 4
11 Jul 19 ZetaZeta 1 - 5 FehérvárFehérvár 18
18 Jul 19 FehérvárFehérvár 0 - 0 ZetaZeta 25
11 Jul 19 StjarnanStjarnan 2 - 1 LevadiaLevadia 42
18 Jul 19 LevadiaLevadia 3 - 2 StjarnanStjarnan 42
18 Jul 19 DomžaleDomžale 1 - 0 Balzan FCBalzan FC 7
11 Jul 19 Balzan FCBalzan FC 3 - 4 DomžaleDomžale 7
11 Jul 19 LaçiLaçi 1 - 1 Hapoel Beer ShevaHapoel Beer 17
18 Jul 19 Hapoel Beer ShevaHapoel Beer 1 - 0 LaçiLaçi 17
18 Jul 19 BudućnostBudućnost 4 - 1 Narva TransNarva Trans 4
11 Jul 19 Narva TransNarva Trans 0 - 2 BudućnostBudućnost 13
18 Jul 19 Dinamo MinskDinamo 1 - 2 FK LiepājaLiepāja 28
11 Jul 19 FK LiepājaLiepāja 1 - 1 Dinamo MinskDinamo 29
11 Jul 19 FK SabailFK Sabail 2 - 3 Universitatea CraiovaUniversitat 11
18 Jul 19 Universitatea CraiovaUniversitat 3 - 2 FK SabailFK Sabail 25
18 Jul 19 IFK NorrköpingNorrköping 2 - 1 St Patrick'sPatrick's 8
11 Jul 19 St Patrick'sPatrick's 0 - 2 IFK NorrköpingNorrköping 12
11 Jul 19 PyunikPyunik 3 - 3 ShkupiShkupi 41
18 Jul 19 ShkupiShkupi 1 - 2 PyunikPyunik 9
18 Jul 19 Levski SofiaLevski 2 - 0 RuzomberokRuzomberok 28
11 Jul 19 RuzomberokRuzomberok 0 - 2 Levski SofiaLevski 16
11 Jul 19 AberdeenAberdeen 2 - 1 RoPS RovaniemiRoPS 8
18 Jul 19 RoPS RovaniemiRoPS 1 - 2 AberdeenAberdeen 26
11 Jul 19 AEK LarnacaLarnaca 1 - 0 Petrocub HînceștiPetrocub 19
18 Jul 19 Petrocub HînceștiPetrocub 0 - 1 AEK LarnacaLarnaca 11
11 Jul 19 OrdabasyOrdabasy 1 - 0 Torpedo KutaisiTorpedo 37
18 Jul 19 Torpedo KutaisiTorpedo 0 - 2 OrdabasyOrdabasy 25
11 Jul 19 Maccabi HaifaMaccabi 2 - 0 NS MuraNS Mura 7
18 Jul 19 NS MuraNS Mura 2 - 3 Maccabi HaifaMaccabi 22
11 Jul 19 CrusadersCrusaders 2 - 0 B36 TorshavnTorshavn 5
18 Jul 19 B36 TorshavnTorshavn 2 - 3 CrusadersCrusaders 9
11 Jul 19 NK Olimpija LjubljanaOlimpija 2 - 3 FK RFSFK RFS 22
18 Jul 19 FK RFSFK RFS 0 - 2 NK Olimpija LjubljanaOlimpija 21
11 Jul 19 AP BreraAP Brera 0 - 3 ZrinjskiZrinjski 6
18 Jul 19 ZrinjskiZrinjski 3 - 0 AP BreraAP Brera 4
11 Jul 19 Budapest HonvedBudapest 3 - 1 Zalgiris VilniusZalgiris 9
18 Jul 19 Zalgiris VilniusZalgiris 1 - 1 Budapest HonvedBudapest 12
11 Jul 19 Siroki BrijegSiroki 1 - 2 Kairat AlmatyKairat 6
18 Jul 19 Kairat AlmatyKairat 2 - 1 Siroki BrijegSiroki 63
11 Jul 19 Connah's QuayConnah's 1 - 2 KilmarnockKilmarnock 12
18 Jul 19 KilmarnockKilmarnock 0 - 2 Connah's QuayConnah's 15
11 Jul 19 Debreceni VSCDebreceni 3 - 0 KukësiKukësi 4
18 Jul 19 KukësiKukësi 1 - 1 Debreceni VSCDebreceni 5
18 Jul 19 Inter TurkuInter Turku 2 - 0 Brøndby IFBrøndby 74
11 Jul 19 Brøndby IFBrøndby 4 - 1 Inter TurkuInter Turku 26
11 Jul 19 SK BrannSK Brann 2 - 2 Shamrock RoversShamrock 12
18 Jul 19 Shamrock RoversShamrock 2 - 1 SK BrannSK Brann 20
18 Jul 19 Radnicki NisRadnicki 2 - 2 FC FloraFC Flora 44
11 Jul 19 FC FloraFC Flora 2 - 0 Radnicki NisRadnicki 28
11 Jul 19 FCSBFCSB 2 - 0 Milsami OrheiMilsami 8
18 Jul 19 Milsami OrheiMilsami 1 - 2 FCSBFCSB 10
11 Jul 19 Shakhtyor SoligorskShakhtyor 1 - 0 HiberniansHibernians 5
18 Jul 19 HiberniansHibernians 0 - 1 Shakhtyor SoligorskShakhtyor 19
11 Jul 19 Fola EschFola Esch 1 - 2 ChikhuraChikhura 10
17 Jul 19 ChikhuraChikhura 2 - 1 Fola EschFola Esch 6
11 Jul 19 VentspilsVentspils 3 - 0 Teuta DurrësTeuta 21
18 Jul 19 Teuta DurrësTeuta 1 - 0 VentspilsVentspils 17
18 Jul 19 VitebskVitebsk 1 - 1 KuPS KuopioKuPS Kuopio 10
11 Jul 19 KuPS KuopioKuPS Kuopio 2 - 0 VitebskVitebsk 9
09 Jul 19 CSKA SofiaCSKA Sofia 4 - 0 Titograd PodgoricaTitograd 21
16 Jul 19 Titograd PodgoricaTitograd 0 - 0 CSKA SofiaCSKA Sofia 35
11 Jul 19 FK CukarickiCukaricki 3 - 0 FC UrartuFC Urartu 7
16 Jul 19 FC UrartuFC Urartu 0 - 5 FK CukarickiCukaricki 8
11 Jul 19 Molde FKMolde FK 7 - 1 KR ReykjavíkReykjavík 7
18 Jul 19 KR ReykjavíkReykjavík 0 - 0 Molde FKMolde FK 52
18 Jul 19 NeftçiNeftçi 6 - 0 Speranţa NisporeniSperanţa 3
11 Jul 19 Speranţa NisporeniSperanţa 0 - 3 NeftçiNeftçi 3
11 Jul 19 AlashkertAlashkert 3 - 1 Makedonija GPMakedonija 7
18 Jul 19 Makedonija GPMakedonija 0 - 3 AlashkertAlashkert 28
18 Jul 19 KS CracoviaCracovia 2 - 2 DACDAC 29
11 Jul 19 DACDAC 1 - 1 KS CracoviaCracovia 10
09 Jul 19 St. Joseph'sJoseph's 0 - 4 Rangers FCRangers FC 36
18 Jul 19 Rangers FCRangers FC 6 - 0 St. Joseph'sJoseph's 14
11 Jul 19 Cork CityCork City 0 - 2 Progrès NiederkornProgrès 6
18 Jul 19 Progrès NiederkornProgrès 1 - 2 Cork CityCork City 20
11 Jul 19 CliftonvilleCliftonvill 0 - 1 HaugesundHaugesund 3
18 Jul 19 HaugesundHaugesund 5 - 1 CliftonvilleCliftonvill 14
18 Jul 19 Legia WarszawaLegia 3 - 0 Europa FCEuropa FC 13
11 Jul 19 Europa FCEuropa FC 0 - 0 Legia WarszawaLegia 30
11 Jul 19 FK RiteriaiRiteriai 1 - 1 Kí KlaksvíkKlaksvík 5
16 Jul 19 Kí KlaksvíkKlaksvík 0 - 0 FK RiteriaiRiteriai 41
18 Jul 19 EngordanyEngordany 0 - 1 Dinamo TbilisiDinamo 8
11 Jul 19 Dinamo TbilisiDinamo 6 - 0 EngordanyEngordany 5
18 Jul 19 Ballymena UnitedBallymena 0 - 4 Malmö FFMalmö FF 8
11 Jul 19 Malmö FFMalmö FF 7 - 0 Ballymena UnitedBallymena 3

  USO DE MEMORIA  
4,952,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0982
Total Execution Time  0.1001
  CADENA URL  
/previa_europa_league2020/grupo2/calendario
  GET DATOS  
$_GET['/previa_europa_league2020/grupo2/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0018  SELECT type FROM routes WHERE alias = 'previa_europa_league2020'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=674 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 674 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 (1275465,1275183,1273994,1273871,1272678) 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 = 50131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 50131 ORDER BY round ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 15:08:29' 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-06 15:08:29' 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-05-06 15:08:29' 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=3 AND last_update > '2024-05-06 15:08:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' 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.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2020
0.0030  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49977,50131,50143,50670,51054) 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.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 (49977,50131,50143,50670,51054) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (234406,46077,54472,131276,192128,202515,246441,2283,54508,119526) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2020
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49977,50131,50143,50670,51054) 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 (49977,50131,50143,50670,51054) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (274001,308414,192305,275637,334397,598767,26755,27219,29753,37937) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 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 (49977,50131,50143,50670,51054) 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 (49977,50131,50143,50670,51054) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (5423,7087,29753,30098,34119,35182,40831,40923,67776,86970) ORDER BY rp.in_squad = 1 DESC