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

Premier League Nigeria 2003

Información Histórica 
						

Final Table:

 1.Enyimba (Aba)                  34 19  6  9  39-19  63  Champions
 2.Julius Berger (Lagos)          34 17  7 10  43-26  58  Champions League
 3.Enugu Rangers                  34 18  4 12  37-28  58  CAF Cup
 4.Plateau United (Jos)           34 16  6 12  28-27  54
 5.Iwuanyanwu Nationale (Owerri)  34 16  5 13  39-29  53
 6.Gabros International (Nnewi)   34 16  5 13  35-33  53 
 7.Wikki Tourists (Bauchi)        34 15  4 15  32-35  49
 8.Bendel Insurance (Benin City)  34 14  6 14  33-32  48
 9.Niger Tornadoes (Minna)        34 14  5 15  31-29  47
10.Gombe United (Bauchi)          34 13  8 13  33-35  47 
11.Kano Pillars                   34 14  5 15  31-35  47
12.Lobi Stars FC (Makurdi)        34 15  2 17  32-40  47
13.Kwara United (Ilorin)          34 14  4 16  32-36  46
14.Dolphins (Port Harcourt)       34 13  6 15  36-32  45
--------------------------------------------------------
15.Port Harcourt Sharks           34 12  8 14  35-40  44  Relegated
16.Delta United (Asaba)           34 12  6 16  30-36  42  Relegated
17.Jigawa Golden Stars            34 11  3 20  20-34  36  Relegated
18.Sunshine Stars (Akure)         34  7 10 17  20-40  31  Relegated

Round 1
[Feb 1]
Jigawa		1-0 Insurance
Wikki		1-1 Sunshine
Kwara		4-2 Pillars
Berger		3-0 Gombe
Plateau		1-0 Dolphins
Tornadoes	3-0 Rangers	[also reported 1-0]
[Feb 2]
Gabros		2-1 Enyimba
Sharks		1-1 Lobi
Nationale	1-0 Delta

Round 2 [Feb 5]
Delta		0-1 Kwara
Gombe		1-0 Jigawa
Pillars		2-0 Wikki
Insurance	2-1 Gabros
Lobi		1-0 Plateau
Dolphins	1-0 Berger
Sunshine	2-0 Sharks
Enyimba		2-0 Tornadoes
Rangers		2-1 Nationale

Round 3
[Feb 8]
Plateau		1-0 Sunshine  
Berger		1-0 Lobi  
Wikki		2-1 Delta     
Jigawa		2-1 Dolphins  
Kwara		1-0 Rangers  
Tornadoes	1-0 Nationale
[Feb 9]
Enyimba		1-0 Insurance  
Sharks		2-1 Pillars  
Gabros		1-2 Gombe

Round 4 [Feb 12]
Pillars		2-0 Plateau  
Sunshine	1-0 Berger  
Insurance	2-1 Tornadoes  
Gombe		0-0 Enyimba  
Nationale	3-0 Kwara  
Lobi		2-1 Jigawa    
Rangers		2-1 Wikki  
Dolphins	0-0 Gabros  
Delta		1-2 Sharks

Round 5
[Feb 15]
Berger		2-1 Pillars  
Tornadoes	0-0 Kwara  
Insurance	2-1 Gombe  
Wikki		2-1 Nationale  
Plateau		2-1 Delta
[Feb 16]
Enyimba		1-0 Dolphins
Gabros		1-0 Lobi  
Sharks		1-0 Rangers
Jigawa		1-0 Sunshine  

Round 6 [Feb 19]
Gombe		2-0 Tornadoes  
Kwara		1-0 Wikki  
Delta		1-0 Berger  
Pillars		1-0 Jigawa  
Dolphins	1-1 Insurance  
Rangers		1-0 Plateau  
Sunshine	1-0 Gabros  
Lobi		0-1 Enyimba  
Nationale	2-1 Sharks 

Round 7
[Feb 22]
Tornadoes	1-0 Wikki
Insurance	3-0 Lobi
Berger		0-0 Rangers
Plateau		0-0 Nationale
[Feb 23]
Jigawa		2-0 Delta          
Gombe		2-1 Dolphins
Sharks		1-0 Kwara
Gabros		2-0 Pillars
Enyimba		1-0 Sunshine

Round 8 [Feb 26]
Kwara		1-0 Plateau
Sunshine	0-0 Insurance
Wikki		2-0 Sharks
Pillars		1-0 Enyimba
Rangers		2-0 Jigawa
Lobi		1-3 Gombe
Dolphins	2-0 Tornadoes
Delta		2-0 Gabros
Nationale	3-2 Berger

Round 9
[Mar 1]
Gombe		2-0 Sunshine
Insurance	2-0 Pillars
Berger		3-1 Kwara
Plateau		1-0 Wikki
Tornadoes	3-0 Sharks
[Mar 2]
Jigawa		0-0 Nationale
Enyimba		abd Delta	[1-0 abd due rain at 60'; to replay]
Gabros		0-1 Rangers
Dolphins	awd Lobi	[awarded 3-0, Lobi walked off in 70']
[Mar 3]
Enyimba		4-0 Delta

Round 10
[Mar 5]
Wikki		1-1 Berger
Kwara		1-0 Jigawa
Pillars		1-0 Gombe
Lobi		1-0 Tornadoes
Sharks		0-1 Plateau
Nationale	2-3 Gabros
Sunshine	1-1 Dolphins
[Mar 6]
Delta		1-2 Insurance
Rangers		0-0 Enyimba

Round 11
[Mar 8]
Tornadoes	2-0 Plateau
Jigawa		2-0 Wikki
Berger		2-0 Sharks
[Mar 9]
Gombe		0-0 Delta
Insurance	1-0 Rangers
Dolphins	3-1 Pillars
Gabros		1-0 Kwara
Enyimba		1-0 Nationale
Lobi		3-0 Sunshine

Round 12 
[Mar 12]
Plateau		1-1 Berger
Sunshine	2-1 Tornadoes
Pillars		abd Lobi	[abandoned at 2-1 in 70' after police fired
Wikki		0-0 Gabros       tear gas at rioting Pillars' fans]
Kwara		0-1 Enyimba
Nationale	1-0 Insurance
Sharks		1-2 Jigawa
Rangers		2-1 Gombe
Delta		1-0 Dolphins
[Apr 27]
Pillars		1-0 Lobi	[replay]

Round 13
[Mar 15]
Tornadoes	2-0 Berger
Insurance	2-1 Kwara
Jigawa		2-1 Plateau
[Mar 16]
Gombe		1-1 Nationale
Sunshine	0-0 Pillars
Enyimba		1-0 Wikki
Lobi		1-0 Delta
Dolphins	0-1 Rangers
Gabros		0-0 Sharks

Round 14 [Mar 19]
Wikki		1-0 Insurance
Pillars		1-0 Tornadoes
Kwara		2-0 Gombe
Berger		1-0 Jigawa
Plateau		0-0 Gabros
Nationale	2-0 Dolphins
Rangers		2-0 Lobi
Sharks		1-1 Enyimba
Delta		2-0 Sunshine

Round 15
[Mar 22]
Pillars		1-1 Delta
Tornadoes	2-0 Jigawa
Gombe		1-0 Wikki
Insurance	1-1 Sharks
[Mar 23]
Dolphins	1-0 Kwara
Enyimba		1-0 Plateau
Gabros		2-0 Berger
Sunshine	1-2 Rangers
Lobi		1-1 Nationale

Round 16 [Mar 26]
Plateau		1-0 Insurance
Delta		1-1 Tornadoes
Wikki		2-1 Dolphins
Kwara		2-0 Lobi
Jigawa		0-1 Gabros
Rangers		1-0 Pillars
Sharks		1-1 Gombe
Berger		1-0 Enyimba
Nationale	2-0 Sunshine

Round 17
[Mar 29]
Gombe		1-1 Plateau
Sunshine	1-0 Kwara
[Mar 30]
Insurance	2-0 Berger
Pillars		1-0 Nationale
Enyimba		1-0 Jigawa
Gabros		2-1 Tornadoes
Delta		1-0 Rangers
Dolphins	0-0 Sharks
Lobi		1-0 Wikki

NB: All league matches involving champions Enyimba of Aba have been
    called off until further notice.  This was done to allow Enyimba 
    to concentrate fully on their African Champions Cup return leg
    match against Jeanne d'Arc in Dakar. 

Round 18
[May 17]
Plateau		2-1 Gombe
Kwara		1-1 Sunshine
Tornadoes	1-0 Gabros
Wikki		1-0 Lobi
[May 18]
Nationale	1-0 Pillars
Sharks		1-1 Dolphins
[May 21]
Rangers		2-1 Delta
[Jun 5]
Berger		2-0 Insurance
[Jun 11]
Jigawa		awd Enyimba     [awarded 3-0, Enyimba dns]

Round 19
[May 24]
Insurance	1-0 Jigawa
Gombe		0-0 Berger
Pillars		1-0 Kwara
[May 25]
Sunshine	0-1 Wikki
Dolphins	3-0 Plateau
Rangers		1-0 Tornadoes
Lobi		2-0 Sharks
Delta		3-2 Nationale
[Jun 18]
Enyimba		4-0 Gabros

Round 20
[May 31]
Kwara		3-1 Delta
Jigawa		0-0 Gombe
Wikki		1-1 Pillars
Plateau		1-0 Lobi
[Jun 1]
Sharks		2-0 Sunshine
[Jun 2]
Gabros		2-0 Insurance
[Jun 11]
Berger		1-2 Dolphins
[Jun 18]
Nationale	2-0 Rangers
[Jun 25]
Tornadoes	1-0 Enyimba

Round 21
[Jun 7]
Sunshine	0-0 Plateau
Pillars		1-1 Sharks
Gombe		2-1 Gabros      [also reported 2-0]   
[Jun 8]
Lobi		2-1 Berger
Delta		2-1 Wikki
Dolphins	1-0 Jigawa
Rangers		3-0 Kwara
Nationale	1-0 Tornadoes
Insurance	0-0 Enyimba

Round 22
[Jun 14]
Plateau		1-0 Pillars
Tornadoes	1-0 Insurance
Kwara		2-0 Nationale
Jigawa		1-0 Lobi
Wikki		1-0 Rangers
[Jun 15]
Berger		1-1 Sunshine
Enyimba		ppd Gombe	
  [match postponed following an armed robbery on the car of Gombe on
   their way to Aba which left two players injured, one (Kalu Usim) in
   critical condition]
Gabros		1-0 Dolphins
Sharks		1-0 Delta
[Jul 3]
Enyimba		1-0 Gombe	

Round 23
[Jun 21]
Pillars  	1-2 Berger
Kwara		2-0 Tornadoes
Gombe		1-0 Insurance
[Jun 22]
Dolphins	0-3 Enyimba
Rangers		2-1 Sharks
Sunshine	1-0 Jigawa
Delta		0-1 Plateau
Lobi		2-1 Gabros
[Jun 23]
Nationale	1-0 Wikki

Round 24
[Jun 28]
Tornadoes	2-1 Gombe
Wikki		3-0 Kwara
Jigawa		0-0 Pillars
Insurance	1-0 Dolphins
Plateau		2-1 Rangers     [abandoned at 2-1 in 80'; Rangers left the 
[Jun 29]                         pitch protesting the expulsion of their
Berger		3-0 Delta        goal keeper; result stood]
Gabros		2-1 Sunshine
Enyimba		1-0 Lobi
Sharks		2-1 Nationale

Round 25 [postponed from Jul 5,6 due to a nationwide strike against increased 
[Jul 16]  fuel prices, which made long-distance transportation impossible]
Wikki		1-0 Tornadoes
Kwara		2-0 Sharks
Sunshine	1-1 Enyimba
Lobi		2-1 Insurance
Rangers		1-1 Berger
Nationale	1-0 Plateau
Dolphins	2-1 Gombe
[Jul 17]
Pillars		2-1 Gabros
Delta		1-0 Jigawa

Round 26
[Jul 12]
Plateau		abd Kwara	[abandoned due to rain; replay Jul 13]
Insurance	2-1 Sunshine
Jigawa		2-0 Rangers
Gombe		1-0 Lobi
Tornadoes	2-2 Dolphins
Berger		1-0 Nationale
[Jul 13]
Plateau		awd Kwara	[awarded 3-0; Kwara dns, returning to                                        
Sharks		0-1 Wikki        Ilorin without playing the replay] 
Gabros		1-0 Delta
Enyimba		awd Pillars	[awarded 3-0; Pillars refused to play
                                 on after a penalty award to Enyimba]
Round 27
[Jul 19]
Pillars		3-1 Insurance
Kwara		1-1 Berger
Wikki		3-1 Plateau
[Jul 20]
Sunshine 	3-1 Gombe
Sharks		2-0 Tornadoes
Nationale	1-0 Jigawa
Delta		0-0 Enyimba
Rangers		2-0 Gabros
Lobi		2-1 Dolphins

Round 28
[Jul 26]
Berger		3-0 Wikki
Jigawa		1-0 Kwara
Gombe		1-0 Pillars
Tornadoes	3-1 Lobi
Plateau		2-1 Sharks
Insurance	0-0 Delta
[Jul 27]
Gabros		1-0 Nationale
Dolphins	3-0 Sunshine
Enyimba		2-0 Rangers

Round 29
[Aug 2]
Plateau		1-0 Tornadoes
Pillars		2-1 Dolphins
Kwara		2-2 Gabros
[Aug 3]
Wikki		1-0 Jigawa
Sunshine	0-1 Lobi
Sharks		2-1 Berger
Delta		1-0 Gombe
Rangers		3-0 Insurance
Nationale	2-0 Enyimba

Round 30
[Aug 9]
Berger		1-0 Plateau
Tornadoes	0-0 Sunshine
Insurance	2-0 Nationale
Jigawa		awd Sharks	        [awarded 0-3; abandoned at 0-1 in 34'
[Aug 10]                                 when Jigawa fans invaded the pitch 
Lobi		2-1 Pillars              protesting a free kick against their
Gabros		2-1 Wikki                team]
Dolphins	1-0 Delta
[Aug 13]
Gombe		1-1 Rangers
Enyimba		1-0 Kwara

Round 31
[Aug 16]
Berger		2-0 Tornadoes
[Aug 17]
Kwara		2-1 Insurance
Plateau		2-0 Jigawa
Pillars		1-0 Sunshine
Delta		3-2 Lobi
Rangers		1-0 Dolphins
Sharks		2-0 Gabros
[Aug 18]
Nationale	3-1 Gombe
[Aug 28]
Wikki		2-1 Enyimba

Round 32
[Aug 23]
Tornadoes	1-0 Pillars
Gombe		1-0 Kwara
Jigawa		0-3 Berger
[Aug 24]
Insurance	4-1 Wikki
Gabros		2-0 Plateau
Dolphins	1-0 Nationale	[match abandoned, according to Nationale
Lobi		2-1 Rangers      after equaliser but result stood as 1-0]
Sunshine	awd Delta       [awarded 0-3; was to be played in Owerri,
[Sep 2]                          Sunshine dns]
Enyimba		4-2 Sharks

Round 33 
[Sep 10]
Delta		2-0 Pillars
Jigawa		0-2 Tornadoes
Wikki		2-0 Gombe
Sharks		2-0 Insurance
Kwara		2-0 Dolphins
Plateau		2-1 Enyimba
Berger		2-0 Gabros
Rangers		3-0 Sunshine
Nationale	n/p Lobi     	[not started due to inadequate security]
[Sep 11]
Nationale	awd Lobi     	[awarded 3-0, Lobi dns claiming Nationale 
                                 failed to take care of their extra expenses]
Round 34 [Sep 14]
Insurance	0-0 Plateau
Tornadoes	0-0 Delta
Dolphins	3-0 Wikki
Lobi		2-0 Kwara
Gabros		3-0 Jigawa
Pillars		2-0 Rangers
Gombe		3-1 Sharks
Enyimba		0-1 Berger
Sunshine	1-1 Nationale

Final Table:

 1.Enyimba (Aba)                  34 19  6  9  39-19  63  Champions
 2.Julius Berger (Lagos)          34 17  7 10  43-26  58  Champions League
 3.Enugu Rangers                  34 18  4 12  37-28  58  CAF Cup
 4.Plateau United (Jos)           34 16  6 12  28-27  54
 5.Iwuanyanwu Nationale (Owerri)  34 16  5 13  39-29  53
 6.Gabros International (Nnewi)   34 16  5 13  35-33  53 
 7.Wikki Tourists (Bauchi)        34 15  4 15  32-35  49
 8.Bendel Insurance (Benin City)  34 14  6 14  33-32  48
 9.Niger Tornadoes (Minna)        34 14  5 15  31-29  47
10.Gombe United (Bauchi)          34 13  8 13  33-35  47 
11.Kano Pillars                   34 14  5 15  31-35  47
12.Lobi Stars FC (Makurdi)        34 15  2 17  32-40  47
13.Kwara United (Ilorin)          34 14  4 16  32-36  46
14.Dolphins (Port Harcourt)       34 13  6 15  36-32  45
--------------------------------------------------------
15.Port Harcourt Sharks           34 12  8 14  35-40  44  Relegated
16.Delta United (Asaba)           34 12  6 16  30-36  42  Relegated
17.Jigawa Golden Stars            34 11  3 20  20-34  36  Relegated
18.Sunshine Stars (Akure)         34  7 10 17  20-40  31  Relegated

Topscorer: Chibuzor Ozurumba (Nationale) 13 goals.

Start of 2004 season postponed from December 13 to February 21





Author: José Batalha
(jose.batalha@netvisao.pt)

Last updated: 10 Jul 2004

(C) Copyright 
José Batalha and RSSSF 2003/04


  USO DE MEMORIA  
4,308,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5214
Total Execution Time  0.5232
  CADENA URL  
/premier_league_nigeria2003
  GET DATOS  
$_GET['/premier_league_nigeria2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0105  SELECT type FROM routes WHERE alias = 'premier_league_nigeria2003'
0.0211  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=490 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 490 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1162543,1162408,1154996,1008473,812430) ORDER BY n.cover_points DESC, update_date DESC
0.0113  SELECT text_es as historical_text FROM leagues_text WHERE id=518
0.0106  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 = 28835 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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='2003' WHERE c.parentId=490 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 490 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 00:16:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 00:16:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 00:16:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 00:16:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28835) 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.0110  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 (28835) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28835) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (28835) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28835) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (28835) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28835) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  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 (28835) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0113  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 = 28835 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0112  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 = 28835 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0110  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 490 GROUP BY l.categoryId
0.0108  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=490 GROUP BY l.year ORDER BY l.year DESC
0.0107  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=28835 AND rel.round=34
0.0107  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 = 28835 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 28835 AND esl.points > 0
0.0106  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-20" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28835 ORDER BY creation_date DESC LIMIT 0, 10
0.0110  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-20" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28835
0.0107  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 `calendars2003` 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` = 28835 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0105  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 `events2003` e INNER JOIN calendars2003 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 = 28835 ORDER BY total DESC LIMIT 40
0.0107  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 `events2003` e INNER JOIN calendars2003 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 = 28835 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0107  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 `tables2003` 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 = 28835 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 28835 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 28835 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=490
0.0107  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 490 AND l.year = 2003 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=490 AND year=2003