4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Kazajistán 1997
1996/1997

Liga Kazajistán 1997

Información Histórica
						
                            GP   W  D  L GF-GA  PT
 1.Taraz                    26  18  2  6 49-18  56  Golden Match
   Irtysh Pavlodar          26  17  5  4 46-15  56  Golden Match
 3.Kayrat Almaty            26  16  5  5 52-14  53
---------------------------------------------------
 4.Shakhtyor Karaganda      26  16  4  6 40-22  52
 5.Vostok Ust'-Kamenogorsk  26  14  8  4 42-16  50
 6.Batyr Ekibastuz          26  15  2  9 38-22  47
 7.Yelimay Semipalatinsk    26  13  7  6 41-26  46
 8.Kaysar Kzyl-Orda         26  13  5  8 39-23  44
 9.Astana Akmola            26  11  4 11 32-21  37
10.Zhiger Chimkent          26   8  5 13 27-40  29
11.Avtomobilist Shortandy   26   5  0 21 23-68  15
12.Aktobemunay Aktyubinsk   26   4  3 19 16-56  15  Relegated
13.Bulat Temirtau           26   3  5 18 13-47  14
14.Ulytau Jezkazgan         26   1  1 24  4-74   4  Relegated
 
Note before season: Apparently, Munayshi Aktau, Kaynar Taldy-Kurgan, 
                    Tobol Kustanay, SKIF Ordabasy Chimkent and Kokshetau
                    were relegated or withdrew, while only Avtomobilist 
                    Shortandy earned promotion.
                    It seems Yenbek Jezkazgan changed name to Ulytau.

Note during season: Ulytau Jezkazgan and Aktobemunay Aktyubinsk withdrew
                    after Round 14 and Round 22 respectively, and therefore
                    are both relegated.
                    Tselinnik Akmola changed name to Astana Akmola during 
                    the season.

Promoted: Ferro (Aktyubinsk) and Uralets (Ural'sk).


GOLDEN MATCH (in Almaty)
------------------------
IRTYSH Pavlodar - FK Taraz  1:0  (Antonov'54)


Round 1
-------
Kayrat Almaty       - Avtomobilist Shortandy  3:0
Shakhtyor Karaganda - Tselinnik Akmola        1:0
Bulat Temirtau      - Yelimay Semipalatinsk   0:3
Zhiger Chimkent     - Irtysh Pavlodar         0:0
Taraz               - Batyr Ekibastuz         1:0
Ulytau Jezkazgan    - Vostok Ust'-Kamenogorsk 0:0
Aktobey Aktyubinsk  - Kaysar Kzyl-Orda        ppd

Round 2
-------
Bulat     - Vostok       0:0
Kaysar    - Aktobemunay  1:0
Shakhtyor - Avtomobilist 3:0
Zhiger    - Batyr        0:0
Ulytau    - Yelimay      0:1
Taraz     - Irtysh       1:1
Kayrat    - Tselinnik    3:0

Round 3
-------
Vostok       - Kayrat      2-0  Sveshnikov(15), Duzmambetov(48)
Yelimay      - Shakhtyor   0-0
Taraz        - Zhiger      ppd
Tselinnik    - Kaysar      3-0  Kushebin-2(85,86), Vishnichenko(2)
Irtysh       - Ulytau      5-1  Noskov-2(77,80), Zubarev(10), Famil'tsev(20),
                                Malyshev(39) - Agliullin(78)
Batyr        - Bulat       3-0  Glazunov-2(49,71), Gumar(84)
Avtomobilist - Aktobemunay 1-0  Basmanov(29)
 
Round 4
-------
Yelimay      - Kayrat      1-1  Zolotukhin(17) - Nisanbayev(3)
Vostok       - Shakhtyor   1-1  Kozhevnikov(23) - Zhumakhanov(60)
Irtysh       - Bulat       5-1  Zubarev-2(44,84), Antonov(54), Noskov(85),
                                Bush(77) - Danilishin(43,own goal)
Taraz        - Zhiger      1-0  Kononov(72)
Batyr        - Ulytau      1-0  Glazunov(20)
Avtomobilist - Kaysar      0-1  Loginov(30)
Tselinnik    - Aktobemunay 2-0  Kenetayev(27), Lisin(75)

Round 5
-------
Kayrat      - Irtysh  0:0
Kaysar      - Yelimay 2:0 (Turmagambetov, Loginov)
Shakhtyor   - Batyr   1:0 (Zhumakhanov)
Ulytau      - Taraz   1:3 (Malikov - Kashkarov, Myrzabayev, Mazbayev)
Aktobemunay - Vostok  1:1 (Yevteyev[own] - Duzmambetov)
Bulat       - Zhiger  0:0
 
Round 6
-------
Shakhtyor   - Irtysh  2:1 (Abil'dayev[own], Zhumakhanov - Zubarev)
Bulat       - Taraz   0:1 (Bulokbayev)
Kaysar      - Vostok  0:0
Kayrat      - Batyr   0:1 (Gumar)
Aktobemunay - Yelimay 0:0
Ulytau      - Zhiger  2:1 (Igamberdiyev[own], Korolyov - Israilov)
 
Round 7
-------
Zhiger - Shakhtyor   1:1 (Israilov - Imankulov)
Batyr  - Kaysar      1:0 (Glazunov)
Irtysh - Aktobemunay 1:0 (Zubarev)
Yelimay-Tselinnik, Vostok-Avtomobilist, Taraz-Kayrat postponed.
 
Round 8
-------
Taraz  - Shakhtyor   3:0 (Mazbayev-2, Kashkarov)
Batyr  - Aktobemunay 2:0 (Zvonarenko, Kurgansky[pen])
Irtysh - Kaysar      1:0 (Antonov)
Ulytau - Bulat       0:1 (Bondarev)
 
Round 9
-------
Aktobemunay  - FK Taraz 0:2 (Mazbayev'4, Bulekbayev'89)
Kaysar       - Zhiger   3:1 (Abuov'10, Gabdullin'27, Turmagambetov'57 -
Salimov'78)
Tselinnik    - Irtysh   0:1 (Zubarev'15)
Avtomobilist - Batyr    0:2 (Zvonarenko'29, Duzev'40)
Kayrat       - Bulat    4:0 (Aposmbonov'30, Luchkin'50/'62, Klimov'65)
Shakhtyor    - Ulytau   1:0 (Imankulov'9)
 
Round 10
--------
Vostok       - Yelimay  0:0
Aktobemunay  - Zhiger   0:0
Kaysar       - FK Taraz 1:2 (Kogay'59 - Lebedev'30, Mirzabayev'78)
Tselinnik    - Batyr    2:3 (Kushebin'38, Lisin'75 - Zvonarenko'4,
                             Glazunov'8/'72)
Avtomobilist - Irtysh   1:4 (Basmanov'54 - Malyshev'10, Noskov'75, Bush'85,
Antonov'87)
Kayrat       - Ulytau   7:0 (Yalovtsev'11own, Luchkin'20, Apsembetov'21/'54, 
                             Nisanbayev'30, Baltiyev'40, Kadyrkulov'79)
Shakhtyor    - Bulat    2:0 (Urdabayev'7pen/'78)

From Round 7
------------
Yelimay - Tselinnik    2:1 (Litvinenko'46, Miroshnichenko'80pen - Kenetayev'13)
Vostok  - Avtomobilist 8:0 (Duzmambetov'25/'41, Kashtanov'27,
                            Obryadov'47/'48/'63', 
                            Rylov'69, Gorokhovodatsky'75)
 
Round 11
--------
Batyr  - Yelimay      1:0 (Duzev'28)
Irtysh - Vostok       2:0 (Zaubarev'36, Malyshev'52)
Taraz  - Tselinnik    2:0 (Walter'60, Mazbayev(66)
Zhiger - Avtomobilist 2:1 (???)
Bulat  - Kaysar       1:1 (Gelazhen'54 - Loginov'21)
Ulytau - Aktobemunay  0:5 (???)
 
Round 12
--------
Irtysh    - Yelimay      1:1 (Zubarev'84 - Miroshnichenko'23)
Batyr     - Vostok       0:2 (Sveshnikov'12/'78)
Shakhtyor - Kayrat       1:2 (Abil'dayev'11 - Pisanbayev'4, Kadyrkulov'63)
Taraz     - Avtomobilist 5:0 (Vaganov'4/'85, Kaynazarov'20, Mazbayev'58,
Mirzabayev'68)
Zhiger    - Tselinnik    2:0 (Ibragimov'31, Maksimenko'65)
Ulytau    - Kaysar       0:4 (Loginov'3/'10/'43, Baybosynov'20)
Bulat     - Aktobemunay  0:2 (Meshcheryakov'63, Nesmeyanov'75)

Rounds 13 and 14 missing.

Round 15
--------
Ulytau    - Astana      0:3 (awarded)
Taraz     - Yelimay     3:1 (Myrzabayev'49, Mazbayev'51, Koshkarov'80 -
                             Mityayev'87)
Kayrat    - Aktobemunay 7:0 (Zheylitbayev'32, Baltiyev'35, Kadyrkulov'56,
                             Klimov'57, Rakhimbayev'75, Urazbakhtin'75/'77)
Shakhtyor - Kaysar      3:2 (Slambekov'2, Abil'dayev'32/'34 - Akhmedov'82,
                             Loginov'84)
Zhiger    - Vostok      2:3 (Maximenko'4, Ibragimov'7 - Yevteyev'2/'86,
                             Duzmambetov'19)
Irtysh v Bakyr postponed

Round 16
--------
Zhiger    - Yelimay      2:1 (Ibragimov'31, Derbisbayev'64 - Litvinenko'40)
Kayrat    - Kaysar       1:1 (Baltiyev'16 - Abuov'43)
Bulat     - Astana       1:1 (S.Pak'58 - Kotov'47)
Ulytau    - Avtomobilist 0:3 (awarded)
Taraz     - Vostok       1:0 (Niyazymbetov'77)
Shakhtyor - Aktobemunay  3:0 (Abil'dayev'27, Imankulov'74, Urdabayev'76)
[moreover, Irtysh has won a match vs Batyr]

Round 17
--------
Kayrat       - Shakhtyor 2:0 (Zheylitbayev'43pen, Yensebayev'53)
Astana       - Zhiger    3:1 (Chigogidze'9, Kotov'38pen/'66 - Maximenko'60)
Kaysar       - Ulytau    3:0 (awarded)
Aktobemunay  - Bulat     2:1 (Urazbayev'8, Meshcheryakov'75 - Sannikov'32)
Avtomobilist - Taraz     0:1 (Mazbayev'2)
Yelimay      - Irtysh    3:1 (Chukhlyoba'5, Aubakirov'28, Litvinenko'30 -
                              Malyshev'70)
Vostok       - Batyr     2:1 (Khamidullov'3/'60 - Afel'chenko'66)

Round 18
--------
Yelimay      - Batyr  2:2 (Chukhlyoba'38, Litvinenko'49 - Zvonarenko'25,
                           Popyrko'64)
Vostok       - Irtysh 1:0 (Khamidullov'43)
Aktobemunay  - Ulytau 3:0 (awarded)
Kaysar       - Bulat  3:0 (Kister'14, Malikov'58, Loginov'84)
Astana       - Taraz  1:0 (Vishnechenko'80)
Avtomobilist - Zhiger 3:4 (Feoktistov'13, Ivanov'39, Jaugashev'65 -
                           Ibragimov'42/'81, 
                           Derbisbayev'47, Tyotushkin'78)

Round 19
--------
Taraz   - Kaysar       2:1 (Niyazymbetov'2, Mazbayev'42 - Abuov'76)
Zhiger  - Aktobemunay  2:1 (Tyotushkin'59, Derbisbayev'66 - Kyzylbayev'44)
Yelimay - Vostok       1:0 (Mukanov'61)
Ulytau  - Kayrat       0:3 (awarded)
Irtysh  - Avtomobilist 3:0 (Antonov'4, Didyk'28, Kostandyan'60)
Bulat   - Shakhtyor    1:4 (Izotov'25 - Abil'dayev'23/'48, Urdabayev'32,
                            Butkov'89)
Batyr   - Astana       1:0 (Makayev'75)

Round 20 missing.

Round 21
--------
Shakhtyor    - Taraz   2:0 (Imankulov'29, Uradabayev'64)
Aktobemunay  - Batyr   0:1 (Reshetnikov'55)
Bulat        - Ulytau  3:0 (awarded)
Avtomobilist - Yelimay 2:4 (Nurgaliyev'38/'64 - Spitsyn'2, Mityayev'39,
                            Bogomolov'62, Smakov'72)
Astana       - Vostok  2:0 (Kushebin'20, Basmanov'40)
Kayrat       - Zhiger  3:0 (Tarasov'10, Urazbakhtin'74, Luchkin'78)
Kaysar       - Irtysh  1:0 (Baybosynov'46)

Round 22
--------
Shakhtyor    - Zhiger  2:0 (Imankulov'25, Musatayev'61)
Kayrat       - Taraz   1:0 (Yurist'64)
Kaysar       - Batyr   1:0 (Akhmedov'81)
Astana       - Yelimay 2:0 (Kenetayev'17, Kotov'87pen)
Aktobemunay  - Irtysh  0:4 (Didyk'26, Yesmagambetov'32/'48, Zubarev'84)
Avtomobilist - Vostok  0:5 (Duzmambetov'4/'20/'40/'70, Kiselyov'18)

Round 23
--------
Astana  - Avtomobilist 5:1 (Chigogidze'7/'64, Basmanov'41, Kucherbayev'71,
                            Polyakov'76 - Saginayev'55)
Taraz   - Bulat        2:0 (Vaganov, Kaynazarov)
Zhiger  - Ulytau       3:0 (awarded)
Yelimay - Aktobemunay  3:0 (awarded)
Vostok  - Kaysar       1:0 (Lotov)
Irtysh  - Shakhtyor    1:0 (Kucheryavykh)
Batyr   - Kayrat       0:2 (Kadyrkulov'25, Luchkin'48)

Round 24
--------
Taraz   - Ulytau      3:0 (awarded)
Zhiger  - Bulat       1:0 (Maximenko'85)
Batyr   - Shakhtyor   3:0 (Glazunov'22, Afel'chenko'66, Gumar'89)
Yelimay - Kaysar      1:1 (Litvinenko'38 - Baybosynov'5)
Irtysh  - Kayrat      1:0 (Kucheryavykh'77)
Vostok  - Aktobemunay 3:0 (awarded)

Round 25
--------
Zhiger      - Taraz        0:1 (Mazbayev'59)
Kayrat      - Yelimay      1:2 (Zheylitbayev - An.Bogomolov, Aubakirov)
Shakhtyor   - Vostok       1:1 (Musatayev'47 - Yevteyev'38)
Bulat       - Irtysh       0:2 (Yesmagambetov'10/'64)
Ulytau      - Batyr        0:3 (awarded)
Kaysar      - Avtomobilist 3:2 (Akhmedov'2pen, Baybosynov'26/'57 -
                                Mukhametkarimov'36, Protsyuk'66)
Aktobemunay - Astana       0:3 (awarded)

Round 26
--------
Aktobemunay - Avtomobilist 0:3 (awarded)
Kaysar      - Astana       0:0
Shakhtyor   - Yelimay      3:0 (Musatayev'31/'70, Imankulov'55)
Ulytau      - Irtysh       0:3 (awarded)
Bulat       - Batyr        2:3 (Lunyov'80, S.Pak'85pen - Zvonarenko'17,
                                Makayev'68, Fadeyev'82)
Kayrat      - Vostok       1:1 (Kozhabergenov'58pen - Kozhevnikov'10)

Round 27
--------
Avtomobilist - Kayrat    2:4 (Nurgaliyev'31, Morozov'60 - Apsembetov'70,
                              Tarasov'83/'85, Yeshmukhambetov'87own)
Batyr        - Taraz     1:3 (Zvonarenko'20 - Niyazymbetov'9/'65, Mazbayev'40)
Irtysh       - Zhiger    4:1 (Bush'1, Yesmagambetov'39/'47, Antonov'65pen -
                              Maximenko'79)
Astana       - Shakhtyor 0:1 (Gelazhen'60)
Yelimay      - Bulat     4:0 (Pinchukov'9pen, Aubakirov'49/'58/'60)
Vostok       - Ulytau    3:0 (awarded)

Round 28
--------
Irtysh       - Taraz     1:0 (Yesmagambetov'18)
Batyr        - Zhiger    2:0 (Kurgansky'38, Zvonarenko'88)
Avtomobilist - Shakhtyor 0:3 (Urdabayev, Imankulov, Butkov)
Astana       - Kayrat    0:1 (Vorogovsky'13)
Vostok       - Bulat     2:1 (Khamidullov'61pen, Obryadov'74 - Igumnov'39)
Yelimay      - Ulytau    3:0 (awarded)
Aktobemunay  - Kaysar    0:3 (awarded)


                            GP   W  D  L GF-GA  PT
 1.Taraz                    26  18  2  6 49-18  56  Golden Match
   Irtysh Pavlodar          26  17  5  4 46-15  56  Golden Match
 3.Kayrat Almaty            26  16  5  5 52-14  53
---------------------------------------------------
 4.Shakhtyor Karaganda      26  16  4  6 40-22  52
 5.Vostok Ust'-Kamenogorsk  26  14  8  4 42-16  50
 6.Batyr Ekibastuz          26  15  2  9 38-22  47
 7.Yelimay Semipalatinsk    26  13  7  6 41-26  46
 8.Kaysar Kzyl-Orda         26  13  5  8 39-23  44
 9.Astana Akmola            26  11  4 11 32-21  37
10.Zhiger Chimkent          26   8  5 13 27-40  29
11.Avtomobilist Shortandy   26   5  0 21 23-68  15
12.Aktobemunay Aktyubinsk   26   4  3 19 16-56  15  Relegated
13.Bulat Temirtau           26   3  5 18 13-47  14
14.Ulytau Jezkazgan         26   1  1 24  4-74   4  Relegated
 
Note before season: Apparently, Munayshi Aktau, Kaynar Taldy-Kurgan, 
                    Tobol Kustanay, SKIF Ordabasy Chimkent and Kokshetau
                    were relegated or withdrew, while only Avtomobilist 
                    Shortandy earned promotion.
                    It seems Yenbek Jezkazgan changed name to Ulytau.

Note during season: Ulytau Jezkazgan and Aktobemunay Aktyubinsk withdrew
                    after Round 14 and Round 22 respectively, and therefore
                    are both relegated.
                    Tselinnik Akmola changed name to Astana Akmola during 
                    the season.

Promoted: Ferro (Aktyubinsk) and Uralets (Ural'sk).


GOLDEN MATCH (in Almaty)
------------------------
IRTYSH Pavlodar - FK Taraz  1:0  (Antonov'54)

 
Top Scorers:
------------
16 - Nurken Mazbayev (Taraz)
12 - Vladimir Loginov (Kaysar)
10 - Viktor Zubarev (Irtysh)
     Ruslan Duzmambetov (Vostok)
 9 - Bulat Yesmagambetov (Yelimay/Irtysh)
 8 - Oleg Litvinenko (Yelimay)
     Fayzulla Urdabayev (Shakhtyor)
     Ruslan Imankulov (Shakhtyor)



Author: Mike Dryomin
(mike.d@g23.relcom.ru)

Last updated: 2 Jul 2001

(C) Copyright Mike Dryomin and RSSSF 1999/2001
						


  USO DE MEMORIA  
4,273,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1089
Total Execution Time  0.1108
  CADENA URL  
/premier_league_kazajistan1997
  GET DATOS  
$_GET['/premier_league_kazajistan1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0020  SELECT type FROM routes WHERE alias = 'premier_league_kazajistan1997'
0.0045  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kazajistan' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=978
0.0021  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 = 29301 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1997' WHERE c.parentId=399 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT type,rule FROM rules WHERE categoryId = 399 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:00:54' 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-04-28 17:00:54' 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=4 AND last_update > '2024-04-28 17:00:54' 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=3 AND last_update > '2024-04-28 17:00:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kazajistan' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29301) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29301) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (29301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29301) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (29301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29301) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT rp.lineup 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29301 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  SELECT rp.events 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29301 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 399 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=399 GROUP BY l.year ORDER BY l.year DESC
0.0021  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29301 AND rel.round=26
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29301 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29301 AND esl.points > 0
0.0019  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29301 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29301
0.0019  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1997` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29301 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1997` e INNER JOIN calendars1997 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 26 AND e.real_date IS NOT NULL AND e.league_id = 29301 ORDER BY total DESC LIMIT 40
0.0025  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1997` e INNER JOIN calendars1997 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29301 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 29301 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 29301 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 29301 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=399
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 399 AND l.year = 1997 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=399 AND year=1997