4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1998
Temporada Siguiente »
Publicidad 600x120.gif
Liga Kazajistán 1998
1997/1998

Liga Kazajistán 1998

Información Histórica 
						
Final Table:

 1.Yelimay Semipalatinsk             26  20  3  3  60-20  63  Champions
 2.Batyr Ekibastuz                   26  18  5  3  50-17  59
 3.Irtysh Pavlodar                   26  17  6  3  44-15  57
------------------------------------------------------------
 4.Kaysar Hurricane Kzyl-Orda        26  16  5  5  42-17  53
 5.Vostok Ust'-Kamenogorsk           26  17  1  8  49-25  52
 6.Astana Akmola                     26  15  6  5  45-22  51
 7.Kayrat CSKA Almaty                26  13  4  9  45-32  43
 8.Khimik Stepnogorsk                26   7  8 11  22-33  29
 9.Shakhtyor-Ispat-Karmet Karaganda  26   8  4 14  29-32  28
10.Taraz                             26   7  6 13  33-35  27
11.Zhiger Chimkent                   26   6  4 16  31-49  22
12.Nasha Kompaniya Akmola            26   3  6 17  15-50  15  [aka Our Company]
------------------------------------------------------------
13.Bulat Temirtau                    26   3  3 20  10-66  12
14.Naryn Ural'sk                     26   0  3 23  11-73   3

Name Change:
   Uralets Ural'sk to Naryn Ural'sk

Round 1
-------
Taraz       - Yelimay 0-1 [Litvinenko'22]
Zhiger      - Vostok  0-1 [Antropov'77]
Kaysar      - Irtysh  0-1 [Malyshev'75]
Naryn       - Batyr   1-3 [Zobnin'75 - Makayev'53, Barsukov'77, Fadeyev'85]
Kayrat      - Astana  3-3 [Urazbakhtin'4, Baltiyev'49, Kadyrkulov'60 - Zvonarenko'71, 
                           Kotov'86/89]
Shakhtyor   - Khimik  2-0 [Bobrov'42, Urdabayev'71)

Round 2
-------
Bulat     - Our Company 0-1 [Khramushin'10]
Taraz     - Vostok      1-2 [Fyodorov'60 - Antropov'64, Obryadov'89]
Zhiger    - Yelimay     0-2 [Litvinenko'53, ?]
Kaysar    - Batyr       0-0 
Naryn     - Irtysh      0-1 [Malyshev'15]
Kayrat    - Khimik      2-1 [Yensebayev'35, Byakov'90 - Yeleskin'41]
Shakhtyor - Astana      1-2 [Musatayev'79 - Kotov'57, Shatskikh'89]

Round 3
-------
Astana  - Naryn       2-0 [Shatskikh'25, Mukhametkaliyev'45og]
Khimik  - Kaysar      0-0
Irtysh  - Taraz       3-0 [Antonov'1pen/'61, Kitsak'64]
Batyr   - Zhiger      1-0 [Gumar'57pen]
Vostok  - Bulat       4-0 [Sveshnikov'25, Yevteyev'29, Antropov'34, Kozhevnikov'44]
Yelimay - Our Company 1-0 [Mityayev'69]

Round 4
-------
Astana    - Kaysar      2-1 [Shatskikh'61, Kotov'72 - Vaganov'86]
Khimik    - Naryn       1-1 [Nurgaliyev'41 - Zobnin'11]
Irtysh    - Zhiger      2-0 [Kalabukhin'18, Antonov'30]
Batyr     - Taraz       1-0 [Gumar'52pen]
Vostok    - Our Company 5-1 [Kozhevnikov'12/'20/'75, Duzmambetov'35, Khamidullov'50 - 
                             Khromushin'59]
Yelimay   - Bulat       5-0 [Aubakirov'7/'61, Miroshnichenko'34/'68, Orlov'85]
Shakhtyor - Kayrat      1-0 [Lunev'81]

Round 5
-------
Bulat       - Irtysh    0-4 [Malyshev'3, Antonov'64, Kostandyan'77, Kononov'88]
Our Company - Batyr     1-2 [Groza'30 - Sisenov'74, Gumar'77]
Taraz       - Astana    1-1 [Koshkarov'24 - Glazunov'63]
Zhiger      - Khimik    0-1 [Baktybayev'29og]
Kaysar      - Kayrat    2-1 [Mazbayev'41/'72 - Zheylitbayev'33]
Naryn       - Shakhtyor 0-2 [Sulimenko'30, Lunev'52]

Round 6
-------
Yelimay     - Vostok    1-0 [Smakov'55pen]
Bulat       - Batyr     0-0
Our Company - Irtysh    0-1 [Bidul'ka'80]
Taraz       - Khimik    0-0
Zhiger      - Astana    2-3 [Zhakipbekov'4, Yeshjanov'20 - Kotov'65, Zhitkov'84,
                             Kushebin'88]
Kaysar      - Shakhtyor 0-0
Naryn       - Kayrat    0-1 [Baltiyev'44]

Round 7
-------
Irtysh    - Vostok      3-1 
Batyr     - Yelimay     2-0 
Astana    - Bulat       0-0  
Khimik    - Our Company 1-0
Shakhtyor - Taraz       2-2 
Kayrat    - Zhiger      6-2

Round 8
-------
Irtysh    - Yelimay     0-0
Batyr     - Vostok      1-0
Astana    - Our Company 3-1
Khimik    - Bulat       3-0
Shakhtyor - Zhiger      5-2
Kayrat    - Taraz       1-0
Kaysar    - Naryn       5-0

Round 9
-------
Vostok      - Astana    1-2
Yelimay     - Khimik    6-1
Bulat       - Kayrat    1-0
Our Company - Shakhtyor 1-3
Taraz       - Kaysar    0-1
Zhiger      - Naryn     3-1

Round 10
--------
Batyr       - Irtysh    2-0 [Tyotushkin 39, Makayev 80]
Vostok      - Khimik    3-0 [Khamidullov 32 pen, 86, Kashtanov 53]
Yelimay     - Astana    3-1 [Miroshnichenko 3, Vishnyakov 8, Mityayev 44 - Shatskikh 71]
Bulat       - Shakhtyor 0-2 [Urdabayev 3, Salimov 86]
Our Company - Kayrat    0-1 [Urazbakhtin 5]
Taraz       - Naryn     4-2 [Koshkarov 27, 73, Tleshev 54, Eirich 80 - Urazbayev 26, Feoktistov 88]
Zhiger      - Kaysar    1-1 [Baybosynov 28 - Vaganov 82]

Round 11
--------
Astana    - Irtysh      1-1 [Kushebin 18 - Antonov 38]
Khimik    - Batyr       1-2 [Abdrashitov 45 - Tyotushkin 48, Makayev 75]
Kaysar    - Bulat       3-0 [Akhmedov 14, Loginov 42, 76]
Naryn     - Our Company 2-2 [Mironenko 42, 57 - Linevich 61, Kucherbayev 87]
Kayrat    - Vostok      1-1 [Zheylitbayev 55 pen - Kashtanov 36]
Shakhtyor - Yelimay     1-1 [Imankulov 82 - Litvinenko 50]

Round 12
--------
Astana    - Batyr       1-1 [Kotov 81 pen - Friedenthal 48]
Khimik    - Irtysh      2-2 [Abdrashitov 8, Izotov 31 - Antonov 53, Asukhanov 65]
Taraz     - Zhiger      2-0 [Kushekbayev 52, Pak 72]
Kaysar    - Our Company 2-0 [Buntov 61, Mazbayev 63]
Naryn     - Bulat       0-1 [Sannikov 29]
Kayrat    - Yelimay     1-0 [Kadyrkulov 27]
Shakhtyor - Vostok      0-1 [Kashtanov 60]

Round 13
--------
Bulat       - Taraz     1-3
Our Company - Zhiger    1-1
Vostok      - Kaysar    2-0
Yelimay     - Naryn     3-0
Batyr       - Kayrat    1-0
Irtysh      - Shakhtyor 1-0

Round 14
--------
Bulat       - Zhiger    0-2
Our Company - Taraz     0-0
Vostok      - Naryn     5-1
Yelimay     - Kaysar    2-1
Batyr       - Shakhtyor 4-0
Irtysh      - Kayrat    2-2
Astana      - Khimik    2-0

Round 15
--------
Taraz     - Bulat       5-0 [Eirich 2, 18, 20, Koshkarov 53, Mironov 73]
Zhiger    - Our Company 1-0 [Baybosynov 28]
Kaysar    - Vostok      2-0 [Vaganov 37, Niyazymbetov 69]
Naryn     - Yelimay     1-4 [Avakyants 74 - Litvinenko 12 pen, 14, Vishnyakov 63, Smakov 71]
Kayrat    - Batyr       2-0 [Nuftiyev 58, Tarasov 69]
Shakhtyor - Irtysh      0-1 [Kitsak 15]

Round 16
--------
Khimik    - Astana      0-0
Taraz     - Our Company 3-0 [Pak 1, Kushekbayev 17, Koshkarov 60]
Zhiger    - Bulat       3-0 [Israilov 52, Baybosynov 68, 83]
Kaysar    - Yelimay     2-3 [Akhmedov 69, Gabdullin 80 - Litvinenko 26, Smakov 59, 75]
Naryn     - Vostok      0-1 [Sveshnikov 89]
Kayrat    - Irtysh      2-1 [Baltiyev 37, Rakhimbayev 81 - Klishin 57]
Shakhtyor - Batyr       1-2 [Gelazhen' 62 - Friedenthal 8, Gornalyov 86]

Round 17
--------
Irtysh      - Astana    1-0
Batyr       - Khimik    4-1
Bulat       - Kaysar    2-4
Our Company - Naryn     2-0
Vostok      - Kayrat    3-2
Yelimay     - Shakhtyor 3-1

Round 18
--------
Irtysh      - Khimik    1-0
Batyr       - Astana    3-0
Bulat       - Naryn     2-0
Our Company - Kaysar    0-1
Vostok      - Shakhtyor 1-0
Yelimay     - Kayrat    4-1
Zhiger      - Taraz     2-2

Round 19
--------
Astana    - Vostok      2-1 [Kushebin 1, Kotov 44 pen - Khamidullov 27]
Khimik    - Yelimay     0-1 [Litvinenko 25]
Kaysar    - Taraz       2-0 [Mazbayev 21 pen, 29]
Naryn     - Zhiger      0-3 [Bektemirov 8, Baybosynov 51, Shvyrkov 90]
Kayrat    - Our Company 7-0 [Usmanov 21, 41, Nuftiyev 47, Kadyrkulov 54, 78, Byakov 82, 87]
Shakhtyor - Bulat       2-0 [Bobrov 15, 53]

Round 20
--------
Astana    - Yelimay     0-1 [Aubakirov 88]
Khimik    - Vostok      1-2 [Baltabayev 41 - Khamidullin 67, Kashtanov 72]
Irtysh    - Batyr       0-0
Kaysar    - Zhiger      1-0 [Loginov 38]
Naryn     - Taraz       0-4 [Kushekbayev 29 pen, Eirich 35, 56, Pak 53]
Kayrat    - Bulat       2-1 [Yensebayev 19, Usmanov 28 - Rudakov 32]
Shakhtyor - Our Company 0-0

Round 21
--------
Vostok      - Irtysh    0-2 [Kitsak 18, Malyshev 70]
Yelimay     - Batyr     2-2 [Mityayev 16, Miroshnichenko 87 - Vishnichenko 55, Makayev 67]
Bulat       - Astana    0-5 [Khetishvili 3, Malikov 31 pen, Zhitkov 55, Kotov 74, Zvonarenko 78]
Our Company - Khimik    0-0
Taraz       - Shakhtyor 2-0 [Mironov 51, Kushekbayev 60 pen]
Zhiger      - Kayrat    1-2 [Baybosynov 70 pen - Yensebayev 29, Kadyrkulov 64]

Round 22
--------
Vostok      - Batyr     2-1 [Yevteyev 4, Duzmambetov 27 - Afel'chenko 45 pen]
Yelimay     - Irtysh    3-2 [Aubakirov 22, Miroshnichenko 42, Vishnyakov 80 pen - Timets 52, Kitsak 73]
Bulat       - Khimik    0-3 [Abdrashitov 49, Samoylov 81, Rotkovich 87]
Our Comapny - Astana    0-1 [Kushebin 53]
Taraz       - Kayrat    1-1 [Usmanov 31 - Bulekbayev 78]
Zhiger      - Shakhtyor 2-1 [Bektimirov 37, Israilov 61 - Slambekov 23]
Naryn       - Kaysar    0-4 [Yurist 10, 50, Niyazymbetov 33, Vaganov 66]

Round 23
--------
Astana    - Zhiger      2-0 [Malikov 26 pen, Kotov 43]
Khimik    - Taraz       1-0 [Baltabayev 48]
Irtysh    - Bulat       4-0 [Malyshev 3, Kucheryavykh 38, Antonov 58 pen, Goryachev 80]
Batyr     - Our Company 6-0 [Tyotushkin 28, Bush 33, 78, Barsukov 43, 63, Sisenov 68]
Shakhtyor - Kaysar      1-2 [Imankulov 17 - Mazbayev 10, Man'kuta 78]
Kayrat    - Naryn       3-0 [awarded]

Round 24
--------
Astana    - Taraz       4-0 [Zhitkov 53, 74, Kleshchyov 57, 82]
Irtysh    - Our Company 2-0 [Kitsak 19, Antonov 35]
Batyr     - Bulat       2-0 [Afel'chenko 55, Vishnichenko 73]
Vostok    - Yelimay     1-0 [Moskalenko 67]
Kayrat    - Kaysar      1-2 [Kadyrkulov 16 - Mazbayev 38, 78]
Shakhtyor - Naryn       4-0 [Imankulov 4, 37, 38, 88]
Khimik    - Zhiger      1-1 [???]

Round 25
--------
Bulat       - Vostok  0-3 [Kashtanov 58, Khamidullov 67, Rylov 88]
Our Company - Yelimay 1-4 [Protsyuk 81 - Aubakirov 16, Litvinenko 30, 62, 68]
Taraz       - Batyr   1-2 [Tleshev 78 - Sisenov 15, Reshetnikov 30]
Zhiger      - Irtysh  1-3 [Israilov 54 - Antonov 26, 50, Kitsak 70]
Kaysar      - Khimik  3-0 [awarded]
Naryn       - Astana  0-4 [Kotov 19, Shatskikh 39 pen, Zakirov 88, Zhitkov 89]

Round 26
--------
Bulat       - Yelimay   0-4 [Litvinenko 24, 26, 38, 65]
Our Company - Vostok    2-1 [Khromushin 56, Kusherbayev 70 - Rylov 68]
Taraz       - Irtysh    0-2 [Asukhanov 18, Malyshev 77]
Zhiger      - Batyr     2-3 [Baybosynov 78, 88 pen - Bedul'ka 28, Friedenthal 49, Sisenov 68]
Kaysar      - Astana    1-0 [Niyazymbetov 61]
Naryn       - Khimik    1-1 [Avakyants 69 - Zobnin 55]
Kayrat      - Shakhtyor 3-0 [Usmanov 28, 58, Urazbakhtin 83]

Round 27
--------
Astana      - Shakhtyor 1-0
Khimik      - Kayrat    2-0
Irtysh      - Naryn     4-1
Batyr       - Kaysar    1-2
Vostok      - Taraz     3-1
Yelimay     - Zhiger    3-1
Our Company - Bulat     2-2

Round 28
--------
Astana      - Kayrat    3-0
Khimik      - Shakhtyor 1-0
Irtysh      - Kaysar    0-0
Batyr       - Naryn     4-0
Vostok      - Zhiger    5-1
Yelimay     - Taraz     3-1

Final Table:

 1.Yelimay Semipalatinsk             26  20  3  3  60-20  63  Champions
 2.Batyr Ekibastuz                   26  18  5  3  50-17  59
 3.Irtysh Pavlodar                   26  17  6  3  44-15  57
------------------------------------------------------------
 4.Kaysar Hurricane Kzyl-Orda        26  16  5  5  42-17  53
 5.Vostok Ust'-Kamenogorsk           26  17  1  8  49-25  52
 6.Astana Akmola                     26  15  6  5  45-22  51
 7.Kayrat CSKA Almaty                26  13  4  9  45-32  43
 8.Khimik Stepnogorsk                26   7  8 11  22-33  29
 9.Shakhtyor-Ispat-Karmet Karaganda  26   8  4 14  29-32  28
10.Taraz                             26   7  6 13  33-35  27
11.Zhiger Chimkent                   26   6  4 16  31-49  22
12.Nasha Kompaniya Akmola            26   3  6 17  15-50  15  [aka Our Company]
------------------------------------------------------------
13.Bulat Temirtau                    26   3  3 20  10-66  12  Relegated
14.Naryn Ural'sk                     26   0  3 23  11-73   3  Relegated

Nasha Kompaniya Akmola disbanded at end of season.
New in 1999: Access Yesil Petropavlovsk, Sintez FK ShNOS Chimkent,
             SOPFK Kayrat Almaty, Zhetysu Taldy-Kurgan and Tobol Kustanay.

Top Scorers
-----------
23 - Litvinenko (Yelimay)
15 - Baybosynov (Zhiger)
14 - Mazbayev (Taraz)
     Antonov (Irtysh)



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,299,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4674
Total Execution Time  0.4692
  CADENA URL  
/premier_league_kazajistan1998
  GET DATOS  
$_GET['/premier_league_kazajistan1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0106  SELECT type FROM routes WHERE alias = 'premier_league_kazajistan1998'
0.0216  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0116  SELECT text_es as historical_text FROM leagues_text WHERE id=980
0.0112  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 = 29303 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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='1998' WHERE c.parentId=399 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 399 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 00:14:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 00:14:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 00:14:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 00:14:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29303) 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.0106  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 (29303) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29303) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (29303) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29303) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  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 (29303) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29303) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (29303) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  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 = 29303 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 29303 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0108  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=29303 AND rel.round=26
0.0107  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 = 29303 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0107  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 = 29303 AND esl.points > 0
0.0106  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` = 29303 ORDER BY creation_date DESC LIMIT 0, 10
0.0112  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` = 29303
0.0107  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 `calendars1998` 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` = 29303 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0105  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 `events1998` e INNER JOIN calendars1998 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 = 29303 ORDER BY total DESC LIMIT 40
0.0107  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 `events1998` e INNER JOIN calendars1998 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 = 29303 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0107  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 `tables1998` 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 = 29303 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 29303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 29303 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=399
0.0107  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 399 AND l.year = 1998 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=399 AND year=1998