4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
22 Ago 17 Igdir ArassporIgdir 1 - 1 KarssporKarsspor ...
22 Ago 17 Artvin HopasporArtvin 3 - 1 ArdahansporArdahanspor ...
22 Ago 17 Mardin 47 SporMardin Spor 0 - 2 Bilecik İl Özel IdaresiBilecik ...
22 Ago 17 Yüksekova CilosporYüksekova 3 - 0 Tatvan GençlerbirliğiTatvan ...
22 Ago 17 Muş SporMuş Spor 3 - 1 Dersim SporDersim Spor ...
22 Ago 17 Ağrı SporAğrı Spor 2 - 0 62 PerteksporPertekspor ...
22 Ago 17 ArsinsporArsinspor 2 - 2 52 OrdusporOrduspor 1
22 Ago 17 ModafensporModafenspor 0 - 1 EdirnesporEdirnespor ...
22 Ago 17 Ergene Velimese SporErgene 3 - 2 EroksporErokspor ...
22 Ago 17 Altınova BelediyesporAltınova 4 - 1 Bozüyük VitrasporBozüyük ...
22 Ago 17 Tavsanlı LinyitsporTavsanlı 2 - 1 KütahyasporKütahyaspo ...
22 Ago 17 TurgutlusporTurgutluspo 3 - 2 UsaksporUsakspor 7
22 Ago 17 IspartasporIspartaspor 1 - 1 Bucak Belediye OguzhansporBucak 2
22 Ago 17 BartinsporBartinspor 2 - 1 Turk Metal KirikkaleTurk Metal ...
22 Ago 17 MKE KırıkkalesporKırıkkale 0 - 3 YozgatsporYozgatspor ...
22 Ago 17 Kalecik FKKalecik FK 3 - 2 CankirisporCankirispor ...
22 Ago 17 Karaman FKKaraman FK 0 - 0 Nevşehir BelediyesporNevşehir ...
22 Ago 17 SinopSporSinopSpor 4 - 2 Yeni AmasyasporYeni 3
22 Ago 17 Karaköprü Bld.Karaköprü 1 - 0 Kilis BelediyesporKilis ...
22 Ago 17 Osmaniyespor KulübüOsmaniyespo 2 - 0 AdiyamansporAdiyamanspo ...
30 Ago 17 Siirt OzelSiirt Ozel 1 - 2 Batman PetrolsporBatman ...
22 Ago 17 Yeşil KırşehirYeşil 0 - 1 AksaraysporAksarayspor ...
22 Ago 17 Mardin 47 SporMardin Spor 0 - 2 Siirt OzelSiirt Ozel ...
Jornada 2
29 Ago 17 KarssporKarsspor 1 - 0 Muş SporMuş Spor 1
29 Ago 17 23 Elazig23 Elazig 2 - 5 DiyarbekirsporDiyarbekirs ...
29 Ago 17 EdirnesporEdirnespor 3 - 0 Canakkale DardanelsporCanakkale 10
30 Ago 17 SinopSporSinopSpor 1 - 1 ErbaasporErbaaspor 1
30 Ago 17 1461 Trabzon1461 0 - 0 ArsinsporArsinspor 11
30 Ago 17 OfsporOfspor 2 - 1 YomrasporYomraspor ...
30 Ago 17 BayburtBayburt 1 - 2 PazarsporPazarspor ...
30 Ago 17 12 BingölsporBingölspor 1 - 1 ErzincansporErzincanspo 1
30 Ago 17 Bilecik İl Özel IdaresiBilecik 1 - 2 Batman PetrolsporBatman ...
30 Ago 17 Cizrespor 2010Cizrespor 1 - 0 Yüksekova CilosporYüksekova ...
30 Ago 17 Kalecik FKKalecik FK 1 - 0 BartinsporBartinspor 1
30 Ago 17 Ankara DemirsporAnkara 2 - 2 Çankaya FKÇankaya ...
30 Ago 17 YozgatsporYozgatspor 0 - 2 Corum FKCorum FK ...
30 Ago 17 KayseriKayseri 0 - 4 Nevşehir BelediyesporNevşehir 2
30 Ago 17 PayasPayas 1 - 0 KirikhansporKirikhanspo ...
30 Ago 17 Osmaniyespor KulübüOsmaniyespo 2 - 3 İskenderunsporİskenderun ...
30 Ago 17 DüzcesporDüzcespor 1 - 0 KocaelisporKocaelispor ...
30 Ago 17 BayrampasasporBayrampasas 1 - 0 Halide Edip Adivar Halide Edip ...
30 Ago 17 Anadolu BağcılarAnadolu 2 - 1 Çatalca SporÇatalca ...
30 Ago 17 Sultanbeyli BelediyesporSultanbeyli 2 - 1 Tepecik BelediyesporTepecik ...
30 Ago 17 Darica GenclerbirligiDarica 2 - 1 GolcuksporGolcukspor ...
30 Ago 17 TekirdağsporTekirdağsp 0 - 2 Ergene Velimese SporErgene ...
30 Ago 17 OrhangazisporOrhangazisp 1 - 0 Altınova BelediyesporAltınova 1
30 Ago 17 Buca FKBuca FK 2 - 0 TurgutlusporTurgutluspo 1
30 Ago 17 Manisa FKManisa FK 0 - 2 Bergama BelediyesporBergama ...
30 Ago 17 Bucak Belediye OguzhansporBucak 1 - 2 KemersporKemerspor ...
30 Ago 17 Tavsanlı LinyitsporTavsanlı 0 - 2 KizilcaboluksporKizilcabolu ...
30 Ago 17 MuğlasporMuğlaspor 1 - 0 AydinsporAydinspor ...
30 Ago 17 Tarsus Idman YurduTarsus 2 - 1 Karaköprü Bld.Karaköprü ...
30 Ago 17 Karacabey BirliksporKaracabey 0 - 1 Yeşil BursaYeşil ...
31 Ago 17 1461 Trabzon FK1461 4 - 3 Artvin HopasporArtvin ...
29 Ago 17 Ağrı SporAğrı Spor 0 - 1 Belediye VansporBelediye ...
30 Ago 17 AksaraysporAksarayspor 0 - 1 KozansporKozanspor ...
Jornada 3
20 Sep 17 İskenderunsporİskenderun 1 - 2 Fatih KaragümrükFatih ...
20 Sep 17 KozansporKozanspor 1 - 3 AdanasporAdanaspor ...
20 Sep 17 GaziantepsporGaziantepsp 0 - 3 Buca FKBuca FK ...
19 Sep 17 MuğlasporMuğlaspor 1 - 1 EtimesgutEtimesgut ...
20 Sep 17 DenizlisporDenizlispor 1 - 0 DüzcesporDüzcespor ...
21 Sep 17 KizilcaboluksporKizilcabolu 2 - 1 UmraniyesporUmraniyespo ...
20 Sep 17 Hacettepe SKHacettepe 1 - 2 Kalecik FKKalecik FK ...
20 Sep 17 BucasporBucaspor 2 - 0 PendiksporPendikspor ...
20 Sep 17 Adana DemirsporAdana 3 - 0 BayrampasasporBayrampasas ...
19 Sep 17 DiyarbekirsporDiyarbekirs 0 - 1 Istanbulspor ASIstanbulspo ...
19 Sep 17 SanliurfasporSanliurfasp 1 - 1 PazarsporPazarspor ...
19 Sep 17 BalikesirsporBalikesirsp 1 - 1 KarssporKarsspor 1
20 Sep 17 FethiyesporFethiyespor 2 - 0 Nazilli BelediyesporNazilli ...
20 Sep 17 KeciorengucuKeciorenguc 3 - 1 Silivrispor KulübüSilivrispor ...
19 Sep 17 KirklarelisporKirklarelis 1 - 3 Nigde AnadoluNigde ...
20 Sep 17 KastamonusporKastamonusp 1 - 3 OfsporOfspor ...
20 Sep 17 InegolsporInegolspor 0 - 2 Yeni MalatyasporYeni 2
20 Sep 17 KocaelisporKocaelispor 2 - 2 EdirnesporEdirnespor ...
21 Sep 17 Afjet AfyonsporAfjet 2 - 0 AnkaragücüAnkaragüc ...
20 Sep 17 ManisasporManisaspor 4 - 1 ArsinsporArsinspor ...
19 Sep 17 BodrumsporBodrumspor 2 - 3 GaziantepGaziantep ...
21 Sep 17 RizesporRizespor 3 - 0 Nevşehir BelediyesporNevşehir ...
19 Sep 17 Anadolu BağcılarAnadolu 0 - 1 1922 Konyaspor1922 ...
20 Sep 17 GiresunsporGiresunspor 3 - 1 Cizrespor 2010Cizrespor ...
19 Sep 17 PayasPayas 1 - 3 AmedsporAmedspor ...
20 Sep 17 HataysporHatayspor 1 - 0 Ergene Velimese SporErgene ...
19 Sep 17 KemersporKemerspor 0 - 1 Sivas BelediyesporSivas ...
20 Sep 17 SamsunsporSamsunspor 3 - 3 Ankara DemirsporAnkara ...
20 Sep 17 Bergama BelediyesporBergama 0 - 2 SariyerSariyer ...
20 Sep 17 AltinorduAltinordu 1 - 0 Sultanbeyli BelediyesporSultanbeyli ...
20 Sep 17 1461 Trabzon FK1461 4 - 4 GumushanesporGumushanesp ...
19 Sep 17 TokatsporTokatspor 0 - 1 KahramanmarassporKahramanmar ...
21 Sep 17 EyupsporEyupspor 2 - 1 SakaryasporSakaryaspor ...
20 Sep 17 Sancaktepe Belediye IstanbuSancaktepe 2 - 4 ElazigsporElazigspor ...
19 Sep 17 BandirmasporBandirmaspo 0 - 1 Corum FKCorum FK ...
19 Sep 17 MenemensporMenemenspor 4 - 2 Darica GenclerbirligiDarica ...
20 Sep 17 TuzlasporTuzlaspor 1 - 0 Zonguldak KömürsporZonguldak ...
20 Sep 17 BursasporBursaspor 4 - 0 Tarsus Idman YurduTarsus 2
20 Sep 17 Batman PetrolsporBatman 3 - 1 GöztepeGöztepe ...
20 Sep 17 Yeşil BursaYeşil 3 - 1 KarsiyakaKarsiyaka ...
19 Sep 17 BolusporBoluspor 3 - 0 SinopSporSinopSpor ...
19 Sep 17 Mersin Mersin 3 - 5 OrhangazisporOrhangazisp ...
21 Sep 17 ErzincansporErzincanspo 4 - 2 EskişehirsporEskişehirs 2
20 Sep 17 AltayAltay 0 - 0 ErzurumsporErzurumspor ...
21 Sep 17 SivassporSivasspor 3 - 0 Mamak FkMamak Fk 2
19 Sep 17 Belediye VansporBelediye 0 - 1 KayserisporKayserispor 2
Jornada 4
26 Oct 17 ManisasporManisaspor 1 - 0 HataysporHatayspor 12
24 Oct 17 FethiyesporFethiyespor 1 - 2 AdanasporAdanaspor ...
26 Oct 17 KarabüksporKarabükspo 3 - 1 KeciorengucuKeciorenguc 7
25 Oct 17 BucasporBucaspor 2 - 1 AmedsporAmedspor ...
24 Oct 17 KasımpaşaKasımpaşa 5 - 1 Nigde AnadoluNigde 7
24 Oct 17 SariyerSariyer 2 - 2 Adana DemirsporAdana 3
25 Oct 17 EyupsporEyupspor 4 - 2 GumushanesporGumushanesp ...
24 Oct 17 Akhisar BelediyesporAkhisar 6 - 0 ErzincansporErzincanspo ...
25 Oct 17 Batman PetrolsporBatman 2 - 1 DenizlisporDenizlispor 1
25 Oct 17 GaziantepGaziantep 1 - 2 Ankara DemirsporAnkara ...
26 Oct 17 Kalecik FKKalecik FK 0 - 0 BursasporBursaspor 11
26 Oct 17 GiresunsporGiresunspor 2 - 1 MenemensporMenemenspor 1
24 Oct 17 KahramanmarassporKahramanmar 1 - 0 RizesporRizespor 2
25 Oct 17 Gençlerbirliği SKGençlerbir 3 - 0 TuzlasporTuzlaspor 1
26 Oct 17 1922 Konyaspor1922 0 - 1 BolusporBoluspor ...
24 Oct 17 AlanyasporAlanyaspor 2 - 0 EdirnesporEdirnespor 23
24 Oct 17 EtimesgutEtimesgut 0 - 1 AntalyasporAntalyaspor 11
25 Oct 17 SivassporSivasspor 3 - 1 KizilcaboluksporKizilcabolu 1
25 Oct 17 Corum FKCorum FK 0 - 6 TrabzonsporTrabzonspor 2
24 Oct 17 AltinorduAltinordu 0 - 1 KarssporKarsspor 2
25 Oct 17 OfsporOfspor 1 - 3 Yeni MalatyasporYeni ...
25 Oct 17 ErzurumsporErzurumspor 2 - 0 Buca FKBuca FK ...
26 Oct 17 Yeşil BursaYeşil 1 - 2 KayserisporKayserispor 7
25 Oct 17 Istanbulspor ASIstanbulspo 4 - 3 Afjet AfyonsporAfjet ...
25 Oct 17 OrhangazisporOrhangazisp 0 - 0 SanliurfasporSanliurfasp ...
25 Oct 17 ElazigsporElazigspor 0 - 1 Sivas BelediyesporSivas 1
25 Oct 17 AnkarasporAnkaraspor 5 - 0 Fatih KaragümrükFatih ...
Jornada 5
28 Nov 17 AnkarasporAnkaraspor 3 - 1 Yeni MalatyasporYeni 11
13 Dic 17 Yeni MalatyasporYeni 1 - 1 AnkarasporAnkaraspor 7
30 Nov 17 GiresunsporGiresunspor 4 - 2 AlanyasporAlanyaspor 11
13 Dic 17 AlanyasporAlanyaspor 2 - 2 GiresunsporGiresunspor 6
29 Nov 17 FenerbahçeFenerbahçe 6 - 0 Adana DemirsporAdana 4
13 Dic 17 Adana DemirsporAdana 1 - 4 FenerbahçeFenerbahçe 3
28 Nov 17 Ankara DemirsporAnkara 0 - 3 Akhisar BelediyesporAkhisar 1
13 Dic 17 Akhisar BelediyesporAkhisar 1 - 1 Ankara DemirsporAnkara 6
28 Nov 17 Galatasaray SKGalatasaray 5 - 1 Sivas BelediyesporSivas 17
12 Dic 17 Sivas BelediyesporSivas 2 - 1 Galatasaray SKGalatasaray 106
30 Nov 17 KahramanmarassporKahramanmar 1 - 3 İstanbul Başakşehirİstanbul 5
14 Dic 17 İstanbul Başakşehirİstanbul 1 - 0 KahramanmarassporKahramanmar 29
29 Nov 17 SivassporSivasspor 2 - 1 BucasporBucaspor 9
13 Dic 17 BucasporBucaspor 1 - 0 SivassporSivasspor 4
28 Nov 17 KarssporKarsspor 1 - 2 Gençlerbirliği SKGençlerbir 10
13 Dic 17 Gençlerbirliği SKGençlerbir 2 - 1 KarssporKarsspor 3
28 Nov 17 BeşiktaşBeşiktaş 9 - 0 ManisasporManisaspor 26
12 Dic 17 ManisasporManisaspor 1 - 1 BeşiktaşBeşiktaş 21
30 Nov 17 ErzurumsporErzurumspor 0 - 4 TrabzonsporTrabzonspor 24
12 Dic 17 TrabzonsporTrabzonspor 5 - 1 ErzurumsporErzurumspor 36
30 Nov 17 KayserisporKayserispor 3 - 2 EyupsporEyupspor 50
14 Dic 17 EyupsporEyupspor 0 - 2 KayserisporKayserispor 13
30 Nov 17 OrhangazisporOrhangazisp 0 - 3 AntalyasporAntalyaspor 21
12 Dic 17 AntalyasporAntalyaspor 2 - 3 OrhangazisporOrhangazisp 18
29 Nov 17 KarabüksporKarabükspo 2 - 1 Istanbulspor ASIstanbulspo ...
14 Dic 17 Istanbulspor ASIstanbulspo 1 - 0 KarabüksporKarabükspo 18
29 Nov 17 Batman PetrolsporBatman 0 - 3 KonyasporKonyaspor 16
14 Dic 17 KonyasporKonyaspor 2 - 0 Batman PetrolsporBatman 14
29 Nov 17 KasımpaşaKasımpaşa 1 - 3 BolusporBoluspor 16
12 Dic 17 BolusporBoluspor 4 - 1 KasımpaşaKasımpaşa 34
29 Nov 17 AdanasporAdanaspor 0 - 2 BursasporBursaspor ...
12 Dic 17 BursasporBursaspor 2 - 0 AdanasporAdanaspor 31
Jornada 6
28 Dic 17 BeşiktaşBeşiktaş 4 - 1 AnkarasporAnkaraspor 83
17 Ene 18 AnkarasporAnkaraspor 2 - 1 BeşiktaşBeşiktaş 43
28 Dic 17 BolusporBoluspor 2 - 1 Akhisar BelediyesporAkhisar 57
17 Ene 18 Akhisar BelediyesporAkhisar 1 - 0 BolusporBoluspor 10
26 Dic 17 Galatasaray SKGalatasaray 3 - 0 BucasporBucaspor 29
18 Ene 18 BucasporBucaspor 0 - 3 Galatasaray SKGalatasaray 52
27 Dic 17 KayserisporKayserispor 3 - 1 AntalyasporAntalyaspor 34
18 Ene 18 AntalyasporAntalyaspor 0 - 2 KayserisporKayserispor 53
27 Dic 17 FenerbahçeFenerbahçe 2 - 0 Istanbulspor ASIstanbulspo 250
16 Ene 18 Istanbulspor ASIstanbulspo 0 - 1 FenerbahçeFenerbahçe 67
27 Dic 17 GiresunsporGiresunspor 3 - 1 İstanbul Başakşehirİstanbul 89
17 Ene 18 İstanbul Başakşehirİstanbul 2 - 1 GiresunsporGiresunspor 38
26 Dic 17 Gençlerbirliği SKGençlerbir 1 - 0 BursasporBursaspor 11
16 Ene 18 BursasporBursaspor 2 - 1 Gençlerbirliği SKGençlerbir 12
27 Dic 17 KonyasporKonyaspor 1 - 0 TrabzonsporTrabzonspor 54
16 Ene 18 TrabzonsporTrabzonspor 1 - 1 KonyasporKonyaspor 109
Jornada 7
31 Ene 18 Akhisar BelediyesporAkhisar 1 - 0 KayserisporKayserispor 27
07 Feb 18 KayserisporKayserispor 2 - 2 Akhisar BelediyesporAkhisar 26
01 Feb 18 KonyasporKonyaspor 2 - 2 Galatasaray SKGalatasaray 231
08 Feb 18 Galatasaray SKGalatasaray 4 - 1 KonyasporKonyaspor 115
30 Ene 18 BeşiktaşBeşiktaş 3 - 1 Gençlerbirliği SKGençlerbir 86
06 Feb 18 Gençlerbirliği SKGençlerbir 0 - 1 BeşiktaşBeşiktaş 67
31 Ene 18 GiresunsporGiresunspor 1 - 2 FenerbahçeFenerbahçe 64
07 Feb 18 FenerbahçeFenerbahçe 2 - 1 GiresunsporGiresunspor 26
Jornada 8
01 Mar 18 BeşiktaşBeşiktaş 2 - 2 FenerbahçeFenerbahçe 323
03 May 18 FenerbahçeFenerbahçe 3 - 0 BeşiktaşBeşiktaş 170
27 Feb 18 Akhisar BelediyesporAkhisar 1 - 2 Galatasaray SKGalatasaray 244
18 Abr 18 Galatasaray SKGalatasaray 0 - 2 Akhisar BelediyesporAkhisar 118
Jornada 9
10 May 18 Akhisar BelediyesporAkhisar 3 - 2 FenerbahçeFenerbahçe 221

  USO DE MEMORIA  
5,641,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4514
Total Execution Time  0.4537
  CADENA URL  
/copa_turquia2018/grupo0/calendario
  GET DATOS  
$_GET['/copa_turquia2018/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_turquia2018'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=528 ORDER BY order_id ASC
0.0172  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 = 39567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0187  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 calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 39567 ORDER BY round ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 528 AND l.year = 2018
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (39567) 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.0149  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 (39567) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (19214,13324,113334,100700,287416,14505,123620,139925,180950,250436) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 528 AND l.year = 2018
0.0156  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (39567) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0174  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 (39567) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (100700,431321,41899,73160,81808,83381,233527,237681,250848,310317) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 528 AND l.year = 2018
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (39567) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  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 (39567) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (431303,6819,7012,19214,22227,27010,31608,44071,45617,66556) ORDER BY rp.in_squad = 1 DESC