4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Copa del Rey 1976
1975/1976

copa de su majestad el rey, copa del rey, campeonato de españa, la copa de españa,

Copa del Rey 1976

Jornada 1
12 Oct 75 AlbaceteAlbacete 3 - 1 Galáctico PegasoGaláctico ...
16 Nov 75 Galáctico PegasoGaláctico 2 - 0 AlbaceteAlbacete ...
12 Oct 75 Club SieroClub Siero 1 - 0 CD MálagaCD Málaga ...
16 Nov 75 CD MálagaCD Málaga 3 - 0 Club SieroClub Siero ...
12 Oct 75 ConstànciaConstància 1 - 0 Real MurciaReal Murcia ...
16 Nov 75 Real MurciaReal Murcia 3 - 0 ConstànciaConstància ...
12 Oct 75 Club LemosClub Lemos 0 - 1 Rayo VallecanoRayo ...
16 Nov 75 Rayo VallecanoRayo 5 - 0 Club LemosClub Lemos ...
12 Oct 75 RM CastillaCastilla 2 - 2 AD AlmeríaAlmería ...
16 Nov 75 AD AlmeríaAlmería 4 - 2 RM CastillaCastilla ...
12 Oct 75 ZamoraZamora 1 - 2 Bilbao Ath.Bilbao Ath. ...
16 Nov 75 Bilbao Ath.Bilbao Ath. 3 - 0 ZamoraZamora ...
12 Oct 75 Valencia MestallaValencia 2 - 0 Salamanca UDSSalamanca ...
16 Nov 75 Salamanca UDSSalamanca 2 - 1 Valencia MestallaValencia ...
12 Oct 75 CD San FernandoFernando 2 - 1 Real JaénReal Jaén ...
16 Nov 75 Real JaénReal Jaén 3 - 0 CD San FernandoFernando ...
12 Oct 75 Atlético BAtlético 5 - 0 Diter ZafraDiter Zafra ...
16 Nov 75 Diter ZafraDiter Zafra 2 - 1 Atlético BAtlético ...
12 Oct 75 Real ValladolidReal 3 - 0 GironaGirona ...
16 Nov 75 GironaGirona 1 - 2 Real ValladolidReal ...
12 Oct 75 Terrassa FCTerrassa 0 - 0 CD LaredoCD Laredo ...
16 Nov 75 CD LaredoCD Laredo 1 - 0 Terrassa FCTerrassa ...
12 Oct 75 MallorcaMallorca 1 - 1 CádizCádiz ...
16 Nov 75 CádizCádiz 3 - 0 MallorcaMallorca ...
12 Oct 75 TudelanoTudelano 3 - 1 MichelínMichelín ...
16 Nov 75 MichelínMichelín 2 - 1 TudelanoTudelano ...
12 Oct 75 Racing FerrolRacing 0 - 0 CD Colonia MoscardóColonia ...
16 Nov 75 CD Colonia MoscardóColonia 0 - 1 Racing FerrolRacing ...
12 Oct 75 Gimnàstic TarragonaGimnàstic 3 - 1 HuescaHuesca ...
16 Nov 75 HuescaHuesca 2 - 1 Gimnàstic TarragonaGimnàstic ...
12 Oct 75 CD TurónCD Turón 5 - 2 MasnouMasnou ...
16 Nov 75 MasnouMasnou 5 - 1 CD TurónCD Turón ...
12 Oct 75 BurgosBurgos 4 - 2 Real Unión ClubReal Unión ...
16 Nov 75 Real Unión ClubReal Unión 1 - 1 BurgosBurgos ...
12 Oct 75 Deportivo AlavésDeportivo 3 - 0 CD BadajozCD Badajoz ...
16 Nov 75 CD BadajozCD Badajoz 1 - 1 Deportivo AlavésDeportivo ...
12 Oct 75 Cultural LeonesaCultural 2 - 0 CD CastellónCastellón ...
16 Nov 75 CD CastellónCastellón 2 - 1 Cultural LeonesaCultural ...
12 Oct 75 CF GandiaCF Gandia 1 - 3 Linares CFLinares CF ...
16 Nov 75 Linares CFLinares CF 1 - 1 CF GandiaCF Gandia ...
12 Oct 75 MirandésMirandés 3 - 1 Sestao Sport ClubSestao ...
16 Nov 75 Sestao Sport ClubSestao 3 - 2 MirandésMirandés ...
12 Oct 75 Barça AtlèticBarça 2 - 1 Getafe DeportivoGetafe ...
16 Nov 75 Getafe DeportivoGetafe 2 - 0 Barça AtlèticBarça ...
12 Oct 75 VillenaVillena 2 - 1 Xerez CDXerez CD ...
16 Nov 75 Xerez CDXerez CD 3 - 2 VillenaVillena ...
12 Oct 75 VinaròsVinaròs 1 - 1 CE SabadellSabadell ...
16 Nov 75 CE SabadellSabadell 4 - 1 VinaròsVinaròs ...
12 Oct 75 Olimpic XátivaOlimpic 5 - 2 OsasunaOsasuna ...
16 Nov 75 OsasunaOsasuna 4 - 0 Olimpic XátivaOlimpic ...
12 Oct 75 SanturtziSanturtzi 1 - 1 RCD CarabanchelCarabanchel ...
16 Nov 75 RCD CarabanchelCarabanchel 5 - 0 SanturtziSanturtzi ...
12 Oct 75 CD BasconiaBasconia 2 - 0 AgD CeutaAgD Ceuta ...
16 Nov 75 AgD CeutaAgD Ceuta 1 - 0 CD BasconiaBasconia ...
12 Oct 75 VillarrealVillarreal 2 - 1 EldenseEldense ...
16 Nov 75 EldenseEldense 1 - 2 VillarrealVillarreal ...
12 Oct 75 RC PortuensePortuense 0 - 0 RecreativoRecreativo ...
16 Nov 75 RecreativoRecreativo 4 - 0 RC PortuensePortuense ...
12 Oct 75 CP CacereñoCacereño 2 - 0 LangreoLangreo ...
16 Nov 75 LangreoLangreo 5 - 1 CP CacereñoCacereño ...
12 Oct 75 CD OurenseCD Ourense 1 - 0 Ontinyent CFOntinyent ...
16 Nov 75 Ontinyent CFOntinyent 1 - 1 CD OurenseCD Ourense ...
12 Oct 75 RB LinenseRB Linense 5 - 1 UD MelillaUD Melilla ...
16 Nov 75 UD MelillaUD Melilla 2 - 0 RB LinenseRB Linense ...
12 Oct 75 BarakaldoBarakaldo 2 - 1 CD LogroñésLogroñés ...
16 Nov 75 CD LogroñésLogroñés 1 - 1 BarakaldoBarakaldo ...
12 Oct 75 AD Torrejón CFTorrejón 0 - 1 CD GetxoCD Getxo ...
16 Nov 75 CD GetxoCD Getxo 1 - 0 AD Torrejón CFTorrejón ...
12 Oct 75 RC DeportivoDeportivo 1 - 0 Sporting AtléticoSporting ...
16 Nov 75 Sporting AtléticoSporting 3 - 1 RC DeportivoDeportivo ...
12 Oct 75 SD IbizaSD Ibiza 0 - 0 Atlético BalearesAtlético ...
16 Nov 75 Atlético BalearesAtlético 1 - 2 SD IbizaSD Ibiza ...
12 Oct 75 CD LugoCD Lugo 1 - 1 CeltaCelta ...
16 Nov 75 CeltaCelta 4 - 0 CD LugoCD Lugo ...
12 Oct 75 EnsidesaEnsidesa 1 - 0 LevanteLevante ...
16 Nov 75 LevanteLevante 2 - 1 EnsidesaEnsidesa ...
12 Oct 75 PalenciaPalencia 1 - 2 Talavera CFTalavera ...
16 Nov 75 Talavera CFTalavera 2 - 0 PalenciaPalencia ...
12 Oct 75 Imperio CeutaImperio 0 - 4 PuertollanoPuertollano ...
16 Nov 75 PuertollanoPuertollano 6 - 2 Imperio CeutaImperio ...
12 Oct 75 CD Lagun OnakLagun Onak 1 - 0 TenerifeTenerife ...
16 Nov 75 TenerifeTenerife 4 - 0 CD Lagun OnakLagun Onak ...
12 Oct 75 SD MelillaSD Melilla 0 - 0 Córdoba CFCórdoba ...
16 Nov 75 Córdoba CFCórdoba 3 - 3 SD MelillaSD Melilla ...
12 Oct 75 Jerez Industrial CFJerez 0 - 0 Algeciras CFAlgeciras ...
16 Nov 75 Algeciras CFAlgeciras 1 - 0 Jerez Industrial CFJerez ...
12 Oct 75 CD AlfaroCD Alfaro 0 - 0 UE Sant AndreuSant Andreu ...
16 Nov 75 UE Sant AndreuSant Andreu 1 - 0 CD AlfaroCD Alfaro ...
12 Oct 75 CE ManresaCE Manresa 2 - 0 PontevedraPontevedra ...
16 Nov 75 PontevedraPontevedra 3 - 0 CE ManresaCE Manresa ...
12 Oct 75 Orihuela Deportiva CFOrihuela 0 - 1 Gimnástica TorrelavegaGimnástica ...
16 Nov 75 Gimnástica TorrelavegaGimnástica 1 - 0 Orihuela Deportiva CFOrihuela ...
12 Oct 75 EibarEibar 0 - 1 Atlético MarbellaAtlético ...
16 Nov 75 Atlético MarbellaAtlético 3 - 1 EibarEibar ...
Jornada 2
03 Dic 75 RB LinenseRB Linense 1 - 0 Gimnàstic TarragonaGimnàstic ...
17 Dic 75 Gimnàstic TarragonaGimnàstic 3 - 1 RB LinenseRB Linense ...
03 Dic 75 Rayo VallecanoRayo 0 - 1 Racing FerrolRacing ...
17 Dic 75 Racing FerrolRacing 3 - 0 Rayo VallecanoRayo ...
03 Dic 75 RCD CarabanchelCarabanchel 3 - 1 AD AlmeríaAlmería ...
17 Dic 75 AD AlmeríaAlmería 1 - 0 RCD CarabanchelCarabanchel ...
03 Dic 75 CD BasconiaBasconia 2 - 2 OsasunaOsasuna ...
17 Dic 75 OsasunaOsasuna 3 - 1 CD BasconiaBasconia ...
03 Dic 75 Atlético MarbellaAtlético 2 - 1 TudelanoTudelano ...
17 Dic 75 TudelanoTudelano 3 - 1 Atlético MarbellaAtlético ...
03 Dic 75 Galáctico PegasoGaláctico 5 - 1 Bilbao Ath.Bilbao Ath. ...
17 Dic 75 Bilbao Ath.Bilbao Ath. 1 - 0 Galáctico PegasoGaláctico ...
03 Dic 75 LangreoLangreo 1 - 0 Real MurciaReal Murcia ...
17 Dic 75 Real MurciaReal Murcia 5 - 0 LangreoLangreo ...
03 Dic 75 MasnouMasnou 2 - 3 SD IbizaSD Ibiza ...
17 Dic 75 SD IbizaSD Ibiza 3 - 0 MasnouMasnou ...
03 Dic 75 BarakaldoBarakaldo 2 - 2 PuertollanoPuertollano ...
17 Dic 75 PuertollanoPuertollano 0 - 2 BarakaldoBarakaldo ...
03 Dic 75 Real JaénReal Jaén 0 - 0 CeltaCelta ...
17 Dic 75 CeltaCelta 1 - 0 Real JaénReal Jaén ...
03 Dic 75 CE SabadellSabadell 1 - 0 CádizCádiz ...
17 Dic 75 CádizCádiz 2 - 0 CE SabadellSabadell ...
03 Dic 75 Xerez CDXerez CD 2 - 1 Valencia MestallaValencia ...
17 Dic 75 Valencia MestallaValencia 3 - 2 Xerez CDXerez CD ...
03 Dic 75 EnsidesaEnsidesa 2 - 1 Getafe DeportivoGetafe ...
17 Dic 75 Getafe DeportivoGetafe 1 - 0 EnsidesaEnsidesa ...
03 Dic 75 SD MelillaSD Melilla 1 - 1 CD MálagaCD Málaga ...
06 Ene 76 CD MálagaCD Málaga 2 - 0 SD MelillaSD Melilla ...
03 Dic 75 MirandésMirandés 2 - 1 CD GetxoCD Getxo ...
17 Dic 75 CD GetxoCD Getxo 2 - 3 MirandésMirandés ...
03 Dic 75 Gimnástica TorrelavegaGimnástica 0 - 0 CD OurenseCD Ourense ...
17 Dic 75 CD OurenseCD Ourense 0 - 0 Gimnástica TorrelavegaGimnástica ...
03 Dic 75 CD LaredoCD Laredo 0 - 0 Real ValladolidReal ...
17 Dic 75 Real ValladolidReal 5 - 1 CD LaredoCD Laredo ...
03 Dic 75 VillarrealVillarreal 1 - 1 Atlético BAtlético ...
17 Dic 75 Atlético BAtlético 2 - 1 VillarrealVillarreal ...
03 Dic 75 PontevedraPontevedra 1 - 3 Sporting AtléticoSporting ...
17 Dic 75 Sporting AtléticoSporting 0 - 0 PontevedraPontevedra ...
03 Dic 75 Algeciras CFAlgeciras 0 - 1 BurgosBurgos ...
17 Dic 75 BurgosBurgos 4 - 0 Algeciras CFAlgeciras ...
03 Dic 75 Talavera CFTalavera 2 - 2 Cultural LeonesaCultural ...
17 Dic 75 Cultural LeonesaCultural 1 - 2 Talavera CFTalavera ...
03 Dic 75 UE Sant AndreuSant Andreu 3 - 1 Linares CFLinares CF ...
17 Dic 75 Linares CFLinares CF 1 - 1 UE Sant AndreuSant Andreu ...
03 Dic 75 Deportivo AlavésDeportivo 1 - 0 TenerifeTenerife ...
17 Dic 75 TenerifeTenerife 6 - 3 Deportivo AlavésDeportivo ...
Jornada 3
14 Ene 76 TudelanoTudelano 1 - 1 CeltaCelta ...
28 Ene 76 CeltaCelta 4 - 1 TudelanoTudelano ...
14 Ene 76 Atlético BAtlético 1 - 0 Racing FerrolRacing ...
28 Ene 76 Racing FerrolRacing 2 - 0 Atlético BAtlético ...
14 Ene 76 Sporting AtléticoSporting 0 - 1 TenerifeTenerife ...
28 Ene 76 TenerifeTenerife 2 - 0 Sporting AtléticoSporting ...
06 Ene 76 Real ValladolidReal 1 - 0 RCD CarabanchelCarabanchel ...
21 Ene 76 RCD CarabanchelCarabanchel 0 - 1 Real ValladolidReal ...
14 Ene 76 Gimnástica TorrelavegaGimnástica 1 - 2 Talavera CFTalavera ...
28 Ene 76 Talavera CFTalavera 1 - 0 Gimnástica TorrelavegaGimnástica ...
14 Ene 76 OsasunaOsasuna 3 - 0 MirandésMirandés ...
28 Ene 76 MirandésMirandés 2 - 1 OsasunaOsasuna ...
14 Ene 76 Gimnàstic TarragonaGimnàstic 0 - 2 Galáctico PegasoGaláctico ...
28 Ene 76 Galáctico PegasoGaláctico 1 - 0 Gimnàstic TarragonaGimnàstic ...
14 Ene 76 BarakaldoBarakaldo 2 - 0 UE Sant AndreuSant Andreu ...
28 Ene 76 UE Sant AndreuSant Andreu 4 - 0 BarakaldoBarakaldo ...
14 Ene 76 Valencia MestallaValencia 3 - 1 SD IbizaSD Ibiza ...
28 Ene 76 SD IbizaSD Ibiza 3 - 0 Valencia MestallaValencia ...
14 Ene 76 CD MálagaCD Málaga 1 - 0 Getafe DeportivoGetafe ...
28 Ene 76 Getafe DeportivoGetafe 0 - 1 CD MálagaCD Málaga ...
14 Ene 76 BurgosBurgos 2 - 1 CádizCádiz ...
28 Ene 76 CádizCádiz 3 - 0 BurgosBurgos ...
14 Ene 76 Real MurciaReal Murcia 2 - 0 RecreativoRecreativo ...
20 Ene 76 RecreativoRecreativo 3 - 0 Real MurciaReal Murcia ...
Jornada 4
12 Feb 76 AtléticoAtlético 1 - 0 RacingRacing ...
26 Feb 76 RacingRacing 1 - 1 AtléticoAtlético ...
12 Feb 76 CádizCádiz 1 - 1 CeltaCelta ...
26 Feb 76 CeltaCelta 2 - 2 CádizCádiz ...
12 Feb 76 EspanyolEspanyol 1 - 0 ElcheElche ...
26 Feb 76 ElcheElche 1 - 1 EspanyolEspanyol ...
12 Feb 76 Racing FerrolRacing 1 - 2 Real MadridReal Madrid ...
17 Feb 76 Real MadridReal Madrid 4 - 1 Racing FerrolRacing ...
12 Feb 76 Real SportingReal 0 - 2 AthleticAthletic ...
26 Feb 76 AthleticAthletic 2 - 5 Real SportingReal ...
12 Feb 76 RecreativoRecreativo 3 - 1 Las PalmasLas Palmas ...
26 Feb 76 Las PalmasLas Palmas 3 - 0 RecreativoRecreativo ...
12 Feb 76 SD IbizaSD Ibiza 2 - 1 Real ZaragozaReal ...
26 Feb 76 Real ZaragozaReal 5 - 0 SD IbizaSD Ibiza 2
12 Feb 76 HérculesHércules 0 - 0 Galáctico PegasoGaláctico ...
26 Feb 76 Galáctico PegasoGaláctico 0 - 2 HérculesHércules ...
12 Feb 76 OsasunaOsasuna 1 - 1 CD MálagaCD Málaga ...
26 Feb 76 CD MálagaCD Málaga 1 - 0 OsasunaOsasuna ...
12 Feb 76 UD SalamancaSalamanca 1 - 0 BarcelonaBarcelona 1
26 Feb 76 BarcelonaBarcelona 3 - 1 UD SalamancaSalamanca ...
12 Feb 76 SevillaSevilla 1 - 1 GranadaGranada ...
26 Feb 76 GranadaGranada 2 - 1 SevillaSevilla ...
12 Feb 76 Talavera CFTalavera 0 - 1 Real OviedoReal Oviedo ...
26 Feb 76 Real OviedoReal Oviedo 2 - 1 Talavera CFTalavera ...
12 Feb 76 ValenciaValencia 3 - 0 UE Sant AndreuSant Andreu ...
26 Feb 76 UE Sant AndreuSant Andreu 0 - 0 ValenciaValencia ...
12 Feb 76 Real ValladolidReal 1 - 2 Real BetisReal Betis ...
26 Feb 76 Real BetisReal Betis 3 - 1 Real ValladolidReal ...
Jornada 5
10 Mar 76 HérculesHércules 3 - 1 Las PalmasLas Palmas ...
07 Abr 76 Las PalmasLas Palmas 7 - 0 HérculesHércules ...
10 Mar 76 CeltaCelta 0 - 0 Real SociedadReal ...
07 Abr 76 Real SociedadReal 2 - 1 CeltaCelta ...
10 Mar 76 Real OviedoReal Oviedo 0 - 0 BarcelonaBarcelona ...
07 Abr 76 BarcelonaBarcelona 4 - 0 Real OviedoReal Oviedo ...
10 Mar 76 Real SportingReal 1 - 2 AtléticoAtlético ...
07 Abr 76 AtléticoAtlético 1 - 1 Real SportingReal ...
10 Mar 76 TenerifeTenerife 2 - 0 Real MadridReal Madrid 1
04 May 76 Real MadridReal Madrid 1 - 0 TenerifeTenerife 1
10 Mar 76 GranadaGranada 3 - 3 Real ZaragozaReal ...
07 Abr 76 Real ZaragozaReal 3 - 1 GranadaGranada ...
10 Mar 76 Real BetisReal Betis 2 - 0 ValenciaValencia ...
07 Abr 76 ValenciaValencia 2 - 1 Real BetisReal Betis ...
10 Mar 76 EspanyolEspanyol 3 - 2 CD MálagaCD Málaga ...
15 Abr 76 CD MálagaCD Málaga 3 - 4 EspanyolEspanyol ...
Jornada 6
29 May 76 Las PalmasLas Palmas 3 - 1 Real SociedadReal ...
05 Jun 76 Real SociedadReal 2 - 0 Las PalmasLas Palmas ...
30 May 76 BarcelonaBarcelona 2 - 3 AtléticoAtlético ...
05 Jun 76 AtléticoAtlético 1 - 1 BarcelonaBarcelona ...
02 Jun 76 TenerifeTenerife 1 - 0 Real ZaragozaReal ...
09 Jun 76 Real ZaragozaReal 2 - 0 TenerifeTenerife ...
30 May 76 Real BetisReal Betis 3 - 1 EspanyolEspanyol ...
05 Jun 76 EspanyolEspanyol 2 - 1 Real BetisReal Betis ...
Jornada 7
12 Jun 76 Real SociedadReal 0 - 1 AtléticoAtlético ...
19 Jun 76 AtléticoAtlético 1 - 1 Real SociedadReal ...
13 Jun 76 Real ZaragozaReal 2 - 1 Real BetisReal Betis ...
19 Jun 76 Real BetisReal Betis 1 - 1 Real ZaragozaReal ...
Jornada 8
26 Jun 76 AtléticoAtlético 1 - 0 Real ZaragozaReal ...

  USO DE MEMORIA  
5,896,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1234
Total Execution Time  0.1254
  CADENA URL  
/copa_del_rey1976/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey1976/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_del_rey1976'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_del_rey' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0026  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 = 21964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047  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 calendars1976 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 21964 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-04-30 15:38:38' 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-04-30 15:38:38' 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-04-30 15:38:38' 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-04-30 15:38:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1976
0.0033  SELECT e.action, count(e.action) as total, e.player_id FROM events1976 e WHERE e.league_id IN (21964) 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.0023  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 (21964) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (255856,255929,256227,262839,255574,255667,255669,256145,256154,256494) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1976
0.0036  SELECT e.action, count(e.action) as total, e.player_id FROM events1976 e WHERE e.league_id IN (21964) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (21964) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (255760,255510,255754,255995,256073,256565,255098,255263,255353,255358) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1976
0.0031  SELECT e.action, count(e.action) as total, e.player_id FROM events1976 e WHERE e.league_id IN (21964) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (21964) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (255182,255906,256138,256171,262915,3469577) ORDER BY rp.in_squad = 1 DESC