4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
11 Ago 12 RochdaleRochdale 3 - 4 BarnsleyBarnsley ...
11 Ago 12 Notts CountyNotts 0 - 1 Bradford CityBradford ...
11 Ago 12 Hull CityHull City 1 - 1 Rotherham UnitedRotherham ...
11 Ago 12 Carlisle UnitedCarlisle 1 - 0 Accrington StanleyAccrington ...
11 Ago 12 Doncaster RoversDoncaster 1 - 1 York CityYork City ...
11 Ago 12 Crewe AlexandraCrewe 5 - 0 Hartlepool UnitedHartlepool ...
11 Ago 12 BuryBury 1 - 2 MiddlesbroughMiddlesbrou ...
11 Ago 12 Sheffield UnitedSheffield 2 - 2 Burton AlbionBurton ...
11 Ago 12 Leeds UnitedLeeds 4 - 0 Shrewsbury TownShrewsbury ...
11 Ago 12 Cheltenham TownCheltenham 1 - 1 Milton Keynes DonsMilton ...
11 Ago 12 WolvesWolves 1 - 1 Aldershot TownAldershot ...
11 Ago 12 WalsallWalsall 1 - 0 BrentfordBrentford ...
11 Ago 12 WatfordWatford 1 - 0 Wycombe WanderersWycombe ...
12 Ago 12 BlackpoolBlackpool 1 - 2 MorecambeMorecambe ...
13 Ago 12 Fleetwood TownFleetwood 0 - 1 Nottingham ForestNottingham ...
13 Ago 12 Preston North EndPreston 2 - 0 Huddersfield TownHuddersfiel ...
13 Ago 12 Oldham Athletic AFCOldham 2 - 4 Sheffield WednesdaySheffield ...
14 Ago 12 Derby CountyDerby 5 - 5 Scunthorpe UnitedScunthorpe ...
14 Ago 12 Port ValePort Vale 1 - 3 BurnleyBurnley ...
14 Ago 12 ChesterfieldChesterfiel 1 - 2 Tranmere RoversTranmere ...
14 Ago 12 Ipswich TownIpswich 3 - 1 Bristol RoversBristol ...
14 Ago 12 StevenageStevenage 3 - 1 AFC WimbledonWimbledon ...
14 Ago 12 Exeter CityExeter City 1 - 2 Crystal PalaceCrystal ...
14 Ago 12 Yeovil TownYeovil Town 3 - 0 Colchester UnitedColchester ...
14 Ago 12 Birmingham CityBirmingham 5 - 1 BarnetBarnet ...
14 Ago 12 Bristol CityBristol 1 - 2 GillinghamGillingham ...
14 Ago 12 NorthamptonNorthampton 2 - 1 Cardiff CityCardiff ...
14 Ago 12 Plymouth ArgylePlymouth 3 - 0 PortsmouthPortsmouth ...
14 Ago 12 MillwallMillwall 2 - 2 Crawley TownCrawley ...
14 Ago 12 Torquay UnitedTorquay 0 - 4 LeicesterLeicester ...
14 Ago 12 Peterborough UnitedPeterboroug 4 - 0 Southend UnitedSouthend ...
14 Ago 12 Swindon TownSwindon 3 - 0 Brighton & Hove AlbionBrighton ...
14 Ago 12 Oxford UnitedOxford 0 - 0 AFC BournemouthBournemouth ...
14 Ago 12 Charlton AthleticCharlton 1 - 1 Leyton OrientLeyton ...
14 Ago 12 Dagenham & RedbridgeDagenham 0 - 1 Coventry CityCoventry ...
Jornada 2
28 Ago 12 Norwich CityNorwich 2 - 1 Scunthorpe UnitedScunthorpe ...
28 Ago 12 SunderlandSunderland 2 - 0 MorecambeMorecambe ...
28 Ago 12 Milton Keynes DonsMilton 2 - 1 Blackburn RoversBlackburn ...
28 Ago 12 Leeds UnitedLeeds 3 - 0 Oxford UnitedOxford ...
28 Ago 12 GillinghamGillingham 0 - 2 MiddlesbroughMiddlesbrou ...
28 Ago 12 Crawley TownCrawley 2 - 1 Bolton WanderersBolton ...
28 Ago 12 Aston VillaAston Villa 3 - 0 Tranmere RoversTranmere ...
28 Ago 12 Stoke CityStoke City 3 - 4 Swindon TownSwindon ...
28 Ago 12 StevenageStevenage 1 - 4 SouthamptonSouthampton ...
28 Ago 12 Queens Park RangersQueens Park 3 - 0 WalsallWalsall ...
28 Ago 12 BurnleyBurnley 1 - 1 Plymouth ArgylePlymouth ...
28 Ago 12 LeicesterLeicester 2 - 4 Burton AlbionBurton ...
28 Ago 12 Sheffield WednesdaySheffield 1 - 0 FulhamFulham ...
28 Ago 12 Carlisle UnitedCarlisle 2 - 1 Ipswich TownIpswich ...
28 Ago 12 Doncaster RoversDoncaster 3 - 2 Hull CityHull City ...
28 Ago 12 West HamWest Ham 2 - 0 Crewe AlexandraCrewe ...
28 Ago 12 Coventry CityCoventry 3 - 2 Birmingham CityBirmingham ...
28 Ago 12 Yeovil TownYeovil Town 2 - 4 West Bromwich AlbionWest ...
28 Ago 12 Swansea CitySwansea 3 - 1 BarnsleyBarnsley ...
28 Ago 12 WatfordWatford 1 - 2 Bradford CityBradford ...
28 Ago 12 Preston North EndPreston 4 - 1 Crystal PalaceCrystal ...
28 Ago 12 Nottingham ForestNottingham 1 - 4 Wigan AthleticWigan ...
28 Ago 12 ReadingReading 3 - 2 Peterborough UnitedPeterboroug ...
29 Ago 12 EvertonEverton 5 - 0 Leyton OrientLeyton ...
30 Ago 12 NorthamptonNorthampton 1 - 3 WolvesWolves ...
Jornada 3
25 Sep 12 Swindon TownSwindon 3 - 1 BurnleyBurnley ...
25 Sep 12 West HamWest Ham 1 - 4 Wigan AthleticWigan ...
25 Sep 12 Leeds UnitedLeeds 2 - 1 EvertonEverton ...
25 Sep 12 Preston North EndPreston 1 - 3 MiddlesbroughMiddlesbrou ...
25 Sep 12 SouthamptonSouthampton 2 - 0 Sheffield WednesdaySheffield ...
25 Sep 12 ChelseaChelsea 6 - 0 WolvesWolves ...
25 Sep 12 Crawley TownCrawley 2 - 3 Swansea CitySwansea ...
25 Sep 12 Bradford CityBradford 3 - 2 Burton AlbionBurton ...
25 Sep 12 Manchester CityManchester 2 - 4 Aston VillaAston Villa ...
25 Sep 12 Milton Keynes DonsMilton 0 - 2 SunderlandSunderland ...
26 Sep 12 Carlisle UnitedCarlisle 0 - 3 Tottenham HotspurTottenham ...
26 Sep 12 ArsenalArsenal 6 - 1 Coventry CityCoventry ...
26 Sep 12 Queens Park RangersQueens Park 2 - 3 ReadingReading ...
26 Sep 12 Norwich CityNorwich 1 - 0 Doncaster RoversDoncaster ...
26 Sep 12 Manchester UnitedManchester 2 - 1 NewcastleNewcastle ...
26 Sep 12 West Bromwich AlbionWest 1 - 2 LiverpoolLiverpool ...
Jornada 4
30 Oct 12 SunderlandSunderland 0 - 1 MiddlesbroughMiddlesbrou ...
30 Oct 12 Swindon TownSwindon 2 - 3 Aston VillaAston Villa ...
30 Oct 12 Wigan AthleticWigan 0 - 0 Bradford CityBradford ...
30 Oct 12 Leeds UnitedLeeds 3 - 0 SouthamptonSouthampton ...
30 Oct 12 ReadingReading 5 - 7 ArsenalArsenal 12
31 Oct 12 Norwich CityNorwich 2 - 1 Tottenham HotspurTottenham ...
31 Oct 12 ChelseaChelsea 5 - 4 Manchester UnitedManchester 3
31 Oct 12 LiverpoolLiverpool 1 - 3 Swansea CitySwansea ...
Jornada 5
11 Dic 12 Norwich CityNorwich 1 - 4 Aston VillaAston Villa ...
11 Dic 12 Bradford CityBradford 1 - 1 ArsenalArsenal ...
12 Dic 12 Swansea CitySwansea 1 - 0 MiddlesbroughMiddlesbrou ...
19 Dic 12 Leeds UnitedLeeds 1 - 5 ChelseaChelsea ...
Jornada 6
08 Ene 13 Bradford CityBradford 3 - 1 Aston VillaAston Villa ...
22 Ene 13 Aston VillaAston Villa 2 - 1 Bradford CityBradford ...
09 Ene 13 ChelseaChelsea 0 - 2 Swansea CitySwansea 1
23 Ene 13 Swansea CitySwansea 0 - 0 ChelseaChelsea 2
Jornada 7
24 Feb 13 Bradford CityBradford 0 - 5 Swansea CitySwansea 2

  USO DE MEMORIA  
4,951,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3028
Total Execution Time  0.3047
  CADENA URL  
/capital_one_cup2013/grupo0/calendario
  GET DATOS  
$_GET['/capital_one_cup2013/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0105  SELECT type FROM routes WHERE alias = 'capital_one_cup2013'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'capital_one_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  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 = 20550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20550 ORDER BY round ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 12:55:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 12:55:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 12:55:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 12:55:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2013
0.0121  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (20550) 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.0112  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 (20550) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27173,29771,30659,487,1534,2847,9625,12878,29938,33122) ORDER BY rp.in_squad = 1 DESC
0.0124  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2013
0.0116  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (20550) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0115  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 (20550) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (30655,411,108,157,29812,47784,56806,66525,70920,85679) ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2013
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (20550) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  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 (20550) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (300,12285,12677,13083,21292,29812,44124,56806,127737,308815) ORDER BY rp.in_squad = 1 DESC