4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						

Tables:

Group A:

 1.Espérance ST     14  8  6  0 29-12 30
 2.CA Bizertin      14  6  5  3 23-13 23
 3.US Monastir      14  5  7  2 21-20 22
 4.Etoile du Sahel  14  5  5  4 13-12 20
 - - - - - - - - - - - - - - - - - - - -
 5.CO Transports    14  4  5  5 15-14 17
 6.Olympique Béja   14  4  5  5 17-18 17
 7.Stade Tunisien   14  3  5  6 13-17 14
 8.CO Médenine      14  1  2 11 10-35  5

Group B:

 1.Club Africain    14 10  3  1 23- 7 33
 2.CS Sfaxien       14  9  3  2 28-14 30
 3.AS Marsa         14  7  2  5 15-16 23
 4.ES Zarzis        14  4  7  3 14-12 19
 - - - - - - - - - - - - - - - - - - - -
 5.CS Hamam Lif     14  4  6  4 14-13 18
 6.ES Beni Khaled   14  4  4  6  9-15 16
 7.JS Kairouan      14  1  4  9  9-23  7
 8.Olympique Kef    14  1  3 10  5-17  6

Round 1 [Aug 15-16]
Group A
Esperance     4-2 Bizertin
Beja          1-2 Transports
Monastir      2-2 Sahel
Medenine      2-2 Stade T
Group B
Beni Khaled   0-1 Club Africain
Kef           2-0 Kairouan        [2-1?]
Sfaxien       2-0 Marsa
Zarzis        1-1 Hamam Lif

Round 2 [Aug 22,23]
Group A
Transports    1-0 Medenine
Stade T       0-2 Esperance
Bizertin      1-1 Monastir
Sahel         1-1 Beja      
Group B
Club Africain 2-1 Kef       
Marsa         1-0 Beni Khaled  
Hamam Lif     2-2 Sfaxien 
Kairouan      1-0 Zarzis   

Round 3 [Aug 29,30]
Group A
Esperance     1-1 Transports
Stade T       0-0 Bizertin
Beja          1-2 Monastir
Medenine      1-1 Sahel
Group B
Marsa         0-2 Club Africain
Beni Khaled   1-0 Hamam Lif
Zarzis        1-0 Kef
Sfaxien       3-1 Kairouan

Round 4 [Sep 12,13]
Group A
Transports    0-0 Stade T
Monastir      1-0 Medenine
Sahel         0-2 Esperance
Bizertin      2-1 Beja
Group B
Hamam Lif     2-0 Marsa
Kef           0-2 Sfaxien
Kairouan      1-1 Beni Khaled
Club Africain 2-1 Zarzis

Round 5 [Sep 19,20]
Group A
Transports    3-1 Bizertin
Medenine      0-2 Beja
Esperance     3-1 Monastir       [played later (Sep 23?)]
Stade T       0-2 Sahel          [played later (Sep 23?)]
Group B
Marsa         1-0 Kairouan
Hamam Lif     0-2 Club Africain
Beni Khaled   2-1 Kef
Sfaxien       2-2 Zarzis         [played later (Sep 23?)]

Round 6 [Oct 10,11]
Group A
Monastir      3-2 Stade T
Bizertin      4-1 Medenine
Sahel         1-0 Transports     [played later]
Beja          1-1 Esperance      [Oct 14(?)]
Group B
Kairouan      1-1 Hamam Lif
Kef           1-3 Marsa
Zarzis        1-0 Beni Khaled
Club Africain 2-2 Sfaxien        [Oct 14(?)]

Round 7 [Oct 17,18]
Group A
Esperance     4-0 Medenine
Transports    1-1 Monastir   
Stade T       2-0 Beja
Sahel         1-0 Bizertin
Group B
Hamam Lif     1-0 Kef
Marsa         0-0 Zarzis 
Beni Khaled   1-2 Sfaxien
Kairouan      0-1 Club Africain

Round 8 [Oct 24-28] 
Group A
Bizertin      0-0 Esperance 
Transports    1-2 Beja
Sahel         3-1 Monastir  
Stade T       2-0 Medenine  
Group B
Club Africain 4-0 Beni Khaled  
Kairouan      0-0 Kef     
Marsa         2-0 Sfaxien  
Hamam Lif     1-1 Zarzis

Round 9 [Oct 31, Nov 1]
Group A
Esperance     2-1 Stade T
Medenine      1-3 Transports  
Beja          0-0 Sahel
Monastir      1-1 Bizertin
Group B
Beni Khaled   2-2 Marsa
Sfaxien       2-0 Hamam Lif
Zarzis        2-2 Kairouan
Kef           0-1 Club Africain

Round 10 [Nov 14,15]
Group A
Transports    1-2 Esperance
Bizertin      2-0 Stade T
Sahel         0-1 Medenine
Monastir      1-1 Beja
Group B
Club Africain 2-0 Marsa
Hamam Lif     0-0 Beni Khaled
Kef           0-0 Zarzis
Kairouan      2-3 Sfaxien        [Nov 22]

Round 11 [Nov 28,29]
Group A
Esperance     1-1 Sahel
Stade T       1-1 Transports
Medenine      1-2 Monastir     
Beja          0-1 Bizertin
Group B
Marsa         3-2 Hamam Lif
Sfaxien       3-0 Kef            [Dec 16]
Beni Khaled   1-0 Kairouan
Zarzis        1-1 Club Africain  [Dec 16]

Round 12 [Dec 5,6]
Group A
Bizertin      0-0 Transports
Beja          3-2 Medenine
Sahel         0-1 Stade T
Monastir      2-2 Esperance      [Dec 16]
Group B
Club Africain 0-0 Hamam Lif
Kef           0-0 Beni Khaled
Kairouan      1-2 Marsa
Zarzis        2-1 Sfaxien  

Round 13 [Dec 20]
Group A
Esperance     2-2 Beja
Transports    0-1 Sahel
Stade T       1-1 Monastir
Medenine      1-7 Bizertin
Group B
Marsa         1-0 Kef
Hamam Lif     3-0 Kairouan
Beni Khaled   1-0 Zarzis
Sfaxien       2-0 Club Africain

Round 14 [Dec 27]
Group A
Bizertin      2-0 Sahel
Beja          2-1 Stade T
Monastir      2-1 Transports
Medenine      0-3 Esperance
Group B
Club Africain 3-0 Kairouan
Sfaxien       2-0 Beni Khaled
Kef           0-1 Hamam Lif
Zarzis        2-0 Marsa

Tables:

Group A:

 1.Espérance ST     14  8  6  0 29-12 30
 2.CA Bizertin      14  6  5  3 23-13 23
 3.US Monastir      14  5  7  2 21-20 22
 4.Etoile du Sahel  14  5  5  4 13-12 20
 - - - - - - - - - - - - - - - - - - - -
 5.CO Transports    14  4  5  5 15-14 17
 6.Olympique Béja   14  4  5  5 17-18 17
 7.Stade Tunisien   14  3  5  6 13-17 14
 8.CO Médenine      14  1  2 11 10-35  5

Group B:

 1.Club Africain    14 10  3  1 23- 7 33
 2.CS Sfaxien       14  9  3  2 28-14 30
 3.AS Marsa         14  7  2  5 15-16 23
 4.ES Zarzis        14  4  7  3 14-12 19
 - - - - - - - - - - - - - - - - - - - -
 5.CS Hamam Lif     14  4  6  4 14-13 18
 6.ES Beni Khaled   14  4  4  6  9-15 16
 7.JS Kairouan      14  1  4  9  9-23  7
 8.Olympique Kef    14  1  3 10  5-17  6

First four of each group qualified for championship playoff,
bottom four for relegation playoff.

Group winners (Espérance ST and Club Africain) obtain two
bonus points for championship playoff, runners-up (CA Bizertin
and CS Sfaxien) one each.  

Four teams to be relegated form relegation section with similar
bonus point system.


Championship Playoff

Final Table:

 1.Espérance ST     14 11  3  0 31- 8 38  [2]  Champions
 2.CA Bizertin      14  6  6  2 18-14 25  [1]     
 3.CS Sfaxien       14  7  2  5 15-12 24  [1]
 4.Etoile du Sahel  14  5  5  4 18-13 20
 5.AS Marsa         14  5  3  6 11-13 18
 6.Club Africain    14  4  3  7 13-20 17  [2] 
 7.US Monastir      14  1  7  6 13-21 10 
 8.ES Zarzis        14  2  1 11  9-27  7 

Round 1 [Jan 31]
Bizertin      2-0 Sfaxien
Sahel         4-0 Zarzis
Monastir      0-1 Club Africain 
Esperance     2-0 Marsa

Round 2 [Feb 7]
Zarzis        0-1 Bizertin
Club Africain 2-2 Sahel
Marsa         0-0 Monastir
Sfaxien       0-0 Esperance           [played later?]

Round 3 [Feb 14]
Bizertin      3-2 Club Africain
Sahel         2-0 Marsa
Sfaxien       3-1 Zarzis
Esperance     2-1 Monastir

Round 4 
[Mar 13]
Marsa         0-0 Bizertin
[Mar 16]
Zarzis        0-1 Esperance
[Mar 17]
Monastir      0-1 Sahel
Club Africain 1-0 Sfaxien

Round 5 [Mar 21]
Esperance     2-1 Sahel  
Zarzis        2-0 Club Africain
Sfaxien       2-0 Marsa
Bizertin      2-2 Monastir

Round 6
[Mar 26]
Marsa         2-0 Zarzis
Monastir      1-1 Sfaxien
[Apr 1]
Club Africain 0-1 Esperance
Sahel         1-1 Bizertin

Round 7 [Apr 17]
Esperance     4-1 Bizertin
Marsa         2-0 Club Africain
Sfaxien       1-0 Sahel
Zarzis        0-1 Monastir

Round 8 [Apr 21]
Sfaxien       0-2 Bizertin
Zarzis        2-0 Sahel
Club Africain 4-2 Monastir
Marsa         0-2 Esperance

Round 9 [Apr 25]
Esperance     2-1 Sfaxien
Bizertin      2-0 Zarzis
Monastir      0-0 Marsa
Sahel         1-1 Club Africain

Round 10 
[May 5]
Club Africain 0-0 Bizertin
Zarzis        2-3 Sfaxien
Monastir      2-4 Esperance
[May 6]
Marsa         1-2 Sahel

Round 11 [May 9]
Esperance     5-0 Zarzis
Sfaxien       1-0 Club Africain
Bizertin      1-0 Marsa
Sahel         1-1 Monastir

Round 12 
[May 19]
Sahel         1-1 Esperance
Club Africain 1-0 Zarzis
Monastir      2-2 Bizertin
[May 26]
Marsa         1-0 Sfaxien  

Round 13 [May 23]
Esperance     4-0 Club Africain
Bizertin      0-2 Sahel
Sfaxien       2-0 Monastir
Zarzis        1-3 Marsa

Round 14 [May 28]
Bizertin      1-1 Esperance
Monastir      1-1 Zarzis
Club Africain 1-2 Marsa
Sahel         0-1 Sfaxien

Final Table:

 1.Espérance ST     14 11  3  0 31- 8 38  [2]  Champions
 2.CA Bizertin      14  6  6  2 18-14 25  [1]     
 3.CS Sfaxien       14  7  2  5 15-12 24  [1]
 4.Etoile du Sahel  14  5  5  4 18-13 20
 5.AS Marsa         14  5  3  6 11-13 18
 6.Club Africain    14  4  3  7 13-20 17  [2] 
 7.US Monastir      14  1  7  6 13-21 10 
 8.ES Zarzis        14  2  1 11  9-27  7 


Relegation Section

Table:

 1.Olympique Béja   14  8  3  3 21- 8 28  [1]
 2.JS Kairouan      14  8  3  3 18-10 27
 3.CO Transports    14  7  3  4 17- 9 26  [2]
 4.Stade Tunisien   14  7  3  4 19-12 24
----------------------------------------
 5.Olympique Kef    14  8  0  6 15-10 24  Relegated
 6.CS Hamam Lif     14  6  1  7 18-18 21  [2]  Relegated
 7.CO Médenine      14  3  2  9 10-29 11  Relegated
 8.ES Beni Khaled   14  1  1 12  8-30  5  [1]  Relegated

Round 1 [Jan 30,31]
Stade T       1-0 Kef
Hamam Lif     1-1 Medenine
Beja          3-0 Beni Khaled
Kairouan      1-1 Transports

Round 2 [Feb 6,7]
Kef           3-0 Kairouan
Medenine      2-5 Stade T
Beni Khaled   0-2 Hamam Lif 
Transports    1-0 Beja

Round 3 [Feb 13,14]
Stade T       1-0 Beni Khaled
Hamam Lif     1-2 Beja
Kef           1-0 Transports
Kairouan      2-0 Medenine

Round 4 [Mar 14]
Transports    1-0 Hamam Lif
Beni Khaled   0-2 Kairouan
Beja          1-1 Stade T
Medenine      1-0 Kef

Round 5 [Mar 21]
Stade T       1-2 Hamam Lif
Kef           2-1 Beni Khaled
Kairouan      0-0 Beja
Medenine      3-2 Transports

Round 6 [Mar 26]
Hamam Lif     1-3 Kairouan
Beja          1-0 Kef
Beni Khaled   3-1 Medenine
Transports    0-2 Stade T

Round 7 [Apr 17]
Stade T       1-0 Kairouan
Beni Khaled   1-1 Transports
Kef           2-1 Hamam Lif
Medenine      0-2 Beja

Round 8 [Apr 21]
Transports    1-0 Kairouan
Beni Khaled   0-2 Beja
Kef           2-1 Stade T
Medenine      1-2 Hamam Lif

Round 9 [Apr 25]
Stade T       0-0 Medenine
Hamam Lif     4-0 Beni Khaled
Beja          1-0 Transports
Kairouan      1-0 Kef

Round 10 [May 2]
Transports    1-0 Kef
Beni Khaled   1-2 Stade T
Beja          2-1 Hamam Lif
Medenine      0-1 Kairouan

Round 11 [May 9]
Stade T       2-0 Beja
Hamam Lif     0-1 Transports
Kef           2-0 Medenine
Kairouan      2-1 Beni Khaled

Round 12 [May 16]
Transports    3-0 Medenine
Hamam Lif     2-1 Stade T
Beni Khaled   1-2 Kef
Beja          1-1 Kairouan

Round 13 [May 23]
Stade T       0-0 Transports
Kef           1-0 Beja
Kairouan      3-0 Hamam Lif
Medenine      1-0 Beni Khaled

Round 14 [May 30]
Hamam Lif     1-0 Kef
Beja          6-0 Medenine
Kairouan      2-1 Stade T
Transports    5-0 Beni Khaled

Table:

 1.Olympique Béja   14  8  3  3 21- 8 28  [1]
 2.JS Kairouan      14  8  3  3 18-10 27
 3.CO Transports    14  7  3  4 17- 9 26  [2]
 4.Stade Tunisien   14  7  3  4 19-12 24
----------------------------------------
 5.Olympique Kef    14  8  0  6 15-10 24  Relegated
 6.CS Hamam Lif     14  6  1  7 18-18 21  [2]  Relegated
 7.CO Médenine      14  3  2  9 10-29 11  Relegated
 8.ES Beni Khaled   14  1  1 12  8-30  5  [1]  Relegated



Authors:
Eric Boesenberg 
(boesy@sprynet.com) 
and Hans Schöggl 
(hans.schoeggl@sbg.ac.at)

Last updated: 18 Aug 1999

(C) Copyright Eric Boesenberg, Hans Schöggl and RSSSF 1999


  USO DE MEMORIA  
4,263,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0995
Total Execution Time  0.1014
  CADENA URL  
/tunez1999
  GET DATOS  
$_GET['/tunez1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'tunez1999'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tunez' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1888
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 = 30151 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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='1999' WHERE c.parentId=66 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-28 07:38:54' 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-28 07:38:54' 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-28 07:38:54' 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-28 07:38:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tunez' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 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 events1999 e WHERE e.league_id IN (30151) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30151) 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 events1999 e WHERE e.league_id IN (30151) AND (e.action IN (4,5) ) 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 (30151) 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 events1999 e WHERE e.league_id IN (30151) 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 (30151) 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 events1999 e WHERE e.league_id IN (30151) 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 (30151) 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 = 30151 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 = 30151 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=30151 AND rel.round=14
0.0036  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 = 30151 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30151 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30151 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30151
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 `calendars1999` 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` = 30151 AND c.`round` = 14 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 `events1999` e INNER JOIN calendars1999 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 = 14 AND e.real_date IS NOT NULL AND e.league_id = 30151 ORDER BY total DESC LIMIT 40
0.0035  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 `events1999` e INNER JOIN calendars1999 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 = 30151 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 30151 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 30151 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30151 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=66
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 66 AND l.year = 1999 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=66 AND year=1999