4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Nueva Caledonia 2001
2000/2001

Liga Nueva Caledonia 2001

Información Histórica
						
National Championship 2001

3 clubs from province Nord; 3 from Sud; 1 from Lifou; 1 from Ouvéa

Qualifiers Nord:
ACB Poya        
JS Baco         
CS Nékoué [Houailou] 

Qualifiers Sud:
AS Magenta [Nouméa]        
Mont-Dore
AS Auteuil                    

Qualifiers Inter-Îles
AS Qanono (champions inter-îles; champions Lifou)
US Pénélo-Cuaden (runners-up inter-îles; champions Maré/Ouvéa(?))

NB: all 6 participants from Nord and Sud are qualified for the championship
    of Grande Terre 2002 (together with Tiéta (Nord) and Thio Sport (Sud)).

Quarterfinals

First Legs [Sep 9]
Auteuil         2-2     Poya
Mont-Dore       0-0     Qanono
Baco            bt      Pénélo-Cuaden      [forfait Pénélo-Cuaden]
Magenta         3-2     Nékoué

Second Legs [Sep 23?]
Poya            2-0     Auteuil
Qanono          0-1     Mont-Dore
Nékoué          1-4     Magenta

Semifinals

First Legs [Oct 7]
Mont-Dore       2-2     Magenta
Poya            1-1     Baco

Second Legs [Oct 27]
Magenta         0-1     Mont-Dore
Baco            1-1     Poya               [abd in extra time due to poor light]

Second Leg Replay [Koné, Nov 3]
Baco            3-2     Poya

Final [Stade Numa-Daly, Nouméa, Nov 18?]
Mont-Dore       0-1     Baco


Championnats de Promotion d'Honneur

[4-2-1 points system]

Provincial Championships

Province Nord

Zone Ouest (Poule A)

Round 1 
Poum         awd Tchambouene     [awarded 3-0, forfeit] 
Poya         4-1 Koumac 
Mahamate     5-5 Tiéta 
Baco         bye

Round 2 
Baco         6-0 Mahamate 
Poya         5-3 Poum 
Koumac       1-4 Tiéta 
Tchambouene  bye

Round 3 
Tchambouene  awd Mahamate        [awarded 0-4 to Mahamate; originally 9-4] 
Poum         4-3 Koumac 
Tiéta        2-3 Baco 
Poya         bye

Round 4
Tiéta        5-2 Tchambouene
Poya         1-1 Baco 
Poum         9-2 Mahamate 
Koumac       bye

Round 5
Mahamate     5-1 Koumac
Tchambouene  1-2 Baco
Tiéta        1-2 Poya 
Poum         bye

Round 6
Mahamate     1-6 Poya
Baco         awd Poum           [abandoned, awarded to Baco]
Tchambouene  2-3 Koumac
Tiéta        bye

Round 7
Baco          -  Koumac     
Tiéta         -  Poum
Poya          -  Tchambouene
Mahamate     bye

Round 8 [May 6] 
Poum         3-3 Tchambouène   
Tiéta        2-2 Mahamate 
Poya         3-2 Koumac 
Baco         bye 

Round 9
Poum         3-1 Poya
Mahamate      -  Baco
Tiéta         -  Koumac
Tchambouene  bye

Round 10
Mahamate      -  Tchambouene
Koumac       2-0 Poum         
Baco          -  Tiéta
Poya         bye

Round 11 [May 27?] 
Poum         6-2 Mahamate 
Baco         1-0 Poya 
Tiéta         -  Tchambouene
Koumac       bye

Round 12
RS Koumac    3-0 AS Mahamate
JS Baco      2-2 Tchambouene
ACB Poya     2-0 JS Tieta 
AS Poum      bye

Round 13
ACB Poya     8-0 AS Mahamate 
RS Koumac    3-0 AS Tchambouene
AS Poum      3-1 JS Baco
JS Tiéta     bye 

Round 14
Baco         2-1 Koumac     
Tiéta        1-1 Poum
Poya         7-1 Tchambouene
Mahamate     bye

Final Table (unofficial):

 1.ACB Poya          12  9  1  2 41-15 40  Qualified
 2.JS Baco           12  7  4  1 24-13 37  Qualified
- - - - - - - - - - - - - - - - - - - - -
 3.AS Poum           12  7  2  3 39-24 34  [-1]
 4.JS Tiéta          12  4  4  4 31-27 28
- - - - - - - - - - - - - - - - - - - - -
 5.RS Koumac         12  4  1  7 25-31 24  [-1]     
-----------------------------------------
 6.AS Mahamate       12  2  3  7 24-51 21
 7.Tchambouène       12  0  3  9 16-39 13  [-2]

NB: AS Mahamate and Tchambouène were relegted to the new 3rd level

NB: Poum 1 point deducted after having been awarded a loss in round 6
    Koumac 1 point deducted after having been awarded a loss in one match
    Tchambouène 1 point deducted due to forfait and
                1 due to award round 3
    ACB (Poya) abbreviates Amicale Croix Bleue

Zone Est (Poule B)

 1.CS Nékoué [Houailou]   
 2.ASLN Kouaoua
- - - - - - - - - - - -
 3.FC Koh
 4.Sporting Ponérihouen 
- - - - - - - - - - - -
 5.Entente Gélima

Province Nord Playoffs
Baco         2-1 Koumac     

Poule des As 

Semifinals

First Legs [Aug 11, stade Yoshida, Koné]
Poya         3-0 Kouaoua
Baco         2-1 Nékoué

Second Legs [Aug 15, stade Yoshida, Koné]
Poya          -  Kouaoua
Baco         2-0 Nékoué

Final
Poya          -  Nékoué

Third Place Match
Baco         bt  Kouaoua

Poya, Nékoué and Baco qualified for the playoffs for the New Caledonian title.


Fifth Place Poule 

Matches Aug 11 were scheduled at field Pomémi, but this turned
out to be unplayable.

First Legs [Aug 11, stade Yoshida, Koné]
Poum         abd Ponérihouen  [abandoned at 1-0 at half-time (darkness)]
Tiéta        n/p Koh

Ponérihouen were replaced by Gélima.

First Legs [Aug 15, stade Yoshida, Koné]
Poum          -  Entente Gélima
Tiéta         -  Koh


NB: Tiéta qualified for the Grande Terre championship 2002.


Province Sud 

First Stage (13 rounds, all-play-all)

Round 1 [Mar 3,4] 
Olympique    0-3 Gaïtcha
Lossi        3-4 Yaté
Thio-Sport   0-2 Mont-Dore 
Kouergoa     1-4 St Louis
Unia         0-5 Auteuil
Magenta      8-3 AC Thio 
USC          2-1 Païta

Round 2 [Mar 10,11] 
Magenta      3-2 Auteuil 
USC          1-3 Mont-Dore 
Lossi        2-4 AC Thio 
Unia         1-4 Saint-Louis 
Kouergoa     0-0 Paita 
Gaitcha      6-2 Yaté 
Olympique    2-3 Thio Sport 

Round 3 [Mar 17,18] 
Olympique    1-1 USC 
Gaitcha      1-1 Thio Sport 
Lossi        2-5 Auteuil 
Magenta      6-1 St. Louis 
AC Thio      2-1 Yaté 
Kouergoa     0-3 Mont-Dore 
Unia         drw Paita 

Round 4 [Mar 24,25] 
Olympique    2-1 Kouergoa 
Gaïtcha      4-0 USC 
Thio Sport   4-1 Yaté 
AC Thio      0-1 Auteuil 
Espoir       1-2 Mont-Dore 
Lossi        1-2 Saint-Louis 
Magenta      5-0 Païta 

Round 5 [Mar 31-Apr 1] 
Olympique    2-4 Unia 
Gaitcha      1-1 Kouergoa 
Thio Sport   1-2 USC 
AC Thio      0-0 St.-Louis 
Lossi        4-5 Paita 
Auteuil      2-0 Yaté 
Magenta      1-0 Mont-Dore 

Round 6 [Apr 7,8] 
USC          0-3 Yaté 
Auteuil      2-1 St.-Louis 
AC Thio      1-3 Paita 
Thio Sport   3-0 Kouergoa 
Lossi        2-3 Mont-Dore 
Olympique    1-5 Magenta 
Gaitcha      7-3 Unia 

Round 7 [Apr 21,22]
Olympique    7-1 Lossi
Gaitcha      1-2 Magenta
St.-Louis    4-2 Yaté
AC Thio      1-1 Mont-Dore
Thio Sport   3-1 Unia
USC          1-0 Kouergoa
Auteuil      4-2 Paita

Round 8 [Apr 28,29]
Olympique    3-1 AC Thio
USC          2-1 Unia
Thio Sport   1-2 Magenta
Gaitcha      2-3 Lossi
Kouergoa     6-1 Yaté
St.-Louis    3-1 Paita
Auteuil      0-1 Mont-Dore

Round 9
Thio Sport   5-4 Lössi  
Gaitcha      2-2 AC Thio
Paita        2-2 Yaté
Kouergoa     3-1 Unia
Mont Dore    2-0 St.-Louis
USC          1-2 Magenta      [0-1?]
Olympique    0-0 Auteuil

Round 10 [May 12]
Kouergoa     0-3 Magenta
Gaitcha      4-0 Auteuil
Thio Sport   1-4 AC Thio
St.-Louis    2-0 Olympique
USC          2-1 Lössi
Unia         1-1 Yaté
Mont Dore    3-1 Paita

Round 11 [May 19,20]
Magenta      3-1 Unia
Thio Sport   4-4 Auteuil
Mont-Dore    1-0 Yaté
Gaitcha      3-0 St. Louis    
USC          5-0 AC Thio      
Lossi        bt  Kouergoa
Paita        lt  Olympique

Round 12 [May 26,27] 
Olympique    0-1 Mont Dore 
USC          1-2 Auteuil 
Thio Sport   5-0 St. Louis
Magenta      4-2 Yaté 
Gaitcha      2-0 Paita   
Unia         lt  Lossi
Kouergoa     bt  AC Thio          

Round 13 [Jun 2,3]
Thio Sport   7-1 Paita
USC          1-2 St. Louis
Gaitcha      1-1 Mont Dore    
Magenta      1-2 Lossi
Kouergoa     2-3 Auteuil
Unia         1-1 AC Thio       
Olympique    w/o Yaté             [Yaté forfeited, awarded 2-0]

Table:

 1.AS Magenta        13 12  0  1 45-15 49  [Nouméa]
 2.Mont-Dore         13 10  2  1 23- 8 45
 3.AS Auteuil        13  8  2  3 30-20 39
 4.FC Gaïtcha        13  7  4  2 37-15 38  [Nouméa]  
 5.Thio Sport        13  7  2  4 38-24 36
 6.CA Saint Louis    13  7  1  5 23-25 35  [Nouméa]  
- - - - - - - - - - - - - - - - - - - - -
 7.USC               13  6  1  6 19-21 32  [Nouméa]  
 8.Olympique         13  5  2  6 20-22 30  [Nouméa]  [*11]
 9.AC Thio           13  3  4  6 19-28 26            [*12]
10.AS Lôssi          13  4  0  9 25-40 25  [Nouméa]  [*11,*12]
11.US Kouergoa       13  3  2  8 14-22 24            [*11,*12]
12.AS Païta          13  2  3  8 16-33 22            [*3,*11]
13.UAC Yaté          13  2  2  9 19-37 20  [-1 forfait]
14.Espoir Unia       13  1  3  9 15-33 19            [*3,*12]
                                
[*i] w/o goals rd i

Second Phase

Championship Group ('Phase II')

Round 1 
[Jun 9,10] 
Auteuil      0-0 Mont-Dore
Gaïtcha      0-1 Magenta
[Jul]
Saint-Louis  1-2 Thio Sport

Round 2 [Jun 17]
Auteuil      3-1 St Louis
Mont-Dore    2-1 Magenta 
Thio Sport   2-1 Gaitcha

Round 3 [Jun 24]
Auteuil      2-1 Gaïtcha
Saint-Louis  1-3 Mont-Dore
Thio Sport   2-2 Magenta

Round 4 [Jun 29,30]
Mont-Dore    3-3 Gaïtcha    
Saint-Louis  2-3 Magenta    
Thio Sport   2-0 Auteuil    [first abandoned at 2-6?]

Round 5 
[Jul 5] 
Saint-Louis  1-1 Gaitcha 
Auteuil      3-3 Magenta 
[Jul 7] 
Thio Sport   1-1 Mont-Dore 

Round 6 [Jul 20,21]
Auteuil      0-0 Mont-Dore
Magenta      1-1 Gaïtcha 
Thio Sport   2-4 Saint-Louis 

Round 7 [Jul 27]
Gaitcha      0-0 Thio Sport
Magenta      2-1 Mont-Dore
Auteuil      3-1 St.-Louis

Round 8 
[Aug 1?] 
Mont-Dore    2-0 St.-Louis 
[Aug 3] 
Magenta      4-0 Thio Sport 
Gaitcha      1-1 Auteuil 

Round 9
Gaïtcha      1-1 Mont-Dore 
Auteuil      3-2 Thio Sport 
Magenta      2-0 Saint-Louis

Round 10 [Aug 17?]
Mont-Dore    3-1 Thio Sport
Magenta      5-2 Auteuil
Gaitcha      ppd Saint-Louis

Final Table:

 1.AS Magenta        23 18  3  2 69-28 80  [Nouméa]        
 2.Mont-Dore         23 14  7  2 39-18 72
 3.AS Auteuil        23 12  6  5 47-36 66  [49-38?]                      
 4.Thio Sport        23 10  5  8 52-43 58 
 5.FC Gaïtcha        22  7 10  5 46-27 53  [Nouméa]  
 6.CA Saint Louis    22  8  2 12 34-46 47  [*1] [Nouméa] 

[*1] St Louis 1 point deducted

AS Magenta champions province Sud; top-3 qualified for championship playoffs

NB: Thio Sport qualified for the Grande Terre championship 2002.

Relegation Group ('Phase III')

Round 1 [Jun 9,10] 
AC Thio      1-0 Kouergoa
Paita        1-1 Olympique
USC          2-1 Lossi
Yaté         n/p Unia         [both teams forfeited, awarded 0-2 against both]

Round 2 [Jun 17]
Kouergoa     1-3 USC
Olympique    8-2 Unia
Lossi        6-3 Yaté
AC Thio      ppd Paita

Round 3 [Jun 24]
AC Thio      1-4 Unia
Kouergoa     0-0 Païta
Olympique    5-1 Lössi
USC          2-1 Yaté

Round 4 [Jun 29,30]
AC Thio      awd Yaté         [awarded 3-0 (?); forfait Yaté]
Kouergoa     ppd Unia 
USC          ppd Olympique  
AS Païta     ppd Lôssi 

Round 5 [Jul 7] 
AC Thio      4-0 Yaté
Kouergoa     4-4 Unia 
USC          1-1 Olympique 
Paita        1-1 Lôssi 

Round 6 [Jul 20,21]
AC Thio      ppd USC
Kouergoa     ppd Lôssi
Olympique    6-1 Yaté
Paita        0-2 Unia

Round 7 [Jul 28]
AC Thio      1-0 Lôssi
AS Paita     0-3 Yaté
USC          2-3 Unia
Kouergoa     ppd Olympique

Round 8
[Aug 4] 
AC Thio      3-2 Olympique 
Kouergoa     2-1 Yaté 

Round 9
Kouergoa     unk AC Thio 
Olympique    1-2 AS Païta 
Lossi        unk USC

Table:

 7.Olympique         20  8  4  8 44-33 48  [Nouméa]     [*11]     [55-36?]   
 8.USC               18  9  2  7 29-28 47  [Nouméa]               [28-27?] 
 9.AC Thio           19  8  4  7 32-34 47               [*12]     [34-37?]
10.US Kouergoa       18  4  4 10 21-31 34               [*11,*12] [23-36?]
11.AS Lôssi          18  5  1 12 34-52 34  [Nouméa]     [*11,*12] [41-55?]
12.Espoir Unia       19  4  4 11 30-50 34  [-1 forfait] [*3,*12]  [36-58?]
13.AS Païta          19  3  6 10 20-41 34               [*3,*11]  [24-52?]
14.UAC Yaté          21  3  2 16 28-62 28  [-3 forfaits]          [28-63?]

NB: Thio vs Yaté included in table although status unclear

[*i] w/o goals rd i

Eventually relegated: US Kouergoa, Espoir Unia, UAC Yaté
Promoted from districts: JS Ouvéa (Nouméa), Entente du Sud (Sud) 
                         and CMO La Foa (Sud-Ouest).


Championship Inter-Îles

Final
Qanono       bt  Pénélo-Cuaden


Lifou Island 

Round 1 [Mar 31] 
Qanono       6-1 Hmelek 
Luecilla     1-1 Wedrumel 
Sissi        1-7 Ponoz 
Traput       5-2 Bethel    
Kirikitr     bye 

Round 2
Traput       3-2 Ponoz 
Bethel       2-5 Kirikitr 
Qanono       2-1 Luecilla 
Wedrumel     8-0 Sissi
Hmelek       bye

Round 3
Traput       1-1 Kirikitr
Qanono       4-0 Wedrumel 
Luecilla     4-2 Sissi 
Hmelek       4-3 Ponoz 
Bethel       bye

Round 4
Qanono       6-0 Sissi
Traput       1-1 Luecilla
Kirikitr     5-2 Hmelek
Bethel       bt  Ponoz
Wedrumel     bye

Round 5 
Kirikitr     1-1 Wedrumel 
Luecilla     3-3 Ponoz 
Qanono       0-0 Traput 
Bethel      11-3 Hmelek   
Sissi        bye 

Round 6 [May 8]
Wedrumel     1-0 Ponoz
Qanono       1-2 Bethel
Sissi        0-7 Kirikitr
Traput       2-1 Hmelek
Luecilla     bye

Round 7 [May 15,16] 
Luecilla     drw Bethel 
Hmelek       drw Sissi 
Wedrumel     lt  Traput 
Qanono       1-0 Kirikitr 
Ponoz        bye 

Round 8
Ponoz        2-4 Qanono
Bethel       bt  Sissi
Hmelek       lt  Wedrumel
Kirikitr     lt  Luecilla     
Traput       bye

Round 9
Traput       bt  Sissi
Wedrumel     bt  Béthel
Luecilla     bt  Hmelek
Ponoz        lt  Kirikitr   
Qanono       bye

Round 10 [stade de Hnassé]
[May 29]
Qanono       3-0 Hmelek
Luécilla     3-2 Wedrumel
[May 30]
Sissi        2-7 Ponoz
Traput       0-0 Béthel
Kirikitr     bye

Round 11
Bethel       2-2 Kirikitr 
Luecila      3-0 Qanono 
Sissi        2-0 Wedrumel 
Traput       2-0 Ponoz 
Hmelek       bye

Round 12
Traput       lt  Kirikitr
Qanono       bt  Wedrumel 
Luecilla     bt  Sissi 
Hmelek       bt  Ponoz    
Bethel       bye

Round 13
Qanono       4-2 Sissi
Traput       3-2 Luecilla
Kirikitr     4-1 Hmelek
Bethel       3-3 Ponoz
Wedrumel     bye

Round 14 
Wedrumel     drw Kirikitr
Ponoz        lt  Luecilla     
Traput       drw Qanono
Hmelek       drw Bethel     
Sissi        bye 

Round 15
Ponoz        bt  Wedrumel
Bethel       lt  Qanono    
Kirikitr     bt  Sissi
Hmelek       lt  Traput 
Luecilla     bye

Round 16 [Jul ?] 
Wedrumel     2-5 Traput 
Qanono       1-1 Kirikitr 
Luécilla     2-2 Béthel 
Hmelek       3-0 Sissi 
Ponoz        bye 

Table:

 1.AS Qanono         15 10  3  2 39-14 48
 2.JS Traput         15  9  5  1 42-16 47  
 3.Kirikitr          14  7  5  2 44-13 40  
 4.Luécilla          14  7  5  2 32-20 40  [*] 
 5.Béthel            14  4  6  4 38-35 32   
 6.Wedrumel          14  4  3  7 27-28 29    
 7.AS Ponoz (Wé)     14  3  2  9 35-42 25        
 8.Hmelek            14  3  2  9 28-52 25  
 9.Sissi             14  1  1 12 11-66 18 

NB: total GD +10; mistake possibly with Kirikitr (34-13?)

[*] formerly known as Wé-Luecilla - apparently a playing cooperation between
    teams from the two places (which are close to each other) was disbanded

AS Qanono won Lifou title and qualified for championship playoffs
Sissi and Ponoz were relegated, Neibac and Inagoj promoted.





Author: Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 25 Jul 2002

(C) Copyright Hans Schöggl and RSSSF 2001/02
						


  USO DE MEMORIA  
4,271,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0733
Total Execution Time  0.0752
  CADENA URL  
/liga_nueva_caledonia2001
  GET DATOS  
$_GET['/liga_nueva_caledonia2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_nueva_caledonia2001'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nueva_caledonia' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1718 AND type_rel = 3
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=2356
0.0019  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 = 30586 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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=1718 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 1718 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 23:49:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 23:49:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 23:49:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 23:49:54' 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 = 'liga_nueva_caledonia' 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.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=30586 AND rel.round=12
0.0018  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 = 30586 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 30586 AND esl.points > 0
0.0018  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-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30586 ORDER BY creation_date DESC LIMIT 0, 10
0.0021  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-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30586
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 `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` = 30586 AND c.`round` = 12 ORDER BY shedule ASC LIMIT 200
0.0021  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 = 12 AND e.real_date IS NOT NULL AND e.league_id = 30586 ORDER BY total DESC LIMIT 40
0.0019  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 = 30586 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 = 30586 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 30586 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  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-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 30586 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=1718
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=1718 AND year=2001