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

Liga Kazajistán 1992

Información Histórica 
						

Preliminary Stage
=================

Group A (19 apr - 2 sep)

Final table

 1. Kairat Alma-Ata           20  16  2  2  49-10  34
 2. Fosfor Dzhambul           20  12  3  5  36-19  27 
 3. Selinnik Selinograd       20  10  4  6  35-26  24
 4. Zhiger Chymkent           20   9  6  5  35-21  24
 5. Gorniak Hromtau           20  10  3  7  24-22  23
 6. Himik Kustanai            20   9  2  9  30-26  20
 7. Aktiubinez Aktiubinsk     20   7  6  7  22-19  20
 8. FC Aktau                  20   8  2 10  27-33  18
 9. Uralez Uralsk             20   5  3 12  15-39  13
10. Koksheatau Kokchetav      20   5  1 14  15-39  11
11. Arman Kentau              20   3  0 17  24-58   6

Crosstable
	                KAI  FOS  SEL  ZHI  GOR  HIM  AKT  FCA  URA  KOK  ARM 
1. Kairat Alma-Ata     	XXX  0-2  5-1  1-1  2-0	 2-1  3-1  1-0	1-0  2-0  3-0	
2. Fosfor Dzhambul 	0-2  XXX  0-2  1-4  0-0	 2-1  0-0  3-1	3-0  2-1  2-0
3. Selinnik Selinograd	2-1  0-2  XXX  3-1  0-2	 1-2  0-1  2-0	6-0  3-0  3-2	
4. Zhiger Chymkent	0-2  1-4  1-1  XXX  3-1	 1-0  0-0  1-1	1-0  0-0  1-3	
5. Gorniak Hromtau	0-2  0-3  1-2  0-0  XXX	 0-1  1-0  4-2	1-0  2-1  2-0	
6. Himik Kustanai	0-3  3-2  2-2  2-1  1-2	 XXX  1-1  0-1	1-2  2-0  3-0	
7. Aktiubinez Aktiubinsk1-1  0-5  0-0  0-2  0-1	 1-0  XXX  2-0	8-0  0-1  0-2 
8. FC Aktau     	0-4  2-1  3-1  0-3  2-0	 0-4  1-1  XXX	3-0  1-0  3-0	
9. Uralez Uralsk	0-2  1-1  2-2  0-3  1-1	 0-2  0-1  1-0	XXX  3-0  2-0	
10. Koksheatau Kokchetav0-4  0-1  1-2  0-3  0-3	 3-1  1-3  1-0	3-2  XXX  2-1	
11. Arman Kentau	1-8  1-2  0-2  2-8  2-3	 2-3  0-2  4-7	0-1  4-1  XXX

Top Scorers
Valery Velman(Himik)       13
Yevgeny Sorokin(Gorniak)   11
Igor Grohovsky(Arman)      10


Group B (20 apr - 3 sep)

Final Table

1. Escibastusez Ekibastuz     24  16  2  6  35-17  34
2. Shahter Karaganda          24  13  8  3  46-17  34
3. Traktor Pavlodar           24  14  5  5  47-26  33
4. Kaisar Kzyl-Orda           24  14  1  9  33-20  29
5. Arsenal-SKIF Chymkent      24  12  5  7  38-21  29
6. Vostok Ust-Kamenogorsk     24  13  1 10  39-26  27
7. Spartak Semipalatinsk      24  12  3  9  42-41  27
8. Bulat Temirtau             24   9  7  8  32-23  25
9. Metallist Petropavlovsk    24   9  6  9  41-41  24
10. Montazhnik Turkestan      24   6  7 11  32-39  19
11. Zhetysu Taldy-Kurgan      24   5  6 13  31-35  16
12. Zenit Kokchetav           24   4  1 19  14-60   9
13. CSKA Alma-Ata             24   3  0 20  27-91   6


Crosstable
                              ESC  SHA  TRA  KAI  ARS  VOS  SPA  BUL  MET  MON  ZHE  ZEN  CSK
1. Escibastusez Ekibastuz     XXX  1-0  1-1  2-0  0-1  1-0  2-1  2-1  0-1  1-0  3-0  1-0  1-0
2. Shahter Karaganda          1-2  XXX  0-0  1-0  2-1  2-0  3-0  0-0  1-1  1-1  0-0  7-1  2-0
3. Traktor Pavlodar           1-0  1-1  XXX  0-2  2-1  2-0  2-0  2-1  0-0  4-2  1-0  4-0  5-3
4. Kaisar Kzyl-Orda           0-1  1-0  0-1  XXX  0-2  2-1  0-2  0-0  4-0  3-0  3-2  2-1  4-1
5. Arsenal-SKIF Chymkent      3-2  0-0  2-0  1-4  XXX  3-1  3-0  0-0  1-2  1-0  0-0  0-1  2-3
6. Vostok Ust-Kamenogorsk     3-0  0-1  2-0  0-1  0-0  XXX  5-2  1-2  4-1  1-0  2-0  4-2  4-0
7. Spartak Semipalatinsk      1-1  1-4  3-1  0-1  1-0  3-2  XXX  0-2  3-3  2-0  2-1  2-0  6-3
8. Bulat Temirtau             2-1  0-2  2-1  0-3  1-1  0-2  0-1  XXX  1-2  0-0  0-0  2-1  5-0
9. Metallist Petropavlovsk    0-3  1-4  2-6  -:+  0-4  1-0  1-1  1-1  XXX  2-2  0-1  3-0  4-1
10. Montazhnik Turkestan      0-2  0-0  1-4  0-1  1-2  4-2  3-5  3-0  3-2  XXX  0-0  4-1  3-1
11. Zhetysu Taldy-Kurgan      0-1  2-3  0-0  2-1  1-3  0-3  2-3  0-2  1-2  3-3  XXX  6-0  2-0
12. Zenit Kokchetav           0-4  1-2  0-3  0-2  -:+  -:+  2-0  0-2  0-6  0-0  2-1  XXX  0-4
13. CSKA Alma-Ata             1-2  2-9  3-6  2-0  0-7  0-1  0-3  0-8  0-6  1-2  1-7  1-2  XXX

Annuled results: Zenit - Vostok  2-1       Metallist - Kaisar  3-1

Top scorers

Sergey Kogai(Kaisar)           15
Sergey Kondratsky(Metallist)   14
Pavel Demyan(Bulat)            12
Niklai Kurgansky(Escibastusez) 12
Radik Baiburin(Metallist)      11

Final stage
===========

Group A(1-14)

Final table:

 1.Kairat Alma-Ata            26 16  5  5  48-22   26  37
 2.Arsenal-SKIF Chymkent      26 14  8  4  39-21   18  36
 3.Traktor Pavlodar           26 14  8  4  39-22   17  36
 4.Eskibastusez Ekibastuz     26 14  6  6  39-24   15  34
 5.Fosfor Dzhambul            26 12  5  9  40-29   11  29
 6.Zhiger Chymkent            26  9 10  7  33-32    1  28
 7.Shahter Karaganda          26  8 12  6  24-22    2  28
 8.Gorniak Hromtau            26  8  7 11  24-29   -5  23
 9.Selinnik Selinograd        26  7  9 10  32-37   -5  23
10.Kaisar Kzyl-Orda           26  9  2 15  25-29   -4  20
11.Vostok Ust-Kamenogorsk     26  8  4 14  29-35   -6  20
12.Aktiubinez Aktiubinsk      26  4 12 10  12-31  -19  20
13.Himik Kustanai             26  7  3 16  29-45  -16  17
14.Spartak Semipalatinsk      26  5  3 18  25-60  -35  13 

Crosstable
                                KAI  ARS  TRA  ESK  FOS  ZHI  SHA  GOR  SEL  KAS  VOS  AKT  HIM  SPA	
1.Kairat Alma-Ata 	        XXX  1-2  0-0  1-2	      2-0	     1-0  1-0		 5-1
2.Arsenal-SKIF Chymkent	        1-1  XXX	    2-2	 0-0       0-0	1-1	       2-0  2-1		
3.Traktor Pavlodar	        4-3	  XXX	    2-0	 2-2	   2-2	1-0	       0-0  3-0		
4.Eskibastusez Ekibastuz        1-1	       XXX  2-3	 0-0	   1-1	4-0	       0-2  2-1		
5.Fosfor Dzhambul	 	     1-2  0-1  0-2  XXX	      0-0	     1-0  2-0		 2-0	
6.Zhiger Chymkent	             1-1  1-2  0-4	 XXX  1-1	     1-3  1-1		 3-0	
7.Shahter Karagamda	        1-3		    2-2	 0-2  XXX  2-1	0-0	       0-0  +:-
8.Gorniak Hromtau	             0-1  0-2  0-2	      0-0  XXX	     0-2  4-0		 1-0
9.Selinnik Selinograd	             0-3  1-1  2-2	      1-1	XXX  3-0  2-2		 6-0	
10.Kaisar Kzyl-Orda	        0-1		    0-2	 2-3	   2-3	3-0  XXX       1-1  0-1	
11.Vostok Ust-Kamenogorsk       1-3		    1-0	 0-1	   1-1	1-0	  XXX  0-1  4-1		
12.Aktiubinez Aktiubinsk	     0-2  0-6  0-1	      1-1	     0-0  1-3  XXX	 0-0	
13.Himik Kustanai		     1-3  1-2  1-2	      1-1	     0-2  1-0	    XXX	 4-2	
14.Spartak Semipalatinsk	0-1		    2-4	 1-2	   0-3	0-2	       1-1  4-2	 XXX

Annulled result: Himik - Shahter  1-0

Group B

Final Table

15.FK Aktau                   18 13  1  4  48-19   29  27
16.Uralez Uralsk              18 13  0  5  42-17   25  26
17.Bulat Temirtau             18 10  4  4  37-12   25  24
18.Montazhnik Turkestan       18  9  5  4  32-23    9  23 
19.Metallist Petropavlovsk    18  9  2  7  43-26    7  20 
20.Kokshetau Kokchetav        18  9  1  8  30-28    2  19 
21.Zhetysu Taldy-Kurgan       18  8  3  7  32-20   12  19 
22.Arman Kentau               18  6  0 12  35-41   -6  12 Relegated
23.Zenit Kokchetav            18  2  2 14  12-61  -49   6 Relegated
24.CSKA Alma-Ata              18  2  0 16  15-79  -64   4 Relegated

Promoted: Dostyk Alma-Ata, Dinamo Alma-Ata, Namys Alma-Ata, and
Karagachanak Aksai.

Crosstable
                            FCA  URA  BUL  MON  MET  KOK  ZHE  ARM  ZEN  CSK
15.FK Aktau                 XXX       2-2  2-3  2-1       2-0       2-0  5-0 
16.Uralez Uralsk                 XXX  1-0  2-3  2-0       2-4       3-1  4-1  
17.Bulat Temirtau           5-0  1-0  XXX            4-1       2-0   
18.Montazhnik Turkestan     2-3  0-2       XXX       2-1       1-2  
19.Metallist Petropavlovsk  0-5  1-2            XXX  4-2       7-2   
20.Kokshetau Kokchetav                1-0  1-0  1-2  XXX  1-3       2-2  5-0 
21.Zhetysu Taldy-Kurgan     -:+  -:+                 0-3  XXX  3-2   
22.Arman Kentau                       0-2  0-1  +:-       0-1  XXX  5-2  1-3
23.Zenit Kokchetav          0-4  0-7                 0-1       1-8  XXX  
24.CSKA Alma-Ata            0-7  0-8                 0-4       2-6       XXX


Top scorers
===========
Sergey Kogai(Kaisar)                21
Nikolay Kurgansky(Escibastusez)     19
Eduard Glazunov(Aktau)              19
Pavel Demyan(Bulat)                 19
Igor Grohovsky(Arman)               19
Yevgeny Sorokin(Gorniak)            18
Radik Baiburin(Metallist)           18
Sergey Kondratsky(Metallist)        18
Oleg Rylov(Traktor)                 16
Oleg Kapustnikov(Arsenal-SKIF)      15
Ruslan Duzmambetov(Vostok)          15




Authors: Almantas Lauzadis
and 
Erlan Manaschev

Last updated: 3 Apr 2014

(C) Copyright Almantas Lauzadis, Erlan Manaschev 
and RSSSF 1999/2014


  USO DE MEMORIA  
4,280,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.5767
Total Execution Time  0.5798
  CADENA URL  
/premier_league_kazajistan1992
  GET DATOS  
$_GET['/premier_league_kazajistan1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'premier_league_kazajistan1992'
0.0252  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=399 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 399 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1234413,1180995,1180959,1177104,1162132) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT text_es as historical_text FROM leagues_text WHERE id=962
0.0145  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 = 29283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='1992' WHERE c.parentId=399 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:14:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:14:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:14:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:14:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29283) 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.0125  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 (29283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29283) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (29283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29283) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29283) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29283) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  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 = 29283 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 29283 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0130  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=29283 AND rel.round=44
0.0126  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 = 29283 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 29283 AND esl.points > 0
0.0128  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29283 ORDER BY creation_date DESC LIMIT 0, 10
0.0132  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29283
0.0127  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 `calendars1992` 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` = 29283 AND c.`round` = 44 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events1992` e INNER JOIN calendars1992 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 = 44 AND e.real_date IS NOT NULL AND e.league_id = 29283 ORDER BY total DESC LIMIT 40
0.0132  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 `events1992` e INNER JOIN calendars1992 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 = 29283 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0128  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 `tables1992` 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 = 29283 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 29283 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29283 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0128  SELECT data1, data2 FROM services_tags WHERE categoryId=399
0.0128  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 399 AND l.year = 1992 ORDER BY l.group_code ASC
0.0128  SELECT group_code, extraName from `leagues` WHERE categoryId=399 AND year=1992