4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1998
Temporada Siguiente »
Publicidad 600x120.gif
Liga Angola Girabola 1998
1997/1998

Liga Angola Girabola 1998

Información Histórica 
						
Girabola 1998

Table (point totals after 28 rounds):

 1.Deportivo Primeiro de Agosto (Luanda) 62  Champions
 2.Petro Atlético (Luanda)               58
 3.ASA                                   50
 4.Saneamento Rangol (Luanda)
 5.Sagrada Esperança                     48
   FC Kabuscorp (Palanca)                47  [*]  Relegated 
   Deportivo Sonangol (Namibe)           40
   Progresso (Sambizanga)
   Petro Atlético (Huambo)               37
   Académica (Lobito)                    36
   Independente (Tômbwa)                 35
   FC Cabinda (Cabinda)                  34
   Sporting (Cabinda)                    33
14.Onze Bravos de Moxico (Luena)         31
-------------------------------------------
15.Sécil Marítima (Luanda)               23  Relegated
16.FC Chicoil (Menongue)                 20  Relegated

[*] FC Kabuscorp forfeited their matches in rounds 29 and 30; due
    to Girabola rules this meant that all their results were annulled,
    and Kabuscorp were relegated in spite of their appeals; in addition
    ASA finished 3rd and Saneamento Rangol 4th, instead of vice versa.

Promoted: Inter (Luanda), Ferroviário de Huila (Lubango), Cambondo (Malanje)

Round 1 [Apr 5]
Académica Lobito	1-0 ASA
Independente		D-V Petro Luanda
Sporting Cabinda	D-V Sagrada Esperança
Sécil			D-V Petro Huambo
Onze Bravos		V-D FC Cabinda
1º Agosto		2-1 Sonangol
Progresso		E-E Rangol
Kabuscorp		V-D Chicoil
  
Round 2 [Apr 12]
ASA			V-D Kabuscorp
Petro Luanda		V-D Académica Lobito
Sagrada Esperança	V-D Independente
Petro Huambo		E-E Sporting Cabinda
FC Cabinda		E-E Sécil
Sonangol		V-D Onze Bravos
Rangol			0-0 1º Agosto
Chicoil			V-D Progresso

Round 3 [Apr 19]
ASA			1-2 Petro Luanda
Académica Lobito	1-2 Sagrada Esperança
Independente		2-1 Petro Huambo
FC Cabinda		2-3 Sporting Cabinda
Sécil			1-0 Sonangol
Onze Bravos		1-2 Rangol
1º Agosto		2-0 Chicoil
Kabuscorp		2-1 Progresso

Round 4 [Apr 26]
Petro Luanda		2-0 Kabuscorp
Sagrada Esperança	2-1 ASA
Petro Huambo		V-D Académica Lobito
FC Cabinda		V-D Independente
Sonangol		D-V Sporting Cabinda
Rangol			V-D Sécil
Chicoil			V-D Onze Bravos
Progresso		E-E 1º Agosto

Round 5 [May 3]
Sagrada Esperança	E-E Petro Luanda
ASA			V-D Petro Huambo
Académica Lobito	V-D FC Cabinda
Independente		E-E Sonangol
Sporting Cabinda	--- Rangol
Sécil			V-D Chicoil
Onze Bravos		V-D Progresso
Kabuscorp		1-6 1º Agosto

Round 6 [May 10]
Sagrada Esperança	V-D Kabuscorp
Petro Huambo		V-D Petro Luanda
FC Cabinda		D-V ASA
Sonangol		V-D Académica Lobito
Rangol			E-E Independente
Chicoil			--- Sporting Cabinda
Sécil			E-E Progresso
1º Agosto		V-D Onze Bravos

Round 7 [May 17]
Sagrada Esperança	0-0 Petro Huambo
Petro Luanda		4-0 FC Cabinda
ASA			2-0 Sonangol
Académica Lobito	1-1 Rangol
Independente		2-0 Chicoil
Sporting Cabinda	0-0 Progresso
Sécil			0-1 1º Agosto
Kabuscorp		3-0 Onze Bravos

Round 8 [May 24]
Petro Huambo		V-D Kabuscorp
FC Cabinda		V-D Sagrada Esperança
Sonangol		V-D Petro Luanda
Rangol			D-V ASA
Chicoil			E-E Académica Lobito
Progresso		V-D Independente
1º Agosto		V-D Sporting Cabinda
Onze Bravos		E-E Sécil

Round 9 [May 31]
Petro Huambo		0-0 FC Cabinda
Sagrada Esperança	2-0 Sonangol
Petro Luanda		2-0 Rangol
ASA			2-1 Chicoil
Académica Lobito	0-0 Progresso
Independente		2-1 1º Agosto
Sporting Cabinda	2-3 Onze Bravos
Kabuscorp		1-0 Sécil

Round 10 [Jun 7]
FC Cabinda		3-2 Kabuscorp
Petro Huambo		ppd Sonangol
Rangol			2-1 Sagrada Esperança
Chicoil			0-0 Petro Luanda
Progresso		0-1 ASA
1º Agosto		1-0 Académica Lobito
Onze Bravos		1-1 Independente
Sécil			0-0 Sporting Cabinda

Table (without total goals):
 1. 1º Agosto		10   7   2   1  23
 2. ASA			10   7   0   3  21
 3. Petro Luanda	10   6   2   2  20
 4. Sagrada Esperança	10   6   2   2  20
 5. Petro Huambo	 9   4   3   2  15
 6. Rangol		 9   3   4   2  13
 7. Independente	10   3   3   4  12
 8. Kabuscorp		10   4   0   6  12
 9. Onze Bravos		10   3   2   5  11
10. FC Cabinda		10   3   2   5  11
11. Sécil		10   2   4   4  10
12. Sonangol		 9   3   1   5  10
13. Sporting Cabinda	 8   2   3   3   9
14. Académica Lobito	10   2   3   5   9
15. Progresso		10   1   5   4   8
16. Chicoil		 9   2   2   5   8

Round 11 [Jun 14]
FC Cabinda		--- Sonangol
Petro Huambo		2-3 Rangol
Chicoil			D-V Sagrada Esperança
Petro Luanda		--- Progresso
ASA			--- 1º Agosto
Académica Lobito	--- Onze Bravos
Independente		--- Sécil
Kabuscorp		--- Sporting Cabinda

Round 12 [Jun 21]
Sonangol		3-1 Kabuscorp
Rangol			1-2 FC Cabinda
Chicoil			1-2 Petro Huambo
Progresso		0-0 Sagrada Esperança
1º Agosto		2-1 Petro Luanda
Onze Bravos		1-4 ASA
Sécil			1-1 Académica Lobito
Sporting Cabinda	--- Independente

Round 13 [Jun 28]
Sonangol		1-1 Rangol
FC Cabinda		3-2 Chicoil
Petro Huambo		1-0 Progresso
Sagrada Esperança	0-2 1º Agosto
Petro Luanda		2-1 Onze Bravos
ASA			1-1 Sécil
Académica Lobito	2-0 Sporting Cabinda
Kabuscorp		6-4 Independente

Round 14 [Jul 5]
Rangol			1-0 Kabuscorp
Chicoil			--- Sonangol
Progresso		2-0 FC Cabinda
1º Agosto		3-1 Petro Huambo
Onze Bravos		1-0 Sagrada Esperança
Sécil			0-3 Petro Luanda
Sporting Cabinda	1-3 ASA
Independente		--- Académica Lobito

Round 15 [Jul 12]
Rangol			1-1 Chicoil
Sonangol		0-3 Progresso
FC Cabinda		0-1 1º Agosto
Petro Huambo		4-2 Onze Bravos
Sagrada Esperança	2-1 Sécil
Petro Luanda		3-1 Sporting Cabinda
ASA			1-0 Independente
Académica Lobito	0-1 Kabuscorp

Round 16 [Jul 19]
ASA			2-2 Académica Lobito
Petro Luanda		V-D Independente
Sagrada Esperança	1-0 Sporting Cabinda
Petro Huambo		--- Sécil
FC Cabinda		2-2 Onze Bravos
Sonangol		E-E 1º Agosto
Rangol			2-1 Progresso
Chicoil			--- Kabuscorp

Round 17 [Aug 2]
Kabuscorp		1-0 ASA
Académica Lobito	--- Petro Luanda
Independente		1-0 Sagrada Esperança
Sporting Cabinda	--- Petro Huambo
Sécil			--- FC Cabinda
Onze Bravos		--- Sonangol
1º Agosto		ppd Rangol		[Nov 25]
Progresso		--- Chicoil

Round 18 [Aug 23]
Petro Luanda		--- ASA
Sagrada Esperança       1-0 Académica Lobito
Petro Huambo            3-0 Independente
Sporting Cabinda        1-0 FC Cabinda
Sonangol                2-0 Sécil
Rangol                  --- Onze Bravos
Chicoil                 --- 1º Agosto
Progresso		--- Kabuscorp

Round 19 [Aug 30]
Kabuscorp		--- Petro Luanda
ASA			E-E Sagrada Esperança
Académica Lobito	--- Petro Huambo
Independente		--- FC Cabinda
Sporting Cabinda	--- Sonangol
Sécil			--- Rangol
Onze Bravos		--- Chicoil
1º Agosto		--- Progresso

Round 20 [Sep 2]
Petro Luanda            2-0 Sagrada Esperança
Petro Huambo            --- ASA
FC Cabinda              --- Académica Lobito
Sonangol                3-1 Independente
Rangol                  2-0 Sporting Cabinda
Chicoil                 --- Sécil
Progresso               1-0 Onze Bravos
1º Agosto		4-1 Kabuscorp

Round 21 [Sep 6]
Kabuscorp               3-1 Sagrada Esperança
Petro Luanda            2-0 Petro Huambo
ASA                     0-1 FC Cabinda
Académica Lobito	--- Sonangol                  [Oct 28]
Independente            --- Rangol
Sporting Cabinda        3-1 Chicoil
Progresso               1-0 Sécil
Onze Bravos             3-1 Primeiro Agosto           [Oct 4] ou [Nov ?]

Round 22 [Sep 13]
Petro Huambo            3-1 Sagrada Esperança
FC Cabinda              0-0 Petro Luanda
Sonangol                1-0 ASA
Rangol                  2-3 Académica Lobito
Chicoil                 --- Independente
Progresso               --- Sporting Cabinda
1º Agosto		1-0 Sécil
Onze Bravos             D-V   Kabuscorp                 [Sep 24]

Round 23 [Sep 20]
Kabuscorp               1-1 Petro Huambo
Sagrada Esperança       E-E FC Cabinda
Petro Luanda            1-0 Sonangol
ASA                     1-1 Rangol
Académica Lobito	5-1 Chicoil
Independente            1-0 Progresso
Sporting Cabinda        0-1 1º Agosto			[Sep 23]
Sécil                   5-0 Onze Bravos

Round 24 [Sep 27]
FC Cabinda              2-1 Petro Huambo
Sonangol                1-0 Sagrada Esperança
Rangol                  2-2 Petro Luanda		[Nov 18]
Chicoil                 ppd ASA
Progresso               ppd Académica Lobito
1º Agosto		5-1 Independente
Onze Bravos             2-2 Sporting Cabinda
Sécil                   1-1 Kabuscorp

Table (September 27):
 1. 1º Agosto		21  16   3   2  39 10  51
 2. Petro Luanda	22  14   5   3  39 11  47
 3. ASA			23  11   5   7  26 15  38
 4. Kabuscorp		24  10   8   9  36 41  37
 5. Sonangol		23  11   4   8  23 24  37
 6. Sagrada Esperança	24  10   5   9  29 28  35
 7. Rangol		22  11   8   5  32 20  35
 8. Petro Huambo	23   9   7   7  31 24  34
 9. FC Cabinda		24   7   8   9  20 28  29
10. Académica Lobito	21   7   7   8  26 22  28
11. Independente	24   9   4  10  29 42  28
12. Progresso		21   6   8   7  15 15  26
13. Sporting Cabinda	23   6   5  12  28 36  23
14. Sécil		24   4   8  11  20 32  20
15. Onze Bravos		23   5   6  13  25 38  20
16. Chicoil		21   3   3  15  22 39  12

Round 25 [Oct 11]
Kabuscorp               --- FC Cabinda
Sonangol		--- Petro Huambo
Sagrada Esperança       --- Rangol
Petro Luanda            7-0 Chicoil
ASA                     --- Progresso
Académica Lobito	--- 1º Agosto
Independente		--- Onze Bravos
Sporting Cabinda	--- Sécil

Round 26 [Oct 18]
Sonangol                1-0 FC Cabinda
Rangol                  3-1 Petro Huambo
Sagrada Esperança       1-0 Chicoil
Progresso               0-1 Petro Luanda		[Nov 4]
1º Agosto		2-0 ASA
Onze Bravos             1-0 Académica Lobito
Sécil                   3-0 Independente
Sporting Cabinda        3-2 Kabuscorp

Round 27 [Oct 25]
Kabuscorp               1-1 Sonangol
FC Cabinda              --- Rangol
Petro Huambo            0-1 Chicoil
Sagrada Esperança       --- Progresso
Petro Luanda            0-0 1º Agosto  
ASA                     --- Onze Bravos
Académica Lobito	--- Sécil
Independente            --- Sporting Cabinda

Round 28 [Nov 1]
Rangol                  --- Sonangol
Chicoil                 --- FC Cabinda
Progresso               --- Petro Huambo
1º Agosto		--- Sagrada Esperança
Onze Bravos		--- Petro Luanda
Sécil			--- ASA
Sporting Cabinda	--- Académica Lobito
Independente		--- Kabuscorp

Round 29 [Nov 22]
Kabuscorp		--- Rangol
Sonangol		--- Chicoil
FC Cabinda		--- Progresso
Petro Huambo		--- 1º Agosto
Sagrada Esperança	--- Onze Bravos
Petro Luanda		--- Sécil
ASA			--- Sporting Cabinda
Académica Lobito	--- Independente

Round 30 [Nov 29]
Chicoil			--- Rangol
Progresso		--- Sonangol
1º Agosto		--- FC Cabinda
Onze Bravos		--- Petro Huambo
Sécil			--- Sagrada Esperança
Sporting Cabinda	--- Petro Luanda
Independente		--- ASA
Kabuscorp		--- Académica Lobito

Table (point totals after 28 rounds):

 1.Deportivo Primeiro de Agosto (Luanda) 62  Champions
 2.Petro Atlético (Luanda)               58
 3.ASA                                   50
 4.Saneamento Rangol (Luanda)
 5.Sagrada Esperança                     48
   FC Kabuscorp (Palanca)                47  [*]  Relegated 
   Deportivo Sonangol (Namibe)           40
   Progresso (Sambizanga)
   Petro Atlético (Huambo)               37
   Académica (Lobito)                    36
   Independente (Tômbwa)                 35
   FC Cabinda (Cabinda)                  34
   Sporting (Cabinda)                    33
14.Onze Bravos de Moxico (Luena)         31
-------------------------------------------
15.Sécil Marítima (Luanda)               23  Relegated
16.FC Chicoil (Menongue)                 20  Relegated

[*] FC Kabuscorp forfeited their matches in rounds 29 and 30; due
    to Girabola rules this meant that all their results were annulled,
    and Kabuscorp were relegated in spite of their appeals; in addition
    ASA finished 3rd and Saneamento Rangol 4th, instead of vice versa.

Promoted: Inter (Luanda), Ferroviário de Huila (Lubango), Cambondo (Malanje).



Authors: José Batalha 
(mop00176@mail.telepac.pt)
and Hans Schöggl 
(hans.schoeggl@sbg.ac.at)

Last updated: 17 Apr 2005

(C) Copyright José Batalha, Hans Schöggl and 
RSSSF 1999/2005


  USO DE MEMORIA  
4,289,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0929
Total Execution Time  0.0947
  CADENA URL  
/liga_angola1998
  GET DATOS  
$_GET['/liga_angola1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_angola1998'
0.0038  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=2251
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 30503 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='1998' WHERE c.parentId=327 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-23 08:09:26' 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-23 08:09:26' 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-23 08:09:26' 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-23 08:09:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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 = 1998 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 events1998 e WHERE e.league_id IN (30503) 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.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 (30503) 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 events1998 e WHERE e.league_id IN (30503) AND (e.action IN (4,5) ) 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 (30503) 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 events1998 e WHERE e.league_id IN (30503) AND (e.action IN (3,4) ) 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 (30503) 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 events1998 e WHERE e.league_id IN (30503) AND (e.action IN (22) ) 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 (30503) 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 = 30503 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 = 30503 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=30503 AND rel.round=28
0.0021  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 = 30503 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 30503 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-24" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30503 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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-24" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30503
0.0019  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1998` 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` = 30503 AND c.`round` = 28 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 `events1998` e INNER JOIN calendars1998 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 30503 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 `events1998` e INNER JOIN calendars1998 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 = 30503 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables1998` 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 = 30503 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 30503 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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-23 00:00:00' AND c.`shedule` < '2024-04-27 23:59:59' AND l.id = 30503 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=327
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 327 AND l.year = 1998 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=327 AND year=1998