4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Azerbaiyán 1999
1998/1999

Liga Azerbaiyán 1999

Información Histórica
						
Table:

 1.Kapaz (Ganja)           26 18  4  4 77-17 58        [-1]  
 2.Garabagh (Aghdam)       26 17  3  6 45-21 54        [-3] 
 3.Dinamo (Baki)           26 16  4  6 46-20 52        [-1]
 4.Neftchi (Baki)          26 15  7  4 57-18 52 
 5.Shamkir (Shamkir)       26 16  2  8 42-24 50        [-1]  
 6.Baki Fahlasi (Baki)     26 15  5  6 46-25 50        [-1]
- - - - - - - - - - - - - - - - - - - - - - - -
 7.Turan (Tovuz)           26 14  7  5 42-21 49        [-2]
 8.Vilash (Masalli)        26 14  4  8 39-25 46
 9.Bakili (Baki)           26  7  7 12 18-33 28        [-2]  
10.OIK (Baki)              26  6  8 12 20-29 26        [-3] 
11.Kimyachi (Sumgayit)     26  5  1 20 20-70 16  [*]   [-1]  
12.Shafa (Baki)            26  3  5 18 24-54 14
13.Shahdag (Kusari)        26  2  4 20 20-86 10  [+]   [-3]
14.Neftegaz-GNKAR (Baki)   26  2  3 21 15-68  9  [x]

Top-6 qualified to final stage.

[*] changed name from Sumgayit to Kimyachi before season.
[+] changed name from Neftegaz to Shahdag during season.
[x] changed name from Dalgich to Dalgich-GNKAR and then to Neftegaz-GNKAR
    during season.

[-1] missing goal difference from 1 match
[-2] missing goal difference from 2 matches
[-3] missing goal difference from 3 matches

[NB: OIK is the Azeri rendering of SKA]

Round 1 [Aug 15]
Bakili       0-2 OIK       
Kimyachi     8-3 Neftegaz K 
Turan        0-2 Baki Fahlasi
Shafa        0-2 Shamkir      
Dalgich      0-2 Dinamo      
Kapaz        2-0 Neftchi       
[played later]
Vilash       1-0 Garabagh      [Orujev 59]

Round 2
OIK          0-0 Dinamo     
Neftchi      1-0 Dalgich       
Garabagh     1-0 Shamkir 
Baki Fahlasi 1-1 Vilash
Neftegaz K   1-2 Turan      
Bakili       1-0 Kimyachi      
[played later]
Shafa        2-5 Kapaz         [A.Abbasov 12, 81 - F.Jabbarov 26, M.Kurbanov 58,
                                A.Mamedov 66, Rzayev 74, Parvarov 84]
Round 3
Neftchi      0-1 Dinamo    
Kimyachi     0-0 OIK      
Turan        2-0 Bakili     
Vilash       3-0 Neftegaz K  
Shamkir      3-1 Baki Fahlasi 
[played later]
Kapaz        3-0 Garabagh      [Rzayev 11 pen, 88, M.Gurbanov 19]
Dalgich G    0-4 Shafa         [Tagizade 10, N.Aliyev 13, 
                                Abdashev 16, Gashumov 74]
Name change: Dalgich becomes Dalgich-GNKAR.

Round 4
OIK          1-3 Neftchi       [Kurbanov 5 - Musayev 8, 40, Alibabayev 55]
Garabagh     4-0 Dalgich G     [Mahmudov 17, Karayev 29, Kuliyev 73, Isayev 78]
Baki Fahlasi 0-2 Kapaz         [Rzayev 60, A.Mamedov 87]
Neftegaz K   0-4 Shamkir       [M.Ibragimov 5, B.Kvaratskhelia 39, 89, Kerimov 73]
Bakili       1-0 Vilash        [E.Mamedov 23]
Kimyachi     1-2 Turan         [A.Mamedov 7 - Madatov 34, Dimitriashvili 88]
Shafa        0-3 Dinamo        [Ismailov 18, 70, R.Mamedov 56]

Round 5
Turan        1-0 OIK           [Shahniyarov 38]
Vilash       1-0 Kimyachi      [Bahyshev 83]
Shamkir      1-0 Bakili
Kapaz       11-1 Neftegaz K    [Parvarov 5, 7, 17, Rzayev 8, 19, 47, Mardanov 31, 
                                M.Gurbanov 36, 70, I.Suleymanov 50, 56 - Bedirhanov 82]
Dalgich G    0-4 Baki Fahlasi  [Vasilyev 29, Yagubaliyev 38, A.Abushev 45, 71]
Dinamo       2-0 Garabagh      [N.Aliyev 78, Ismailov 89]
Neftchi      5-0 Shafa         [Mahmudov 37, I.Mamedov 57, B.Musayev 74, 76, Alibabayev 88]

Round 6
OIK          0-0 Shafa         
Garabagh     1-0 Neftchi       [S.Aliyev 68]
Baki Fahlasi awd Dinamo        [awarded 3-0, Dinamo fielded an ineligible player]
Neftegaz K   1-1 Dalgich G     [Mirzagayev 90 pen - Badalov 82]
Bakili       1-0 Kapaz         [Shahguseyni 7]
Kimyachi     3-2 Shamkir       [A.Isayev 6, 57, A.Aliyev 47 - Kvaratskhelia 7,
                                Mustafayev 33]
Turan        1-0 Vilash        [N.Sadygov 54 pen]


Round 7
Shamkir      2-2 Turan         [R.Ahmedov 72, 89 - Shaguliyev 21, Nabiyev 60]
Dalgich G    0-3 Bakili        [E.Mamedov 11, 84, Shahguseyni 90]
[played later]
Kapaz        5-0 Kimyachi      [Parvarov 23, Rzayev 25 pen, Tanryverdiyev 30,
                                G.Abdullayev 57, M.Gurbanov 71]
Dinamo       5-0 Shahdag       [Sultanov 2, N. Aliyev 5, 8, 17, 57]
Neftchi      2-2 Baki Fahlasi  [Kalfa 3, 52 - Vasilyev 16, Farzaliyev 85]
Vilash       2-1 OIK           [Asadov 65, Bakhshiyev 67 - A.Kurbanov 29]
Shafa        1-4 Garabag    

Name change: Neftegaz K becomes Shahdag.

Round 8
OIK          0-2 Garabagh      [Ya.Guseynov 70, M.Guseynov 85]
Kimyachi     3-1 Dalgich G     [I.Mamedov 55, A.Mamedov 64, A.Isayev 74 pen - 
                                J.Mamedov 83]
Vilash       3-0 Shamkir       [A.Bahramov 19, Nurullayev 54, Bahyshev 78]
Turan        1-1 Kapaz         [N.Sadygov 80 pen - Mardanov 86]
Bakili       0-2 Dinamo        [Askerov 45, N.Aliyev 53]
Shahdag      1-4 Neftchi       [Sh.Mamedov 66 - A.Ibragimov 2, Z.Ibragimov 7,
                                Guliyev 63, I.Mamedov 90]
Baki Fahlasi 1-0 Shafa         [Vasilyev 80]

Round 9
Shamkir      2-0 OIK           [S.Mamedov 56, Kerimov 90]
Kapaz        2-0 Vilash        [Mardanov 65, Ya.Suleymanov 85]
Dalgich G    1-2 Turan         [Babayev 86 - Sadygov 20 pen, Farhadov 43]
Neftchi      0-0 Bakili       
Garabagh     2-2 Baki Fahlasi  [M.Guseynov 58, Azimov 61 - Yagubaliyev 15, 
                                T.Mamedov 32]
Shafa        1-2 Shahdag       [F.Aliyev 3 - Niftaliyev 38, Hydyrov 51]
Dinamo       awd Kimyachi      [awarded 3-0, Kimyachi didn't appear]

Round 10
OIK          2-0 Baki Fahlasi  [Hankishiyev 36, H.Mamedov 72]
Shahdag      0-1 Garabagh      [Bagirov 78]
Vilash       1-0 Dalgich G     [Bahyshev 21]
Turan        2-0 Dinamo        [Shagudiyev 4, Gzdanov 25]
Shamkir      2-0 Kapaz         [Kvaratskhelia 33, 49]
Kimyachi     0-4 Neftchi       [Rahmanov 7, I.Mamedov 71, Mahmudov 75, B.Musayev 88]
[played later]
Bakili       2-1 Shafa         [V.Ganbarov 22, M.Shukurov 72 - F.Aliyev 85]

Round 11
Kapaz        3-0 OIK           [G.Abdullayev 4, 9, 34]
Dinamo       3-0 Vilash        [R.Mamedov 53, N.Aliyev 58, F.Ismailov 62]
Neftchi      1-1 Turan         [Kalfa 89 - Shauuliyev 53]
Dalgich G    0-2 Shamkir       [Kvaratskhelia 28, S.Mamedov 73]
Garabagh     2-0 Bakili        [Bagirov 38, 42]
Baki Fahlasi awd Shahdag       [awarded 3-0, Shahdag didn't appear]
[played later]
Shafa        0-1 Kimyachi

Round 12
Bakili       1-1 Baki Fahlasi  [Shahguseyni 89 - M.Aliyev 75]
Kimyachi     0-3 Garabagh      [Bagirov 14, 83, M.Guseynov 63]
Shamkir      2-0 Dinamo        [S.Mamedov 61, R.Ahmedov 79]
OIK          4-0 Shahdag       [K.Kerimov 8, 31, 90, Muslimov 64]
Kapaz        7-0 Dalgich G     [Rzayev 10, 71, 90, Abdullayev 17, Tayriverdiyev 19,
                                I.Suleymanov 30, Ya.Suleymanov 69]
Vilash       2-2 Neftchi       
[played later]
Turan        1-1 Shafa         [Aliyev 80 - Imamaliyev 56]

Round 13
Neftchi      2-0 Shamkir       [Kalfa 74, 88]
Garabagh     3-1 Turan         [Bagirov 60, 83, M.Guseynov 41 - Tsiklauri 45]
Dinamo       1-1 Kapaz         [Abdullayev 13 - Ismailov 59]
Baki Fahlasi 2-0 Kimyachi      [Vasilyev 44 pen, V.Gurbanov 63]
Dalgich G    1-2 OIK           [Veliyev 37 - F.Mamedov 62, Kerimov 89]
Shahdag      2-2 Bakili        [T.Mamedov 61, 90 - E.Mamedov 63, M.Gurbanov]
Shafa        2-2 Vilash        [Gajiyev 75, Sadygov 84 - Orujev 17, Asadov 40]

Name change: Dalgich-GNKAR becomes Neftegaz-GNKAR.

Round 14
Baki Fahlasi 5-1 Turan         [Yagubaliyev 10, Vasilyev 20, M.Aliyev 44, 
                                V.Gurbanov 45, Farzaliyev 79 - Madatov 58]
OIK          0-0 Bakili     
Shahdag      4-0 Kimyachi      [R.Guseynov 39, Niftaliyev 41, Sh.Mamedov 47, 57]
Neftchi      1-3 Kapaz         [Rakhmanov 85 - G.Abdullayev 14, Tayeryverdiyev 51,
                                Rzayev 58]
Garabagh     3-1 Vilash        [M.Guseynov 71, Bagirov 73, Gasanov 85 - Bakhramov 56]
Shamkir      1-0 Shafa         [Abbasov 47 og]
Dinamo       5-1 Neftegaz-G    [F.Ismailov 4, N.Aliyev 35, 65, 85, Sultanov 61 -
                                Agayev 74]
Round 15
Neftegaz-G   0-2 Neftchi       [Stukas 37, I.Mamedov 82]
Vilash       1-0 Baki Fahlasi  [Bakhramov 36]
Dinamo       1-1 OIK           [F.Ismailov 59 pen - Kh.Mamedov 38]
Shamkir      3-2 Garabagh   
Kapaz        6-0 Shafa      
Kimyachi     3-2 Bakili     
Turan        8-0 Shahdag   

Round 16
OIK          2-0 Kimyachi      [K.Kerimov 12, Hanzhigazov 71]
Bakili       0-0 Turan      
Shahdag      1-3 Vilash        [Mirzagayev 64 - Bahramov 3, 49, Veliyev 83]
Baki Fahlasi 1-0 Shamkir       [M.Aliyev 52 pen]
Neftchi      1-0 Dinamo        [Kalfa 39]
Garabagh     2-1 Kapaz         [M.Azimov 47 pen, 57 - Bagirov 57]
Shafa        4-0 Neftegaz-G    [S.Sadyhov 1, A.Gajiyev 26, 62, F.Aliyev 85]

Round 17
Neftchi      2-0 OIK           
Neftegaz-G   0-1 Garabagh
Shamkir      2-0 Shahdag   
Vilash       1-0 Bakili   
Turan        5-0 Kimyachi  
[played earlier]
Kapaz        4-1 Baki Fahlasi  [G.Abdullayev 14, 52, Rzayev 45 pen,
                                Tanryverdiyev 50 - Vasilyev 63 pen]
Dinamo       2-0 Shafa         [F.Ismailov 62, N.Aliyev 83]

Round 18
OIK          0-3 Turan          
Kimyachi     0-4 Vilash      
Baki Fahlasi 7-1 Neftegaz-G 
Shahdag      0-7 Kapaz   
Garabagh     2-1 Dinamo         
Shafa        1-3 Neftchi     
Bakili       0-5 Shamkir     

Round 19
Neftchi      0-0 Garabagh 
Vilash       1-0 Turan         [Alisanov 9]
Dinamo       1-0 Baki Fahlasi  [Askerov 88]
Shafa        2-2 OIK           [Sadihov 19, N.Aliyev 56 - Gulmaliyev 29, H.Mamedov 87]
Neftegaz     1-1 Shahdag       [Agayev 51 - Niftaliyev 30]
Kapaz        awd Bakili        [awarded 3-0]
Shamkir      awd Kimyachi      [awarded 3-0]

Round 20
Kimyachi     0-4 Kapaz         [A.Mamedov 16, 75, Ya.Suleymanov 46, Rzayev 83]
Bakili       1-1 Neftegaz      [Gambarov 88 - Agayev 89]
Garabagh     2-0 Shafa         [Bagirov 70, 90]
OIK          0-0 Vilash   
Baki Fahlasi 0-0 Neftchi
Turan        awd Shamkir       [awarded 3-0]
Shahdag      1-2 Dinamo

Round 21
Neftchi     11-0 Shahdag       [Musayev 7, Kalfa 12, 27, 44, 79, 83, I.Mamedov 
                                13, 47, Getman 37, Ibragimov 72, Kuliyev 87]
Neftegaz     2-0 Kimyachi      [Nasibov 28, Balakisiyev 61]
Kapaz        1-1 Turan         [Kress 80 - Abdullayev 88]
Shamkir      1-0 Vilash        [Ocagverdiyev 84 pen]
Garabagh     3-1 OIK
Dinamo       2-1 Bakili
Shafa        0-1 Baki Fahlasi

Round 22
OIK          lt  Shamkir       [1-1?]
Vilash       3-0 Kapaz   
Turan        1-0 Neftegaz
Bakili       1-3 Neftchi   
Baki Fahlasi 4-2 Garabagh  
Shahdag      1-1 Shafa    
Kimyachi     0-3 Dinamo  

Round 23
Baki Fahlasi 2-1 OIK
Garabagh     bt  Shahdag  
Neftegaz     2-3 Vilash  
Dinamo       drw Turan  
Kapaz        1-0 Shamkir    
Neftchi      6-0 Kimyachi   
Shafa        1-2 Bakili   

Round 24
OIK          drw Kapaz  
Vilash       2-3 Dinamo  
Turan        0-1 Neftchi  
Shamkir      3-0 Neftegaz
Bakili       drw Garabagh 
Shahdag      1-2 Baki Fahlasi 
Kimyachi     1-3 Shafa

Round 25
Baki Fahlasi 1-0 Bakili        [M.Eminov 11]
Garabagh     5-0 Kimyachi      [M.Azimov 29, 32, M.Guseynov 61, 79, 89]
Neftchi      2-1 Vilash        [B.Musayev 54, Alibabayev 85 - Bahsiyev 58]
Dinamo       4-1 Shamkir       [F.Ismaylov 39, 79, S.Musayev 50,
                                Sultanov 52 - R.Ahmedov 89]
Neftegaz     1-3 Kapaz         [S.Mamedov 60 - Mardanov 14,
                                I.Suleymanov 37, G.Abdullayev 81]
Shafa        0-2 Turan         [Aliyev 38, N.Sadigov 42 pen]
Shahdag      lt  OIK

Round 26
OIK          1-2 Neftegaz      [S.Aliyev 86 - G.Agayev 30, R.Nasibov 64]
Kapaz        2-0 Dinamo        [Parvarov 37, V.Rzayev 60 pen]
Shamkir      1-1 Neftchi       [Kvaratskhelia 64 - Z.Ismaylov 43]
Vilash       3-0 Shafa         [A.Bahramov 30, 44, 86]
Turan        bt  Garabagh
Kimyachi     lt  Baki Fahlasi
Bakili       bt  Shahdag

Table:

 1.Kapaz (Ganja)           26 18  4  4 77-17 58        [-1]  
 2.Garabagh (Aghdam)       26 17  3  6 45-21 54        [-3] 
 3.Dinamo (Baki)           26 16  4  6 46-20 52        [-1]
 4.Neftchi (Baki)          26 15  7  4 57-18 52 
 5.Shamkir (Shamkir)       26 16  2  8 42-24 50        [-1]  
 6.Baki Fahlasi (Baki)     26 15  5  6 46-25 50        [-1]
- - - - - - - - - - - - - - - - - - - - - - - -
 7.Turan (Tovuz)           26 14  7  5 42-21 49        [-2]
 8.Vilash (Masalli)        26 14  4  8 39-25 46
 9.Bakili (Baki)           26  7  7 12 18-33 28        [-2]  
10.OIK (Baki)              26  6  8 12 20-29 26        [-3] 
11.Kimyachi (Sumgayit)     26  5  1 20 20-70 16  [*]   [-1]  
12.Shafa (Baki)            26  3  5 18 24-54 14
13.Shahdag (Kusari)        26  2  4 20 20-86 10  [+]   [-3]
14.Neftegaz-GNKAR (Baki)   26  2  3 21 15-68  9  [x]

Top-6 qualified to final stage.

[*] changed name from Sumgayit to Kimyachi before season.
[+] changed name from Neftegaz to Shahdag during season.
[x] changed name from Dalgich to Dalgich-GNKAR and then to Neftegaz-GNKAR
    during season.

[-1] missing goal difference from 1 match
[-2] missing goal difference from 2 matches
[-3] missing goal difference from 3 matches

[NB: OIK is the Azeri rendering of SKA]

Top Scorers:
------------
18 - Rzayev (Kapaz)
16 - Vasilyev (Baki Fahlasi)
14 - G.Abdullayev (Kapaz)
     A.Bahramov (Vilash)
     M.Guseynov (Garabagh)


Championship Playoff

Name change: Baki Fahlasi to ANS Pivani.

Table:
 
 1.Kapaz (Ganja)           10  8  1  1 17- 7 25  Champions
 2.FK Shamkir (Shamkir)    10  5  1  4 10-10 16
 3.Neftchi (Baki)          10  4  3  3 11- 7 15
 5.Garabagh (Aghdam)       10  3  3  4  5- 8 12  
 4.ANS Pivani (Baki)       10  2  3  5  5- 8  9
 6.Dinamo (Baki)           10  2  1  7  6-14  7

Round 1
Garabagh   0-0 Dinamo
Shamkir    drw Kapaz
ANS Pivani drw Neftchi
  
Round 2  
Garabagh   0-2 Kapaz      [Yu.Guseynov 58, 61]
Dinamo     1-0 ANS Pivani [A.Alekperov 65]
Neftchi    1-0 Shamkir    [K.Guliyev 8]
  
Round 3
ANS Pivani 2-0 Garabagh   [Vasilyev 18, T.Mamedov 83]
Kapaz      1-0 Neftchi    [I.Suleymanov 88 pen]
Shamkir    2-1 Dinamo     [Yunusov 36, Ibragimov 51 - R.Guseynov 49]
 
Round 4
Garabagh   bt  Neftchi    [1-0 or 2-0]
ANS Pivani bt  Shamkir
Dinamo     0-1 Kapaz   

Round 5
Kapaz      bt  ANS Pivani
Shamkir    1-0 Garabagh
Neftchi    bt  Dinamo     [1-0 or 2-0]

Round 6
Dinamo     lt  Garabagh   [0-3 or 0-2]
Kapaz      bt  Shamkir
Neftchi    drw ANS Pivani
  
Round 7
Kapaz      3-0 Garabagh   [A.Mamedov 27, Kerdzevadze 56, Bespalih 82]
Shamkir    3-2 Neftchi    [M.Ibragimov 5, Kvaratskhelia 21, Gabisonia 43 -  
                           Stukas 50 og, I.Mamedov 66]
ANS Pivani 0-2 Dinamo     [R.Mamedov 3, F.Ismailov 90]

Round 8
Garabagh   0-0 ANS Pivani
Dinamo     0-1 Shamkir    [B.Kvaratskhelia 67]
Neftchi    3-0 Kapaz      [K.Guliyev 11, I.Mamedov 51, 53]
  
Round 9
Neftchi    0-0 Garabagh
Shamkir    1-0 ANS Pivani [Ocagverdiyev 90]
Kapaz      3-1 Dinamo     [G.Abdullayev 56, 72, Yu.Guseynov 83 - S.Musayev 73]  

Round 10 
ANS Pivani 1-2 Kapaz      [Vasilyev 6 - Kerdzevadze 82, 89]
Garabagh   1-0 Shamkir    [Hankisev 6 pen]
Dinamo     1-3 Neftchi    [A.Ismailov 88 - Niftaliyev 21, Z.Ismailov 40, Alibabayev 80] 

Table:
 
 1.Kapaz (Ganja)           10  8  1  1 17- 7 25  Champions
 2.FK Shamkir (Shamkir)    10  5  1  4 10-10 16
 3.Neftchi (Baki)          10  4  3  3 11- 7 15
 5.Garabagh (Aghdam)       10  3  3  4  5- 8 12  
 4.ANS Pivani (Baki)       10  2  3  5  5- 8  9
 6.Dinamo (Baki)           10  2  1  7  6-14  7

Name change: Baki Fahlasi to ANS Pivani.

Top Scorers: 
------------ 
24 - Bahramov (Vilash)
19 - Vasilyev (ANS Pivani)
18 - Rzayev (Kapaz)
  
For places 7 to 10:
  
 7.Turan Tovuz         6   4  2  0  17- 6  14
 8.Vilash Masalli      6   2  3  1  16-12   9
 9.OIK Baki            6   2  3  1   8- 7   9
10.Bakili Baki         6   0  0  6   0-16   0 
  
Relegation Play-off:
  
11.Shafa Baki          4   3  1  0  12- 3  10
12.Kimyachi Sumgayit   4   1  2  1   9- 9   5 
---------------------------------------------
13.Neftegaz Baki       4   0  1  3   3-12   1  Relegated
  
Shahdagh Kusari withdrew after the first stage and relegated.

NB: after the season Bakili were demoted because of financial problem 
    and Hazar University Baki promoted.



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

Last updated: 28 Sep 2005

(C) Copyright Mike Dryomin and RSSSF 1999/2005						


  USO DE MEMORIA  
4,279,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0970
Total Execution Time  0.0994
  CADENA URL  
/premier_league_azerbayan1999
  GET DATOS  
$_GET['/premier_league_azerbayan1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_azerbayan1999'
0.0041  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=2486
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 = 30741 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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='1999' WHERE c.parentId=396 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:18:05' 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 12:18:05' 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 12:18:05' 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 12:18:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30741) 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.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 (30741) 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 events1999 e WHERE e.league_id IN (30741) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (30741) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30741) AND (e.action IN (3,4) ) 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 (30741) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30741) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (30741) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 30741 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 30741 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0027  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=30741 AND rel.round=26
0.0022  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 = 30741 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  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 = 30741 AND esl.points > 0
0.0021  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` = 30741 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  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` = 30741
0.0020  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 `calendars1999` 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` = 30741 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 `events1999` e INNER JOIN calendars1999 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 = 30741 ORDER BY total DESC LIMIT 40
0.0024  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 `events1999` e INNER JOIN calendars1999 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 = 30741 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0032  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 `tables1999` 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 = 30741 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 30741 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 30741 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0032  SELECT data1, data2 FROM services_tags WHERE categoryId=396
0.0032  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 396 AND l.year = 1999 ORDER BY l.group_code ASC
0.0032  SELECT group_code, extraName from `leagues` WHERE categoryId=396 AND year=1999