4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1997
Temporada Siguiente »
Publicidad 600x120.gif
Ascenso MX - Apertura 1997
1996/1997

Ascenso MX - Apertura 1997

Información Histórica 
						
Second Level (Division 1 A)


WEEK 1 (10-11/AG/96)

(Start of Winter 96 Tournament)

 Tigres        vs San Luis       1 - 0
 San Francisco vs Yucatan        0 - 2
 C.A. Hidalgo  vs Marte          0 - 1
 U.A.T.        vs Acapulco       3 - 2
 Tijuana       vs A. Hidalgo     1 - 0
 Zacatepec     vs Tampico        0 - 0
 Irapuato      vs Saltillo       1 - 0
 La Piedad     vs Zacatecas      1 - 1
 Open date: U. de N.L.

WEEK 2 (16-17/AG/96)

 San Luis      vs Tijuana        1 - 0
 Saltillo      vs Zacatepec      1 - 2
 A. Hidalgo    vs C.A. Hidalgo   4 - 1
 Marte         vs Irapuato       2 - 2
 Yucatan       vs La Piedad      1 - 1
 U. de N.L.    vs San Francisco  1 - 2
 Zacatecas     vs U.A.T.         0 - 0
 Acapulco      vs Tigres         1 - 2
 Open date: Tampico

WEEK 3 (24-25/AG/96)

 Zacatecas     vs Yucatan        1 - 1
 San Francisco vs Tampico        4 - 0
 C.A. Hidalgo  vs San Luis       4 - 2
 U.A.T.        vs Tigres         1 - 0
 Tijuana       vs Acapulco       1 - 0
 Zacatepec     vs Marte          1 - 1
 La Piedad     vs U. de N.L.     1 - 1
 Irapuato      vs A. Hidalgo     0 - 1
 Open date: Saltillo

WEEK 4 (30-31/AG/96)

 U. de N.L.    vs Zacatecas      1 - 1
 San Luis      vs Irapuato       0 - 0
 Saltillo      vs San Francisco  1 - 0
 A. Hidalgo    vs Zacatepec      4 - 1
 Yucatan       vs U.A.T.         0 - 0
 Tigres        vs Tijuana        5 - 1
 Acapulco      vs C.A. Hidalgo   2 - 2
 Tampico       vs La Piedad      1 - 0
 Open date: Marte

WEEK 5 (07-08/SP/96)

 Yucatan       vs U. de N.L.     1 - 0
 Zacatecas     vs Tampico        1 - 3
 San Francisco vs Marte          3 - 0
 C.A. Hidalgo  vs Tigres         1 - 2
 U.A.T.        vs Tijuana        2 - 0
 Zacatepec     vs San Luis       0 - 1
 La Piedad     vs Saltillo       1 - 1
 Irapuato      vs Acapulco       1 - 0
Open date: A. Hidalgo

WEEK 6 (13-15/SP/96)

 U. de N.L.    vs U.A.T.         5 - 1
 Saltillo      vs Zacatecas      3 - 2
 A. Hidalgo    vs San Francisco  1 - 0
 Marte         vs La Piedad      3 - 1
 Tigres        vs Irapuato       1 - 0
 Acapulco      vs Zacatepec      2 - 0
 Tampico       vs Yucatan        1 - 0
 Tijuana       vs C.A. Hidalgo   0 - 0
Open date: San Luis

WEEK 7 (21-22/SP/96)

 Yucatan       vs Saltillo       2 - 0
 U. de N.L.    vs Tampico        1 - 2
 Zacatecas     vs Marte          1 - 1
 San Francisco vs San Luis       4 - 6
 U.A.T.        vs C.A. Hidalgo   2 - 1
 Zacatepec     vs Tigres         3 - 2
 La Piedad     vs A. Hidalgo     0 - 1
 Irapuato      vs Tijuana        1 - 0
Open date: Acapulco

WEEK 8 (27-29/SP/96)

 San Luis      vs La Piedad      2 - 1
 Saltillo      vs U. de N.L.     2 - 1
 A. Hidalgo    vs Zacatecas      0 - 1
 Marte         vs Yucatan        1 - 2
 Acapulco      vs San Francisco  3 - 2
 Tampico       vs U.A.T.         1 - 0
 C.A. Hidalgo  vs Irapuato       3 - 1
 Tijuana       vs Zacatepec      1 - 0
Open date: Tigres  

WEEK 9 (05-06/OC/96)

 Yucatan       vs A. Hidalgo     0 - 0
 U. de N.L.    vs Marte          1 - 0
 Zacatecas     vs San Luis       1 - 1
 Tampico       vs Saltillo       0 - 0
 San Francisco vs Tigres         1 - 2
 U.A.T.        vs Irapuato       1 - 1
 Zacatepec     vs C.A. Hidalgo   0 - 0
 La Piedad     vs Acapulco       4 - 0
Open date: Tijuana

WEEK 10 (11-13/OC/96)

 San Luis      vs Yucatan        4 - 1
 Saltillo      vs U.A.T.         1 - 1
 A. Hidalgo    vs U. de N.L.     2 - 0
 Marte         vs Tampico        2 - 0
 Tigres        vs La Piedad      4 - 0
 Acapulco      vs Zacatecas      1 - 4
 Tijuana       vs San Francisco  2 - 1
 Irapuato      vs Zacatepec      0 - 1
Open date: C.A. Hidalgo

WEEK 11 (19-20/OC/96)

 Saltillo      vs Marte          0 - 0
 Yucatan       vs Acapulco       0 - 1
 U. de N.L.    vs San Luis       4 - 1
 Zacatecas     vs Tigres         1 - 1
 Tampico       vs A. Hidalgo     1 - 0
 San Francisco vs C.A. Hidalgo   1 - 0
 U.A.T.        vs Zacatepec      3 - 4
 La Piedad     vs Tijuana        3 - 2
Open date: Irapuato

WEEK 12 (25-27/OC/96)

 San Luis      vs Tampico        2 - 2
 A. Hidalgo    vs Saltillo       1 - 1
 Marte         vs U.A.T.         1 - 1
 Tigres        vs Yucatan        2 - 0
 Acapulco      vs U. de N.L.     1 - 0
 C.A. Hidalgo  vs La Piedad      3 - 0
 Tijuana       vs Zacatecas      1 - 2
 Irapuato      vs San Francisco  2 - 1
Open date: Zacatepec

WEEK 13 (02-03/NV/96)

 Saltillo      vs San Luis       5 - 0
 Marte         vs A. Hidalgo     5 - 1
 Yucatan       vs Tijuana        2 - 1
 U. de N.L.    vs Tigres         1 - 2
 Zacatecas     vs C.A. Hidalgo   2 - 1
 San Francisco vs Zacatepec      0 - 0
 Tampico       vs Acapulco       1 - 0
 La Piedad     vs Irapuato       1 - 0
Open date: U.A.T.

WEEK 14 (08-11/NV/96)

 San Luis      vs Marte          1 - 0
 Tigres        vs Tampico        2 - 0
 Acapulco      vs Saltillo       1 - 1
 A. Hidalgo    vs U.A.T.         1 - 2
 C.A. Hidalgo  vs Yucatan        2 - 0
 Tijuana       vs U. de N.L.     1 - 1
 Zacatepec     vs La Piedad      0 - 1
 Irapuato      vs Zacatecas      2 - 0
Open date: San Francisco

WEEK 15 (16-17/NV/96)

 Saltillo      vs Tigres         0 - 1
 Marte         vs Acapulco       1 - 0
 Yucatan       vs Irapuato       0 - 1
 A. Hidalgo    vs San Luis       4 - 1
 U. de N.L.    vs C.A. Hidalgo   1 - 1
 Zacatecas     vs Zacatepec      3 - 0
 U.A.T.        vs San Francisco  1 - 0
 Tampico       vs Tijuana        2 - 2
Open date: La Piedad

WEEK 16 (20/NV/96)

 Zacatepec     vs Yucatan        1 - 1
 C.A. Hidalgo  vs Tampico        2 - 1
 Tijuana       vs Saltillo       2 - 3
 Acapulco      vs A. Hidalgo     1 - 1
 San Francisco vs La Piedad      1 - 1
 Irapuato      vs U. de N.L.     2 - 1
 U.A.T.        vs San Luis       2 - 0
 Tigres        vs Marte          2 - 3
Open date: Zacatecas

WEEK 17 (22-24/NV/96)

(End of Winter 96 Tournament)

 San Luis      vs Acapulco       4 - 2
 Saltillo      vs C.A. Hidalgo   1 - 0
 Marte         vs Tijuana        3 - 1
 U. de N.L.    vs Zacatepec      2 - 1
 Zacatecas     vs San Francisco  3 - 0
 A. Hidalgo    vs Tigres         0 - 0
 Tampico       vs Irapuato       1 - 2
 La Piedad     vs U.A.T.         4 - 1
Open date: Yucatan


FINAL STANDINGS WEEK 17
 ------------------------------------------------
  GROUP 1            G   W  D  L   F  A PTS   MN
 ------------------------------------------------
  1. Tigres         16  11  2  3  29 13  35   **
  2. U.A.T.         16   7  5  4  21 21  26   **
  3. Zacatecas      16   6  7  3  24 17  25    *
  4. San Luis       16   7  3  6  26 31  24    X
  5. U. de N.L.     16   4  4  8  21 21  16    X
 ------------------------------------------------

 ------------------------------------------------
  GROUP 2            G   W  D  L   F  A PTS   MN
 ------------------------------------------------
  1. Tampico        16   7  4  5  16 18  25   **
  2. La Piedad      16   5  5  6  20 22  20    *
  3. Yucatan        16   5  5  6  13 16  20    X
  4. Tijuana        16   4  3  9  16 26  15    X
 ------------------------------------------------

 ------------------------------------------------
  GROUP 3            G   W  D  L   F  A PTS   MN
 ------------------------------------------------
  1. Marte          16   7  5  4  24 17  26   **
  2. A. Hidalgo     16   7  4  5  21 15  25   **
  3. Acapulco       16   4  3  9  17 27  15    X
  4. San Francisco  16   4  2 10  20 25  14    X
 ------------------------------------------------

 ------------------------------------------------
  GROUP 4            G   W  D  L   F  A PTS   MN
 ------------------------------------------------
  1. Irapuato       16   8  3  5  16 13  27   **
  2. Saltillo       16   6  6  4  20 15  24   **
  3. C.A. Hidalgo   16   5  4  7  21 20  19    X
  4. Zacatepec      16   4  5  7  14 22  17    X
 ------------------------------------------------

 MN := Magic number of points needed to clinch a playoff spot.

         **  := qualified to the quarter-finals
         *   := qualified to the 1st round
         X   := eliminated


 QUALIFIED TEAMS
 ------------------------------------------------------------
    STANDING          G   W  D  L   F  A  PTS  1st round
 ------------------------------------------------------------
     1. Tigres       16  11  2  3  29 13   35     bye
     2. Irapuato     16   8  3  5  16 13   27     bye
     3. Marte        16   7  5  4  24 17   26     bye
     4. U.A.T.       16   7  5  4  21 21   26     bye
     5. Zacatecas    16   6  7  3  24 17   25     WC1
     6. A. Hidalgo   16   7  4  5  21 15   25     bye
     7. Tampico      16   7  4  5  16 18   25     bye
     8. Saltillo     16   6  6  4  20 15   24     bye
    10. La Piedad    16   5  5  6  20 22   20     RU4
 ------------------------------------------------------------

 WC: Wild card
 RU: Group runner-up

1st ROUND (27-30/NV/96)

   - 1st leg:
   La Piedad  vs Zacatecas  2 - 1
      0-1 '38  Francisco Rodriguez (ZAC)
      1-1 '60  Rafael 'Cadaver' Vazquez (LP)
      2-1 '88  Gustavo Godoy (LP), p.k.
          '89  Jesus Osorio (ZAC) misses p.k.

   - 2nd leg:
   Zacatecas  vs La Piedad  6 - 0  ==> Zacatecas 7-2 (aggregate)
      1-0 '12  Juan Sandona (ZAC)
      2-0 '32  Hugo Ortiz (ZAC)
      3-0 '47  Juan Sandona (ZAC)
      4-0 '73  Hugo Ortiz (ZAC)
      5-0 '81  Juan Sandona (ZAC)
      6-0 '83  Gustavo Martinez (ZAC), p.k.


QUARTER-FINALS (03-07/DC/96)

   - 1st leg:
   03.Dc.96  Saltillo, Coahuila  15:00
   Saltillo   vs Tigres      1 - 1
      0-1 '26  Arnulfo Tinoco (TIG)
      1-1 '29  Julio Cesar Carrasco (SAL)

   03.Dc.96  Tampico, Tamaulipas  21:00
   Tampico    vs Irapuato    3 - 1
      1-0 '06  Humberto Roon (TAM)
      1-1 '48  Jorge Salas (IRA), p.k.
      2-1 '68  Gabriel Mora (TAM)
      3-1 '87  Porfirio Jimenez (TAM)

   04.Dc.96  Pachuca, Hidalgo  20:30
   A. Hidalgo vs Marte       0 - 0

   04.Dc.96  Zacatecas, Zacatecas  20:30
   Zacatecas  vs U.A.T.      2 - 0
      1-0 '23  Juan Zandona (ZAC)
      2-0 '51  Carlos Vega (ZAC)

   - 2nd leg:
   07.Dc.96  San Nicolas de los Garza, Nuevo Leon  17:00
   Tigres     vs Saltillo    1 - 1  ==> Tigres 2-2 (standing)
      0-1 '26  Edson Zwaricz (SAL)
      1-1 '63  Marcos Ayala (TIG)

   07.Dc.96  Irapuato, Guanajuato  20:30
   Irapuato   vs Tampico     0 - 0  ==> Tampico 3-1 (aggregate)

   08.Dc.96  Xochitepec, Morelos  12:00
   Marte      vs A. Hidalgo  0 - 1  ==> A. Hidalgo 1-0 (aggregate)
      0-1 '32  Julio Jaramillo (AH)

   08.Dc.96  Cd. Victoria, Tamaulipas  15:30
   U.A.T.     vs Zacatecas   1 - 0  ==> Zacatecas 2-1 (aggregate)
      1-0 '73  Pablo Rodriguez (UAT)


 SEMI-FINALS (11-15/DC/96)

  - 1st leg:
  11.Dc.96  Tampico, Tamaulipas  15:30
  Tampico    vs Tigres      1 - 2
     0-1 '34  Nilson Esidio (TIG)
     0-2 '75  Claudio Nunez (TIG)
     1-2 '88  Gerardo Fernandez (TAM)

  12.Dc.96  Pachuca, Hidalgo  20:30
  A. Hidalgo vs Zacatecas   2 - 0
     1-0 '69  Jorge Uribe (AH)
     2-0 '76  Adrian Mahia (AH), p.k.
         '80  Hugo Ortiz (ZAC) ejected

  - 2nd leg:
  14.Dc.96  San Nicolas de los Garza, Nuevo Leon  17:00
  Tigres     vs Tampico     8 - 0  ==> Tigres 10-1 (aggregate)
     1-0 '09  Francisco 'Flaco' Gomez (TIG)
         '10  Porfirio Jimenez (TAM) ejected
     2-0 '46  Claudio 'Diable' Nunez (TIG)
     3-0 '51  Panfilo Escobar (TAM), o.g.
     4-0 '57  Marco A. Ruiz (TIG)
     5-0 '70  Nilson Esidio (TIG)
     6-0 '80  Francisco J. 'Abuelo' Cruz (TIG), p.k.
         '84  Gerardo Fernandez (TAM) misses p.k.
     7-0 '87  Francisco J. 'Abuelo' Cruz (TIG)
     8-0 '89  Francisco J. 'Abuelo' Cruz (TIG)

  15.Dc.96  Zacatecas, Zacatecas  16:00
  Zacatecas  vs A. Hidalgo  1 - 5  ==> A. Hidalgo 7-1 (aggregate)
     0-1 '08  Cesar Gomez (AH)
     0-2 '41  Cesar Gomez (AH)
     0-3 '71  Cesar Gomez (AH)
     1-3 '73  German Osorio (ZAC)
     1-4 '83  Manuel Rios (AH)
     1-5 '89  Adrian Mahia (AH)


 FINAL (18-21/DC/96)

  1st leg:
  18.Dc.96  Pachuca, Hidalgo  20:45 CDT
  A. Hidalgo vs Tigres       1 - 0
     1-0 '55  Cesar Gomez (AH)

  2nd leg:
  21.Dc.96  San Nicolas de los Garza, Nuevo Leon  17:00
  Tigres     vs A. Hidalgo   3 - 0   ==> Tigres 3-1 (aggregate)
     1-0 '07  Gabriel 'Coca' Mendoza (TIG)
     2-0 '45  Claudio 'Diablo' Nunez (TIG)
     3-0 '47  Nilson Esidio (TIG), p.k.


 COMMENTS

   The Tigres become the Division 1-A Winter '96 Champion and
   earn the right to play the promotion match next June against the
   Summer '97 Champion.




                  MEXICAN FOOTBALL LEAGUE                   
                        1 9 9 6 - 9 7                        
                         SUMMER 97                          
                        DIVISION  1-A                        
                                                             
 



Authors: Roger Z. Rios-Mercado and Erik Francisco Lugo

Last updated: 6 Feb 2014

(C) Copyright Roger Z. Rios-Mercado, Erik Francisco Lugo
and RSSSF 1998/2014

INFORMACIÓN

La Liga de Ascenso es el torneo de segunda categoría del fútbol en México formando parte de Liga Mexicana de Fútbol. El torneo fue establecido en 1994 cuando se intentó crear una "Liga Premier" y la Segunda División de México cambió de nombre a "Primera A". Cambia de nuevo de nombre en 2009 tomando el de Liga de Ascenso, que es con el que se le conocerá a partir del Torneo Apertura 2009. Se juegan dos torneos por año. En cada torneo, siete equipos califican a una liguilla (el primer lugar de la tabla general clasifica directo a semifinal). La liguilla consiste en partidos de visita recíproca de cuartos de final, semifinal y la gran final. El descenso y ascenso es cada dos torneos, contando el porcentaje de partidos ganados y jugados de los últimos seis torneos. Para ascender a Primera División el equipo debe de ganar un torneo y disputar un "juego de ascenso" ante el ganador del otro, o bien, puede ganar los dos y ganar su pase automáticamente. Para el torneo Clausura 2012 se ha confirmado la participación de 15 equipos.

  USO DE MEMORIA  
4,299,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0828
Total Execution Time  0.0847
  CADENA URL  
/apertura_liga_de_ascenso1997
  GET DATOS  
$_GET['/apertura_liga_de_ascenso1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso1997'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_liga_de_ascenso' 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.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 210 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (920880,863232,861248,856474,839257) ORDER BY n.cover_points DESC, update_date DESC
0.0018  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 = 30394 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='1997' WHERE c.parentId=210 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:52:57' 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=2 AND last_update > '2024-04-30 22:52:57' 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-30 22:52:57' 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=3 AND last_update > '2024-04-30 22:52:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_liga_de_ascenso' 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.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=30394 AND rel.round=17
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 = 30394 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-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30394 ORDER BY creation_date DESC LIMIT 0, 10
0.0030  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-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30394
0.0024  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` = 30394 AND c.`round` = 17 ORDER BY shedule ASC LIMIT 200
0.0025  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 = 17 AND e.real_date IS NOT NULL AND e.league_id = 30394 ORDER BY total DESC LIMIT 40
0.0023  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 = 30394 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0032  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 = 30394 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 30394 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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-05-01 00:00:00' AND c.`shedule` < '2024-05-05 23:59:59' AND l.id = 30394 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=210
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=210 AND year=1997