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 1996/1997


Round 1
Bloemfontein Celtic - Qwa Qwa Stars          0-1
Cape Town Spurs - Hellenic                   0-0
Jomo Cosmos - Kaizer Chiefs                  0-1
Manning Rangers - Amazulu                    0-2
Michau Warriors - Umtata Bucks               1-2
Orlando Pirates - Moroka Swallows            2-1
Real Rovers - Mamelodi Sundowns              1-0
Vaal Professionals - Wits University         0-0
Witbank Aces - Supersport United             0-0

Round 2
Amazulu - Jomo Cosmos                        1-1
Hellenic - Real Rovers                       3-0
Kaizer Chiefs - Bloemfontein Celtic          2-0
Mamelodi Sundowns - Vaal Professionals       1-0
Michau Warriors - Witbank Aces               1-0
Moroka Swallows - Manning Rangers            1-2
Qwa Qwa Stars - Umtata Bucks                 1-1
Supersport United - Cape Town Spurs          2-0
Wits University - Orlando Pirates            2-0

Round 3
Bloemfontein Celtic - Jomo Cosmos            0-2
Cape Town Spurs - Michau Warriors            1-1
Manning Rangers - Wits University            1-0
Moroka Swallows - Amazulu                    1-1
Orlando Pirates - Mamelodi Sundowns          0-0
Real Rovers - Supersport United              1-1
Umtata Bucks - Kaizer Chiefs                 0-1
Vaal Professionals - Hellenic                3-0
Witbank Aces - Qwa Qwa Stars                 0-1

Round 4
Amazulu - Bloemfontein Celtic                1-2
Hellenic - Orlando Pirates
Jomo Cosmos - Umtata Bucks                   0-3
Kaizer Chiefs - Witbank Aces                 7-2
Mamelodi Sundowns - Manning Rangers          1-2
Michau Warriors - Real Rovers                0-1
Qwa Qwa Stars - Cape Town Spurs              1-2
Supersport United - Vaal Professionals
Wits University - Moroka Swallows            0-1

Round 5
Cape Town Spurs - Kaizer Chiefs              1-4
Manning Rangers - Hellenic                   1-0
Moroka Swallows - Mamelodi Sundowns          0-0
Orlando Pirates - Supersport United          0-1
Real Rovers - Qwa Qwa Stars                  0-0
Umtata Bucks - Bloemfontein Celtic           1-0
Vaal Professionals - Michau Warriors         3-0
Witbank Aces - Jomo Cosmos                   0-2
Wits University - Amazulu                    2-2

Round 6
Amazulu - Vaal Professionals                 2-1
Bloemfontein Celtic - Mamelodi Sundowns      0-1
Cape Town Spurs - Manning Rangers            0-1
Jomo Cosmos - Hellenic                       1-1
Kaizer Chiefs - Supersport United            1-1
Qwa Qwa Stars - Michau Warriors              0-0
Real Rovers - Orlando Pirates                3-0
Umtata Bucks - Wits University               1-0
Witbank Aces - Moroka Swallows               0-2

Round 7
Amazulu - Umtata Bucks                       0-2
Bloemfontein Celtic - Witbank Aces           0-0
Hellenic - Moroka Swallows                   1-0
Jomo Cosmos - Cape Town Spurs                1-1
Kaizer Chiefs - Real Rovers                  5-0
Mamelodi Sundowns - Wits University          0-3
Michau Warriors - Orlando Pirates            1-3
Qwa Qwa Stars - Vaal Professionals           4-1
Supersport United - Manning Rangers          0-2

Round 8
Cape Town Spurs - Bloemfontein Celtic        1-0
Mamelodi Sundowns - Amazulu                  3-0
Manning Rangers - Michau Warriors            0-0
Moroka Swallows - Supersport United          0-1
Orlando Pirates - Qwa Qwa Stars              3-0
Real Rovers - Jomo Cosmos                    1-1
Vaal Professionals - Kaizer Chiefs           0-2
Witbank Aces - Umtata Bucks                  0-0
Wits University - Hellenic                   1-2

Round 9
Cape Town Spurs - Witbank Aces               3-0
Hellenic - Amazulu                           1-1
Mamelodi Sundowns - Supersport United        3-2
Manning Rangers - Kaizer Chiefs              1-3
Moroka Swallows - Qwa Qwa Stars              0-1
Orlando Pirates - Jomo Cosmos                1-0
Real Rovers - Umtata Bucks                   1-0
Vaal Professionals - Bloemfontein Celtic     1-0
Wits University - Michau Warriors            1-0

Round 10
Amazulu - Cape Town Spurs                    0-1
Bloemfontein Celtic - Orlando Pirates        1-0
Jomo Cosmos - Manning Rangers                1-4
Kaizer Chiefs - Moroka Swallows              0-0
Michau Warriors - Mamelodi Sundowns          1-0
Qwa Qwa Stars - Wits University              2-0
Supersport United - Hellenic                 1-0
Umtata Bucks - Vaal Professionals            3-1
Witbank Aces - Real Rovers                   1-1

Round 11
             Hellenic 1 - 0 Michau Warriors      (Fri, 13/12/96)
    Supersport United 1 - 0 Amazulu              (Fri, 13/12/96)
      Manning Rangers 3 - 2 Bloemfontein Celtic  (Fri, 13/12/96)
      Wits University 0 - 0 Kaizer Chiefs        (Sat, 14/12/96)
          Real Rovers 0 - 2 Cape Town Spurs      (Sun, 15/12/96)
      Moroka Swallows 0 - 0 Jomo Cosmos          (Sun, 15/12/96)
    Mamelodi Sundowns 2 - 0 Qwa Qwa Stars        (Sun, 15/12/96)
      Orlando Pirates   -   Umtata Bucks         (Sun, 15/12/96)
   Vaal Professionals   -   Witbank Aces         (Sun, 15/12/96)
                            (Games postponed due to waterlogged pitches)

Round 14
             Hellenic 0 - 0 Mamelodi Sundowns    (Fri, 17/01/97)
    Supersport United 0 - 0 Wits University      (Fri, 17/01/97)
        Kaizer Chiefs 0 - 1 Orlando Pirates      (Sat, 18/01/97)
              Amazulu 1 - 0 Witbank Aces         (Sun, 19/01/97)
         Umtata Bucks 2 - 1 Cape Town Spurs      (Sun, 19/01/97)
  Bloemfontein Celtic 2 - 1 Real Rovers          (Sun, 19/01/97)
          Jomo Cosmos 3 - 2 Vaal Professionals   (Sun, 19/01/97)
        Qwa Qwa Stars 0 - 1 Manning Rangers      (Sun, 19/01/97)
      Michau Warriors 1 - 2 Moroka Swallows      (Sun, 19/01/97)

Round 16
                  Kaizer Chiefs 2 - 1 Qwa Qwa Stars        (Sat, 25/01/97)
                        Amazulu 1 - 1 Orlando Pirates      (Sat, 25/01/97)
                    Jomo Cosmos 0 - 1 Michau Warriors      (Sat, 26/01/97)
                Cape Town Spurs 2 - 1 Wits University      (Sun, 25/01/97)
                   Umtata Bucks 3 - 1 Hellenic             (Sun, 26/01/97)
            Bloemfontein Celtic 1 - 3 Supersport United    (Sun, 26/01/97)
                    Real Rovers 0 - 2 Moroka Swallows      (Sun, 26/01/97)
             Vaal Professionals 0 - 1 Manning Rangers      (Sun, 26/01/97)
                   Witbank Aces 0 - 4 Mamelodi Sundowns    (Sun, 26/01/97)

Round 17
           Hellenic 2 - 1 Witbank Aces         (Fri, 31/01/97)
    Manning Rangers 2 - 2 Orlando Pirates      (Fri, 31/01/97)
    Wits University 0 - 0 Real Rovers          (Fri, 31/01/97)
  Supersport United 1 - 1 Umtata Bucks         (Sat, 01/02/97)
    Moroka Swallows 2 - 3 Vaal Professionals   (Sat, 01/02/97)
            Amazulu 1 - 1 Kaizer Chiefs        (Sun, 02/02/97)
      Qwa Qwa Stars 1 - 3 Jomo Cosmos          (Sun, 02/02/97)
  Mamelodi Sundowns 0 - 1 Cape Town Spurs      (Sun, 02/02/97)
    Michau Warriors 2 - 3 Bloemfontein Celtic  (Sun, 02/02/97)

Round 18
           Hellenic 3 - 0 Cape Town Spurs      (Fri, 07/02/97)
    Wits University 0 - 0 Vaal Professionals   (Fri, 07/02/97)
  Supersport United 4 - 0 Witbank Aces         (Fri, 07/02/97)
       Umtata Bucks 4 - 2 Michau Warriors      (Sat, 08/02/97)
      Kaizer Chiefs 0 - 0 Jomo Cosmos          (Sat, 08/02/97)
            Amazulu 0 - 1 Manning Rangers      (Sun, 09/02/97)
      Qwa Qwa Stars 0 - 2 Bloemfontein Celtic  (Sun, 09/02/97)
  Mamelodi Sundowns 2 - 2 Real Rovers          (Sun, 09/02/97)
    Moroka Swallows 0 - 1 Orlando Pirates      (Sun, 09/02/97)

ROUND 19
           Manning Rangers 2 - 1 Moroka Swallows      (Fri, 14/02/97)
           Cape Town Spurs 1 - 1 Supersport United    (Fri, 14/02/97)
               Jomo Cosmos 3 - 1 Amazulu              (Sat, 15/02/97)
           Orlando Pirates 3 - 1 Wits University      (Sat, 15/02/97)
              Umtata Bucks 2 - 4 Qwa Qwa Stars        (Sun, 16/02/97)
   *   Bloemfontein Celtic 0 - 2 Kaizer Chiefs        (Sun, 16/02/97) *
               Real Rovers 3 - 0 Hellenic             (Sun, 16/02/97)
        Vaal Professionals 3 - 2 Mamelodi Sundowns    (Sun, 16/02/97)
              Witbank Aces 2 - 0 Michau Warriors      (Sun, 16/02/97)
* (Game abandoned after 40 minutes due to crowd trouble)

ROUND 20
               Hellenic 2 - 0 Vaal Professionals   (Fri, 21/02/97)
      Supersport United 0 - 0 Real Rovers          (Fri, 21/02/97)
        Wits University 1 - 3 Manning Rangers      (Sat, 22/02/97)
                Amazulu 1 - 1 Moroka Swallows      (Sun, 23/02/97)
            Jomo Cosmos 1 - 0 Bloemfontein Celtic  (Sun, 23/02/97)
          Kaizer Chiefs 0 - 0 Umtata Bucks         (Sun, 23/02/97)
          Qwa Qwa Stars 2 - 1 Witbank Aces         (Sun, 23/02/97)
      Mamelodi Sundowns 1 - 0 Orlando Pirates      (Sun, 23/02/97)
        Michau Warriors 1 - 2 Cape Town Spurs      (Sun, 23/02/97)

ROUND 21
        Manning Rangers 0 - 1 Mamelodi Sundowns    (Fri, 28/02/97)
        Cape Town Spurs 3 - 2 Qwa Qwa Stars        (Fri, 28/02/97)
        Moroka Swallows 2 - 0 Wits University      (Sat, 01/03/97)
           Umtata Bucks 0 - 0 Jomo Cosmos          (Sun, 02/03/97)
    Bloemfontein Celtic 5 - 3 Amazulu              (Sun, 02/03/97)
        Orlando Pirates 0 - 3 Hellenic             (Sun, 02/03/97)
            Real Rovers 2 - 1 Michau Warriors      (Sun, 02/03/97)
     Vaal Professionals 1 - 1 Supersport United    (Sun, 02/03/97)
           Witbank Aces 0 - 1 Kaizer Chiefs        (Sun, 02/03/97)
 
ROUND 22
                Hellenic 2 - 0 Manning Rangers      (Fri, 07/03/97)
           Kaizer Chiefs 1 - 2 Cape Town Spurs      (Sat, 08/03/97)
                 Amazulu 0 - 1 Wits University      (Sun, 09/03/97)
           Qwa Qwa Stars 3 - 0 Real Rovers          (Sun, 09/03/97)
         Michau Warriors 2 - 0 Vaal Professionals   (Sun, 09/03/97)

ROUND 23
             Wits University 2 - 0 Mamelodi Sundowns    (Fri, 14/03/97)
             Orlando Pirates 2 - 1 Michau Warriors      (Sat, 15/03/97)
                Umtata Bucks 0 - 0 Amazulu              (Sun, 16/03/97)
                 Real Rovers 1 - 2 Kaizer Chiefs        (Sun, 16/03/97)
             Moroka Swallows 1 - 2 Hellenic             (Sun, 16/03/97)
          Vaal Professionals 1 - 0 Qwa Qwa Stars        (Sun, 16/03/97)
                Witbank Aces 0 - 2 Bloemfontein Celtic  (Sun, 16/03/97)
             Manning Rangers 2 - 2 Supersport United    (Sun, 16/03/97)
             Cape Town Spurs 1 - 3 Jomo Cosmos          (Mon, 17/03/97)
 
ROUND 24
                    Hellenic 0 - 1 Wits University      (Fri, 21/03/97)
           Supersport United 1 - 1 Moroka Swallows      (Sat, 22/03/97)
               Kaizer Chiefs 1 - 1 Vaal Professionals   (Sun, 23/03/97)
                     Amazulu 0 - 1 Mamelodi Sundowns    (Sun, 23/03/97)
         Bloemfontein Celtic 3 - 1 Cape Town Spurs      (Sun, 23/03/97)
             Michau Warriors 2 - 3 Manning Rangers      (Sun, 23/03/97)

ROUND 25
          Manning Rangers 2 - 1 Cape Town Spurs      (Fri, 28/03/97)
       Vaal Professionals 1 - 2 Amazulu              (Fri, 28/03/97)
          Wits University 0 - 1 Umtata Bucks         (Fri, 28/03/97)
        Mamelodi Sundowns 1 - 1  Bloemfontein Celtic (Fri, 28/03/97)
          Orlando Pirates 3 - 0 Real Rovers          (Fri, 28/03/97)
        Supersport United 1 - 1 Kaizer Chiefs        (Fri, 28/03/97)
          Moroka Swallows 0 - 2 Witbank Aces         (Fri, 28/03/97)
                 Hellenic 1 - 0 Jomo Cosmos          (Fri, 28/03/97)
          Michau Warriors 3 - 0 Qwa Qwa Stars        (Fri, 28/03/97)

ROUND 26
          Michau Warriors 1 - 0 Wits University      (Mon, 31/03/97)
             Witbank Aces 2 - 1 Cape Town Spurs      (Mon, 31/03/97)
                  Amazulu 0 - 1 Hellenic             (Mon, 31/03/97)
             Umtata Bucks 1 - 0 Real Rovers          (Mon, 31/03/97)
      Bloemfontein Celtic 3 - 0 Vaal Professionals   (Mon, 31/03/97)
            Kaizer Chiefs 3 - 2 Manning Rangers      (Mon, 31/03/97)
              Jomo Cosmos 0 - 0 Orlando Pirates      (Mon, 31/03/97)
            Qwa Qwa Stars 1 - 1 Moroka Swallows      (Mon, 31/03/97)
        Supersport United 1 - 1 Mamelodi Sundowns    (Mon, 31/03/97)
 
ROUND 27
                  Hellenic 1 - 0 Supersport United    (Fri, 11/04/97)
           Manning Rangers 0 - 1 Jomo Cosmos          (Fri, 11/04/97)
           Wits University 2 - 0 Qwa Qwa Stars        (Fri, 11/04/97)
           Moroka Swallows 0 - 0 Kaizer Chiefs        (Sat, 12/04/97)
           Orlando Pirates 1 - 1 Bloemfontein Celtic  (Sun, 13/04/97)
               Real Rovers 3 - 3 Witbank Aces         (Sun, 13/04/97)
           Cape Town Spurs 1 - 0 Amazulu              (Sun, 13/04/97)
         Mamelodi Sundowns 0 - 0 Michau Warriors      (Sun, 13/04/97)
        Vaal Professionals 1 - 2 Umtata Bucks         (Sun, 13/04/97)

ROUND 28
      Cape Town Spurs 0 - 2 Real Rovers          (Fri, 18/04/97) 
              Amazulu 2 - 1 Supersport United    (Sat, 19/04/97)
        Kaizer Chiefs 0 - 1 Wits University      (Sat, 19/04/97)
         Umtata Bucks 0 - 0 Orlando Pirates      (Sun, 20/04/97)
  Bloemfontein Celtic 0 - 1 Manning Rangers      (Sun, 20/04/97)
          Jomo Cosmos 2 - 1 Moroka Swallows      (Sun, 20/04/97)
        Qwa Qwa Stars 0 - 0 Mamelodi Sundowns    (Sun, 20/04/97)
      Michau Warriors 2 - 1 Hellenic             (Sun, 20/04/97)
         Witbank Aces 1 - 0 Vaal Professionals   (Sun, 20/04/97)
 
ROUND 33
                   Hellenic 1 - 1 Umtata Bucks         (Fri, 23/05/97)
            Manning Rangers 2 - 0 Vaal Professionals   (Fri, 23/05/97)
            Wits University 0 - 1 Cape Town Spurs      (Fri, 23/05/97)
          Supersport United 1 - 3 Bloemfontein Celtic  (Sat, 24/05/97)
            Moroka Swallows 0 - 0 Real Rovers          (Sun, 25/05/97)
 
Midweek fixtures
           Manning Rangers 1 - 0 Umtata Bucks         (Wed, 28/05/97)
           Cape Town Spurs 1 - 1 Orlando Pirates      (Wed, 28/05/97)
              Witbank Aces 1 - 7 Hellenic             (Wed, 28/05/97)
Weekend fixtures
         Cape Town Spurs 0 - 1 Mamelodi Sundowns    (Sun, 01/06/97)
            Umtata Bucks 3 - 2 Wtbank Aces          (Sun, 01/06/97)
           Qwa Qwa Stars 1 - 1 Kaizer Chiefs        (Sun, 01/06/07)
       Mamelodi Sundowns 1 - 1 Orlando Pirates      (Sun, 01/06/97)
 

Final Table:

 1. Manning Rangers       34   23    5    6   53   28   74  ** Champions **
 2. Kaizer Chiefs         34   18   12    4   56   23   66
 3. Orlando Pirates       34   18   10    6   43   27   64
 4. Umtata Bucks          34   16    9    9   45   29   57
 5. Hellenic              34   16    7   11   46   31   56
 6. Mamelodi Sundowns     34   13   11   10   35   30   50
 7. Jomo Cosmos           34   11   16    7   32   27   49
 8. Cape Town Spurs       34   14    6   14   40   45   48
 9. Supersport United     34   10   16    8   40   35   46
10. Bloemfontein Celtic   34   13    5   16   38   39   44
11. Moroka Swallows       34   11   10   13   33   35   43
12. Wits University       34   11    8   15   27   31   41
13. Qwa Qwa Stars         34   10    8   16   39   49   38
14. Amazulu               34    9   10   15   34   46   37
14. Vaal Professionals    34   10    6   18   38   49   36
16. Real Rovers           34    8   12   14   35   46   36
17. Warriors              34   10    5   19   32   50   35  ** Relegated **
18. Witbank Aces          34    4    7   23   26   72   19  ** Relegated ** 

Promoted : Santos and African Wanderers
 


Author: Ian King
(worldsoccer@btinternet.com)

Last updated: 27 May 2001

(C) Copyright Ian King and RSSSF 1999/2001


  USO DE MEMORIA  
4,289,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6178
Total Execution Time  0.6198
  CADENA URL  
/sudafrica1997
  GET DATOS  
$_GET['/sudafrica1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT type FROM routes WHERE alias = 'sudafrica1997'
0.0291  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=1383
0.0145  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 = 29659 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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='1997' WHERE c.parentId=21 GROUP BY c.id ORDER BY c.order_id ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:27:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:27:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:27:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:27:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29659) 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.0145  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 (29659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29659) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29659) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (29659) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 29659 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 29659 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0148  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=29659 AND rel.round=34
0.0146  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 = 29659 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 29659 AND esl.points > 0
0.0148  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` = 29659 ORDER BY creation_date DESC LIMIT 0, 10
0.0154  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` = 29659
0.0146  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 `calendars1997` 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` = 29659 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0145  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 `events1997` e INNER JOIN calendars1997 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 = 29659 ORDER BY total DESC LIMIT 40
0.0147  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 `events1997` e INNER JOIN calendars1997 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 = 29659 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0149  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 `tables1997` 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 = 29659 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 29659 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 29659 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0149  SELECT data1, data2 FROM services_tags WHERE categoryId=21
0.0149  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 21 AND l.year = 1997 ORDER BY l.group_code ASC
0.0149  SELECT group_code, extraName from `leagues` WHERE categoryId=21 AND year=1997