4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2002
Temporada Siguiente »
Publicidad 600x120.gif
Premier League Nigeria 2002
2001/2002

Premier League Nigeria 2002

Información Histórica 
						
Table:

 1.Enyimba (Aba)                  34 18  7  9  34-19  61  [*]       Champions
 2.Enugu Rangers                  34 17  6 11  42-30  57  [41-29?]  Runners-Up
 3.Kano Pillars                   34 17  5 12  40-35  56  [*]
 4.Iwuanyanwu Nationale (Owerri)  34 17  3 14  41-31  54  [56 pts?]
 5.Bendel Insurance (Benin City)  34 15  8 11  35-27  53  [35-28?]
 6.Julius Berger (Lagos)          34 15  7 12  32-25  52  [32-24?] [*]
 7.Sunshine Stars (Akure)         34 15  5 14  36-34  50
 8.Gombe United (Bauchi)          34 16  1 17  36-43  49
 9.Port Harcourt Sharks           34 13  9 12  41-39  48  [47 pts?] [*]
10.Wikki Tourists (Bauchi)        34 15  3 16  33-34  48  [*]
11.Gabros International           34 15  2 17  31-36  47  [*]
12.Lobi Stars FC (Makurdi)        34 14  4 15  34-37  46
13.Jigawa Golden Stars            34 14  4 16  33-37  46  [*]
14.Plateau United (Jos)           34 13  5 16  28-29  44  [28-27?] [*]
--------------------------------------------------------
15.NPA (Warri)                    34 10 11 13  26-29  41  [*]  Relegated
16.Yobe Desert Stars (Damaturu)   34 11  6 17  26-36  39  [#] [40 pts?]  Relegated
17.El-Kanemi Warriors (Maiduguri) 34 10  9 15  24-33  39  [*]  Relegated
18.Jasper United (Onitsha)        34  9  8 17  23-48  35  [34 pts?]   Relegated

[*] w/o goals Berger vs Plateau, Berger vs Gabros, Enyimba vs Berger,
    Wikki vs Sharks, Jigawa vs Pillars, NPA vs Pillars, El-Kanemi vs Wikki,
    El-Kanemi vs Plateau
[#] Yobe Desert Stars DFC played home matches in Maiduguri, Makurdi, 
    Kaduna and Bauchi

NB: total goal difference -7; Nationale are reported to have finished with
    56 points, Sharks 47, Yobe 40, Jasper 34; possibly Jasper vs Nationale
    (round 21) was later awarded an away win.

NB: there is no top-4 Super League playoff to decide the championship
    this season

Round 1 [Dec 16]
Nationale	2-0 Pillars
Gombe		0-2 Enyimba
Berger		3-2 Rangers
Sharks		2-1 Jasper
Jigawa		1-1 Sunshine
Gabros		1-0 Lobi
Wikki		2-0 NPA
El-Kanemi	1-0 Insurance
Plateau		3-1 Yobe

Round 2 
[Dec 23]
Yobe            1-1 Gombe 
Insurance       1-1 Plateau 
Pillars         2-1 El-Kanemi 
Rangers         1-0 Nationale 
Enyimba         1-0 Gabros 
NPA             1-0 Sharks 
Sunshine        2-0 Wikki 
Lobi            3-1 Jigawa 
[Dec 26]
Jasper          0-1 Berger

Round 3 [Dec 30]
Wikki		2-0 Lobi
El-Kanemi	1-0 Rangers
Gombe		0-2 Insurance
Jigawa		1-1 Enyimba
Berger		3-0 Sharks
Plateau		1-2 Pillars
Gabros		2-0 Yobe
Nationale	3-0 Jasper
Sunshine	1-0 NPA

Round 4 [Jan 6,7]
NPA             2-2 Berger
Lobi            3-1 Sunshine
Enyimba         1-0 Wikki
Yobe            1-0 Jigawa
Insurance       3-0 Gabros
Pillars         2-0 Gombe
Rangers         1-0 Plateau
Jasper          1-0 El-Kanemi
Sharks          1-1 Nationale

Round 5 [Jan 13,14]
Nationale       1-0 Berger  
El-Kanemi       3-1 Sharks  
Sunshine        0-0 Enyimba  
Gabros          1-0 Pillars  
Gombe           2-1 Rangers 
Jigawa          1-0 Insurance  
Plateau         3-0 Jasper  
Wikki           2-1 Yobe  
Lobi            1-0 NPA 

Table:

 1.Enyimba (Aba)                   5  3  2  0   5- 1  11
 2.Iwuanyanwu Nationale (Owerri)   5  3  1  1   7- 2  10 
 3.Julius Berger (Lagos)           5  3  1  1   9- 5  10          
 4.Lobi Stars FC (Makurdi)         5  3  0  2   7- 5   9
 5.El Kanemi Warriors (Maiduguri)  5  3  0  2   6- 4   9       
 6.Wikki Tourists (Bauchi)         5  3  0  2   6- 4   9
 7.Kano Pillars                    5  3  0  2   6- 5   9  
 8.Gabros International            5  3  0  2   4- 4   9
 9.Sunshine Stars (Akure)          5  2  2  1   5- 4   8
10.Plateau United (Jos)            5  2  1  2   8- 5   7  
11.Bendel Insurance (Benin City)   5  2  1  2   6- 3   7
12.Enugu Rangers                   5  2  0  3   5- 6   6
13.Jigawa Golden Stars             5  1  2  2   4- 6   5
14.NPA (Warri)                     5  1  1  3   3- 6   4
15.Yobe Stars                      5  1  1  3   4- 8   4
16.Port Harcourt Sharks            5  1  1  3   4- 9   4
17.Gombe United (Bauchi)           5  1  1  3   3- 8   4
18.Jasper United (Onitsha)         5  1  0  4   2- 9   3

NB: there will be no top-4 Super League playoff to decide the championship
    this season

Rounds 6-9 missing

Round 10 [Feb 16, 17]
NPA		1-0 Plateau
Insurance	2-0 Yobe
Pillars		2-0 Enyimba
Rangers		2-1 Lobi
Jasper		1-0 Sunshine
Sharks		2-0 Wikki
Berger		2-0 Jigawa
Nationale	2-0 Gabros
El-Kanemi	0-1 Gombe

Round 11 [Feb 23, 24]
Lobi            3-1 Jasper 
Sunshine        2-1 Sharks  
Enyimba         1-0 Rangers  
Insurance       2-1 NPA  
Jigawa          4-1 Nationale  
Gombe           2-0 Plateau  
Wikki           4-0 Berger  
Gabros          1-0 El-Kanemi  
Yobe            1-2 Pillars  

Round 12 [Mar 2, 3]
Berger		3-1 Sunshine
Pillars		1-0 Insurance
Jasper		1-0 Enyimba
Sharks		2-1 Lobi
NPA		2-1 Gombe
El-Kanemi	2-0 Jigawa
Rangers		2-1 Yobe
Nationale	3-0 Wikki
Plateau		1-0 Gabros

Round 13
[Mar 9,10]
Insurance	0-1 Rangers
Wikki		1-1 El-Kanemi
Jigawa		1-0 Plateau
Lobi		2-0 Berger
Gabros		1-0 Gombe
Sunshine	1-0 Nationale
[Mar 13]
Enyimba		1-2 Sharks
Pillars		3-1 NPA
Yobe            1-0 Jasper	

Moved Match
Gabros          2-0 Berger

Round 14 
[Mar 16,17]
Sharks          2-0 Yobe  
Jasper          1-1 Insurance  
Nationale       abd Lobi            [abandoned at 1-0 in 65' after referee was
Rangers         3-1 Pillars          attacked by Nationale fans following a red card]
Berger          0-0 Enyimba  
El-Kanemi       1-0 Sunshine  
NPA             3-1 Gabros 
Plateau         1-0 Wikki  
Gombe           1-0 Jigawa  
[May 12]
Nationale       3-0 Lobi

Round 15
[Mar 24]
Lobi		1-0 El-Kanemi
Wikki		abd Gombe           [abandoned at 0-0 in 75']
Yobe		2-1 Berger
Jigawa		4-1 Gabros
Insurance	3-3 Sharks
Sunshine	1-0 Plateau
Pillars		2-0 Jasper
[Apr 3]
Enyimba         2-0 Nationale
Rangers         2-0 NPA
[May 22]
Wikki           2-0 Gombe

Round 16 [Mar 31]
Nationale	1-0 Yobe
Sharks		2-0 Pillars
Gabros		3-1 Wikki
Berger		0-0 Insurance
Plateau		1-0 Lobi
Jasper		2-2 Rangers
El-Kanemi	0-0 Enyimba
NPA		1-0 Jigawa
Gombe		1-0 Sunshine

Round 17 
[Apr 6,7]
NPA             0-0 Jasper  
Yobe            2-2 El-Kanemi 
Rangers         1-1 Sharks  
Pillars         1-1 Berger  
Wikki           2-2 Jigawa  
Sunshine        1-0 Gabros  
Lobi            1-0 Gombe 
[Apr 21]
Insurance       2-0 Nationale
[May 1]
Enyimba		2-0 Plateau

Round 18
[Apr 28]
El-Kanemi	0-1 Yobe
Berger		5-0 Pillars
Nationale	2-0 Insurance
Jasper		0-0 NPA
Gombe		2-0 Lobi
Jigawa		3-1 Wikki
Sharks		1-1 Rangers
Gabros		1-0 Sunshine
[May 22]
Plateau		2-0 Enyimba

Round 19 [May 5]
Lobi		2-0 Gabros
Yobe		2-0 Plateau
Insurance	2-0 El-Kanemi
Enyimba		3-1 Gombe
Pillars		3-2 Nationale
Rangers		1-0 Berger
Jasper		1-1 Sharks
NPA		1-0 Wikki
Sunshine	4-0 Jigawa

Round 20 [May 15]
Gombe		2-0 Yobe
Nationale	4-2 Rangers
Plateau		1-1 Insurance
Gabros		1-0 Enyimba
Wikki		2-1 Sunshine
Jigawa		2-0 Lobi
Sharks		0-0 NPA
Berger		2-0 Jasper
El-Kanemi	0-0 Pillars

Round 21
[May 19]
Enyimba		2-0 Jigawa
Rangers		2-0 El-Kanemi
Sharks		2-1 Berger
Pillars		3-1 Plateau
Insurance	2-1 Gombe
Lobi		1-0 Wikki
NPA		1-1 Sunshine
Jasper		1-1 Nationale
[May 22]
Yobe		1-0 Gabros

Round 22 [May 26]
Nationale	2-0 Sharks
Plateau		3-1 Rangers
Gombe		3-2 Pillars
El-Kanemi	0-0 Jasper
Jigawa		1-0 Yobe
Sunshine	2-0 Lobi
Berger		1-0 NPA
Gabros		0-0 Insurance
Wikki		1-0 Enyimba

Round 23 [Jun 2]
Jasper		0-0 Plateau
Rangers		4-1 Gombe
Insurance	2-0 Jigawa
Pillars		1-0 Gabros
Yobe		1-1 Wikki
NPA		1-0 Lobi
Berger		0-0 Nationale
Enyimba		1-0 Sunshine
Sharks		3-0 El-Kanemi

Round 24 
[Jun 30]
Gombe		4-0 Jasper
Gabros		0-1 Rangers
Nationale	1-0 NPA
Jigawa		abd Pillars	    [abandoned at 0-0]
Wikki		2-0 Insurance
Lobi		awd Enyimba         [awarded 0-3? to Enyimba; originally 1-0 but 
El-Kanemi	0-0 Berger           protest Enyimba on lack of security upheld]
Plateau		1-0 Sharks
Sunshine	2-0 Yobe
[later?; inferred]
Jigawa          drw Pillars

Round 25
[Jul 3]
Rangers		3-0 Jigawa
Jasper		2-3 Gabros
Sharks		awd Gombe           [abandoned at 2-0 in 30' when Gombe withdrew 
NPA		1-1 Enyimba          in protest to refereeing, awarded 3-0?]
Yobe		2-2 Lobi
Pillars		1-0 Wikki
Nationale	1-0 El-Kanemi
Insurance	2-0 Sunshine
[later]
Berger		bt  Plateau

Round 26 [Jul 7]
Gabros		2-2 Sharks
El-Kanemi	1-1 NPA
Enyimba		1-0 Yobe
Jigawa		3-0 Jasper
Gombe		1-0 Berger
Plateau		1-0 Nationale
Lobi		2-0 Insurance
Sunshine	1-0 Pillars
Wikki		2-1 Rangers

Round 27
[Jul 10]
NPA		1-0 Yobe
Nationale	3-1 Gombe
Insurance	1-0 Enyimba
Rangers		1-1 Sunshine
Jasper		1-0 Wikki
Sharks		1-0 Jigawa
Pillars		1-1 Lobi
[Jul 30]
Berger		bt  Gabros
[later, inferred]
El-Kanemi       bt  Plateau         

Round 28
[Jul 14]
Lobi		0-0 Rangers
Gabros		1-0 Nationale
Yobe		1-0 Insurance
Plateau		2-1 NPA
Gombe		1-0 El-Kanemi
Sunshine	2-0 Jasper
Enyimba		2-1 Pillars
Jigawa		2-0 Berger
[later]
Wikki		bt  Sharks

Round 29 [Jul 21]
Jasper		1-0 Lobi
Sharks		2-1 Sunshine
Rangers		1-0 Enyimba
NPA		1-0 Insurance
Nationale	1-0 Jigawa
Plateau		1-0 Gombe
Berger		1-0 Wikki
El-Kanemi	3-1 Gabros
Pillars		2-0 Yobe

Round 30 [Jul 24]
Sunshine	1-0 Berger
Insurance	1-0 Pillars
Enyimba		2-0 Jasper
Lobi		3-2 Sharks
Gombe		2-1 NPA
Jigawa		3-1 El-Kanemi
Yobe		2-0 Rangers
Wikki		1-0 Nationale
Gabros		2-0 Plateau

Round 31
[Jul 28]
Sharks		0-0 Enyimba
Rangers		2-0 Insurance
Jasper		2-1 Yobe
Berger		1-0 Lobi
Gombe		1-0 Gabros
Plateau		2-0 Jigawa
Nationale	3-1 Sunshine
[later, inferred]
El-Kanemi	bt  Wikki
NPA		drw Pillars

Round 32
[Jul 31]
Pillars		1-0 Rangers
Lobi		2-0 Nationale
Wikki		3-1 Plateau
Sunshine	1-0 El-Kanemi
Yobe		2-0 Sharks
Gabros		1-0 NPA
Jigawa		2-0 Gombe
Insurance	2-0 Jasper
[later]
Enyimba		bt  Berger

Round 33
[Aug 4]
Nationale	2-0 Enyimba
Jasper		1-0 Pillars
Gabros		1-0 Jigawa
Plateau		1-0 Sunshine
NPA		0-0 Rangers
Berger		2-0 Yobe
Gombe		1-0 Wikki
El-Kanemi	2-0 Lobi
[Aug 6]
Sharks		2-2 Insurance

Round 34 [Aug 11]
Yobe		1-0 Nationale
Pillars		2-0 Sharks
Wikki		2-0 Gabros
Insurance	1-0 Berger
Lobi		1-0 Plateau
Rangers		3-1 Jasper
Enyimba		2-1 El-Kanemi
Jigawa		1-0 NPA
Sunshine	3-1 Gombe

Table:

 1.Enyimba (Aba)                  34 18  7  9  34-19  61  [*]       Champions
 2.Enugu Rangers                  34 17  6 11  42-30  57  [41-29?]  Runners-Up
 3.Kano Pillars                   34 17  5 12  40-35  56  [*]
 4.Iwuanyanwu Nationale (Owerri)  34 17  3 14  41-31  54  [56 pts?]
 5.Bendel Insurance (Benin City)  34 15  8 11  35-27  53  [35-28?]
 6.Julius Berger (Lagos)          34 15  7 12  32-25  52  [32-24?] [*]
 7.Sunshine Stars (Akure)         34 15  5 14  36-34  50
 8.Gombe United (Bauchi)          34 16  1 17  36-43  49
 9.Port Harcourt Sharks           34 13  9 12  41-39  48  [47 pts?] [*]
10.Wikki Tourists (Bauchi)        34 15  3 16  33-34  48  [*]
11.Gabros International           34 15  2 17  31-36  47  [*]
12.Lobi Stars FC (Makurdi)        34 14  4 15  34-37  46
13.Jigawa Golden Stars            34 14  4 16  33-37  46  [*]
14.Plateau United (Jos)           34 13  5 16  28-29  44  [28-27?] [*]
--------------------------------------------------------
15.NPA (Warri)                    34 10 11 13  26-29  41  [*]  Relegated
16.Yobe Desert Stars (Damaturu)   34 11  6 17  26-36  39  [#] [40 pts?]  Relegated
17.El-Kanemi Warriors (Maiduguri) 34 10  9 15  24-33  39  [*]  Relegated
18.Jasper United (Onitsha)        34  9  8 17  23-48  35  [34 pts?]   Relegated

[*] w/o goals Berger vs Plateau, Berger vs Gabros, Enyimba vs Berger,
    Wikki vs Sharks, Jigawa vs Pillars, NPA vs Pillars, El-Kanemi vs Wikki,
    El-Kanemi vs Plateau
[#] Yobe Desert Stars DFC played home matches in Maiduguri, Makurdi, 
    Kaduna and Bauchi

NB: total goal difference -7; Nationale are reported to have finished with
    56 points, Sharks 47, Yobe 40, Jasper 34; possibly Jasper vs Nationale
    (round 21) was later awarded an away win.

NB: there is no top-4 Super League playoff to decide the championship
    this season

Promoted: Kwara United, Dolphin, Delta United and Niger Tornadoes 

Topscorers:
 Joetex Frimpong (El-Kanemi)    18
 Victor Ezeji (Sharks)	        15 






Authors: Chuka Onwumechili
(agodi2_mechili@yahoo.com)
and José Batalha
(jose.batalha@netvisao.pt)

Last updated: 19 Jan 2003

(C) Copyright Chuka Onwumechili,
José Batalha and RSSSF 2002/03


  USO DE MEMORIA  
4,305,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0930
Total Execution Time  0.0954
  CADENA URL  
/premier_league_nigeria2002
  GET DATOS  
$_GET['/premier_league_nigeria2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_nigeria2002'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_nigeria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=517
0.0020  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 = 28834 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2002' WHERE c.parentId=490 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 00:39:34' 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-04-20 00:39:34' 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-04-20 00:39:34' 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-04-20 00:39:34' 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_nigeria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28834) 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 (28834) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28834) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (28834) 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 events2002 e WHERE e.league_id IN (28834) AND (e.action IN (3,4) ) 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 (28834) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28834) AND (e.action IN (22) ) 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 (28834) 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 = 28834 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 = 28834 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=28834 AND rel.round=34
0.0019  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 = 28834 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 28834 AND esl.points > 0
0.0020  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-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28834 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28834
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 `calendars2002` 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` = 28834 AND c.`round` = 34 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 `events2002` e INNER JOIN calendars2002 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 28834 ORDER BY total DESC LIMIT 40
0.0020  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 `events2002` e INNER JOIN calendars2002 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 = 28834 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables2002` 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 = 28834 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 28834 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 28834 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=490
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 490 AND l.year = 2002 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=490 AND year=2002