4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Premier League Nigeria 2004
2003/2004

Premier League Nigeria 2004

Información Histórica
						
Final Table:

 1.Dolphin (Port Harcourt)          34  19  5 10  44-30  62  Champions
 2.Enyimba (Aba)                    34  18  6 10  44-24  60
 3.Bendel Insurance (Benin City)    34  17  5 12  45-29  56
 4.Kano Pillars                     34  17  5 12  43-27  56
 5.Iwuanyanwu Nationale (Owerri)    34  17  5 12  31-23  56
 6.Enugu Rangers                    34  14 10 10  28-21  52
 7.Lobi Stars FC (Makurdi)          34  15  5 14  44-34  50
 8.Gombe United (Bauchi)            34  15  3 16  30-40  48
 9.Gabros International (Nnewi)     34  14  5 15  23-27  47
10.Shooting Stars (Ibadan)          34  14  5 15  39-47  47
11.Nigerian Ports Authority (Warri) 34  14  4 16  35-35  46  [aka NPA]
12.Julius Berger (Lagos)            34  13  7 14  36-37  46
13.Niger Tornadoes (Minna)          34  14  4 16  27-32  46
14.El-Kanemi Warriors (Maiduguri)   34  14  4 16  25-37  46
-----------------------------------------------------------
15.Wikki Tourists (Bauchi)          34  14  3 17  36-42  45  Relegation Playoff
16.Kwara United (Ilorin)            34  12  6 16  37-43  42  Relegation Playoff
17.Plateau United (Jos)             34   8 11 15  26-36  35  Relegation Playoff
18.Mighty Jets (Jos)                34   7  7 20  20-49  28  Relegation Playoff

Round 1
[Feb 28]
Shooting	2-0 Enyimba
  [Seyi Ogunsanya 1, Lukman Ijaya 7]
Tornadoes	2-0 Insurance
  [Ali Haruna 60, David Solomon 75]
Jets		0-0 Lobi
Berger		2-0 Wikki
  [Endurance Idahor 38pen, Odili Iyasile 52]
El-Kanemi	0-0 Pillars
[Feb 29]
Rangers		1-0 Kwara
  [Igho Otegheri 78]
Gabros		1-0 Dolphin 
  [Ndubuisi Okonkwo 77]
Nationale	1-0 Plateau
  [Onyeka Uche 78pen]
Gombe		1-0 NPA

Round 2
[Mar 3]
Plateau		2-1 Tornadoes
  [Stanley Ihugba 36, Imadu Telumun 89pen; Abdulrazak Wuraola 54]
Pillars		1-1 Rangers
  [Clement Ogidi; ? 90]
Insurance	2-2 Gabros
  [Ifeanyi Obidiah 65, Eguatu Collins 75; ?]
Kwara		3-1 Shooting
  [Chinazor Okeke 9, Emeka Ekwueme 36, Daniel Njoku 88; Lasisi Kehinde 26]
Wikki		1-0 El-Kanemi
Dolphin 	2-1 Gombe
  [Kelechi Osunwa 43, Uwazuoke Wobo; Kennedy Chinwo 3og]
Enyimba		2-0 Jets
  [Seyi Ogunsanya 85, Abdulazeez Umar 90]
Lobi		1-0 Nationale
  [Kelechi Okoye]
[May 9]
NPA		2-1 Berger

Round 3
[Mar 6]
Tornadoes	1-1 Lobi
  [?; Iliya Yahaya 55]
El-Kanemi	1-0 NPA
  [Benedict Ime 82]
Jets		1-1 Nationale
  [Nura Nakargo 43pen; Uzoma Igwe 50]
Shooting	2-1 Pillars
  [Abiodun Sampson 19, Rafiu Fadaiya 77; ?]
[Mar 7]
Gabros		2-0 Plateau
  [Chukwuma Ezeagu 50, Kingsley Eleta 80]
Rangers		2-0 Wikki
Enyimba		1-0 Kwara
  [Benedict Ime 82]
Gombe		1-0 Insurance
[May 6]
Berger		1-0 Dolphin 

Round 4
[Mar 10]
Dolphin 	1-0 El-Kanemi
Kwara		2-0 Jets
Pillars		1-1 Enyimba
Nationale	1-0 Tornadoes
NPA		0-0 Rangers
Lobi		0-2 Gabros
Wikki		2-3 Shooting
Plateau		1-0 Gombe
[Apr 28]
Insurance	0-0 Berger

Round 5
[Mar 13]
El-Kanemi	1-0 Insurance
Jets		1-0 Tornadoes
Kwara		0-1 Pillars
Berger		0-0 Plateau
Shooting	3-0 NPA
[Mar 14]
Rangers		1-1 Dolphin 
Gabros		1-0 Nationale
Enyimba		1-1 Wikki
Gombe		0-0 Lobi

Round 6 
[Mar 17]
Wikki		2-1 Kwara
Plateau		1-0 El-Kanemi
Insurance	2-0 Rangers
Tornadoes	1-0 Gabros
Pillars		1-0 Jets
Dolphin 	3-1 Shooting
NPA		1-2 Enyimba
Nationale	1-0 Gombe
[Jun 9]
Lobi		3-0 Berger

Round 7
[Mar 20]
Jets            1-0 Gabros
Pillars         2-2 Wikki
Kwara           1-1 NPA
El-Kanemi       3-0 Lobi
Shooting        0-0 Insurance
[Mar 21]
Rangers         1-0 Plateau
Gombe           2-1 Tornadoes
Enyimba         0-1 Dolphin 
[Jun 2]
Berger          1-0 Nationale

Round 8 [Mar 24]
Lobi            2-0 Rangers
Insurance       1-0 Enyimba
Nationale       4-0 El-Kanemi
  [Uzoma Igwe (2), ?, ?]
Plateau         4-0 Shooting
  [Timzing Nims 11, Richard Salami 33, Gregory Peters, Manu Garba]
Tornadoes       1-0 Berger
  [Kelvin Njoku 12pen]
Dolphin         1-0 Kwara
Gabros          0-2 Gombe
Wikki           0-1 Jets
NPA             1-0 Pillars

Round 9
[Mar 31]
El-Kanemi       2-0 Tornadoes
Shooting        1-1 Lobi
Kwara           3-0 Insurance
Jets            3-1 Gombe
Pillars         3-0 Dolphin
Rangers         0-0 Nationale
Enyimba         1-0 Plateau
Berger          1-0 Gabros
  [Usman Mohammed 86]
[Apr 1]
Wikki           2-1 NPA

Round 10
[Apr 3]
Plateau		1-1 Kwara
Insurance	1-0 Pillars
Tornadoes	1-1 Rangers
[Apr 4]
NPA		2-1 Jets
Lobi		1-0 Enyimba
Gombe		1-1 Berger
Nationale	1-0 Shooting
Gabros		0-0 El-Kanemi
Dolphin 	2-0 Wikki

Round 11 
[Apr 7]
Pillars		4-0 Plateau
El-Kanemi	1-0 Gombe
Shooting	0-0 Tornadoes
NPA		0-1 Dolphin
  [Bola Bello 35]
Jets		1-0 Berger
Wikki		0-3 Insurance
[Apr 28]
Kwara		2-0 Lobi
Rangers		1-0 Gabros
[Jun 9]
Enyimba		2-1 Nationale

Round 12
[Apr 10]
Insurance	3-0 NPA
Plateau		2-1 Wikki
Berger		3-0 El-Kanemi
[Apr 11]
Dolphins	2-0 Jets
Nationale	4-0 Kwara
Gabros		2-0 Shooting
[May 5]
Tornadoes	1-0 Enyimba
Gombe		2-0 Rangers
Lobi		0-1 Pillars

Round 13
[Apr 14]
Shooting	1-0 Gombe
NPA		1-1 Plateau
Enyimba		3-0 Gabros
Dolphin		1-0 Insurance
Pillars		2-1 Nationale
Kwara		1-0 Tornadoes
  [Daniel Njoku 5pen]
Jets		1-0 El-Kanemi
[Apr 15]
Wikki		2-0 Lobi
  [Iliya Yahaya 33, Yakubu Yankari 86]
Rangers		0-0 Berger

Round 14
[Apr 17]
Insurance	2-1 Jets
Tornadoes	2-1 Pillars
  [Jibrin Yakubu 72, Ali Haruna 76; Ibrahim Ibrahim 20]
Plateau		0-1 Dolphin
  [Jide Michael 87; following protest by Plateau and a pitch invasion by
   their fans, the referee disallowed the goal and let the final minutes 
   be played after a 10-minute interruption; however, in his match report
   he stated the goal was valid and only said would disallow it in order
   for the match to continue safely; the NFA homologated the result as 0-1]
[Apr 18]
El-Kanemi	1-1 Rangers
Berger		2-1 Shooting
Gabros		1-0 Kwara
Nationale	1-0 Wikki
Lobi		3-1 NPA
Gombe		1-1 Enyimba

Round 15 
[Apr 21]
NPA		1-0 Nationale
  [Godwin Umukoro 11]
Shooting	2-0 El-Kanemi
Kwara		3-0 Gombe
  [Daniel Njoku (2), Sunday Okoh]
Pillars		2-0 Gabros
  [Promise Chinecherem, Yakubu Ibrahim 70]
Wikki		2-1 Tornadoes
  [Johnson Chidozie 30pen, Iliya Yahaya 72; Isa Mohammed 67]
Insurance	1-1 Plateau
[May 19]
Dolphin		3-1 Lobi
Enyimba		2-0 Berger
[Jun 9]
Jets		0-0 Rangers

Round 16
[Apr 24]
Tornadoes	1-0 NPA
Plateau		0-1 Jets
  [Felix Orode 42]
Berger		3-2 Kwara
[Apr 25]
Gombe		1-0 Pillars
Gabros		1-0 Wikki
Nationale	2-0 Dolphin
  [Uche Onyeka 40, Ikedinachi 63]
[May 8]
El-Kanemi	1-0 Enyimba
[May 9]
Lobi		2-1 Insurance
Rangers		2-0 Shooting

Round 17
[May 1]
Shooting	4-0 Jets
Plateau		0-0 Lobi
NPA		2-0 Gabros
Pillars		2-0 Berger
Insurance	2-0 Nationale
Kwara		1-0 El-Kanemi
[May 2]
Enyimba		1-0 Rangers
Wikki		1-0 Gombe
Dolphin		3-0 Tornadoes

Round 18
[May 26]
Jets		1-1 Shooting
Gabros		1-0 NPA
El-Kanemi	2-0 Kwara
Gombe		1-0 Wikki
Tornadoes	1-0 Dolphin
Nationale	2-0 Insurance
[Jun 23]
Lobi		2-0 Plateau
Rangers		2-0 Enyimba
[later]
Berger		awd Pillars	[0-3 awarded]
  [The organizing and disciplinary committee of the NFA had ordered a 
   replay of the match after the MKO Abiola Stadium, venue for the game, 
   was unavailable at the time of the game; but Pillars appealed against 
   this decision and were awarded the match]

Round 19
[May 29]
Insurance	1-0 Tornadoes
Pillars		1-1 El-Kanemi
Plateau		0-0 Nationale
NPA		2-0 Gombe
[May 30]
Wikki		0-0 Berger
Dolphin		1-1 Gabros
[Jun 2]
Kwara		1-0 Rangers
[Jun 16]
Enyimba		3-1 Shooting
[Jun 17]
Lobi		3-0 Jets

Round 20
[Jun 5]
Shooting	3-1 Kwara
Jets		2-2 Enyimba
Berger		1-0 NPA
El-Kanemi	awd Wikki	[0-3 awarded; abandoned at 1-1 around 75' when 
[Jun 6]  			 home fans stormed the pitch attacking match
Tornadoes	1-0 Plateau      officials and the visiting team, who had at least
Rangers		2-0 Pillars      five players injured; match was played at Damataru]
Gabros		0-0 Insurance
Gombe		2-1 Dolphin
Nationale	1-0 Lobi

Round 21
[Jun 12]
NPA		2-1 El-Kanemi
Pillars		1-0 Shooting
Plateau		2-0 Gabros
Wikki		1-0 Rangers
Kwara		2-1 Enyimba
Insurance	1-0 Gombe
[Jun 13]
Lobi		2-0 Tornadoes
Dolphin		2-1 Berger
[Jun 14]
Nationale	2-0 Jets

Round 22
[Jun 19]
El-Kanemi	3-1 Dolphin
Tornadoes	0-1 Nationale
Shooting	2-1 Wikki
Berger		2-1 Insurance
[Jun 20]
Jets		1-1 Kwara
Enyimba		1-0 Pillars
Rangers		2-0 NPA
Gabros		1-0 Lobi
Gombe		awd Plateau	[3-0 awarded; abandoned at 0-1]
  [the appeal committee of NFA have awarded Gombe United the match 3-0
   after Plateau United abandoned it while leading by one goal but refusing
   to continue alleging that their lives were in danger after some crowd
   trouble during the encounter]

Round 23
[Jun 26]
Insurance	awd El-Kanemi	[3-0 awarded; originally abandoned at
Pillars		1-0 Kwara        4-0 (!); El-Kanemi walked off]
Plateau		2-2 Berger
NPA		4-1 Shooting
Wikki		2-0 Enyimba
[Jun 27]
Tornadoes	awd Jets	[3-0 awarded; Jets dns]
Dolphin		1-1 Rangers
Nationale	1-0 Gabros
Lobi		4-0 Gombe

Round 24
[Jul 3]
Kwara		3-1 Wikki
  [Daniel Njoku 15, 60pen, 88; Chidozie Ngom 32pen]
El-Kanemi	1-0 Plateau
Shooting	2-0 Dolphin
Berger		3-2 Lobi
[Jul 4]
Jets		0-1 Pillars
Rangers		1-0 Insurance
Gabros		0-0 Tornadoes
Enyimba		2-0 NPA
Gombe		1-0 Nationale

Round 25
[Jul 10]
Wikki		1-0 Pillars
NPA		2-0 Kwara
Insurance	4-1 Shooting
Tornadoes	2-1 Gombe
[Jul 11]
Gabros		2-0 Jets
Lobi		4-0 El-Kanemi
Nationale	1-0 Berger
[Aug 18]
Dolphin		1-1 Enyimba
[Aug 19]
Plateau		2-0 Rangers

Round 26
[Jul 17]
El-Kanemi	1-0 Nationale
Shooting	1-1 Plateau
Berger		2-1 Tornadoes
Kwara		2-2 Dolphin
Pillars		1-0 NPA
[Jul 18]
Jets		1-2 Wikki
Rangers		1-0 Lobi
Enyimba		5-0 Insurance
Gombe		1-0 Gabros
   
Round 27
[Jul 24]
Tornadoes	2-0 El-Kanemi
NPA		4-1 Wikki
Insurance	awd Kwara	[3-0 awarded; abandoned at 2-0]
[Jul 25]
Lobi		4-0 Shooting
Gombe		1-0 Jets
Dolphin		2-0 Pillars
Gabros		2-1 Berger
[Jul 28]
Plateau		0-2 Enyimba
[Jul 29]
Nationale	1-0 Rangers

Round 28
[Jul 31]
Kwara		0-0 Plateau
Pillars		2-1 Insurance
Berger		3-0 Gombe
Shooting	2-0 Nationale
El-Kanemi	1-0 Gabros
Wikki		1-2 Dolphin
[Aug 1]
Jets		0-2 NPA
Rangers		2-0 Tornadoes
Enyimba		3-0 Lobi

Round 29
[Aug 7]
Plateau		3-0 Pillars
Berger		3-1 Jets
Insurance	1-0 Wikki
[Aug 8]
Gombe		2-0 El-Kanemi
Dolphin		1-0 NPA
Lobi		4-1 Kwara
[Aug 25]
Tornadoes	1-0 Shooting
Nationale	0-0 Enyimba
[Aug 26]
Gabros		1-0 Rangers

Round 30
[Aug 14]
NPA		1-0 Insurance
Wikki		2-1 Plateau
El-Kanemi	1-0 Berger
Jets		1-2 Dolphins
Kwara		2-2 Nationale
Shooting	1-0 Gabros
Pillars		1-0 Lobi
[Aug 15]
Enyimba		1-0 Tornadoes
Rangers		2-0 Gombe

Round 31
[Aug 21]
Plateau		1-1 NPA
Insurance	2-1 Dolphin
Tornadoes	1-0 Kwara
El-Kanemi	2-0 Jets
Berger		1-1 Rangers
[Aug 22]
Gombe		2-0 Shooting
Nationale	1-0 Pillars
Lobi		2-0 Wikki
Gabros		1-0 Enyimba

Round 32
[Aug 28]
Pillars		3-0 Tornadoes
Shooting	1-0 Berger
Wikki		2-0 Nationale
NPA		2-1 Lobi
[Aug 29]
Jets		awd Insurance	[awarded 0-3; Jets refused to play its home game
Kwara		1-0 Gabros       at the Rwang Pam Stadium in Jos]
Dolphin		1-0 Plateau
Rangers		1-0 El-Kanemi
Enyimba		1-0 Gombe

Round 33 [Sep 5]
Nationale	1-0 NPA
El-Kanemi	2-0 Shooting
Gombe		2-1 Kwara
Gabros		2-0 Pillars
Tornadoes	2-0 Wikki
Plateau		0-3 Insurance
Lobi		1-0 Dolphin
Rangers		1-0 Jets
Berger		1-2 Enyimba


Round 34 [Sep 22]
NPA		2-0 Tornadoes
Jets		1-1 Plateau
Pillars		7-1 Gombe
Wikki		3-0 Gabros
Dolphin		4-0 Nationale
Insurance	4-0 Lobi     	[protest Lobi against margin of defeat; they
Kwara		2-1 Berger       said they walked out at 0-3 and were forced
Enyimba		3-0 El-Kanemi    back on the pitch by guns for Insurance to 
Shooting	2-1 Rangers      score the extra goal qualifying them to the
Pillars		7-1 Gombe        Confederations Cup; a 3-0 award would give
Wikki		3-0 Gabros       Kano Pillars third place]

Final Table:

 1.Dolphin (Port Harcourt)          34  19  5 10  44-30  62  Champions
 2.Enyimba (Aba)                    34  18  6 10  44-24  60
 3.Bendel Insurance (Benin City)    34  17  5 12  45-29  56
 4.Kano Pillars                     34  17  5 12  43-27  56
 5.Iwuanyanwu Nationale (Owerri)    34  17  5 12  31-23  56
 6.Enugu Rangers                    34  14 10 10  28-21  52
 7.Lobi Stars FC (Makurdi)          34  15  5 14  44-34  50
 8.Gombe United (Bauchi)            34  15  3 16  30-40  48
 9.Gabros International (Nnewi)     34  14  5 15  23-27  47
10.Shooting Stars (Ibadan)          34  14  5 15  39-47  47
11.Nigerian Ports Authority (Warri) 34  14  4 16  35-35  46  [aka NPA]
12.Julius Berger (Lagos)            34  13  7 14  36-37  46
13.Niger Tornadoes (Minna)          34  14  4 16  27-32  46
14.El-Kanemi Warriors (Maiduguri)   34  14  4 16  25-37  46
-----------------------------------------------------------
15.Wikki Tourists (Bauchi)          34  14  3 17  36-42  45  Relegation Playoff
16.Kwara United (Ilorin)            34  12  6 16  37-43  42  Relegation Playoff
17.Plateau United (Jos)             34   8 11 15  26-36  35  Relegation Playoff
18.Mighty Jets (Jos)                34   7  7 20  20-49  28  Relegation Playoff

Top scorers: 1. Kabiru Alausa (Berger)	13 goals
             2. Daniel Njoku (Kwara)	12
             3. Chidoze Johnson (Wikki)	12

Promoted: Gateway FC (Abeokuta), Sharks (Port Harcourt), 
          Nasarawa United (Lafia) and Zamfara United (Gusau). 

2005 season starts on Feb 12 (postponed from Jan 15) due to a decision
to extend the top level to 20 clubs; the 2 remaining places will be
decided in a play-off between the originally relegated teams from the 
top level and the 3rd placed teams from both second level groups.

Promotion/Relegation Playoffs [Jan 28-30, 2005]

Group A (in Kaduna)
Wikki Tourists (Bauchi) - winners
Mighty Jets (Jos)   
Adamawa United
NB: Adamawa announced they will not enter claiming they should have
    obtained automatic promotion

Group B (in Benin City) 
Kwara United (Ilorin)   - winners
Plateau United (Jos)  
Ebonyi Angels FC





Authors: José Batalha
(jose.batalha@netvisao.pt)
and Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 20 Feb 2005

(C) Copyright 
José Batalha, Hans Schöggl and RSSSF 2004/05
						


  USO DE MEMORIA  
4,302,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.6176
Total Execution Time  0.6199
  CADENA URL  
/premier_league_nigeria2004
  GET DATOS  
$_GET['/premier_league_nigeria2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT type FROM routes WHERE alias = 'premier_league_nigeria2004'
0.0298  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0149  SELECT text_es as historical_text FROM leagues_text WHERE id=519
0.0145  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 = 28836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='2004' WHERE c.parentId=490 GROUP BY c.id ORDER BY c.order_id ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 04:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 04:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 04:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 04:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0154  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (28836) 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.0152  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 (28836) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (28836) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (28836) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (28836) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0152  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 (28836) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (28836) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (28836) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 28836 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 28836 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=28836 AND rel.round=34
0.0146  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 = 28836 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 28836 AND esl.points > 0
0.0146  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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28836 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28836
0.0146  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 `calendars2004` 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` = 28836 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events2004` e INNER JOIN calendars2004 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 = 28836 ORDER BY total DESC LIMIT 40
0.0147  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 `events2004` e INNER JOIN calendars2004 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 = 28836 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  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 `tables2004` 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 = 28836 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 28836 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 28836 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=490
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 490 AND l.year = 2004 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=490 AND year=2004