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

Liga Azerbaiyán 2001

Información Histórica 
						
Final Table: 

 1.FK Shamkir               20  16  3  1  60-14  51
 2.Neftchi Baki             20  16  3  1  57-11  51
 3.Vilash Masalli           20  11  5  4  24-11  38
 4.Shafa Baki               20  10  1  9  27-26  31  [*S]
 5.Turan Tovuz              20   9  3  8  42-28  30
 6.Dinamo-Bakili Baki       20   9  2  9  30-29  29  
 7.Hazar Universiteti Baki  20   9  2  9  26-38  29  [*Z]      
 8.Kapaz Ganca              20   8  1 11  34-29  25          
 9.Garabagh Aghdam          20   5  4 11  19-34  19  [*B]  
--------------------------------------------------- 
10.Araz Nahchivan           20   3  3 14  14-55  12  [+]
11.Shahdagh Guba            20   0  1 19   5-63   1  [+] [-]  

[+]  promoted clubs 
[*B] play home games in Buzovna
[*S] play several home games in Sumgayit
[*Z] play home games in Zabrat
[-]  Shahdagh withdrew after the winter break; all remaining matches were
     awarded 0-3 against them

NB: ANS Pivani ceased to be due to financial problems. This caused Hazar Uni to stay at 
    highest level. 
    Kimyachi announced they are not prepared to take part in the championship; this  
    left 11 teams in competition. 

Round 1 
[Aug 5]
Dinamo-B 4-1 Turan    [P.Aliyev-2, E.Mamedov, S.Musayev - B.Sahguliyev] 
Garabagh 1-0 Araz     [T.Gasanov] 
Shahdagh 0-3 Neftchi  [F.Ismaylov, K.Guliyev-2] 
[Aug 6]
Shamkir  0-1 Vilash   [E.Tanryverdiyev(Sh)-og] 
Hazar Un 1-0 Shafa    [A.Omarov] 
Kapaz    bye

Round 2 
[Aug 12]
Turan    4-1 Shahdagh [B.Sahguliyev, G.Kilasonia, V.Kilasonia, V.Farhadov - Ya.Niftaliyev] 
Kapaz    7-1 Hazar Un [R.Ahmedov, R.Sadihov, F.Cabbarov, Yu.Guseynov-2, M.Khundadze, 
                       F.Parvarov - K.Dzebeisashvili] 
Araz     0-0 Dinamo-B 
[Aug 13]
Vilash   0-0 Garabagh  
Shafa    1-4 Shamkir  [E.Imamaliyev - E.Gurbanov, M.Gurbanov, V.Kulikov, H.Mamedov] 
Neftchi  bye

Round 3 
[Aug 19]
Neftchi  5-1 Turan    [Aliyev, R.Mamedov, Musayev, K.Guliyev-2 - G.Kilasonia] 
[Aug 20]
Shamkir  2-1 Kapaz    [B.Kvaratskhelia, H.Mamedov - R.Ahmedov] 
Dinamo-B 2-1 Vilash   [A.Bayramov, P.Aliyev - K.Kerimov] 
Garabagh 1-3 Shafa    [T.Gasanov - R.Musayev, Imamaliyev-2] 
Shahdagh 0-1 Araz     [Allahyarov] 
Hazar Un bye

Round 4 
[Sep 9]
Araz     0-7 Neftchi  [R.Mamedov-2, B.Musayev, S.Aliyev, M.Guseynov-2, F.Ismaylov] 
Shafa    1-3 Dinamo-B [E.Mamedov(DB)-og - Spirin(Sh)-og, P.Aliyev, R.Guseynov] 
[Sep 10]
Kapaz    2-1 Garabagh [Ahmedov, Sadihov - Garayev] 
Vilash   awd Shahdagh [awarded 3-0] 
Hazar Un 2-2 Shamkir  [Dzebeisashvili-2 - Kulikov, Kvaratskhelia] 
Turan    bye

Round 5 
[Sep 16]
Garabagh 3-0 Hazar Un [A.Bagirov(HU) 14 og, Ya.Guseynov 65, A.Niyazov 74] 
Dinamo-B 0-2 Kapaz    [Yu.Guseynov 34, I.Guseynov 37] 
[Sep 17]
Shahdagh 1-4 Shafa    [A.Mehtiyev 8 - A.Ibragimov 25, S.Allahverdiyev 46, 
                       R.Nasibov 89, 90] 
Turan    7-2 Araz     [J.Tsiklauri 6, 32, A.Ismaylov 60, E.Aslanov 65, V.Kilasonia 70, 76, 
                       G.Kilasonia 86 - I.Allahyarov 38, H.Guliyev(T) 44 og] 
Neftchi  1-0 Vilash   [S.Aliyev 70] 
Shamkir  bye

Round 6
[Sep 23]
Vilash   4-1 Turan    [Z.Askerov 37, A.Bahramov 54, E.Kerimov 80 pen, A.Gasimov 90 - 
                       G.Kilasonia] 
Shafa    0-1 Neftchi  [K.Guliyev 12] 
[Sep 24]
Shamkir  5-1 Garabagh [V.Kulikov 12, I.Mamedov 22, B.Kvaratskhelia 50, 60, I.Suleymanov 86 
                       - M.Gurbanov 88] 
Hazar Un 1-2 Dinamo-B [G.Tfalabeishvili 86 pen - Ya.Abuzarov 59, P.Aliyev 65] 
Kapaz    awd Shahdagh [awarded 3-0] 
Araz     bye
 
Round 7 
[Oct 14] 
Dinamo-B 1-4 Shamkir  [P.Aliyev 43 - A.Abisov 21, M.Gurbanov 23, B.Kvaratskhelia 41, 
                       I.Mamedov 65] 
Shahdagh 0-2 Hazar Un [K.Dzebeisashvili 33, 87] 
[Oct 15] 
Araz     1-2 Vilash   [I.Allahyarov 21 - R.Azarenka 7, 40] 
Turan    5-0 Shafa 
Neftchi  1-0 Kapaz    [F.Ismaylov] 
Garabagh bye

Round 8 
[Oct 21] 
Kapaz    2-1 Turan    [E.Guliyev 47, Yu.Guseynov 60 - R.Abbasov 88] 
Shafa    1-0 Araz     [S.Mamedov 68] 
[Oct 22] 
Hazar Un 1-4 Neftchi  [S.Alekperov 90 - T.Ahmedov 28, VVasilyev 37, F.Ismaylov 44, 
                       S.Aliyev 60] 
Shamkir 10-1 Shahdagh [M.Gurbanov 6, 17, I.Mamedov 30, M.Mamedov 52, 56, 89, 
          I.Suleymanov 54, Ag.Mamedov 64, H.Mardanov 70, B.Kvaratskhelia 76 - A.Orucev 78] 
Garabagh 0-1 Dinamo-B [P.Aliyev 55] 
Vilash   bye

Round 9 
[Oct 28] 
Shahdagh 1-1 Garabagh [G.Guseynov 10 - M.Isayev 81] 
Neftchi  1-1 Shamkir  [B.Kvaratskhelia 28 - T.Ahmedov 45] 
[Oct 29] 
Araz     1-3 Kapaz    [I.Allahyarov 3 - I.Guseynov 2, 86, M.Khundadze 90] 
Vilash   1-0 Shafa    [E.Kerimov 72] 
Turan    3-1 Hazar Un [G.Kilasonia 6, 43, N.Nabiyev 71 - K.Dzebeisashvili 89 pen] 
Dinamo-B bye

Round 10 [Nov 4] 
Dinamo-B 2-1 Shahdagh 
Hazar Un 3-1 Araz     
Garabagh 0-4 Neftchi 
Kapaz    0-0 Vilash 
Shamkir  1-0 Turan 
Shafa    bye

Round 11 
[Nov 11] 
Neftchi  1-1 Dinamo-B [K.Guliyev 22 - Ya.Bagirov 38] 
Turan    awd Garabagh [awarded 3-0] 
[Nov 12] 
Vilash   1-0 Hazar Un [R.Azarenka 65] 
Araz     1-5 Shamkir  [I.Allahyarov 13 - H.Mamedov 15, V.Kulikov 19, 22, I.Suleymanov 56, 
                       A.Abisev 67] 
Shafa    1-0 Kapaz    [A.Gaciyev 90] 
Shahdagh bye

Round 12
[Mar 3]
Turan    2-1 Dinamo-B
[Mar 4]
Neftchi  awd Shahdagh [awarded 3-0]
Shafa    0-1 Hazar Un
Vilash   1-1 Shamkir
[Apr 12]
Araz     0-0 Garabagh
Kapaz    bye

Round 13 [Mar 8]
Hazar Un 3-0 Kapaz
Garabagh 0-1 Vilash
Shamkir  2-1 Shafa
Shahdagh awd Turan    [awarded 0-3]
Dinamo-B 3-0 Araz
Neftchi  bye

Round 14 [Mar 11]
Vilash   2-1 Dinamo-B
Shafa    2-1 Garabagh
Turan    1-2 Neftchi 
Kapaz    0-3 Shamkir
Araz     awd Shahdagh [awarded 3-0]
Hazar Un bye

Round 15
[Mar 17]
Shamkir  5-0 Hazar Un 
[Mar 18]
Garabagh 2-1 Kapaz
Dinamo-B 0-1 Shafa
Shahdagh awd Vilash   [awarded 0-3]
[Apr 26]
Neftchi  6-0 Araz    
Turan    bye

Round 16
[Mar 31]
Araz     1-1 Turan
Hazar Un 0-0 Garabagh 
[Apr 1]
Kapaz    1-2 Dinamo-B  
Shafa    awd Shahdagh [awarded 3-0]
[Apr 11]
Neftchi  0-0 Vilash
Shamkir  bye

Round 17
[Apr 5]
Neftchi  3-1 Shafa
Garabagh 0-1 Shamkir 
[Apr 6]
Turan    0-0 Vilash 
Dinamo-B 1-2 Hazar Un  
Shahdagh awd Kapaz    [awarded 0-3]   
Araz     bye

Round 18 
[Apr 14]
Vilash   2-1 Araz  
[Apr 15]
Kapaz    1-3 Neftchi  
Shamkir  3-1 Dinamo-B  
Safa     0-0 Turan  
Hazar Un awd Shahdagh [awarded 3-0]
Garabagh bye

Round 19 
[Apr 18]
Dinamo-B 2-4 Garabagh 
Araz     0-4 Shafa
[Apr 19]
Neftchi  7-2 Hazar Un  
Turan    3-0 Kapaz  
Shahdagh awd Shamkir  [awarded 0-3]
Vilash   bye

Round 20 
[Apr 23]
Kapaz    6-0 Araz  
[Apr 24]
Shamkir  2-0 Neftchi  
Shafa    1-0 Vilash  
Hazar Un 1-0 Turan
Garabagh awd Shahdagh [awarded 3-0]
Dinamo-B bye

Round 21
[Mar 4]
Neftchi  3-0 Garabagh 
[Apr 29]
Shahdagh awd Dinamo-B [awarded 0-3]
Araz     2-0 Hazar Un
Vilash   2-0 Kapaz   
Turan    1-2 Shamkir 
Shafa    bye

Round 22 [May 5]
Dinamo-B 0-2 Neftchi
Garabagh 1-5 Turan   
Hazar Un 2-0 Vilash
Shamkir  4-0 Araz 
Kapaz    2-3 Shafa 
Shahdagh bye

Final Table: 

 1.FK Shamkir               20  16  3  1  60-14  51
 2.Neftchi Baki             20  16  3  1  57-11  51
 3.Vilash Masalli           20  11  5  4  24-11  38
 4.Shafa Baki               20  10  1  9  27-26  31  [*S]
 5.Turan Tovuz              20   9  3  8  42-28  30
 6.Dinamo-Bakili Baki       20   9  2  9  30-29  29  
 7.Hazar Universiteti Baki  20   9  2  9  26-38  29  [*Z]      
 8.Kapaz Ganca              20   8  1 11  34-29  25          
 9.Garabagh Aghdam          20   5  4 11  19-34  19  [*B]  
--------------------------------------------------- 
10.Araz Nahchivan           20   3  3 14  14-55  12  [+]
11.Shahdagh Guba            20   0  1 19   5-63   1  [+] [-]  

[+]  promoted clubs 
[*B] play home games in Buzovna
[*S] play several home games in Sumgayit
[*Z] play home games in Zabrat
[-]  Shahdagh withdrew after the winter break; all remaining matches were
     awarded 0-3 against them

NB: ANS Pivani ceased to be due to financial problems. This caused Hazar Uni to stay at 
    highest level. 
    Kimyachi announced they are not prepared to take part in the championship; this  
    left 11 teams in competition. 


Championship Playoff [Sumgayit, May 15]
Shamkir  1-0 Neftchi
  [Arif Asadov 21og] 

Shamkir champions 2000/01



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

Last updated: 27 Aug 2001

(C) Copyright Mike Dryomin and RSSSF 2000/01


  USO DE MEMORIA  
4,245,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0061
Controller Execution Time ( Home / Category )  0.5863
Total Execution Time  0.5924
  CADENA URL  
/premier_league_azerbayan2001
  GET DATOS  
$_GET['/premier_league_azerbayan2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'premier_league_azerbayan2001'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azerbayan' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=396 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 396 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 (1026283,996023,966668,925956,924713) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT text_es as historical_text FROM leagues_text WHERE id=2493
0.0127  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 = 30748 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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='2001' WHERE c.parentId=396 GROUP BY c.id ORDER BY c.order_id ASC
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 20:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 20:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 20:56:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azerbayan' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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 events2001 e WHERE e.league_id IN (30748) 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.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 (30748) 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 events2001 e WHERE e.league_id IN (30748) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129  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 (30748) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (30748) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0132  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 (30748) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (30748) AND (e.action IN (22) ) 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 (30748) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 30748 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0124  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 = 30748 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0129  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=30748 AND rel.round=20
0.0127  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 = 30748 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 = 30748 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` = 30748 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 30748
0.0126  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 `calendars2001` 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` = 30748 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 200
0.0127  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 `events2001` e INNER JOIN calendars2001 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 = 20 AND e.real_date IS NOT NULL AND e.league_id = 30748 ORDER BY total DESC LIMIT 40
0.0128  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 `events2001` e INNER JOIN calendars2001 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 = 30748 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0129  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 `tables2001` 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 = 30748 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 30748 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 30748 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0129  SELECT data1, data2 FROM services_tags WHERE categoryId=396
0.0129  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 396 AND l.year = 2001 ORDER BY l.group_code ASC
0.0129  SELECT group_code, extraName from `leagues` WHERE categoryId=396 AND year=2001