4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
FA Cup 1989
1988/1989

copa inglesa, copa de inglaterra, the emirates fa cup,

FA Cup 1989

Jornada 1
07 Ene 89 BarnsleyBarnsley 4 - 0 ChelseaChelsea ...
07 Ene 89 Birmingham CityBirmingham 0 - 1 Wimbledon FCWimbledon ...
07 Ene 89 BlackpoolBlackpool 0 - 1 AFC BournemouthBournemouth ...
07 Ene 89 Bradford CityBradford 1 - 0 Tottenham HotspurTottenham ...
07 Ene 89 Brighton & Hove AlbionBrighton 1 - 2 Leeds UnitedLeeds ...
07 Ene 89 Cardiff CityCardiff 1 - 2 Hull CityHull City ...
07 Ene 89 Charlton AthleticCharlton 2 - 1 Oldham Athletic AFCOldham ...
07 Ene 89 Crewe AlexandraCrewe 2 - 3 Aston VillaAston Villa ...
07 Ene 89 Derby CountyDerby 1 - 1 SouthamptonSouthampton ...
07 Ene 89 Hartlepool UnitedHartlepool 1 - 0 Bristol CityBristol ...
07 Ene 89 Huddersfield TownHuddersfiel 0 - 1 Sheffield UnitedSheffield ...
07 Ene 89 Kettering TownKettering 1 - 1 FC Halifax TownHalifax ...
07 Ene 89 Manchester CityManchester 1 - 0 LeicesterLeicester ...
07 Ene 89 Manchester UnitedManchester 0 - 0 Queens Park RangersQueens Park ...
07 Ene 89 MiddlesbroughMiddlesbrou 1 - 2 Grimsby TownGrimsby ...
07 Ene 89 MillwallMillwall 3 - 2 Luton TownLuton Town ...
07 Ene 89 NewcastleNewcastle 0 - 0 WatfordWatford ...
07 Ene 89 Nottingham ForestNottingham 3 - 0 Ipswich TownIpswich ...
07 Ene 89 Plymouth ArgylePlymouth 2 - 0 Cambridge UnitedCambridge ...
07 Ene 89 PortsmouthPortsmouth 1 - 1 Swindon TownSwindon ...
07 Ene 89 Sheffield WednesdaySheffield 5 - 1 Torquay UnitedTorquay ...
07 Ene 89 Shrewsbury TownShrewsbury 0 - 3 Colchester UnitedColchester ...
07 Ene 89 Stoke CityStoke City 1 - 0 Crystal PalaceCrystal ...
07 Ene 89 SunderlandSunderland 1 - 1 Oxford UnitedOxford ...
07 Ene 89 Sutton UnitedSutton 2 - 1 Coventry CityCoventry ...
07 Ene 89 Tranmere RoversTranmere 1 - 1 ReadingReading ...
07 Ene 89 WalsallWalsall 1 - 1 BrentfordBrentford ...
07 Ene 89 Welling UnitedWelling 0 - 1 Blackburn RoversBlackburn ...
07 Ene 89 West Bromwich AlbionWest 1 - 1 EvertonEverton ...
08 Ene 89 Port ValePort Vale 1 - 3 Norwich CityNorwich ...
08 Ene 89 West HamWest Ham 2 - 2 ArsenalArsenal ...
10 Ene 89 BrentfordBrentford 1 - 0 WalsallWalsall ...
10 Ene 89 FC Halifax TownHalifax 2 - 3 Kettering TownKettering ...
10 Ene 89 SouthamptonSouthampton 1 - 2 Derby CountyDerby ...
10 Ene 89 Swindon TownSwindon 2 - 0 PortsmouthPortsmouth ...
10 Ene 89 WatfordWatford 2 - 2 NewcastleNewcastle ...
11 Ene 89 ArsenalArsenal 0 - 1 West HamWest Ham ...
11 Ene 89 EvertonEverton 1 - 0 West Bromwich AlbionWest ...
11 Ene 89 Oxford UnitedOxford 2 - 0 SunderlandSunderland ...
11 Ene 89 Queens Park RangersQueens Park 2 - 2 Manchester UnitedManchester ...
11 Ene 89 ReadingReading 2 - 1 Tranmere RoversTranmere ...
16 Ene 89 NewcastleNewcastle 0 - 0 WatfordWatford ...
18 Ene 89 WatfordWatford 1 - 0 NewcastleNewcastle ...
23 Ene 89 Manchester UnitedManchester 3 - 0 Queens Park RangersQueens Park ...
19 Nov 88 Enfield TownEnfield x - x Leyton OrientLeyton ...
19 Nov 88 BlackpoolBlackpool 2 - 1 Scunthorpe UnitedScunthorpe ...
19 Nov 88 Darlington FCDarlington 1 - 2 Notts CountyNotts ...
19 Nov 88 Bath CityBath City 2 - 0 Grays AthleticGrays ...
19 Nov 88 Bristol CityBristol 3 - 1 Southend UnitedSouthend ...
19 Nov 88 BurnleyBurnley 0 - 2 Chester City FCChester ...
19 Nov 88 Preston North EndPreston 1 - 1 Tranmere RoversTranmere ...
19 Nov 88 Yeovil TownYeovil Town 3 - 2 Merthyr Tydfil FCMerthyr ...
19 Nov 88 ReadingReading 4 - 2 HendonHendon ...
19 Nov 88 WokingWoking 1 - 4 Cambridge UnitedCambridge ...
19 Nov 88 GillinghamGillingham 3 - 3 Peterborough UnitedPeterboroug ...
19 Nov 88 Bolton WanderersBolton 0 - 0 ChesterfieldChesterfiel ...
19 Nov 88 Grimsby TownGrimsby 1 - 0 WolvesWolves ...
19 Nov 88 Stafford RangersStafford 2 - 2 Crewe AlexandraCrewe ...
19 Nov 88 Scarborough AthleticScarborough 2 - 1 Stockport CountyStockport ...
19 Nov 88 FulhamFulham 0 - 1 Colchester UnitedColchester ...
19 Nov 88 BrentfordBrentford 2 - 0 Halesowen TownHalesowen ...
19 Nov 88 AltrinchamAltrincham 3 - 2 Lincoln CityLincoln ...
19 Nov 88 Bognor Regis TownBognor 2 - 1 Exeter CityExeter City ...
19 Nov 88 Huddersfield TownHuddersfiel 1 - 1 RochdaleRochdale ...
19 Nov 88 Mansfield TownMansfield 1 - 1 Sheffield UnitedSheffield ...
19 Nov 88 Cardiff CityCardiff 3 - 0 Hereford UnitedHereford ...
19 Nov 88 FC Halifax TownHalifax 1 - 0 York CityYork City ...
19 Nov 88 Newport CountyNewport 1 - 2 Maidstone UnitedMaidstone ...
19 Nov 88 SouthportSouthport 0 - 2 Port ValePort Vale ...
19 Nov 88 Runcorn LinnetsRuncorn 2 - 2 Wrexham AFCWrexham ...
19 Nov 88 Torquay UnitedTorquay 2 - 2 Fareham TownFareham ...
19 Nov 88 Kettering TownKettering 2 - 1 DartfordDartford ...
19 Nov 88 Rotherham UnitedRotherham 3 - 1 BarrowBarrow ...
19 Nov 88 Aldershot TownAldershot 1 - 0 Hayes FCHayes FC ...
19 Nov 88 Dagenham & RedbridgeDagenham 0 - 4 Sutton UnitedSutton ...
19 Nov 88 Havant & WaterloovilleHavant 1 - 4 Aylesbury UnitedAylesbury ...
19 Nov 88 AFC Telford UnitedTelford 1 - 1 Carlisle UnitedCarlisle ...
19 Nov 88 Swansea CitySwansea 3 - 1 NorthamptonNorthampton ...
19 Nov 88 Frickley AthleticFrickley 0 - 2 Northwich VictoriaNorthwich ...
19 Nov 88 Hartlepool UnitedHartlepool 2 - 0 Wigan AthleticWigan ...
19 Nov 88 Welling UnitedWelling 3 - 0 Bromsgrove RoversBromsgrove ...
19 Nov 88 Doncaster RoversDoncaster 0 - 0 Hayes & Yeading UnitedHayes ...
19 Nov 88 Guisborough TownGuisborough 0 - 1 BuryBury ...
20 Nov 88 Bristol RoversBristol 3 - 0 Fisher Athletic FCFisher ...
22 Nov 88 Crewe AlexandraCrewe 3 - 2 Stafford RangersStafford ...
22 Nov 88 Sheffield UnitedSheffield 2 - 1 Mansfield TownMansfield ...
22 Nov 88 Wrexham AFCWrexham 2 - 3 Runcorn LinnetsRuncorn ...
22 Nov 88 Carlisle UnitedCarlisle 4 - 1 AFC Telford UnitedTelford ...
22 Nov 88 Hayes & Yeading UnitedHayes 1 - 2 Doncaster RoversDoncaster ...
23 Nov 88 Leyton OrientLeyton 2 - 2 Enfield TownEnfield ...
23 Nov 88 Tranmere RoversTranmere 3 - 0 Preston North EndPreston ...
23 Nov 88 Peterborough UnitedPeterboroug 1 - 0 GillinghamGillingham ...
23 Nov 88 Fareham TownFareham 2 - 3 Torquay UnitedTorquay ...
28 Nov 88 ChesterfieldChesterfiel 2 - 3 Bolton WanderersBolton ...
28 Nov 88 RochdaleRochdale 3 - 4 Huddersfield TownHuddersfiel ...
19 Nov 88 Enfield TownEnfield 1 - 0 Leyton OrientLeyton ...
Jornada 2
28 Ene 89 Aston VillaAston Villa 0 - 1 Wimbledon FCWimbledon ...
28 Ene 89 Blackburn RoversBlackburn 2 - 1 Sheffield WednesdaySheffield ...
28 Ene 89 Bradford CityBradford 1 - 2 Hull CityHull City ...
28 Ene 89 BrentfordBrentford 3 - 1 Manchester CityManchester 1
28 Ene 89 Grimsby TownGrimsby 1 - 1 ReadingReading ...
28 Ene 89 Hartlepool UnitedHartlepool 1 - 1 AFC BournemouthBournemouth ...
28 Ene 89 Manchester UnitedManchester 4 - 0 Oxford UnitedOxford ...
28 Ene 89 Norwich CityNorwich 8 - 0 Sutton UnitedSutton ...
28 Ene 89 Nottingham ForestNottingham 2 - 0 Leeds UnitedLeeds ...
28 Ene 89 Plymouth ArgylePlymouth 1 - 1 EvertonEverton ...
28 Ene 89 Sheffield UnitedSheffield 3 - 3 Colchester UnitedColchester ...
28 Ene 89 Stoke CityStoke City 3 - 3 BarnsleyBarnsley ...
28 Ene 89 Swindon TownSwindon 0 - 0 West HamWest Ham ...
28 Ene 89 WatfordWatford 2 - 1 Derby CountyDerby ...
28 Ene 89 Charlton AthleticCharlton 2 - 1 Kettering TownKettering ...
31 Ene 89 BarnsleyBarnsley 2 - 1 Stoke CityStoke City ...
31 Ene 89 AFC BournemouthBournemouth 5 - 2 Hartlepool UnitedHartlepool ...
31 Ene 89 Colchester UnitedColchester 0 - 2 Sheffield UnitedSheffield ...
31 Ene 89 EvertonEverton 4 - 0 Plymouth ArgylePlymouth ...
01 Feb 89 ReadingReading 1 - 2 Grimsby TownGrimsby ...
01 Feb 89 West HamWest Ham 1 - 0 Swindon TownSwindon ...
10 Dic 88 Aldershot TownAldershot x - x Bristol CityBristol ...
10 Dic 88 AltrinchamAltrincham 0 - 3 FC Halifax TownHalifax ...
10 Dic 88 Aylesbury UnitedAylesbury 0 - 1 Sutton UnitedSutton ...
10 Dic 88 Bath CityBath City 0 - 0 Welling UnitedWelling ...
10 Dic 88 BlackpoolBlackpool 3 - 0 BuryBury ...
10 Dic 88 Bognor Regis TownBognor 0 - 1 Cambridge UnitedCambridge ...
10 Dic 88 Bolton WanderersBolton 1 - 2 Port ValePort Vale ...
10 Dic 88 Colchester UnitedColchester 2 - 2 Swansea CitySwansea ...
10 Dic 88 Grimsby TownGrimsby 3 - 2 Rotherham UnitedRotherham ...
10 Dic 88 Hartlepool UnitedHartlepool 1 - 0 Notts CountyNotts ...
10 Dic 88 Huddersfield TownHuddersfiel 1 - 0 Chester City FCChester ...
10 Dic 88 Kettering TownKettering 2 - 1 Bristol RoversBristol ...
10 Dic 88 Northwich VictoriaNorthwich 1 - 2 Tranmere RoversTranmere ...
10 Dic 88 Peterborough UnitedPeterboroug 0 - 0 BrentfordBrentford ...
10 Dic 88 ReadingReading 1 - 1 Maidstone UnitedMaidstone ...
10 Dic 88 Runcorn LinnetsRuncorn 0 - 3 Crewe AlexandraCrewe ...
10 Dic 88 Scarborough AthleticScarborough 0 - 1 Carlisle UnitedCarlisle ...
10 Dic 88 Yeovil TownYeovil Town 1 - 1 Torquay UnitedTorquay ...
11 Dic 88 Doncaster RoversDoncaster 1 - 3 Sheffield UnitedSheffield ...
11 Dic 88 Enfield TownEnfield 1 - 4 Cardiff CityCardiff ...
13 Dic 88 Bristol CityBristol x - x Aldershot TownAldershot ...
13 Dic 88 Swansea CitySwansea 1 - 3 Colchester UnitedColchester ...
14 Dic 88 BrentfordBrentford 3 - 2 Peterborough UnitedPeterboroug ...
14 Dic 88 Maidstone UnitedMaidstone 1 - 2 ReadingReading ...
14 Dic 88 Torquay UnitedTorquay 1 - 0 Yeovil TownYeovil Town ...
14 Dic 88 Welling UnitedWelling 3 - 2 Bath CityBath City ...
10 Dic 88 Aldershot TownAldershot 2 - 2 Bristol CityBristol ...
13 Dic 88 Bristol CityBristol 1 - 0 Aldershot TownAldershot ...
Jornada 3
18 Feb 89 BarnsleyBarnsley 0 - 1 EvertonEverton ...
18 Feb 89 Blackburn RoversBlackburn 0 - 2 BrentfordBrentford ...
18 Feb 89 AFC BournemouthBournemouth 1 - 1 Manchester UnitedManchester ...
18 Feb 89 Charlton AthleticCharlton 0 - 1 West HamWest Ham ...
18 Feb 89 Norwich CityNorwich 3 - 2 Sheffield UnitedSheffield ...
18 Feb 89 Wimbledon FCWimbledon 3 - 1 Grimsby TownGrimsby ...
19 Feb 89 WatfordWatford 0 - 3 Nottingham ForestNottingham ...
22 Feb 89 Manchester UnitedManchester 1 - 0 AFC BournemouthBournemouth ...
07 Ene 89 BarnsleyBarnsley 4 - 0 ChelseaChelsea ...
07 Ene 89 Birmingham CityBirmingham 0 - 1 Wimbledon FCWimbledon ...
07 Ene 89 BlackpoolBlackpool 0 - 1 AFC BournemouthBournemouth ...
07 Ene 89 Bradford CityBradford 1 - 0 Tottenham HotspurTottenham ...
07 Ene 89 Brighton & Hove AlbionBrighton 1 - 2 Leeds UnitedLeeds ...
07 Ene 89 Cardiff CityCardiff 1 - 2 Hull CityHull City ...
07 Ene 89 Carlisle UnitedCarlisle 0 - 3 LiverpoolLiverpool ...
07 Ene 89 Charlton AthleticCharlton 2 - 1 Oldham Athletic AFCOldham ...
07 Ene 89 Crewe AlexandraCrewe 2 - 3 Aston VillaAston Villa ...
07 Ene 89 Derby CountyDerby 1 - 1 SouthamptonSouthampton ...
07 Ene 89 Hartlepool UnitedHartlepool 1 - 0 Bristol CityBristol ...
07 Ene 89 Huddersfield TownHuddersfiel 0 - 1 Sheffield UnitedSheffield ...
07 Ene 89 Kettering TownKettering 1 - 1 FC Halifax TownHalifax ...
07 Ene 89 Manchester CityManchester 1 - 0 LeicesterLeicester ...
07 Ene 89 Manchester UnitedManchester x - x Queens Park RangersQueens Park ...
07 Ene 89 MiddlesbroughMiddlesbrou 1 - 2 Grimsby TownGrimsby ...
07 Ene 89 MillwallMillwall 3 - 2 Luton TownLuton Town ...
07 Ene 89 NewcastleNewcastle x - x WatfordWatford ...
07 Ene 89 Nottingham ForestNottingham 3 - 0 Ipswich TownIpswich ...
07 Ene 89 Plymouth ArgylePlymouth 2 - 0 Cambridge UnitedCambridge ...
07 Ene 89 PortsmouthPortsmouth 1 - 1 Swindon TownSwindon ...
07 Ene 89 Sheffield WednesdaySheffield 5 - 1 Torquay UnitedTorquay ...
07 Ene 89 Shrewsbury TownShrewsbury 0 - 3 Colchester UnitedColchester ...
07 Ene 89 Stoke CityStoke City 1 - 0 Crystal PalaceCrystal ...
07 Ene 89 SunderlandSunderland 1 - 1 Oxford UnitedOxford ...
07 Ene 89 Sutton UnitedSutton 2 - 1 Coventry CityCoventry ...
07 Ene 89 Tranmere RoversTranmere 1 - 1 ReadingReading ...
07 Ene 89 WalsallWalsall 1 - 1 BrentfordBrentford ...
07 Ene 89 Welling UnitedWelling 0 - 1 Blackburn RoversBlackburn ...
07 Ene 89 West Bromwich AlbionWest 1 - 1 EvertonEverton ...
08 Ene 89 Port ValePort Vale 1 - 3 Norwich CityNorwich ...
08 Ene 89 West HamWest Ham 2 - 2 ArsenalArsenal ...
10 Ene 89 BrentfordBrentford 1 - 0 WalsallWalsall ...
10 Ene 89 FC Halifax TownHalifax 2 - 3 Kettering TownKettering ...
10 Ene 89 SouthamptonSouthampton 1 - 2 Derby CountyDerby ...
10 Ene 89 Swindon TownSwindon 2 - 0 PortsmouthPortsmouth ...
10 Ene 89 WatfordWatford x - x NewcastleNewcastle ...
11 Ene 89 ArsenalArsenal 0 - 1 West HamWest Ham ...
11 Ene 89 EvertonEverton 1 - 0 West Bromwich AlbionWest ...
11 Ene 89 Oxford UnitedOxford 2 - 0 SunderlandSunderland ...
11 Ene 89 Queens Park RangersQueens Park 2 - 2 Manchester UnitedManchester ...
11 Ene 89 ReadingReading 2 - 1 Tranmere RoversTranmere ...
07 Ene 89 NewcastleNewcastle 0 - 0 WatfordWatford ...
10 Ene 89 WatfordWatford 1 - 0 NewcastleNewcastle ...
07 Ene 89 Manchester UnitedManchester 3 - 0 Queens Park RangersQueens Park ...
Jornada 4
18 Mar 89 Manchester UnitedManchester 0 - 1 Nottingham ForestNottingham ...
18 Mar 89 West HamWest Ham 0 - 0 Norwich CityNorwich ...
22 Mar 89 Norwich CityNorwich 3 - 1 West HamWest Ham ...
28 Ene 89 Aston VillaAston Villa 0 - 1 Wimbledon FCWimbledon ...
28 Ene 89 Blackburn RoversBlackburn 2 - 1 Sheffield WednesdaySheffield ...
28 Ene 89 Bradford CityBradford 1 - 2 Hull CityHull City ...
28 Ene 89 BrentfordBrentford 3 - 1 Manchester CityManchester ...
28 Ene 89 Grimsby TownGrimsby 1 - 1 ReadingReading ...
28 Ene 89 Hartlepool UnitedHartlepool 1 - 1 AFC BournemouthBournemouth ...
28 Ene 89 Manchester UnitedManchester 4 - 0 Oxford UnitedOxford ...
28 Ene 89 Norwich CityNorwich 8 - 0 Sutton UnitedSutton ...
28 Ene 89 Nottingham ForestNottingham 2 - 0 Leeds UnitedLeeds ...
28 Ene 89 Plymouth ArgylePlymouth 1 - 1 EvertonEverton ...
28 Ene 89 Sheffield UnitedSheffield 3 - 3 Colchester UnitedColchester ...
28 Ene 89 Stoke CityStoke City 3 - 3 BarnsleyBarnsley ...
28 Ene 89 Swindon TownSwindon 0 - 0 West HamWest Ham ...
28 Ene 89 WatfordWatford 2 - 1 Derby CountyDerby ...
28 Ene 89 Charlton AthleticCharlton 2 - 1 Kettering TownKettering ...
29 Ene 89 MillwallMillwall 0 - 2 LiverpoolLiverpool ...
31 Ene 89 BarnsleyBarnsley 2 - 1 Stoke CityStoke City ...
31 Ene 89 AFC BournemouthBournemouth 5 - 2 Hartlepool UnitedHartlepool ...
31 Ene 89 Colchester UnitedColchester 0 - 2 Sheffield UnitedSheffield ...
31 Ene 89 EvertonEverton 4 - 0 Plymouth ArgylePlymouth ...
01 Feb 89 ReadingReading 1 - 2 Grimsby TownGrimsby ...
01 Feb 89 West HamWest Ham 1 - 0 Swindon TownSwindon ...
Jornada 5
15 Abr 89 EvertonEverton 1 - 0 Norwich CityNorwich ...
07 May 89 LiverpoolLiverpool 3 - 1 Nottingham ForestNottingham 9
18 Feb 89 BarnsleyBarnsley 0 - 1 EvertonEverton ...
18 Feb 89 Blackburn RoversBlackburn 0 - 2 BrentfordBrentford ...
18 Feb 89 AFC BournemouthBournemouth 1 - 1 Manchester UnitedManchester ...
18 Feb 89 Charlton AthleticCharlton 0 - 1 West HamWest Ham ...
18 Feb 89 Hull CityHull City 2 - 3 LiverpoolLiverpool ...
18 Feb 89 Norwich CityNorwich 3 - 2 Sheffield UnitedSheffield ...
18 Feb 89 Wimbledon FCWimbledon 3 - 1 Grimsby TownGrimsby ...
19 Feb 89 WatfordWatford 0 - 3 Nottingham ForestNottingham ...
22 Feb 89 Manchester UnitedManchester 1 - 0 AFC BournemouthBournemouth ...
Jornada 6
18 Mar 89 LiverpoolLiverpool 4 - 0 BrentfordBrentford ...
18 Mar 89 Manchester UnitedManchester 0 - 1 Nottingham ForestNottingham ...
18 Mar 89 West HamWest Ham 0 - 0 Norwich CityNorwich ...
19 Mar 89 EvertonEverton 1 - 0 Wimbledon FCWimbledon ...
22 Mar 89 Norwich CityNorwich 3 - 1 West HamWest Ham ...
Jornada 7
15 Abr 89 EvertonEverton 1 - 0 Norwich CityNorwich ...
15 Abr 89 LiverpoolLiverpool 3 - 1 Nottingham ForestNottingham ...
Jornada 8
20 May 89 LiverpoolLiverpool 3 - 2 EvertonEverton ...

  USO DE MEMORIA  
6,079,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1397
Total Execution Time  0.1428
  CADENA URL  
/fa_cup1989/grupo0/calendario
  GET DATOS  
$_GET['/fa_cup1989/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0020  SELECT type FROM routes WHERE alias = 'fa_cup1989'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fa_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0028  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 = 14683 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0071  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 calendars1989 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 14683 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 10:35:52' 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=2 AND last_update > '2024-05-05 10:35:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 10:35:52' 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-05 10:35:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1989
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (14683) 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.0022  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 (14683) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252339,265678,265858,265975,322595,265974,322592,406249,435233,454384) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1989
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (14683) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1989
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (14683) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10