4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Premier League 1938
1937/1938

liga inglesa,the premiership,liga premier,football league first division,primera division inglesa,premier,premier league,primera division de inglaterra

Premier League 1938

  • Arsenal
  • Wolves
  • Preston North End
  • Charlton Athletic
  • Middlesbrough
  • Brentford
  • Bolton Wanderers
  • Sunderland
  • Leeds United
  • Chelsea
  • Liverpool
  • Blackpool
  • Derby County
  • Everton
  • Huddersfield Town
  • Leicester
  • Stoke City
  • Birmingham City
  • Portsmouth
  • Grimsby Town
  • Manchester City
  • West Bromwich Albion
Jornada 1
28 Ago 37 WolvesWolves 3 - 1 Manchester CityManchester ...
28 Ago 37 Charlton AthleticCharlton 1 - 1 Leeds UnitedLeeds ...
28 Ago 37 ChelseaChelsea 6 - 1 LiverpoolLiverpool ...
28 Ago 37 EvertonEverton 1 - 4 ArsenalArsenal ...
28 Ago 37 Huddersfield TownHuddersfiel 3 - 1 BlackpoolBlackpool ...
28 Ago 37 LeicesterLeicester 0 - 0 Derby CountyDerby ...
28 Ago 37 PortsmouthPortsmouth 2 - 3 West Bromwich AlbionWest ...
28 Ago 37 Preston North EndPreston 4 - 1 Grimsby TownGrimsby ...
28 Ago 37 Stoke CityStoke City 2 - 2 Birmingham CityBirmingham ...
28 Ago 37 SunderlandSunderland 3 - 1 MiddlesbroughMiddlesbrou ...
28 Ago 37 Bolton WanderersBolton 2 - 0 BrentfordBrentford ...
Jornada 2
01 Sep 37 Manchester CityManchester 2 - 0 EvertonEverton ...
01 Sep 37 ArsenalArsenal 3 - 1 Huddersfield TownHuddersfiel ...
01 Sep 37 Birmingham CityBirmingham 3 - 1 MiddlesbroughMiddlesbrou ...
01 Sep 37 BrentfordBrentford 2 - 1 Preston North EndPreston ...
01 Sep 37 Derby CountyDerby 1 - 2 WolvesWolves ...
01 Sep 37 Leeds UnitedLeeds 2 - 0 ChelseaChelsea ...
01 Sep 37 LiverpoolLiverpool 3 - 2 PortsmouthPortsmouth ...
31 Ago 37 Grimsby TownGrimsby 1 - 1 Charlton AthleticCharlton ...
30 Ago 37 West Bromwich AlbionWest 0 - 1 Stoke CityStoke City ...
30 Ago 37 LeicesterLeicester 4 - 0 SunderlandSunderland ...
30 Ago 37 BlackpoolBlackpool 2 - 2 Bolton WanderersBolton ...
Jornada 3
04 Sep 37 West Bromwich AlbionWest 4 - 0 ChelseaChelsea ...
04 Sep 37 Birmingham CityBirmingham 2 - 2 PortsmouthPortsmouth ...
04 Sep 37 BlackpoolBlackpool 1 - 0 EvertonEverton ...
04 Sep 37 BrentfordBrentford 2 - 0 Huddersfield TownHuddersfiel ...
04 Sep 37 Derby CountyDerby 2 - 2 SunderlandSunderland ...
04 Sep 37 Grimsby TownGrimsby 0 - 1 Bolton WanderersBolton ...
04 Sep 37 Leeds UnitedLeeds 0 - 0 Preston North EndPreston ...
04 Sep 37 LiverpoolLiverpool 1 - 2 Charlton AthleticCharlton ...
04 Sep 37 Manchester CityManchester 3 - 0 LeicesterLeicester ...
04 Sep 37 MiddlesbroughMiddlesbrou 2 - 1 Stoke CityStoke City ...
04 Sep 37 ArsenalArsenal 5 - 0 WolvesWolves ...
Jornada 4
08 Sep 37 SunderlandSunderland 1 - 0 LeicesterLeicester ...
08 Sep 37 ChelseaChelsea 4 - 1 Leeds UnitedLeeds ...
08 Sep 37 EvertonEverton 4 - 1 Manchester CityManchester ...
08 Sep 37 Huddersfield TownHuddersfiel 2 - 1 ArsenalArsenal ...
08 Sep 37 MiddlesbroughMiddlesbrou 1 - 1 Birmingham CityBirmingham ...
08 Sep 37 PortsmouthPortsmouth 1 - 1 LiverpoolLiverpool ...
06 Sep 37 WolvesWolves 2 - 2 Derby CountyDerby ...
06 Sep 37 Stoke CityStoke City 4 - 0 West Bromwich AlbionWest ...
06 Sep 37 Preston North EndPreston 1 - 1 BrentfordBrentford ...
06 Sep 37 Charlton AthleticCharlton 0 - 0 Grimsby TownGrimsby ...
06 Sep 37 Bolton WanderersBolton 3 - 0 BlackpoolBlackpool ...
Jornada 5
11 Sep 37 WolvesWolves 1 - 0 BlackpoolBlackpool ...
11 Sep 37 ChelseaChelsea 2 - 0 Birmingham CityBirmingham ...
11 Sep 37 EvertonEverton 3 - 0 BrentfordBrentford ...
11 Sep 37 Grimsby TownGrimsby 1 - 1 Leeds UnitedLeeds ...
11 Sep 37 Huddersfield TownHuddersfiel 1 - 0 Bolton WanderersBolton ...
11 Sep 37 LeicesterLeicester 1 - 1 ArsenalArsenal ...
11 Sep 37 PortsmouthPortsmouth 0 - 2 MiddlesbroughMiddlesbrou ...
11 Sep 37 Preston North EndPreston 4 - 1 LiverpoolLiverpool ...
11 Sep 37 Stoke CityStoke City 8 - 1 Derby CountyDerby ...
11 Sep 37 SunderlandSunderland 3 - 1 Manchester CityManchester ...
11 Sep 37 Charlton AthleticCharlton 3 - 1 West Bromwich AlbionWest ...
Jornada 6
16 Sep 37 BrentfordBrentford 2 - 4 BlackpoolBlackpool ...
15 Sep 37 Birmingham CityBirmingham 4 - 1 LeicesterLeicester ...
15 Sep 37 Bolton WanderersBolton 1 - 0 ArsenalArsenal ...
15 Sep 37 ChelseaChelsea 1 - 0 Grimsby TownGrimsby ...
15 Sep 37 Derby CountyDerby 2 - 1 EvertonEverton ...
15 Sep 37 Leeds UnitedLeeds 3 - 1 PortsmouthPortsmouth ...
15 Sep 37 LiverpoolLiverpool 3 - 0 Stoke CityStoke City ...
15 Sep 37 Manchester CityManchester 3 - 2 Huddersfield TownHuddersfiel ...
15 Sep 37 WolvesWolves 4 - 0 SunderlandSunderland ...
13 Sep 37 West Bromwich AlbionWest 3 - 1 MiddlesbroughMiddlesbrou ...
13 Sep 37 Preston North EndPreston 0 - 1 Charlton AthleticCharlton ...
Jornada 7
18 Sep 37 West Bromwich AlbionWest 1 - 1 Preston North EndPreston ...
18 Sep 37 Birmingham CityBirmingham 1 - 1 Charlton AthleticCharlton ...
18 Sep 37 BlackpoolBlackpool 2 - 4 LeicesterLeicester ...
18 Sep 37 Bolton WanderersBolton 1 - 2 EvertonEverton ...
18 Sep 37 BrentfordBrentford 2 - 1 WolvesWolves ...
18 Sep 37 Leeds UnitedLeeds 2 - 1 Huddersfield TownHuddersfiel ...
18 Sep 37 LiverpoolLiverpool 2 - 1 Grimsby TownGrimsby ...
18 Sep 37 Manchester CityManchester 6 - 1 Derby CountyDerby ...
18 Sep 37 MiddlesbroughMiddlesbrou 4 - 3 ChelseaChelsea ...
18 Sep 37 Stoke CityStoke City 3 - 1 PortsmouthPortsmouth ...
18 Sep 37 ArsenalArsenal 4 - 1 SunderlandSunderland ...
Jornada 8
25 Sep 37 WolvesWolves 1 - 1 Bolton WanderersBolton ...
25 Sep 37 Charlton AthleticCharlton 1 - 0 MiddlesbroughMiddlesbrou ...
25 Sep 37 ChelseaChelsea 2 - 1 Stoke CityStoke City ...
25 Sep 37 Derby CountyDerby 2 - 0 ArsenalArsenal ...
25 Sep 37 EvertonEverton 1 - 2 Huddersfield TownHuddersfiel ...
25 Sep 37 Grimsby TownGrimsby 1 - 4 West Bromwich AlbionWest ...
25 Sep 37 Leeds UnitedLeeds 2 - 0 LiverpoolLiverpool ...
25 Sep 37 LeicesterLeicester 0 - 1 BrentfordBrentford ...
25 Sep 37 PortsmouthPortsmouth 2 - 2 Manchester CityManchester ...
25 Sep 37 Preston North EndPreston 2 - 1 Birmingham CityBirmingham ...
25 Sep 37 SunderlandSunderland 2 - 1 BlackpoolBlackpool ...
Jornada 9
02 Oct 37 BlackpoolBlackpool 1 - 1 Derby CountyDerby ...
02 Oct 37 West Bromwich AlbionWest 2 - 1 Leeds UnitedLeeds ...
02 Oct 37 Birmingham CityBirmingham 2 - 2 Grimsby TownGrimsby ...
02 Oct 37 Bolton WanderersBolton 6 - 1 LeicesterLeicester ...
02 Oct 37 BrentfordBrentford 4 - 0 SunderlandSunderland ...
02 Oct 37 Huddersfield TownHuddersfiel 1 - 0 WolvesWolves ...
02 Oct 37 LiverpoolLiverpool 1 - 2 EvertonEverton ...
02 Oct 37 MiddlesbroughMiddlesbrou 2 - 1 Preston North EndPreston ...
02 Oct 37 PortsmouthPortsmouth 2 - 4 ChelseaChelsea ...
02 Oct 37 Stoke CityStoke City 2 - 0 Charlton AthleticCharlton ...
02 Oct 37 ArsenalArsenal 2 - 1 Manchester CityManchester ...
Jornada 10
09 Oct 37 Manchester CityManchester 2 - 1 BlackpoolBlackpool ...
09 Oct 37 Derby CountyDerby 1 - 3 BrentfordBrentford ...
09 Oct 37 WolvesWolves 2 - 0 EvertonEverton ...
09 Oct 37 Charlton AthleticCharlton 5 - 1 PortsmouthPortsmouth ...
09 Oct 37 ChelseaChelsea 2 - 2 ArsenalArsenal ...
09 Oct 37 Grimsby TownGrimsby 2 - 1 MiddlesbroughMiddlesbrou ...
09 Oct 37 Leeds UnitedLeeds 1 - 0 Birmingham CityBirmingham ...
09 Oct 37 LeicesterLeicester 2 - 1 Huddersfield TownHuddersfiel ...
09 Oct 37 LiverpoolLiverpool 0 - 1 West Bromwich AlbionWest ...
09 Oct 37 Preston North EndPreston 2 - 1 Stoke CityStoke City ...
09 Oct 37 SunderlandSunderland 3 - 1 Bolton WanderersBolton ...
Jornada 11
16 Oct 37 WolvesWolves 2 - 0 LiverpoolLiverpool ...
16 Oct 37 ArsenalArsenal 1 - 1 PortsmouthPortsmouth ...
16 Oct 37 BlackpoolBlackpool 0 - 2 ChelseaChelsea ...
16 Oct 37 Bolton WanderersBolton 1 - 4 Preston North EndPreston ...
16 Oct 37 BrentfordBrentford 5 - 2 Charlton AthleticCharlton ...
16 Oct 37 Derby CountyDerby 1 - 1 MiddlesbroughMiddlesbrou ...
16 Oct 37 EvertonEverton 1 - 1 Leeds UnitedLeeds ...
16 Oct 37 Huddersfield TownHuddersfiel 1 - 2 Grimsby TownGrimsby ...
16 Oct 37 LeicesterLeicester 4 - 1 West Bromwich AlbionWest ...
16 Oct 37 Manchester CityManchester 0 - 0 Stoke CityStoke City ...
16 Oct 37 SunderlandSunderland 1 - 0 Birmingham CityBirmingham ...
Jornada 12
23 Oct 37 West Bromwich AlbionWest 1 - 6 SunderlandSunderland ...
23 Oct 37 Charlton AthleticCharlton 1 - 1 Bolton WanderersBolton ...
23 Oct 37 ChelseaChelsea 2 - 1 BrentfordBrentford ...
23 Oct 37 Grimsby TownGrimsby 2 - 1 EvertonEverton ...
23 Oct 37 Leeds UnitedLeeds 1 - 2 WolvesWolves ...
23 Oct 37 LiverpoolLiverpool 1 - 1 LeicesterLeicester ...
23 Oct 37 MiddlesbroughMiddlesbrou 4 - 0 Manchester CityManchester ...
23 Oct 37 PortsmouthPortsmouth 1 - 2 BlackpoolBlackpool ...
23 Oct 37 Preston North EndPreston 1 - 1 Huddersfield TownHuddersfiel ...
23 Oct 37 Stoke CityStoke City 1 - 1 ArsenalArsenal ...
23 Oct 37 Birmingham CityBirmingham 1 - 0 Derby CountyDerby ...
Jornada 13
30 Oct 37 WolvesWolves 1 - 1 Grimsby TownGrimsby ...
30 Oct 37 BlackpoolBlackpool 0 - 1 Stoke CityStoke City ...
30 Oct 37 Bolton WanderersBolton 5 - 5 ChelseaChelsea ...
30 Oct 37 BrentfordBrentford 2 - 0 PortsmouthPortsmouth ...
30 Oct 37 Derby CountyDerby 5 - 3 West Bromwich AlbionWest ...
30 Oct 37 EvertonEverton 3 - 5 Preston North EndPreston ...
30 Oct 37 Huddersfield TownHuddersfiel 1 - 1 Charlton AthleticCharlton ...
30 Oct 37 LeicesterLeicester 2 - 4 Leeds UnitedLeeds ...
30 Oct 37 Manchester CityManchester 2 - 0 Birmingham CityBirmingham ...
30 Oct 37 SunderlandSunderland 2 - 3 LiverpoolLiverpool ...
30 Oct 37 ArsenalArsenal 1 - 2 MiddlesbroughMiddlesbrou ...
Jornada 14
06 Nov 37 LiverpoolLiverpool 3 - 4 BrentfordBrentford ...
06 Nov 37 Leeds UnitedLeeds 1 - 1 BlackpoolBlackpool ...
06 Nov 37 West Bromwich AlbionWest 2 - 4 Bolton WanderersBolton ...
06 Nov 37 Stoke CityStoke City 1 - 1 WolvesWolves ...
06 Nov 37 Preston North EndPreston 2 - 2 Manchester CityManchester ...
06 Nov 37 PortsmouthPortsmouth 1 - 1 LeicesterLeicester ...
06 Nov 37 MiddlesbroughMiddlesbrou 1 - 2 EvertonEverton ...
06 Nov 37 Grimsby TownGrimsby 2 - 1 ArsenalArsenal ...
06 Nov 37 ChelseaChelsea 0 - 0 SunderlandSunderland ...
06 Nov 37 Charlton AthleticCharlton 1 - 2 Derby CountyDerby ...
06 Nov 37 Birmingham CityBirmingham 2 - 2 Huddersfield TownHuddersfiel ...
Jornada 15
13 Nov 37 BrentfordBrentford 3 - 3 MiddlesbroughMiddlesbrou ...
13 Nov 37 BlackpoolBlackpool 0 - 3 Birmingham CityBirmingham ...
13 Nov 37 WolvesWolves 1 - 1 Charlton AthleticCharlton ...
13 Nov 37 ArsenalArsenal 1 - 1 West Bromwich AlbionWest ...
13 Nov 37 Bolton WanderersBolton 1 - 0 Stoke CityStoke City ...
13 Nov 37 Derby CountyDerby 2 - 2 Leeds UnitedLeeds ...
13 Nov 37 EvertonEverton 4 - 1 ChelseaChelsea ...
13 Nov 37 Huddersfield TownHuddersfiel 2 - 0 PortsmouthPortsmouth ...
13 Nov 37 LeicesterLeicester 1 - 0 Preston North EndPreston ...
13 Nov 37 Manchester CityManchester 1 - 3 LiverpoolLiverpool ...
13 Nov 37 SunderlandSunderland 2 - 2 Grimsby TownGrimsby ...
Jornada 16
20 Nov 37 West Bromwich AlbionWest 3 - 1 EvertonEverton ...
20 Nov 37 Birmingham CityBirmingham 2 - 0 WolvesWolves ...
20 Nov 37 Charlton AthleticCharlton 0 - 3 ArsenalArsenal ...
20 Nov 37 ChelseaChelsea 2 - 2 Manchester CityManchester ...
20 Nov 37 Grimsby TownGrimsby 0 - 1 BrentfordBrentford ...
20 Nov 37 Leeds UnitedLeeds 1 - 1 Bolton WanderersBolton ...
20 Nov 37 LiverpoolLiverpool 0 - 1 Huddersfield TownHuddersfiel ...
20 Nov 37 MiddlesbroughMiddlesbrou 4 - 2 LeicesterLeicester ...
20 Nov 37 PortsmouthPortsmouth 4 - 0 Derby CountyDerby ...
20 Nov 37 Preston North EndPreston 2 - 0 BlackpoolBlackpool ...
20 Nov 37 Stoke CityStoke City 0 - 0 SunderlandSunderland ...
Jornada 17
27 Nov 37 BlackpoolBlackpool 0 - 1 LiverpoolLiverpool ...
27 Nov 37 WolvesWolves 5 - 0 PortsmouthPortsmouth ...
27 Nov 37 Bolton WanderersBolton 1 - 1 Birmingham CityBirmingham ...
27 Nov 37 BrentfordBrentford 0 - 2 West Bromwich AlbionWest ...
27 Nov 37 Derby CountyDerby 1 - 1 Preston North EndPreston ...
27 Nov 37 EvertonEverton 3 - 0 Stoke CityStoke City ...
27 Nov 37 Huddersfield TownHuddersfiel 3 - 0 MiddlesbroughMiddlesbrou ...
27 Nov 37 LeicesterLeicester 1 - 0 ChelseaChelsea ...
27 Nov 37 Manchester CityManchester 3 - 1 Grimsby TownGrimsby ...
27 Nov 37 SunderlandSunderland 1 - 1 Charlton AthleticCharlton ...
27 Nov 37 ArsenalArsenal 4 - 1 Leeds UnitedLeeds ...
Jornada 18
16 Mar 38 West Bromwich AlbionWest 1 - 1 Manchester CityManchester ...
04 Dic 37 MiddlesbroughMiddlesbrou 2 - 2 BlackpoolBlackpool ...
04 Dic 37 Stoke CityStoke City 3 - 0 BrentfordBrentford ...
04 Dic 37 Birmingham CityBirmingham 1 - 2 ArsenalArsenal ...
04 Dic 37 Charlton AthleticCharlton 3 - 1 EvertonEverton ...
04 Dic 37 ChelseaChelsea 3 - 1 Huddersfield TownHuddersfiel ...
04 Dic 37 Grimsby TownGrimsby 2 - 1 LeicesterLeicester ...
04 Dic 37 Leeds UnitedLeeds 4 - 3 SunderlandSunderland ...
04 Dic 37 LiverpoolLiverpool 3 - 4 Derby CountyDerby ...
04 Dic 37 PortsmouthPortsmouth 1 - 1 Bolton WanderersBolton ...
04 Dic 37 Preston North EndPreston 2 - 0 WolvesWolves ...
Jornada 19
06 Abr 38 Manchester CityManchester 5 - 3 Charlton AthleticCharlton ...
23 Mar 38 WolvesWolves 0 - 1 MiddlesbroughMiddlesbrou ...
11 Dic 37 BrentfordBrentford 1 - 1 Leeds UnitedLeeds ...
11 Dic 37 BlackpoolBlackpool 2 - 2 Grimsby TownGrimsby ...
11 Dic 37 SunderlandSunderland 0 - 2 PortsmouthPortsmouth ...
11 Dic 37 LeicesterLeicester 2 - 0 Stoke CityStoke City ...
11 Dic 37 Huddersfield TownHuddersfiel 2 - 1 West Bromwich AlbionWest ...
11 Dic 37 EvertonEverton 1 - 1 Birmingham CityBirmingham 1
11 Dic 37 Derby CountyDerby 4 - 0 ChelseaChelsea ...
11 Dic 37 Bolton WanderersBolton 0 - 0 LiverpoolLiverpool ...
11 Dic 37 ArsenalArsenal 2 - 0 Preston North EndPreston ...
Jornada 20
18 Dic 37 West Bromwich AlbionWest 1 - 2 BlackpoolBlackpool ...
18 Dic 37 Birmingham CityBirmingham 0 - 0 BrentfordBrentford ...
18 Dic 37 ChelseaChelsea 0 - 2 WolvesWolves ...
18 Dic 37 Grimsby TownGrimsby 0 - 0 Derby CountyDerby ...
18 Dic 37 Leeds UnitedLeeds 2 - 1 Manchester CityManchester ...
18 Dic 37 LiverpoolLiverpool 2 - 0 ArsenalArsenal ...
18 Dic 37 MiddlesbroughMiddlesbrou 1 - 2 Bolton WanderersBolton ...
18 Dic 37 PortsmouthPortsmouth 3 - 1 EvertonEverton ...
18 Dic 37 Preston North EndPreston 0 - 0 SunderlandSunderland ...
18 Dic 37 Stoke CityStoke City 0 - 1 Huddersfield TownHuddersfiel ...
18 Dic 37 Charlton AthleticCharlton 2 - 0 LeicesterLeicester ...
Jornada 21
02 May 38 WolvesWolves 2 - 1 West Bromwich AlbionWest ...
27 Abr 38 ChelseaChelsea 1 - 1 Charlton AthleticCharlton ...
06 Abr 38 LiverpoolLiverpool 3 - 2 Birmingham CityBirmingham ...
22 Ene 38 Bolton WanderersBolton 0 - 2 Derby CountyDerby ...
25 Dic 37 Manchester CityManchester 0 - 2 BrentfordBrentford ...
25 Dic 37 BlackpoolBlackpool 2 - 1 ArsenalArsenal ...
25 Dic 37 Grimsby TownGrimsby 1 - 5 Stoke CityStoke City ...
25 Dic 37 Leeds UnitedLeeds 5 - 3 MiddlesbroughMiddlesbrou ...
25 Dic 37 LeicesterLeicester 3 - 1 EvertonEverton ...
25 Dic 37 PortsmouthPortsmouth 3 - 2 Preston North EndPreston ...
25 Dic 37 SunderlandSunderland 2 - 1 Huddersfield TownHuddersfiel ...
Jornada 22
27 Dic 37 BrentfordBrentford 2 - 1 Manchester CityManchester ...
27 Dic 37 ArsenalArsenal 2 - 1 BlackpoolBlackpool ...
27 Dic 37 EvertonEverton 3 - 0 LeicesterLeicester ...
27 Dic 37 Huddersfield TownHuddersfiel 1 - 1 SunderlandSunderland ...
27 Dic 37 MiddlesbroughMiddlesbrou 2 - 0 Leeds UnitedLeeds ...
27 Dic 37 Preston North EndPreston 1 - 1 PortsmouthPortsmouth ...
27 Dic 37 Stoke CityStoke City 1 - 1 Grimsby TownGrimsby ...
27 Dic 37 Derby CountyDerby 4 - 2 Bolton WanderersBolton ...
27 Dic 37 Birmingham CityBirmingham 2 - 2 LiverpoolLiverpool ...
27 Dic 37 West Bromwich AlbionWest 2 - 2 WolvesWolves ...
27 Dic 37 Charlton AthleticCharlton 3 - 1 ChelseaChelsea 1
Jornada 23
01 Ene 38 ArsenalArsenal 2 - 1 EvertonEverton ...
01 Ene 38 Birmingham CityBirmingham 1 - 1 Stoke CityStoke City ...
01 Ene 38 BlackpoolBlackpool 4 - 0 Huddersfield TownHuddersfiel ...
01 Ene 38 Derby CountyDerby 0 - 1 LeicesterLeicester ...
01 Ene 38 Grimsby TownGrimsby 1 - 1 Preston North EndPreston ...
01 Ene 38 MiddlesbroughMiddlesbrou 2 - 1 SunderlandSunderland ...
01 Ene 38 West Bromwich AlbionWest 1 - 2 PortsmouthPortsmouth ...
01 Ene 38 LiverpoolLiverpool 2 - 2 ChelseaChelsea ...
01 Ene 38 BrentfordBrentford 1 - 1 Bolton WanderersBolton ...
01 Ene 38 Manchester CityManchester 2 - 4 WolvesWolves ...
01 Ene 38 Leeds UnitedLeeds 2 - 2 Charlton AthleticCharlton ...
Jornada 24
15 Ene 38 Huddersfield TownHuddersfiel 0 - 3 BrentfordBrentford ...
15 Ene 38 LeicesterLeicester 1 - 4 Manchester CityManchester ...
15 Ene 38 PortsmouthPortsmouth 1 - 1 Birmingham CityBirmingham ...
15 Ene 38 Preston North EndPreston 3 - 1 Leeds UnitedLeeds ...
15 Ene 38 Stoke CityStoke City 3 - 0 MiddlesbroughMiddlesbrou ...
15 Ene 38 SunderlandSunderland 2 - 0 Derby CountyDerby ...
15 Ene 38 EvertonEverton 3 - 1 BlackpoolBlackpool ...
15 Ene 38 ChelseaChelsea 2 - 2 West Bromwich AlbionWest ...
15 Ene 38 Bolton WanderersBolton 3 - 1 Grimsby TownGrimsby ...
15 Ene 38 WolvesWolves 3 - 1 ArsenalArsenal ...
15 Ene 38 Charlton AthleticCharlton 3 - 0 LiverpoolLiverpool ...
Jornada 25
02 Feb 38 ArsenalArsenal 3 - 1 LeicesterLeicester ...
02 Feb 38 Derby CountyDerby 4 - 1 Stoke CityStoke City ...
02 Feb 38 LiverpoolLiverpool 2 - 2 Preston North EndPreston ...
02 Feb 38 Manchester CityManchester 0 - 0 SunderlandSunderland ...
26 Ene 38 MiddlesbroughMiddlesbrou 0 - 0 PortsmouthPortsmouth ...
26 Ene 38 Leeds UnitedLeeds 1 - 1 Grimsby TownGrimsby ...
26 Ene 38 BrentfordBrentford 3 - 0 EvertonEverton ...
26 Ene 38 Bolton WanderersBolton 2 - 0 Huddersfield TownHuddersfiel ...
26 Ene 38 West Bromwich AlbionWest 0 - 0 Charlton AthleticCharlton ...
26 Ene 38 BlackpoolBlackpool 0 - 2 WolvesWolves ...
22 Ene 38 Birmingham CityBirmingham 1 - 1 ChelseaChelsea ...
Jornada 26
29 Ene 38 PortsmouthPortsmouth 2 - 0 Stoke CityStoke City ...
29 Ene 38 Huddersfield TownHuddersfiel 0 - 3 Leeds UnitedLeeds ...
29 Ene 38 Grimsby TownGrimsby 0 - 0 LiverpoolLiverpool ...
29 Ene 38 EvertonEverton 4 - 1 Bolton WanderersBolton ...
29 Ene 38 ChelseaChelsea 0 - 1 MiddlesbroughMiddlesbrou ...
29 Ene 38 Derby CountyDerby 1 - 7 Manchester CityManchester ...
29 Ene 38 LeicesterLeicester 0 - 1 BlackpoolBlackpool ...
29 Ene 38 Preston North EndPreston 1 - 1 West Bromwich AlbionWest ...
29 Ene 38 SunderlandSunderland 1 - 1 ArsenalArsenal ...
29 Ene 38 WolvesWolves 2 - 1 BrentfordBrentford ...
29 Ene 38 Charlton AthleticCharlton 2 - 0 Birmingham CityBirmingham ...
Jornada 27
05 Feb 38 Birmingham CityBirmingham 0 - 2 Preston North EndPreston ...
05 Feb 38 BlackpoolBlackpool 0 - 0 SunderlandSunderland ...
05 Feb 38 Bolton WanderersBolton 1 - 2 WolvesWolves ...
05 Feb 38 BrentfordBrentford 1 - 1 LeicesterLeicester ...
05 Feb 38 Huddersfield TownHuddersfiel 1 - 3 EvertonEverton ...
05 Feb 38 LiverpoolLiverpool 1 - 1 Leeds UnitedLeeds ...
05 Feb 38 Manchester CityManchester 2 - 1 PortsmouthPortsmouth ...
05 Feb 38 ArsenalArsenal 3 - 0 Derby CountyDerby ...
05 Feb 38 Stoke CityStoke City 2 - 1 ChelseaChelsea ...
05 Feb 38 West Bromwich AlbionWest 2 - 1 Grimsby TownGrimsby ...
05 Feb 38 MiddlesbroughMiddlesbrou 3 - 1 Charlton AthleticCharlton ...
Jornada 28
02 Mar 38 Charlton AthleticCharlton 3 - 0 Stoke CityStoke City ...
16 Feb 38 EvertonEverton 1 - 3 LiverpoolLiverpool ...
16 Feb 38 Manchester CityManchester 1 - 2 ArsenalArsenal ...
16 Feb 38 Preston North EndPreston 0 - 2 MiddlesbroughMiddlesbrou ...
16 Feb 38 SunderlandSunderland 1 - 0 BrentfordBrentford ...
16 Feb 38 WolvesWolves 1 - 4 Huddersfield TownHuddersfiel ...
12 Feb 38 Derby CountyDerby 3 - 1 BlackpoolBlackpool ...
12 Feb 38 LeicesterLeicester 1 - 1 Bolton WanderersBolton ...
12 Feb 38 Grimsby TownGrimsby 4 - 0 Birmingham CityBirmingham ...
12 Feb 38 ChelseaChelsea 3 - 1 PortsmouthPortsmouth ...
12 Feb 38 Leeds UnitedLeeds 1 - 0 West Bromwich AlbionWest ...
Jornada 29
19 Feb 38 BrentfordBrentford 2 - 3 Derby CountyDerby ...
19 Feb 38 BlackpoolBlackpool 2 - 1 Manchester CityManchester ...
19 Feb 38 Bolton WanderersBolton 1 - 1 SunderlandSunderland ...
19 Feb 38 EvertonEverton 0 - 1 WolvesWolves ...
19 Feb 38 Huddersfield TownHuddersfiel 0 - 0 LeicesterLeicester ...
19 Feb 38 MiddlesbroughMiddlesbrou 1 - 0 Grimsby TownGrimsby ...
19 Feb 38 Stoke CityStoke City 1 - 1 Preston North EndPreston ...
19 Feb 38 Birmingham CityBirmingham 3 - 2 Leeds UnitedLeeds ...
19 Feb 38 ArsenalArsenal 2 - 0 ChelseaChelsea ...
19 Feb 38 West Bromwich AlbionWest 5 - 1 LiverpoolLiverpool ...
19 Feb 38 PortsmouthPortsmouth 2 - 1 Charlton AthleticCharlton ...
Jornada 30
26 Feb 38 Birmingham CityBirmingham 2 - 2 SunderlandSunderland ...
26 Feb 38 Grimsby TownGrimsby 4 - 2 Huddersfield TownHuddersfiel ...
26 Feb 38 Leeds UnitedLeeds 4 - 4 EvertonEverton ...
26 Feb 38 MiddlesbroughMiddlesbrou 4 - 2 Derby CountyDerby ...
26 Feb 38 PortsmouthPortsmouth 0 - 0 ArsenalArsenal ...
26 Feb 38 Preston North EndPreston 2 - 2 Bolton WanderersBolton ...
26 Feb 38 West Bromwich AlbionWest 1 - 3 LeicesterLeicester ...
26 Feb 38 Stoke CityStoke City 3 - 2 Manchester CityManchester ...
26 Feb 38 ChelseaChelsea 1 - 3 BlackpoolBlackpool ...
26 Feb 38 LiverpoolLiverpool 0 - 1 WolvesWolves ...
26 Feb 38 Charlton AthleticCharlton 1 - 0 BrentfordBrentford ...
Jornada 31
16 Mar 38 Huddersfield TownHuddersfiel 1 - 3 Preston North EndPreston ...
09 Mar 38 SunderlandSunderland 3 - 0 West Bromwich AlbionWest ...
09 Mar 38 BrentfordBrentford 1 - 1 ChelseaChelsea ...
09 Mar 38 Manchester CityManchester 1 - 6 MiddlesbroughMiddlesbrou ...
05 Mar 38 LeicesterLeicester 2 - 2 LiverpoolLiverpool ...
05 Mar 38 EvertonEverton 3 - 2 Grimsby TownGrimsby ...
05 Mar 38 Bolton WanderersBolton 1 - 0 Charlton AthleticCharlton ...
05 Mar 38 BlackpoolBlackpool 2 - 0 PortsmouthPortsmouth ...
05 Mar 38 ArsenalArsenal 4 - 0 Stoke CityStoke City ...
05 Mar 38 Derby CountyDerby 0 - 0 Birmingham CityBirmingham ...
05 Mar 38 WolvesWolves 1 - 1 Leeds UnitedLeeds ...
Jornada 32
12 Mar 38 Leeds UnitedLeeds 0 - 2 LeicesterLeicester ...
12 Mar 38 ChelseaChelsea 0 - 0 Bolton WanderersBolton ...
12 Mar 38 LiverpoolLiverpool 4 - 0 SunderlandSunderland ...
12 Mar 38 MiddlesbroughMiddlesbrou 2 - 1 ArsenalArsenal ...
12 Mar 38 PortsmouthPortsmouth 4 - 1 BrentfordBrentford ...
12 Mar 38 Preston North EndPreston 2 - 1 EvertonEverton ...
12 Mar 38 Stoke CityStoke City 1 - 3 BlackpoolBlackpool ...
12 Mar 38 Birmingham CityBirmingham 2 - 2 Manchester CityManchester ...
12 Mar 38 West Bromwich AlbionWest 4 - 2 Derby CountyDerby ...
12 Mar 38 Grimsby TownGrimsby 1 - 0 WolvesWolves ...
12 Mar 38 Charlton AthleticCharlton 4 - 0 Huddersfield TownHuddersfiel ...
Jornada 33
19 Mar 38 Manchester CityManchester 1 - 2 Preston North EndPreston ...
19 Mar 38 LeicesterLeicester 3 - 3 PortsmouthPortsmouth ...
19 Mar 38 BrentfordBrentford 1 - 3 LiverpoolLiverpool ...
19 Mar 38 BlackpoolBlackpool 5 - 2 Leeds UnitedLeeds ...
19 Mar 38 ArsenalArsenal 5 - 1 Grimsby TownGrimsby ...
19 Mar 38 Bolton WanderersBolton 3 - 0 West Bromwich AlbionWest ...
19 Mar 38 EvertonEverton 2 - 2 MiddlesbroughMiddlesbrou ...
19 Mar 38 Huddersfield TownHuddersfiel 2 - 1 Birmingham CityBirmingham ...
19 Mar 38 WolvesWolves 2 - 2 Stoke CityStoke City ...
19 Mar 38 SunderlandSunderland 1 - 1 ChelseaChelsea ...
19 Mar 38 Derby CountyDerby 3 - 2 Charlton AthleticCharlton ...
Jornada 34
30 Mar 38 PortsmouthPortsmouth 3 - 0 Huddersfield TownHuddersfiel ...
29 Mar 38 Grimsby TownGrimsby 0 - 2 SunderlandSunderland ...
26 Mar 38 MiddlesbroughMiddlesbrou 0 - 1 BrentfordBrentford ...
26 Mar 38 Birmingham CityBirmingham 1 - 1 BlackpoolBlackpool ...
26 Mar 38 Leeds UnitedLeeds 0 - 2 Derby CountyDerby ...
26 Mar 38 Stoke CityStoke City 3 - 2 Bolton WanderersBolton ...
26 Mar 38 West Bromwich AlbionWest 0 - 0 ArsenalArsenal ...
26 Mar 38 LiverpoolLiverpool 2 - 0 Manchester CityManchester ...
26 Mar 38 ChelseaChelsea 2 - 0 EvertonEverton ...
26 Mar 38 Charlton AthleticCharlton 4 - 1 WolvesWolves ...
09 Mar 38 Preston North EndPreston 0 - 0 LeicesterLeicester ...
Jornada 35
02 Abr 38 BrentfordBrentford 6 - 1 Grimsby TownGrimsby ...
02 Abr 38 EvertonEverton 5 - 3 West Bromwich AlbionWest ...
02 Abr 38 Huddersfield TownHuddersfiel 1 - 2 LiverpoolLiverpool ...
02 Abr 38 LeicesterLeicester 0 - 1 MiddlesbroughMiddlesbrou ...
02 Abr 38 SunderlandSunderland 1 - 1 Stoke CityStoke City ...
02 Abr 38 WolvesWolves 3 - 2 Birmingham CityBirmingham ...
02 Abr 38 Manchester CityManchester 1 - 0 ChelseaChelsea ...
02 Abr 38 ArsenalArsenal 2 - 2 Charlton AthleticCharlton ...
02 Abr 38 Derby CountyDerby 1 - 0 PortsmouthPortsmouth ...
02 Abr 38 Bolton WanderersBolton 0 - 0 Leeds UnitedLeeds ...
02 Abr 38 BlackpoolBlackpool 1 - 0 Preston North EndPreston ...
Jornada 36
09 Abr 38 Charlton AthleticCharlton 2 - 1 SunderlandSunderland ...
09 Abr 38 ChelseaChelsea 4 - 1 LeicesterLeicester ...
09 Abr 38 West Bromwich AlbionWest 4 - 3 BrentfordBrentford ...
09 Abr 38 Birmingham CityBirmingham 2 - 0 Bolton WanderersBolton ...
09 Abr 38 Stoke CityStoke City 1 - 1 EvertonEverton ...
09 Abr 38 Preston North EndPreston 4 - 1 Derby CountyDerby ...
09 Abr 38 PortsmouthPortsmouth 1 - 0 WolvesWolves ...
09 Abr 38 MiddlesbroughMiddlesbrou 0 - 1 Huddersfield TownHuddersfiel ...
09 Abr 38 Leeds UnitedLeeds 0 - 1 ArsenalArsenal ...
09 Abr 38 Grimsby TownGrimsby 3 - 1 Manchester CityManchester ...
09 Abr 38 LiverpoolLiverpool 4 - 2 BlackpoolBlackpool ...
Jornada 37
15 Abr 38 Birmingham CityBirmingham 2 - 1 West Bromwich AlbionWest ...
15 Abr 38 BlackpoolBlackpool 1 - 0 Charlton AthleticCharlton ...
15 Abr 38 ChelseaChelsea 0 - 2 Preston North EndPreston ...
15 Abr 38 WolvesWolves 10 - 1 LeicesterLeicester ...
15 Abr 38 MiddlesbroughMiddlesbrou 1 - 1 LiverpoolLiverpool ...
15 Abr 38 Manchester CityManchester 1 - 2 Bolton WanderersBolton ...
15 Abr 38 Grimsby TownGrimsby 1 - 0 PortsmouthPortsmouth ...
15 Abr 38 EvertonEverton 3 - 3 SunderlandSunderland ...
15 Abr 38 ArsenalArsenal 0 - 2 BrentfordBrentford ...
18 Abr 38 Stoke CityStoke City 0 - 1 Leeds UnitedLeeds ...
18 Abr 38 Derby CountyDerby 0 - 4 Huddersfield TownHuddersfiel ...
Jornada 38
16 Abr 38 BrentfordBrentford 0 - 0 Stoke CityStoke City ...
16 Abr 38 Derby CountyDerby 4 - 1 LiverpoolLiverpool ...
16 Abr 38 EvertonEverton 3 - 0 Charlton AthleticCharlton ...
16 Abr 38 Huddersfield TownHuddersfiel 1 - 2 ChelseaChelsea ...
16 Abr 38 Manchester CityManchester 7 - 1 West Bromwich AlbionWest ...
16 Abr 38 ArsenalArsenal 0 - 0 Birmingham CityBirmingham ...
16 Abr 38 Bolton WanderersBolton 1 - 1 PortsmouthPortsmouth ...
16 Abr 38 LeicesterLeicester 1 - 0 Grimsby TownGrimsby ...
16 Abr 38 SunderlandSunderland 0 - 0 Leeds UnitedLeeds ...
16 Abr 38 WolvesWolves 0 - 0 Preston North EndPreston ...
16 Abr 38 BlackpoolBlackpool 4 - 2 MiddlesbroughMiddlesbrou ...
Jornada 39
18 Abr 38 Preston North EndPreston 0 - 0 ChelseaChelsea ...
18 Abr 38 Charlton AthleticCharlton 4 - 1 BlackpoolBlackpool ...
18 Abr 38 West Bromwich AlbionWest 4 - 3 Birmingham CityBirmingham ...
18 Abr 38 SunderlandSunderland 2 - 0 EvertonEverton ...
18 Abr 38 PortsmouthPortsmouth 3 - 0 Grimsby TownGrimsby ...
18 Abr 38 LiverpoolLiverpool 1 - 1 MiddlesbroughMiddlesbrou ...
18 Abr 38 LeicesterLeicester 1 - 1 WolvesWolves ...
18 Abr 38 BrentfordBrentford 3 - 0 ArsenalArsenal ...
18 Abr 38 Bolton WanderersBolton 2 - 1 Manchester CityManchester ...
19 Abr 38 Huddersfield TownHuddersfiel 2 - 0 Derby CountyDerby ...
19 Abr 38 Leeds UnitedLeeds 2 - 1 Stoke CityStoke City ...
Jornada 40
23 Abr 38 Charlton AthleticCharlton 0 - 0 Manchester CityManchester ...
23 Abr 38 ChelseaChelsea 3 - 0 Derby CountyDerby ...
23 Abr 38 MiddlesbroughMiddlesbrou 0 - 3 WolvesWolves ...
23 Abr 38 Birmingham CityBirmingham 0 - 3 EvertonEverton ...
23 Abr 38 LiverpoolLiverpool 2 - 1 Bolton WanderersBolton ...
23 Abr 38 PortsmouthPortsmouth 1 - 0 SunderlandSunderland ...
23 Abr 38 Preston North EndPreston 1 - 3 ArsenalArsenal ...
23 Abr 38 Stoke CityStoke City 1 - 2 LeicesterLeicester ...
23 Abr 38 West Bromwich AlbionWest 5 - 1 Huddersfield TownHuddersfiel ...
23 Abr 38 Grimsby TownGrimsby 1 - 0 BlackpoolBlackpool ...
23 Abr 38 Leeds UnitedLeeds 4 - 0 BrentfordBrentford ...
Jornada 41
30 Abr 38 WolvesWolves 1 - 1 ChelseaChelsea ...
30 Abr 38 Manchester CityManchester 6 - 2 Leeds UnitedLeeds ...
30 Abr 38 LeicesterLeicester 1 - 0 Charlton AthleticCharlton ...
30 Abr 38 EvertonEverton 5 - 2 PortsmouthPortsmouth ...
30 Abr 38 Derby CountyDerby 1 - 2 Grimsby TownGrimsby ...
30 Abr 38 BrentfordBrentford 1 - 2 Birmingham CityBirmingham ...
30 Abr 38 Bolton WanderersBolton 3 - 1 MiddlesbroughMiddlesbrou ...
30 Abr 38 ArsenalArsenal 1 - 0 LiverpoolLiverpool ...
30 Abr 38 BlackpoolBlackpool 3 - 1 West Bromwich AlbionWest ...
02 May 38 Huddersfield TownHuddersfiel 3 - 0 Stoke CityStoke City ...
04 May 38 SunderlandSunderland 0 - 2 Preston North EndPreston ...
Jornada 42
20 Sep 37 BlackpoolBlackpool 1 - 1 BrentfordBrentford ...
07 May 38 Stoke CityStoke City 2 - 0 LiverpoolLiverpool ...
07 May 38 PortsmouthPortsmouth 4 - 0 Leeds UnitedLeeds ...
07 May 38 MiddlesbroughMiddlesbrou 4 - 1 West Bromwich AlbionWest ...
07 May 38 LeicesterLeicester 1 - 4 Birmingham CityBirmingham ...
07 May 38 Huddersfield TownHuddersfiel 1 - 0 Manchester CityManchester ...
07 May 38 Grimsby TownGrimsby 2 - 0 ChelseaChelsea ...
07 May 38 EvertonEverton 1 - 1 Derby CountyDerby ...
07 May 38 Charlton AthleticCharlton 0 - 0 Preston North EndPreston ...
07 May 38 ArsenalArsenal 5 - 0 Bolton WanderersBolton ...
07 May 38 SunderlandSunderland 1 - 0 WolvesWolves ...

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Arsenal Arsenal 42 77 44 52
2 Wolves Wolves 42 72 49 51
3 Preston North End Preston 42 64 44 49
4 Charlton Athletic Charlton 42 65 51 46
5 Middlesbrough Middlesbroug 42 72 65 46
6 Brentford Brentford 42 69 59 45
7 Bolton Wanderers Bolton 42 64 60 45
8 Sunderland Sunderland 42 55 57 44
9 Leeds United Leeds United 42 64 69 43
10 Chelsea Chelsea 42 65 65 41
11 Liverpool Liverpool 42 65 71 41
12 Blackpool Blackpool 42 61 66 40
13 Derby County Derby County 42 66 87 40
14 Everton Everton 42 79 75 39
15 Huddersfield Town Huddersfield 42 55 68 39
16 Leicester Leicester 42 54 75 39
17 Stoke City Stoke City 42 58 59 38
18 Birmingham City Birmingham 42 58 62 38
19 Portsmouth Portsmouth 42 62 68 38
20 Grimsby Town Grimsby Town 42 51 68 38
21 Manchester City Manchester 42 80 77 36
22 West Bromwich Albion West 42 74 91 36

  USO DE MEMORIA  
8,487,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2888
Total Execution Time  0.2908
  CADENA URL  
/premier1938/grupo1/calendario
  GET DATOS  
$_GET['/premier1938/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10 AND type_rel = 3
0.0984  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 10 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1313262,1313250,1313176,1313155,1313138) ORDER BY n.cover_points DESC, update_date DESC
0.0068  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 calendars1938 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 5648 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-05-01 00:50:13' 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-01 00:50:13' 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-01 00:50:13' 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-01 00:50:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0247  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1938 e ON e.player_id = p.id AND e.league_id = 5648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5648 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 LIMIT 10
0.0030  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1938 e ON e.player_id = p.id AND e.league_id = 5648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5648 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1938 e ON e.player_id = p.id AND e.league_id = 5648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5648 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1938` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 5648 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC