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

Round 1 [Jul 31-Aug 2]
Amazulu       0-0 Bucks
Spurs         1-1 Sundowns
Dynamos       0-1 Chiefs
Cosmos        1-2 Celtic
Swallows      0-1 Seven Stars
Qwa Qwa Stars 0-0 Rangers
Santos        0-1 Wits
Supersport    0-1 Hellenic
Vaal Pros     1-1 Pirates

Round 2 [Aug 7,8]
Celtic        2-1 Chiefs
Bucks         3-4 Spurs      
Dynamos       0-1 Vaal Pros   
Hellenic      0-1 Qwa Qwa Stars
Rangers       5-0 Santos 
Pirates       4-1 Swallows
Seven Stars   0-2 Amazulu  
Sundowns      0-4 Supersport 
Wits          2-2 Cosmos  

Round 3 [Aug 9,10]
Amazulu       2-1 Pirates
Celtic        3-0 Dynamos      
Spurs         3-0 Seven Stars
Cosmos        1-1 Rangers
Chiefs        1-1 Wits
Swallows      1-1 Vaal Pros
Qwa Qwa Stars 1-3 Sundowns
Santos        2-2 Hellenic
Supersport    0-0 Bucks

Round 4 [Aug 14-16]
Bucks         2-1 Qwa Qwa Stars
Dynamos       1-1 Swallows
Hellenic      2-0 Cosmos
Rangers       1-1 Chiefs
Pirates       1-0 Spurs
Seven Stars   1-1 Supersport
Sundowns      7-1 Santos
Vaal Pros     1-3 Amazulu
Wits          1-0 Celtic

Round 5 [Aug 21-23]
Spurs         4-0 Vaal Pros
Cosmos        1-1 Sundowns
Chiefs        5-0 Hellenic
Santos        0-1 Bucks
Seven Stars   0-0 Qwa Qwa Stars
Supersport    0-1 Pirates
Wits          2-0 Dynamos      
Amazulu       0-1 Swallows       [Sep 2]
Celtic        0-0 Rangers        [Sep 9]

Round 6 [Sep 4-6]
Rangers       3-0 Wits           [Sep 1]
Bucks         0-0 Cosmos
Dynamos       2-1 Amazulu
Hellenic      0-2 Celtic
Swallows      1-0 Spurs
Pirates       2-2 Qwa Qwa Stars
Seven Stars   1-1 Santos
Sundowns      0-0 Chiefs
Vaal Pros     1-3 Supersport

Round 7 [Sep 18-20]
Spurs         2-2 Amazulu
Supersport    2-1 Swallows   
Wits          0-0 Hellenic
Celtic        2-1 Sundowns
Cosmos        0-0 Seven Stars  
Chiefs        3-1 Bucks
Qwa Qwa Stars 1-0 Vaal Pros
Santos        1-0 Pirates
Rangers       2-0 Dynamos        [Sep 30]

Round 8 [Sep 23,24]
Sundowns      3-0 Wits    
Amazulu       2-2 Supersport
Bucks         0-0 Celtic
Dynamos       1-1 Spurs
Swallows      0-3 Qwa Qwa Stars
Pirates       0-1 Cosmos
Seven Stars   1-2 Chiefs
Vaal Pros     1-1 Santos
Hellenic      1-1 Rangers        [Oct 13]

Round 9 [Oct 9-11]
Rangers       0-1 Sundowns       [Oct 6]
Hellenic      1-0 Dynamos     
Chiefs        0-0 Pirates
Santos        1-1 Swallows
Supersport    0-0 Spurs
Celtic        1-0 Seven Stars
Cosmos        3-1 Vaal Pros
Qwa Qwa Stars 1-2 Amazulu
Wits          1-1 Bucks

Round 10 [Oct 24,25]
Seven Stars   0-0 Wits
Sundowns      0-0 Hellenic
Pirates       3-0 Celtic
Swallows      2-2 Cosmos         [abandoned at 0-2 in 78' due to lightning;
Amazulu       4-2 Santos          replayed Nov 4]
Vaal Pros     3-3 Chiefs
Spurs         1-1 Qwa Qwa Stars 
Dynamos       1-1 Supersport     [Nov 18]
Bucks         1-2 Rangers        [Nov 18]

Round 11 [Nov 6-8]
Pirates       3-0 Rangers        [Feb 3]
Supersport    2-1 Santos
Swallows      0-0 Celtic
Dynamos       0-4 Qwa Qwa Stars
Amazulu       1-3 Chiefs
Spurs         2-4 Cosmos         [1-4?]
Vaal Pros     2-3 Wits
Bucks         2-1 Sundowns  
Seven Stars   3-0 Hellenic

Round 12 [Nov 13-15]
Santos        1-1 Qwa Qwa Stars
Swallows      0-0 Wits
Cosmos        2-1 Supersport
Celtic        1-0 Amazulu
Bucks         5-1 Dynamos
Rangers       5-4 Vaal Pros
Chiefs        5-1 Spurs          [Feb 10]
Hellenic      1-1 Pirates        [Nov 18]
Sundowns      6-2 Seven Stars    [Feb 10]

Round 13 [Nov 21-23]
Pirates       1-2 Sundowns  
Dynamos       0-2 Santos
Vaal Pros     1-3 Hellenic
Swallows      0-0 Rangers  
Amazulu       1-1 Wits
Supersport    2-4 Chiefs
Qwa Qwa Stars 3-0 Cosmos        
Seven Stars   1-2 Bucks
Spurs         3-0 Celtic

Round 14 [Nov 27-29]
Wits          1-0 Spurs
Hellenic      2-1 Swallows
Rangers       2-0 Amazulu
Cosmos        2-3 Santos
Celtic        1-1 Supersport
Bucks         1-2 Pirates
Seven Stars   1-0 Dynamos
Chiefs        2-1 Qwa Qwa Stars  [Feb 3]
Sundowns      7-1 Vaal Pros      [Feb 3]

Round 15 [Dec 4-6]
Supersport    2-1 Wits
Vaal Pros     1-3 Bucks
Swallows      0-1 Sundowns
Spurs         3-4 Rangers
Dynamos       1-1 Cosmos
Pirates       1-1 Seven Stars
Amazulu       1-0 Hellenic
Qwa Qwa Stars 2-0 Celtic
Santos        4-2 Chiefs

Round 16 [Dec 8,9]
Bucks         3-1 Swallows
Seven Stars   3-1 Vaal Pros
Wits          0-0 Qwa Qwa Stars
Rangers       4-1 Supersport
Hellenic      0-4 Spurs
Chiefs        1-0 Cosmos
Celtic        1-1 Santos
Sundowns      4-0 Amazulu
Dynamos       0-2 Pirates

Round 17 [Dec 12-13]
Hellenic      5-2 Bucks
Rangers       3-0 Seven Stars
Wits          1-3 Pirates
Celtic        3-1 Vaal Pros
Santos        0-0 Spurs
Sundowns      1-0 Dynamos
Chiefs        1-0 Swallows
Cosmos        3-1 Amazulu
Qwa Qwa Stars 3-2 Supersport

Round 18 [Dec 16]
Hellenic      1-1 Santos         [Oct 30]
Rangers       2-1 Cosmos         [Oct 30]
Vaal Pros     1-0 Swallows       [Nov 1]
Bucks         2-0 Supersport     [Nov 1]
Dynamos       2-1 Celtic         [Nov 11]
Pirates       3-1 Amazulu        [Jan 27]
Wits          0-2 Chiefs         [Jan 27]
Sundowns      2-0 Qwa Qwa Stars  [Jan 27]
Seven Stars   3-2 Spurs

Round 19 [Dec 18-20]
Supersport    0-0 Sundowns
Spurs         2-1 Bucks
Santos        0-2 Rangers
Chiefs        1-0 Celtic
Vaal Pros     2-0 Dynamos
Swallows      0-0 Pirates
Amazulu       0-2 Seven Stars
Qwa Qwa Stars 0-0 Hellenic
Cosmos        2-0 Wits

Round 20 [Jan 9-11]
Spurs         0-1 Dynamos        [Jan 7]
Chiefs        2-0 Seven Stars
Wits          1-2 Sundowns
Supersport    2-0 Amazulu
Rangers       0-0 Hellenic
Celtic        5-1 Bucks
Cosmos        1-0 Pirates
Qwa Qwa Stars 2-3 Swallows  
Santos        3-0 Vaal Pros  

Round 21 [Jan 15-17]
Hellenic      1-1 Chiefs
Rangers       3-0 Celtic    
Swallows      1-1 Amazulu
Sundowns      2-0 Cosmos   
Pirates       2-2 Supersport
Vaal Pros     1-1 Spurs
Bucks         2-0 Santos     
Qwa Qwa Stars 1-0 Seven Stars
Dynamos       2-0 Wits

Round 22 [Jan 28-31]
Spurs         3-1 Swallows 
Supersport    3-2 Vaal Pros
Chiefs        1-2 Sundowns  
Santos        2-0 Seven Stars
Cosmos        2-3 Bucks   
Amazulu       0-1 Dynamos   
Qwa Qwa Stars 1-0 Pirates
Wits          2-3 Rangers  
Celtic        2-2 Hellenic  

Round 23 [Feb 5-7]
Hellenic      1-1 Wits
Seven Stars   1-0 Cosmos
Pirates       5-1 Santos
Dynamos       0-0 Rangers   
Vaal Pros     1-2 Qwa Qwa Stars 
Amazulu       2-2 Spurs
Swallows      0-4 Supersport 
Bucks         1-0 Chiefs  
Sundowns      2-0 Celtic

Round 24 [Feb 13,14]
Pirates       1-2 Chiefs
Dynamos       1-1 Hellenic  
Seven Stars   0-3 Celtic
Vaal Pros     1-2 Cosmos
Swallows      1-0 Santos
Amazulu       0-1 Qwa Qwa Stars
Sundowns      0-1 Rangers
Bucks         0-2 Wits   
Spurs         0-1 Supersport   

Round 25 [Feb 19,21]
Supersport    3-0 Dynamos 
Rangers       3-1 Bucks
Wits          0-1 Seven Stars 
Qwa Qwa Stars 1-2 Spurs
Cosmos        0-1 Swallows   
Santos        1-1 Amazulu        [Feb 24]
Chiefs        3-1 Vaal Pros      [Mar 10]
Hellenic      0-2 Sundowns       [played later]
Celtic        0-2 Pirates        [Apr 4]

Round 26 [Mar 12-15]
Pirates       0-0 Wits           [Mar 3]
Dynamos       0-1 Sundowns       [Mar 3]
Supersport    0-0 Qwa Qwa Stars
Spurs         2-2 Santos  
Vaal Pros     0-1 Celtic
Swallows      0-3 Chiefs
Amazulu       2-0 Cosmos
Bucks         0-1 Hellenic 
Seven Stars   1-0 Rangers

Round 27 [Mar 24]
Santos        1-0 Supersport
Chiefs        2-3 Amazulu
Celtic        1-0 Swallows
Wits          1-3 Vaal Pros    
Hellenic      1-2 Seven Stars
Sundowns      3-1 Bucks
Cosmos        2-2 Spurs
Qwa Qwa Stars 0-0 Dynamos
Rangers       0-3 Pirates        [?; played later]

Round 28 [Mar 27,28]
Pirates       1-1 Hellenic       [Mar 10]
Supersport    0-0 Cosmos
Wits          1-1 Swallows
Vaal Pros     2-1 Rangers
Dynamos       2-0 Bucks
Qwa Qwa Stars 1-1 Santos
Amazulu       1-0 Celtic
Spurs         4-5 Chiefs
Seven Stars   2-2 Sundowns       [Apr 3]

Round 29 [Apr 9-14]
Supersport    1-2 Seven Stars
Amazulu       1-1 Vaal Pros
Swallows      2-0 Dynamos
Qwa Qwa Stars 3-2 Bucks
Celtic        0-1 Wits
Chiefs        4-1 Rangers
Santos        1-3 Sundowns 
Spurs         1-2 Pirates
Cosmos        2-0 Hellenic

Round 30 [Apr 16-18]
Hellenic      2-1 Vaal Pros
Rangers       1-3 Swallows
Wits          2-0 Amazulu
Chiefs        2-0 Supersport
Santos        1-1 Dynamos
Celtic        0-0 Spurs
Cosmos        0-1 Qwa Qwa Stars
Sundowns      1-2 Pirates
Bucks         1-4 Seven Stars

Round 31 [Apr 30-May 2]
Dynamos       2-1 Seven Stars
Qwa Qwa Stars 0-2 Chiefs
Swallows      2-0 Hellenic
Amazulu       2-1 Rangers
Spurs         1-0 Wits
Santos        0-0 Cosmos
Supersport    2-0 Celtic
Pirates       3-0 Bucks          [May 5]
Vaal Pros     0-3 Sundowns       [May 30]

Round 32 [May 7-9]
Wits          1-1 Supersport
Rangers       1-0 Spurs
Hellenic      1-1 Amazulu
Cosmos        1-0 Dynamos
Bucks         1-0 Vaal Pros
Celtic        2-1 Qwa Qwa Stars
Seven Stars   2-0 Pirates
Chiefs        2-1 Santos         [May 19]
Sundowns      1-0 Swallows       [May 26]

Round 33 [May 14-16]
Spurs         1-1 Hellenic
Supersport    1-1 Rangers
Swallows      2-1 Bucks          
Cosmos        0-1 Chiefs
Santos        0-0 Celtic
Vaal Pros     0-1 Seven Stars
Qwa Qwa Stars 2-2 Wits
Amazulu       1-3 Sundowns       [May 19]
Pirates       3-0 Dynamos        [May 19]

Round 34 [May 21-23]
Rangers       7-2 Qwa Qwa Stars
Hellenic      1-1 Supersport
Pirates       2-1 Vaal Pros
Bucks         4-2 Amazulu
Celtic        0-1 Cosmos
Seven Stars   3-1 Swallows
Sundowns      2-0 Spurs          [Jun 9]
Chiefs        5-1 Dynamos        [Jun 9]
Wits          2-0 Santos         [Jun 9]

Table:

 1.Mamelodi Sundowns     34 23  6  5  70-26  75  Champions
 2.Kaizer Chiefs         34 23  6  5  73-34  75
 3.Orlando Pirates       34 17  9  8  55-28  60
 4.Manning Rangers       34 17  9  8  60-38  60  
 5.Seven Stars           34 15  7 12  40-41  52
 6.Qwa Qwa Stars         34 13 11 10  43-39  50
 7.Bloemfontein Celtic   34 13  8 13  33-34  47 
 8.Supersport United     34 11 13 10  45-38  46   
 9.Bush Bucks            34 13  5 16  48-57  44
10.Jomo Cosmos           34 11 10 13  37-39  43     
11.Wits University       34  9 13 12  31-39  40  
12.Hellenic              34  8 16 10  32-43  40
13.Cape Town Spurs       34  9 12 13  52-50  39  
14.Amazulu               34 10  9 15  40-53  39
15.Moroka Swallows       34  9 10 15  29-44  37
16.Santos                34  7 14 13  36-54  35
-----------------------------------------------
17.Dynamos               34  7  8 19  20-51  29  Relegated
18.Vaal Professionals    34  5  6 23  38-74  21  Relegated

Promoted: African Wanderers and Thembisa Classic

NB: Cape Town Spurs and Seven Stars merge to form Ajax Cape Town for 1999/2000.
    The Spurs franchise will be sold to the highest bidder.



Authors: Mark Gleeson and Ian King 

Last updated: 9 Jan 2009

(C) Copyright Mark Gleeson, Ian King and RSSSF 1999/2009


  USO DE MEMORIA  
4,268,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.0985
Total Execution Time  0.1017
  CADENA URL  
/sudafrica1999
  GET DATOS  
$_GET['/sudafrica1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0017  SELECT type FROM routes WHERE alias = 'sudafrica1999'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'sudafrica' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=21 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 21 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1310262,1309300,1221330,1179753,1148850) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1361
0.0022  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 = 29641 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=21 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-27 21:42:13' 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-27 21:42:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:42:13' 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-27 21:42:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'sudafrica' 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.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29641) 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 (29641) 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 (29641) 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 (29641) 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 events1999 e WHERE e.league_id IN (29641) 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 (29641) 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 events1999 e WHERE e.league_id IN (29641) 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 (29641) 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 = 29641 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 = 29641 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=29641 AND rel.round=34
0.0020  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 = 29641 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 = 29641 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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29641 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29641
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` = 29641 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0017  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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 29641 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 `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 = 29641 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 `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 = 29641 AND t.round = 32 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 `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 = 29641 AND t.round = 34 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29641 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=21
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 21 AND l.year = 1999 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=21 AND year=1999