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 Jul 21 FCSBFCSB 1 - 0 Shakhter KaragandyShakhter 11
29 Jul 21 Shakhter KaragandyShakhter 2 - 1 FCSBFCSB 85
22 Jul 21 AstanaAstana 2 - 0 Aris ThessalonikiAris 45
29 Jul 21 Aris ThessalonikiAris 2 - 1 AstanaAstana 3
22 Jul 21 Viktoria PlzeňViktoria 2 - 1 Dinamo BrestDinamo 3
29 Jul 21 Dinamo BrestDinamo 1 - 2 Viktoria PlzeňViktoria 23
22 Jul 21 QarabağQarabağ 0 - 0 FC AshdodFC Ashdod 32
29 Jul 21 FC AshdodFC Ashdod 0 - 1 QarabağQarabağ 1
22 Jul 21 Molde FKMolde FK 3 - 0 ServetteServette 21
29 Jul 21 ServetteServette 2 - 0 Molde FKMolde FK 30
22 Jul 21 KobenhavnKobenhavn 4 - 1 Torpedo ZhodinoTorpedo 3
29 Jul 21 Torpedo ZhodinoTorpedo 0 - 5 KobenhavnKobenhavn 5
22 Jul 21 Arda KardzhaliArda 0 - 2 Hapoel Beer ShevaHapoel Beer 19
29 Jul 21 Hapoel Beer ShevaHapoel Beer 4 - 0 Arda KardzhaliArda 1
22 Jul 21 Lokomotiv PlovdivLokomotiv 1 - 0 SlováckoSlovácko 11
29 Jul 21 SlováckoSlovácko 1 - 0 Lokomotiv PlovdivLokomotiv 8
22 Jul 21 Pogon SzczecinPogon 0 - 0 NK OsijekNK Osijek 4
29 Jul 21 NK OsijekNK Osijek 1 - 0 Pogon SzczecinPogon 3
22 Jul 21 Újpest FCÚjpest FC 2 - 1 FC VaduzFC Vaduz 6
29 Jul 21 FC VaduzFC Vaduz 1 - 3 Újpest FCÚjpest FC 13
22 Jul 21 FK PanevėžysPanevėžys 0 - 1 Vojvodina Novi SadVojvodina 31
29 Jul 21 Vojvodina Novi SadVojvodina 1 - 0 FK PanevėžysPanevėžys 10
22 Jul 21 KAA GentKAA Gent 4 - 0 Valerenga IFValerenga 13
29 Jul 21 Valerenga IFValerenga 2 - 0 KAA GentKAA Gent 45
22 Jul 21 HNK Hajduk SplitHajduk 2 - 0 Tobol KostanayTobol 4
29 Jul 21 Tobol KostanayTobol 4 - 1 HNK Hajduk SplitHajduk 34
21 Jul 21 FK CukarickiCukaricki 0 - 0 SumgayitSumgayit 7
29 Jul 21 SumgayitSumgayit 0 - 2 FK CukarickiCukaricki 1
22 Jul 21 SochiSochi 3 - 0 ShamakhiShamakhi 12
29 Jul 21 ShamakhiShamakhi 2 - 4 SochiSochi 4
22 Jul 21 AberdeenAberdeen 5 - 1 HäckenHäcken 7
29 Jul 21 HäckenHäcken 2 - 0 AberdeenAberdeen 13
20 Jul 21 FolgoreFolgore 1 - 3 HiberniansHibernians 4
27 Jul 21 HiberniansHibernians 4 - 2 FolgoreFolgore 14
22 Jul 21 Teuta DurrësTeuta 0 - 2 Inter EscaldesInter 7
27 Jul 21 Inter EscaldesInter 0 - 3 Teuta DurrësTeuta 25
22 Jul 21 Riga FCRiga FC 2 - 0 KF ShkëndijaShkëndija 2
29 Jul 21 KF ShkëndijaShkëndija 0 - 1 Riga FCRiga FC 4
27 Jul 21 BudućnostBudućnost 0 - 2 HB TórshavnTórshavn 10
22 Jul 21 HB TórshavnTórshavn 4 - 0 BudućnostBudućnost 6
22 Jul 21 LinfieldLinfield 4 - 0 Borac Banja LukaBorac Banja 5
29 Jul 21 Borac Banja LukaBorac Banja 0 - 0 LinfieldLinfield 6
22 Jul 21 Shakhtyor SoligorskShakhtyor 1 - 2 Fola EschFola Esch 7
29 Jul 21 Fola EschFola Esch 1 - 0 Shakhtyor SoligorskShakhtyor 11
22 Jul 21 Ararat YerevanArarat 2 - 4 Śląsk WrocławŚląsk 21
29 Jul 21 Śląsk WrocławŚląsk 3 - 3 Ararat YerevanArarat 7
20 Jul 21 PrishtinaPrishtina 4 - 1 Connah's QuayConnah's 4
29 Jul 21 Connah's QuayConnah's 4 - 2 PrishtinaPrishtina 1
22 Jul 21 ShkupiShkupi 0 - 3 CD Santa ClaraSanta Clara 3
22 Jul 21 Petrocub HînceștiPetrocub 0 - 1 SivassporSivasspor 3
29 Jul 21 SivassporSivasspor 1 - 0 Petrocub HînceștiPetrocub 19
22 Jul 21 KuPS KuopioKuPS Kuopio 2 - 2 Vorskla PoltavaVorskla 14
29 Jul 21 Vorskla PoltavaVorskla 2 - 3 KuPS KuopioKuPS Kuopio 17
22 Jul 21 FH HafnarfjordurHafnarfjord 0 - 2 Rosenborg BKRosenborg 8
29 Jul 21 Rosenborg BKRosenborg 4 - 1 FH HafnarfjordurHafnarfjord 7
22 Jul 21 SūduvaSūduva 0 - 0 Raków CzęstochowaRaków 6
29 Jul 21 Raków CzęstochowaRaków 0 - 0 SūduvaSūduva 8
22 Jul 21 SutjeskaSutjeska 0 - 0 Maccabi Tel AvivMaccabi 13
29 Jul 21 Maccabi Tel AvivMaccabi 3 - 1 SutjeskaSutjeska 1
22 Jul 21 Dinamo BatumiDinamo 0 - 1 BATE BorisovBATE 23
29 Jul 21 BATE BorisovBATE 1 - 4 Dinamo BatumiDinamo 35
22 Jul 21 Partizan BelgradePartizan 1 - 0 DACDAC 11
29 Jul 21 DACDAC 0 - 2 Partizan BelgradePartizan 8
22 Jul 21 Dinamo TbilisiDinamo 1 - 2 Maccabi HaifaMaccabi 18
29 Jul 21 Maccabi HaifaMaccabi 5 - 1 Dinamo TbilisiDinamo 2
22 Jul 21 Hammarby IFHammarby 3 - 1 MariborMaribor 11
29 Jul 21 MariborMaribor 0 - 1 Hammarby IFHammarby 10
22 Jul 21 Apollon LimassolApollon 1 - 3 ŽilinaŽilina 4
29 Jul 21 ŽilinaŽilina 2 - 2 Apollon LimassolApollon 13
22 Jul 21 CSKA SofiaCSKA Sofia 0 - 0 FK LiepājaLiepāja 10
29 Jul 21 FK LiepājaLiepāja 0 - 0 CSKA SofiaCSKA Sofia 58
22 Jul 21 BaselBasel 3 - 0 Partizani TiranaPartizani 12
29 Jul 21 Partizani TiranaPartizani 0 - 2 BaselBasel 5
22 Jul 21 Hibernian FCHibernian 3 - 0 FC Santa ColomaSanta 9
29 Jul 21 FC Santa ColomaSanta 1 - 2 Hibernian FCHibernian 17
22 Jul 21 DundalkDundalk 2 - 2 LevadiaLevadia 10
29 Jul 21 LevadiaLevadia 1 - 2 DundalkDundalk 7
22 Jul 21 Valur ReykjavíkValur 0 - 3 FK Bodo GlimtBodo Glimt 20
29 Jul 21 FK Bodo GlimtBodo Glimt 3 - 0 Valur ReykjavíkValur 29
29 Jul 21 CD Santa ClaraSanta Clara 2 - 0 ShkupiShkupi 5
22 Jul 21 FK RFSFK RFS 3 - 0 Puskás AkadémiaPuskás 24
29 Jul 21 Puskás AkadémiaPuskás 0 - 2 FK RFSFK RFS 11
20 Jul 21 Kauno ŽalgirisKauno 0 - 5 The New SaintsSaints 30
29 Jul 21 The New SaintsSaints 5 - 1 Kauno ŽalgirisKauno 3
20 Jul 21 DomžaleDomžale 1 - 1 FC HonkaFC Honka 55
29 Jul 21 Universitatea CraiovaUniversitat 0 - 0 LaçiLaçi 21
29 Jul 21 FC HonkaFC Honka 0 - 1 DomžaleDomžale 29
22 Jul 21 LaçiLaçi 1 - 0 Universitatea CraiovaUniversitat 7
22 Jul 21 LarneLarne 2 - 1 AGF AarhusAGF Aarhus 5
29 Jul 21 AGF AarhusAGF Aarhus 1 - 1 LarneLarne 10
22 Jul 21 Spartak TrnavaSpartak 0 - 0 SepsiSepsi 17
29 Jul 21 SepsiSepsi 1 - 1 Spartak TrnavaSpartak 3
22 Jul 21 Velež MostarVelež 2 - 1 AEK AthensAEK Athens 9
29 Jul 21 AEK AthensAEK Athens 1 - 0 Velež MostarVelež 36
22 Jul 21 FC DritaFC Drita 0 - 0 FeyenoordFeyenoord 32
29 Jul 21 FeyenoordFeyenoord 3 - 2 FC DritaFC Drita 31
22 Jul 21 Austria WienAustria 1 - 1 BreidablikBreidablik 27
22 Jul 21 AEL LimassolLimassol 1 - 0 Vllaznia ShkodërVllaznia 1
29 Jul 21 BreidablikBreidablik 2 - 1 Austria WienAustria 14
29 Jul 21 Vllaznia ShkodërVllaznia 0 - 1 AEL LimassolLimassol 1
22 Jul 21 NK Olimpija LjubljanaOlimpija 1 - 0 BirkirkaraBirkirkara 20
29 Jul 21 BirkirkaraBirkirkara 1 - 0 NK Olimpija LjubljanaOlimpija 11
22 Jul 21 F91 DudelangeDudelange 0 - 1 Bohemian FCBohemian 2
29 Jul 21 Bohemian FCBohemian 3 - 0 F91 DudelangeDudelange 3
22 Jul 21 IF ElfsborgElfsborg 4 - 0 Milsami OrheiMilsami 3
29 Jul 21 Milsami OrheiMilsami 0 - 5 IF ElfsborgElfsborg 4
22 Jul 21 Gzira UnitedGzira 0 - 2 HNK RijekaHNK Rijeka 3
29 Jul 21 HNK RijekaHNK Rijeka 1 - 0 Gzira UnitedGzira 8

  USO DE MEMORIA  
5,036,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1367
Total Execution Time  0.1393
  CADENA URL  
/previa-conference-league2022/grupo2/calendario
  GET DATOS  
$_GET['/previa-conference-league2022/grupo2/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'previa-conference-league2022'
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa-conference-league' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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=2472 AND type_rel = 3
0.0021  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=2492 ORDER BY l.group_code ASC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2492 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2472 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2472 GROUP BY l.year ORDER BY l.year DESC
0.0051  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 62615 ORDER BY round ASC
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 11:27:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 11:27:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 11:27:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 11:27:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa-conference-league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2472 AND l.year = 2022
0.0073  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62614,62615,62616,62617) 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.0053  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 (62614,62615,62616,62617) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (280694,201826,300730,331670,174833,212359,250964,319800,321695,41758) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2472 AND l.year = 2022
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62614,62615,62616,62617) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0061  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 (62614,62615,62616,62617) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (280865,753596,47444,100952,110082,111919,112580,138160,182813,183014) ORDER BY rp.in_squad = 1 DESC
0.0030  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2472 AND l.year = 2022
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62614,62615,62616,62617) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0044  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 (62614,62615,62616,62617) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (85283,100952,104617,117578,145210,146764,152817,160962,177318,191489) ORDER BY rp.in_squad = 1 DESC