4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Angola Girabola 2000
1999/2000

Liga Angola Girabola 2000

Información Histórica
						
Final Table:

 1.Petro Atlético (Luanda)               26  20  3  3  66-17  63  Champions
 2.ASA                                   26  13  5  8  47-29  44  CAF Cup
 3.Petro Atlético (Huambo)               26  12  6  8  28-23  42  
 4.Inter (Luanda)                        26  12  4 10  30-27  40  [2 1 0 1 2-1 3]  Cup Winners
 5.Deportivo Primeiro de Agosto (Luanda) 26  11  7  8  33-19  40  [2 1 0 1 1-2 3]
 6.Deportivo Sonangol (Namibe)           26  11  6  9  32-30  39
 7.Académica (Lobito)                    26  10  6 10  28-35  36   
 8.Benfica (Luanda)                      26  11  2 13  35-44  35 
 9.Onze Bravos de Moxico (Luena)         26   8  9  9  29-34  33  [2 1 1 0 2-1 4]
10.Sagrada Esperança                     26   9  6 11  21-30  33  [2 0 1 1 1-2 1]
11.FC Cabinda (Cabinda)                  26   8  8 10  24-31  32
----------------------------------------------------------------
12.Sporting (Cabinda)                    26   8  7 11  28-29  31  Relegated
13.ARA (Gabela)                          26   6  2 18  23-46  20  Relegated
14.Sporting (Bié)                        26   5  3 18  20-50  18  Relegated

Round 1 [Mar 18]
Sagrada Esperança       0-0 1º de Agosto        [Mar 25]
Benfica Luanda          2-1 11 Bravos Maqui     [Mar 20]
  (Fofana, 38, Olavo, 90; ?, 1)
Sporting Bié            0-1 Sonangol Namibe
  (Yaba, 90)
Petro Huambo            2-0 FC Cabinda
Sporting Cabinda        0-3 Petro Luanda        [Mar 19]
  (Biavanga, Guedes, Jonas)
Inter Luanda		3-1 Académica Lobito	[Apr 5]
ARA Gabela		0-2 ASA Luanda          [Apr 26]

Round 2 [Apr 2]
Académica Lobito        1-0 Sporting Cabinda    [Mar 29]
  (César Cana, 91)
FC Cabinda              3-2 Sporting Bié
1º Agosto		0-2 Inter Luanda	[Apr 9]
Onze Bravos		1-0 Sagrada Esperança	[Jun 18]
ASA			3-1 Benfica Luanda	[Apr 12]
  (Tostão, 13, Zé d'Angola, 25, Diniz, 44; ?)
Sonangol		3-0 ARA Gabela          [May 3]
Petro Luanda		2-1 Petro Huambo	[Apr 8]
  (Biav M'Biyavanla, Guedes; Gazeta)

Round 3	[Apr 16]
Académica Lobito	0-0 1º Agosto		[Apr 15]
Inter Luanda		2-1 Onze Bravos		[Apr 15]
  (André, 41, Pati, 68; Gilberto, 57)
Sagrada Esperança	1-0 ASA
Benfica Luanda		4-2 Sonangol
ARA Gabela		4-0 FC Cabinda		[Apr 17]
  (Manuel Marreta, 22, 38, 55, António, 45)
Sporting Bié		0-3 Petro Luanda        [May 17]
Sporting Cabinda	3-0 Petro Huambo	[Apr 17]
  (Nélson, 67, 80, Kani, 58)

Round 4 [Apr 30]
1º Agosto		1-1 Sporting Cabinda	[Apr 29]
  (Moisés, 12; ?, 90)
Onze Bravos		1-1 Académica Lobito	[May 1]
ASA			5-2 Inter Luanda	[May 1]
Sonangol		3-0 Sagrada Esperana
FC Cabinda		1-2 Benfica Luanda	[Apr 29]
Petro Luanda		6-1 ARA Gabela
Petro Huambo		2-1 Sporting Bié        [May 2]	

Round 5 [May 7]	
1º Agosto		1-1 Onze Bravos         [May 17]
Académica Lobito	1-0 ASA
  (Bravo da Rosa, 88)
Inter Luanda		0-2 Sonangol
  (Zé Augusto, 68, Jean Jacques, 84)
Sagrada Esperança	0-0 FC Cabinda		[Jun 22]
Benfica Luanda		0-6 Petro Luanda	[May 6]
  (Flávio, 5, 14, Zico, 32, Renato, 54, Betinho, 69, Guedes, 81)
ARA Gabela		0-1 Petro Huambo
  (Renato, 3)
Sporting Cabinda	1-0 Sporting Bié
  (Nílsson, 46)

Round 6 [May 14]	
Onze Bravos		1-0 Sporting Cabinda
ASA			2-1 1º Agosto		[May 13]
  (Miro, 75, Joni, 89; Isaac, 88)
Sonangol		0-1 Académica Lobito
FC Cabinda		1-0 Inter Luanda
Petro Luanda		4-1 Sagrada Esperança
Petro Huambo		2-1 Benfica Luanda
Sporting Bié		1-0 ARA Gabela

Round 7	[May 21]
1º Agosto		4-1 Sonangol		[May 20]
Sagrada Esperança	3-0 Petro Huambo	[May 20]
Benfica Luanda		4-1 Sporting Bié
Sporting Cabinda	2-1 ARA Gabela
Onze Bravos		2-2 ASA			[May 25]			
Académica Lobito	2-0 FC Cabinda		[Jun 18]		
Inter Luanda		0-3 Petro Luanda	[May 24]	

Round 8	[May 28]
ASA			2-2 Sporting Cabinda	[May 30]
Sonangol		1-1 Onze Bravos
  (Kandé, 33; Batalha, 50)
FC Cabinda		1-0 1º Agosto		[May 31]
  (Jorge, 20)
Petro Luanda		6-1 Académica Lobito	[May 29]
  (Flávio (3 goals), Bétinho (2 goals), Biavanga (1 goal); Brandão)
Petro Huambo		1-1 Inter Luanda	[Jun 18]	
Sporting Bié		awd Sagrada Esperança	[awarded 0-0 loss against both]
ARA Gabela		1-2 Benfica Luanda	[May 27]

Round 9 [Jun 4]	
ASA			2-0 Sonangol		[Jun 2]
Onze Bravos		2-1 FC Cabinda          [played later]
1º Agosto		0-0 Petro Luanda
Académica Lobito	0-0 Petro Huambo
Inter Luanda		3-1 Sporting Bié	[Jun 3]
  (Dady, Mimoso, Paulito; Papi (own goal)) 
Sagrada Esperança	2-1 ARA Gabela          [Jul 16]
Sporting Cabinda	2-1 Benfica Luanda

Round 10 [Jun 7]	
Sonangol		2-0 Sporting Cabinda
FC Cabinda		1-0 ASA
Petro Luanda		2-1 Onze Bravos		[Jun 8]
Petro Huambo		1-0 1º Agosto
Sporting Bié		1-0 Académica Lobito	[Jun 28]
  (Zaza, 3)
ARA Gabela		0-3 Inter Luanda
Benfica Luanda		1-2 Sagrada Esperança	[Jun 8]
  (Blanchar; Lopes, Natércio)

Round 11 [Jun 11]	
Sonangol		0-0 FC Cabinda          [Jun 12]
ASA			1-2 Petro Luanda	[Jun 10]
  (Yamba-Ashi; Zico, Betinho)
Onze Bravos		0-0 Petro Huambo        [Jun 12]
1º Agosto		4-0 Sporting Bié
Académica Lobito	3-2 ARA Gabela
Inter Luanda		1-0 Benfica Luanda	[Jun 12]
Sporting Cabinda	1-1 Sagrada Esperança

Round 12 [Jun 25]	
Sporting Cabinda	1-1 FC Cabinda
Petro Luanda		3-0 Sonangol		[Jun 24]
  (Avelino Lopes, Jonas, Chinho)
Petro Huambo		1-0 ASA			
Sporting Bié		0-0 Onze Bravos
ARA Gabela		1-0 1º Agosto		[Jun 24]
Benfica Luanda		5-1 Académica Lobito
  (Blanchar-3 goals)
Sagrada Esperança	0-3 Inter Luanda

Round 13 [Jul 2]	
FC Cabinda		0-3 Petro Luanda	[Jul 1]
Sonangol		2-1 Petro Huambo
ASA			3-2 Sporting Bié	[Jul 27]
Onze Bravos		2-1 ARA Gabela
1º Agosto		5-0 Benfica Luanda	[Jul 27]
Académica Lobito	2-0 Sagrada Esperança
Inter Luanda		1-0 Sporting Cabinda

Round 14 [Jul 30]
Académica Lobito	0-0 Inter Luanda	[Jul 29]
1º Agosto		5-1 Sagrada Esperança
  (Isaac, 17, 41, Benjamin, 54, Jorginho, 66, Dé, 89; Naterço, 38)
Onze Bravos		2-0 Benfica Luanda
  (Quim Batalha, 19, Van Basten, 90)
ASA			4-1 Ara Gabela
  (Esquerdinho, 1, Dinis, 10, Zé d'Angola, 23, Miro, 61; Fernando, 20)
Sonangol		1-0 Sporting Bié
  (Jorge, 30)
FC Cabinda		1-0 Petro Huambo
  (André, 73)
Petro Luanda		2-1 Sporting Cabinda	[Jul 29]
  (Zico, 1, Chinho, 24; Rico, 67)

Round 15 [Aug 6]
Sporting Cabinda	4-1 Académica Lobito
Inter Luanda		0-1 1º Agosto		[Aug 7]
  (Stopirra, 90)
Sagrada Esperança	1-1 Onze Bravos		[Aug 7]
Benfica Luanda		2-1 ASA			[Aug 5]
  (Blanchard, 59, Maccabi, 88; Zé d´Angola, 25)
Ara Gabela		0-1 Sonangol
Sporting Bié		1-0 FC Cabinda
Petro Huambo		0-2 Petro Luanda	[Aug 5]
  (Flávio, 38, Zico, 70)

Round 16 [Aug 13]
1º Agosto		2-1 Académica Lobito	[Aug 12]
  (Mwemby, 85,penalty, Loló, 90; César Ganã, 15)
Onze Bravos		1-1 Inter Luanda	[Aug 12]
ASA			1-0 Sagrada Esperança	[Aug 14]
  (Silas, 28)
Sonangol		1-1 Benfica Luanda	[Aug 12]
FC Cabinda		2-3 ARA Gabela
  (André, 27, penalty, Sebastião, 90; Osvaldo, 1, Jesus, 24, Chico, 45)
Petro Luanda		5-0 Sporting Bié
  (Flávio, 33, 90, Zico, 74, Biavanga, 78, Avelino Lopes, 85)
Petro Huambo		1-0 Sporting Cabinda
  (Eliseu, 74)

Round 17 [Aug 20]
Sporting Cabinda	1-1 1º Agosto
  (Além, 86; Nelo, 4)
Académica Lobito	1-0 Onze Bravos
  (Cotel, 54 penalty)
Inter Luanda		1-3 ASA
  (Mimoso, 67; Love, 22, Minhonha, 71, Filas, 90)
Sagrada Esperança	1-0 Sonangol
  (Natércio, 68)
Benfica Luanda		1-1 FC Cabinda		[Aug 21]
  (Cadima, 57; Ntonda, 85)
ARA Gabela		2-2 Petro Luanda
  (Jamba, 30, Avelino Lopes, 53 own goal; Biavanga, 72, Flávio, 84)
Sporting Bié		0-0 Petro Huambo

Round 18 [Aug 27]
Onze Bravos		0-1 1º Agosto		[Aug 26]
ASA			2-0 Académica Lobito	[Aug 29]
  (Arsénio Love, 15, 81)
FC Cabinda		1-0 Sagrada Esperança	[Aug 26]
Sporting Bié		2-0 Sporting Cabinda	[Aug 29]
  (Korando, 42, Daddy, 88)
Sonangol		1-0 Inter Luanda	[Sep 2]
Petro Luanda		3-0 Benfica Luanda	[Sep 13]
  (Biavanga (2), Zico)
Petro Huambo		awd ARA Gabela		[Sep 13; awarded 3-0, ARA dns]

Round 19 [Sep 10]
Sporting Cabinda	5-1 Onze Bravos
  (Além, 57, André, 59, Agô, 75, Moni, 85, 89; Quim Batalha, 78 penalty)
1º Agosto		1-0 ASA			[Sep 9]
  (Muembe, 52)
Académica Lobito	1-1 Sonangol
  (Joãozinho, 30; Cambota, 61)
Inter Luanda		2-1 FC Cabinda
  (Júlio, 55, André, 60; Miulé, 88)
Sagrada Esperança	2-1 Petro Luanda
  (Cubano, 20 penalty, Bunga, 24;Jonas, 62) 
Benfica Luanda		3-2 Petro Huambo	[Sep 9]
  (Maccabi, 20, Fofana, 23, Blanchard, 45; Gazeta, 66, Rufino, 80) 
ARA Gabela		2-0 Sporting Bié
  (Jesus, 4, Manuel Marreta, 80 penalty)

Round 20 [Sep 17]
ASA			4-2 Onze Bravos		[Sep 16]
  (Nelo, Love (2 goals), Vítor; Quim Batalha, Jorge)
Sonangol		2-0 1º Agosto
  (Cambota, Além penalty)
FC Cabinda		2-1 Académica Lobito
  (Baton, Andya penalty; Patrik)
Petro Luanda		1-0 Inter Luanda
  (Flávio, 90)
Petro Huambo		1-0 Sagrada Esperança
  (Zé Nely)
Sporting Bié		3-1 Benfica Luanda	[Oct 7]
  (Taty, 7, 13, Zazá, 62; Blanchard, 1)
ARA Gabela		0-1 Sporting Cabinda
  (Lopinho)

Round 21 [Sep 24]
Sporting Cabinda	0-0 ASA			[Sep 23]
Onze Bravos		3-1 Sonangol		[Sep 23]
  (Quim Batalha (2), Van Basten; Jean Jacques)
1º Agosto		1-1 FC Cabinda		[Oct 11]
  (Filipe, 85 pen; Manuel, 38)
Académica Lobito	1-0 Petro Luanda
  (Betinho, 84)
Inter Luanda		1-0 Petro Huambo
  (Papi, 56)
Sagrada Esperança	1-1 Sporting Bié	[Oct 12]
Benfica Luanda		1-0 ARA Gabela
  (Rui Carlos, 20)

Round 22 [Oct 1]
Sonangol		2-2 ASA			[Sep 30]
  (Jean Jacques, 17, Kandé, 21; Jamba, 9, Love, 75)
FC Cabinda		3-0 Onze Bravos
  (Baton, 3, Andia, 46, Jorge, 78)
Petro Luanda		1-0 1º Agosto
  (Avelino Lopes, 16)
Petro Huambo		2-0 Académica Lobito
  (Calala, 73, Betinho, 80)
Sporting Bié		1-3 Inter Luanda	[Sep 30]
  (Tapi, 87 pen; Pati, 41, 43, Zigor, 75)
ARA Gabela		0-1 Sagrada Esperança
  (Bunga, 72)
Benfica Luanda		1-0 Sporting Cabinda	[Sep 30]
  (Blanchar, 2)

Round 23 [Oct 15]
Sporting Cabinda	1-3 Sonangol
  (Nilsson, 86; Kaldé, 20, 45, 78)
ASA			1-0 FC Cabinda		[Oct 16]
  (Simão, 79)
Onze Bravos		1-0 Petro Luanda	[Oct 14]
  (Quim Batalha, 29)
1º Agosto		0-2 Petro Huambo	[Oct 14]
  (Silvino, 25, Kalala, 42)
Académica Lobito	4-0 Sporting Bié
  (César Cana, 7, 29, 59, Patrick, 37)
Inter Luanda		0-0 ARA Gabela
Sagrada Esperança	1-0 Benfica Luanda	[Oct 16]

Round 24 [Oct 22]
FC Cabinda		0-0 Sonangol		[Oct 21]
Petro Luanda		2-1 ASA			[Oct 20]
Petro Huambo		1-1 Onze Bravos
Sporting Bié		0-1 1º Agosto		[Oct 21]
  (Mulembé, 60)
ARA Gabela		2-1 Académica Lobito
Benfica Luanda		2-0 Inter Luanda	[Oct 25]
  (Kadima, 10, Dito, 85)
Sagrada Esperança	1-0 Sporting Cabinda

Round 25 [Oct 29]
FC Cabinda		1-1 Sporting Cabinda
Sonangol		1-2 Petro Luanda
ASA			1-1 Petro Huambo
Onze Bravos		3-2 Sporting Bié
1º Agosto		3-0 ARA Gabela		[Nov 1]
Académica Lobito	1-0 Benfica Luanda
Inter Luanda		1-0 Sagrada Esperança

Round 26 [Nov 5]
Petro Luanda		2-2 FC Cabinda
  (Gugu, 53 own goal, Biavanga, 85; Andia, 32, Gugu, 87)
Petro Huambo		3-1 Sonangol
  (Gazeta, 7, 90, Calala, 28; Codeh, 46)
Sporting Bié		1-5 ASA
  (Papi, 45; Love, 10, 43, Zé d'Angola, 26, 55, Miro, 65)
ARA Gabela		1-0 Onze Bravos
  (Manuel Marreta, 31)
Benfica Luanda		0-1 1º Agosto		[Nov 4]
  (Vítor, 38)
Sagrada Esperança	2-2 Académica Lobito
  (Jaburu, 23, Nzaji, 26; Bravo da Rosa, 20, Martinho, 71)
Sporting Cabinda	1-0 Inter Luanda
  (Valic, 46 pen)

Final Table:

 1.Petro Atlético (Luanda)               26  20  3  3  66-17  63  Champions
 2.ASA                                   26  13  5  8  47-29  44  CAF Cup
 3.Petro Atlético (Huambo)               26  12  6  8  28-23  42  
 4.Inter (Luanda)                        26  12  4 10  30-27  40  [2 1 0 1 2-1 3]  Cup Winners
 5.Deportivo Primeiro de Agosto (Luanda) 26  11  7  8  33-19  40  [2 1 0 1 1-2 3]
 6.Deportivo Sonangol (Namibe)           26  11  6  9  32-30  39
 7.Académica (Lobito)                    26  10  6 10  28-35  36   
 8.Benfica (Luanda)                      26  11  2 13  35-44  35 
 9.Onze Bravos de Moxico (Luena)         26   8  9  9  29-34  33  [2 1 1 0 2-1 4]
10.Sagrada Esperança                     26   9  6 11  21-30  33  [2 0 1 1 1-2 1]
11.FC Cabinda (Cabinda)                  26   8  8 10  24-31  32
----------------------------------------------------------------
12.Sporting (Cabinda)                    26   8  7 11  28-29  31  Relegated
13.ARA (Gabela)                          26   6  2 18  23-46  20  Relegated
14.Sporting (Bié)                        26   5  3 18  20-50  18  Relegated

NB: one round (sic!) before the end of the season, the FA decided to relegated
    3 (rather than 2) teams.

NB: Cambondo Sport Clube (Malanje) withdrew due to financial
    difficulties and were replaced by ARA Gabela (after Independente
    de Tômbwa had declined to play off against ARA for the place;
    Saneamento Rangol were renamed Benfica
    ARA = Associação Recreativa do Amboím

Topscorer: Blanchard (Benfica)	19 goals




Girabola 2001 will start March 2001.

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

Last updated: 7 Mar 2001

(C) Copyright José Batalha and
RSSSF 2000/01
						


  USO DE MEMORIA  
4,296,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1201
Total Execution Time  0.1222
  CADENA URL  
/liga_angola2000
  GET DATOS  
$_GET['/liga_angola2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0020  SELECT type FROM routes WHERE alias = 'liga_angola2000'
0.0049  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_angola' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=327 AND type_rel = 3
0.0052  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 327 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0034  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 (828726,820194,648077,240734,176654) ORDER BY n.cover_points DESC, update_date DESC
0.0027  SELECT text_es as historical_text FROM leagues_text WHERE id=2238
0.0027  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 = 30490 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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='2000' WHERE c.parentId=327 GROUP BY c.id ORDER BY c.order_id ASC
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 09:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 09:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 09:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 09:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0052  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_angola' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30490) 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.0023  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 (30490) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30490) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (30490) 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 events2000 e WHERE e.league_id IN (30490) 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 (30490) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30490) AND (e.action IN (22) ) 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 (30490) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30490 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 30490 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
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=30490 AND rel.round=26
0.0031  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 = 30490 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30490 AND esl.points > 0
0.0021  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-25" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30490 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-25" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30490
0.0021  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 `calendars2000` 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` = 30490 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 26 AND e.real_date IS NOT NULL AND e.league_id = 30490 ORDER BY total DESC LIMIT 40
0.0021  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 `events2000` e INNER JOIN calendars2000 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 = 30490 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 `tables2000` 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 = 30490 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 30490 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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-24 00:00:00' AND c.`shedule` < '2024-04-28 23:59:59' AND l.id = 30490 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=327
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 327 AND l.year = 2000 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=327 AND year=2000