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


Week 1
[Feb 14]
Cape Town Spurs            1-1 Umtata Bucks
Total Aces                 0-0 Santos
[Feb 15]
Hellenic                   6-0 Crusaders
Kaizer Chiefs              3-0 Orlando Pirates
[Feb 16]
Amazulu                    2-0 Manning Rangers
Bloemfontein Celtic        4-1 Ratanang
Fairway Stars              1-1 Vaal Reef Stars
Jomo Cosmos                1-4 Moroka Swallows
Highlands Park             0-1 Wits University
Sundowns                   2-1 Albany City
[tba]
Dangerous Darkies           -  Dynamos
 
Week 2
[Feb 21]
Santos                     1-4 Hellenic
[Feb 23]
Albany City                2-3 Kaizer Chiefs
Amazulu                    1-1 Bloemfontein Celtic
Crusaders                  1-1 Total Aces
Dynamos                    1-3 Jomo Cosmos
Moroka Swallows             -  Highlands Park
Orlando Pirates             -  Cape Town Spurs
Ratanang                   4-1 Dangerous Darkies
Vaal Reefs Stars            -  Sundowns
Wits University            2-0 Fairway Stars
[later]
Umtata Bucks               2-1 Manning Rangers
 
Week 3
[Feb 28]
Santos                     2-0 Ratanang
[Feb 29]
Highlands Park             0-1 Dynamos
Jomo Cosmos                3-0 Crusaders
Vaal Reef Stars            3-0 Albany City
[Mar 1]
Bloemfontein Celtic        4-2 Umtata Bucks
Dangerous Darkies          3-1 Amazulu
Fairway Stars              0-1 Moroka Swallows
Hellenic                   3-2 Ratanang
Kaizer Chiefs              0-0 Cape Town Spurs
Manning Rangers            1-0 Orlando Pirates
Sundowns                   2-0 Wits University
 
Week 4
[Mar 6]
Hellenic                   4-1 Manning Rangers
Santos                     2-2 Jomo Cosmos
[Mar 7]
Moroka Swallows            1-1 Sundowns
Vaal Reefs Stars           0-1 Kaizer Chiefs
[Mar 8]
Albany City                1-0 Wits University
Amazulu                    2-0 Hellenic
Cape Town Spurs            3-0 Manning Rangers
Crusaders                  0-3 Highlands Park
Dynamos                    2-1 Fairways Stars
Orlando Pirates            0-5 Bloemfontein Celtic
Ratanang                   1-0 Total Aces
Umtata Bucks               5-0 Dangerous Darkies
 
Week 5
[Mar 13]
Santos                     2-1 Umtata Bucks
[Mar 14]
Kaizer Chiefs              3-1 Manning Rangers
Moroka Swallows            0-2 Albany City
[Mar 15]
Bloemfontein Celtic        1-1 Cape Town Spurs
Dangerous Darkies          1-2 Orlando Pirates
Fairways Stars             0-0 Crusaders
Hellenic                   4-0 Umtata Bucks
Highlands Park             1-0 Santos
Jomo Cosmos                1-1 Ratanang
Sundowns                   5-1 Dynamos
Total Aces                 2-2 Amazulu
[later]
Wits University            4-0 Vaal Reefs Stars
 
Week 6
[Mar 20]
Albany City                1-2 Hellenic
[Mar 21]
Crusaders                  0-1 Sundowns
Manning Rangers            1-1 Bloemfontein Celtic
Santos                     1-0 Fairways Stars
Vaal Reefs Stars           1-2 Moroka Swallows
Wits University            1-1 Kaizer Chiefs
[Mar 22]
Amazulu                    0-3 Jomo Cosmos
Cape Town Spurs            6-1 Dangerous Darkies
Dynamos                    2-1 Albany City
Orlando Pirates            2-1 Hellenic
Ratanang                   1-0 Highlands Park
Umtata Bucks               1-1 Total Aces
 
Week 7
[Mar 27]
Hellenic                   0-1 Cape Town Spurs
Vaal Reefs Stars           1-0 Santos
[Mar 28]
Jomo Cosmos                6-0 Umtata Bucks
Kaizer Chiefs              2-0 Bloemfontein Celtic
[Mar 29]
Albany City                2-1 Crusaders
Amazulu                    1-3 Highlands Park
Dangerous Darkies          4-4 Manning Rangers
Dynamos                    0-1 Vaal Reefs Stars
Fairways Stars             0-1 Ratanang
Moroka Swallows            1-2 Wits University
Sundowns                   3-1 Santos
Total Aces                 0-0 Orlando Pirates
 
Week 8
[Apr 3]
Hellenic                   3-0 Total Aces
Wits University            2-1 Dynamos
[Apr 4]
Moroka Swallows            1-2 Kaizer Chiefs
Santos                     1-1 Albany City
[Apr 5]
Amazulu                    1-0 Fairways Stars
Cape Town Spurs            3-0 Total Aces
Crusaders                  1-0 Vaal Reefs Stars
Orlando Pirates            4-2 Jomo Cosmos
Ratanang                   0-0 Sundowns
Umtata Bucks               1-0 Highlands Park
[later]
Bloemfontein Celtic        3-0 Dangerous Darkies
 
Week 9
[Apr 16]
Cape Town Spurs            0-0 Highlands Park
Manning Rangers            2-3 Jomo Cosmos
[Apr 17]
Amazulu                    2-1 Albany City
Bloemfontein Celtic        0-0 Total Aces
Crusaders                  0-0 Moroka Swallows
Dangerous Darkies          1-5 Hellenic
Dynamos                    1-1 Kaizer Chiefs
Ratanang                   0-0 Vaal Reefs Stars
Santos                     0-0 Wits University
Umtata Bucks               0-0 Sundowns
[Apr 18]
Highlands Park             2-0 Manning Rangers
Orlando Pirates            0-1 Fairway Stars
 
Week 10
[Apr 19]
Albany City                0-1 Umtata Bucks
Dynamos                    1-0 Crusaders
Kaizer Chiefs              2-0 Hellenic
Moroka Swallows            1-1 Santos
Vaal Reefs Stars           0-0 Amazulu
[Apr 20]
Fairways Stars             2-0 Cape Town Spurs
Jomo Cosmos                1-0 Bloemfontein Celtic
Sundowns                   2-0 Orlando Pirates
Total Aces                 3-0 Dangerous Darkies
Wits University            1-0 Ratanang
 
Week 11
[Apr 24]
Santos                     2-0 Bloemfontein Celtic
Wits University            5-0 Crusades
[Apr 25]
Hellenic                   1-1 Bloemfontein Celtic
[Apr 26]
Albany City                2-1 Ratanang
Sundowns                    -  Amazulu
Total Aces                 2-1 Manning Rangers
[later]
Dynamos                    4-1 Moroka Swallows
Highlands Park             1-1 Orlando Pirates
Jomo Cosmos                3-0 Cape Town Spurs
Kaizer Chiefs              6-0 Dangerous Darkies
Umtata Bucks               1-0 Fairway Stars
 
Week 12
[Apr 30]
Cape Town Spurs            4-1 Vaal Reefs Stars
Crusaders                  0-0 Santos
Dynamos                    1-1 Ratanang
Manning Rangers            2-1 Albany City
Moroka Swallows            4-1 Amazulu
[May 1]
Bloemfontein Celtic        1-1 Sundowns
Jomo Cosmos                0-0 Hellenic
Kaizer Chiefs              3-2 Total Aces
Vaal Reefs Stars            -  Orlando Pirates
Wits University            1-0 Umtata Bucks
[later]
Fairway Stars              2-1 Dangerous Darkies
 
Week 13
[May 2]
Highlands Park             3-0 Dangerous Darkies
Ratanang                   2-2 Crusaders
[May 3]
Albany City                2-1 Cape Town Spurs
Amazulu                    1-3 Dynamos
Fairway Stars              1-1 Bloemfontein Celtic
Orlando Pirates            0-1 Wits University
Santos                     0-2 Kaizer Chiefs
Sundowns                   0-0 Manning Rangers
Total Aces                 3-1 Jomo Cosmos
Umtata Bucks               1-0 Moroka Swallows
 
Week 14
[May 8]
Hellenic                    -  Sundowns
Manning Rangers             -  Fairway Stars
[May 9]
Amazulu                     -  Wits University
Santos                      -  Dynamos
[May 10]
Bloemfontein Celtic         -  Highlands Park
Cape Town Spurs             -  Sundowns
Crusaders                   -  Kaizer Chiefs
Dangerous Darkies          0-4 Jomo Cosmos
Orlando Pirates             -  Albany City
Ratanang                    -  Moroka Swallows
Umtata Bucks                -  Vaal Reefs Stars
 
Week 15
[May 15]
Dynamos                     -  Cape Town Spurs
Wits University            1-1 Hellenic
[May 16]
Kaizer Chiefs              1-1 Jomo Cosmos
Sundowns                    -  Dangerous Darkies
[May 17]
Albany City                0-0 Bloemfontein Celtic
Crusaders                  0-1 Amazulu
Dynamos                    1-0 Umtata Bucks
Fairway Stars               -  Hellenic
Highlands Park             0-1 Total Aces
Moroka Swallows             -  Orlando Pirates
Vaal Reefs Stars           0-0 Manning Rangers
Wits University             -  Cape Town Spurs
 
Week 16
[May 22]
Hellenic                   3-0 Moroka Swallows
Manning Rangers            0-1 Santos
[May 23]
Highlands Park             3-1 Jomo Cosmos
[May 24]
Amazulu                    0-2 Santos
Bloemfontein Celtic        0-0 Vaal Reefs Stars
Cape Town Spurs             -  Moroka Swallows
Dangerous Darkies          1-2 Albany City
Manning Rangers            2-1 Wits University
Orlando Pirates             -  Dynamos
Ratanang                   0-1 Kaizer Chiefs
Total Aces                  -  Fairway Stars
Umtata Bucks               1-1 Crusaders
 
Week 17
[May 27]
Dangerous Darkies          0-3 Moroka Swallows
Highlands Park             1-2 Sundowns
[May 28]
Albany City                0-1 Jomo Cosmos
Amazulu                    2-0 Umtata Bucks
Crusaders                  2-0 Manning Rangers
Dynamos                    3-0 Bloemfontein Celtic
Kaizer Chiefs              1-0 Fairways Stars
Ratanang                   0-1 Orlando Pirates
Santos                     0-0 Cape Town Spurs
Vaal Reefs Stars           1-0 Total Aces
 
Week 18
[May 30]
Orlando Pirates            2-0 Amazulu
Sundowns                   2-2 Fairway Stars
[May 31]
Albany City                1-2 Highlands Park
Bloemfontein Celtic        2-0 Crusaders
Cape Town Spurs            1-1 Ratanang
Dangerous Darkies          1-1 Dynamos
Jomo Cosmos                1-2 Vaal Reef Stars
Total Aces                 2-2 Wits University
Umtata Bucks               1-0 Kaizer Chiefs
 
Week 19
[Jun 5]
Highlands Park             0-2 Hellenic
[Jun 6]
Crusaders                  1-2 Dangerous Darkies
Kaizer Chiefs               -  Sundowns
Ratanang                   1-0 Manning Rangers
[Jun 7]
Amazulu                     -  Cape Town Spurs
Dynamos                    1-2 Hellenic
Fairway Stars               -  Albany City
Highlands Park             0-0 Vaal Reefs Stars
Moroka Swallows            0-1 Total Aces
Umtata Bucks                -  Orlando Pirates
Wits University            2-0 Jomo Cosmos
 
Week 20
[Jun 12]
Hellenic                   2-0 Vaal Reefs Stars
[Jun 13]
Manning Rangers            2-3 Dynamos
Orlando Pirates            3-0 Santos
[Jun 14]
Amazulu                    3-1 Kaizer Chiefs
Bloemfontein Celtic        0-0 Moroka Swallows
Cape Town Spurs            1-0 Crusaders
Dangerous Darkies          0-5 Wits University
Fairways Stars             0-0 Highlands Park
Jomo Cosmos                3-0 Sundowns
Total Aces                 1-0 Albany City
Umtata Bucks               0-0 Ratanang
 
Week 21
[Jun 20]
Fairway Stars              3-2 Jomo Cosmos
Moroka Swallows            2-0 Manning Rangers
Vaal Reefs Stars           2-0 Dangerous Darkies
Wits University            2-1 Bloemfontein Celtic
[Jun 21]
Crusaders                  0-0 Orlando Pirates
Kaizer Chiefs              2-0 Highlands Park
Ratanang                   2-1 Amazulu
Sundowns                   2-0 Total Aces

Final Table:

 1.Kaizer Chiefs (Johannesburg)    42 24 12  6 70-22 60 
 2.Hellenic (Cape Town)            42 23 11  8 82-39 57
 3.Wits University (Johannesburg)  42 20 11 11 53-29 51
 4.Orlando Pirates (Johannesburg)  42 21  8 13 47-41 50
 5.Jomo Cosmos (Johannesburg)      42 18 11 13 64-49 47
 6.Mamelodi Sundowns (Pretoria)    42 16 15 11 62-49 47
 7.Witbank Aces (KwaMhlanga)       42 17 13 12 47-38 47
 8.Lightbody's Santos (Cape Town)  42 15 17 10 46-41 47
 9.Moroka Swallows (Johannesburg)  42 17 11 14 53-46 45
10.Cape Town Spurs                 42 13 17 12 47-43 43
11.Fairway Stars (Witsieshoek)     42 15 13 14 40-40 43
12.Ratanang                        42 14 15 13 40-40 43
13.Halls Dynamos (Johannesburg)    42 14 15 13 53-56 43
14.Bloemfontein Celtic (B'fontein) 42 12 17 13 54-49 41
15.Ama Zulu (Durban)               42 13 15 14 47-48 41
16.Pretoria City                   42 16  7 19 47-53 39
17.Umtata Bush Bucks (Umtata)      42 12 14 16 33-42 38
18.Highlands Park                  42 13 11 18 36-38 37
-------------------------------------------------------
19.Crusaders United (Stanger)      42 11 13 18 34-58 35  Relegated
20.Vaal Reef Stars (Orkney)        42 12 10 20 32-53 34  Relegated
21.Manning Rangers (Durban)        42  9 11 22 40-58 29  Relegated
22.Dangerous Darkies (Nelspruit)   42  1  5 36 27-122 7  Relegated

Promoted: D'Alberton Callies and Vaal Professionals 

Topscorers:
George Deamaley (Ama Zulu) 20 goals
Mark Williams (Hellenic)   20 goals

Player's Player of the Year: Stephan Khompela (Fairway Stars)

Changes after the season:

NB: Ratanang Mahlosians of QwaQwa were bought by the owners of relegated
    Manning Rangers of Durban. Ratanang now play in Durban as Rangers, in
    all but name.
    Highlands Park have become the second NSL club to change ownership and 
    location this season. This Johannesburg club are now based in Welkom,
    Orange Free State.


Authors:
Josef Bobrowsky
(jrjb@chello.at)
and
Ian King

Last updated: 10 Jul 2005
(C) Copyright Josef Bobrowsky, Ian King and RSSSF 1999/2005


  USO DE MEMORIA  
4,278,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1106
Total Execution Time  0.1125
  CADENA URL  
/sudafrica1992
  GET DATOS  
$_GET['/sudafrica1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0021  SELECT type FROM routes WHERE alias = 'sudafrica1992'
0.0046  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=1393
0.0026  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 = 29670 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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='1992' WHERE c.parentId=21 GROUP BY c.id ORDER BY c.order_id ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:17:13' 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-28 13:17:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:17:13' 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-28 13:17:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29670) 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 (29670) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29670) AND (e.action IN (4,5) ) 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 (29670) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29670) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  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 (29670) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29670) AND (e.action IN (22) ) 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 (29670) 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 = 29670 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 = 29670 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=29670 AND rel.round=42
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 = 29670 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 = 29670 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29670 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 29670
0.0020  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 `calendars1992` 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` = 29670 AND c.`round` = 42 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 `events1992` e INNER JOIN calendars1992 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 = 42 AND e.real_date IS NOT NULL AND e.league_id = 29670 ORDER BY total DESC LIMIT 40
0.0024  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 `events1992` e INNER JOIN calendars1992 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 = 29670 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 `tables1992` 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 = 29670 AND t.round = 40 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 `tables1992` 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 = 29670 AND t.round = 42 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 = 29670 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=21
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 21 AND l.year = 1992 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=21 AND year=1992