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,274,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.6733
Total Execution Time  0.6765
  CADENA URL  
/apertura_liga_de_ascenso1997
  GET DATOS  
$_GET['/apertura_liga_de_ascenso1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0148  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso1997'
0.0304  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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=210 AND type_rel = 3
0.0153  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.0147  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.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=2125
0.0146  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.0149  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:48:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:48:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:48:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:48:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0165  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.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30394) 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 (30394) 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 (30394) 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 (30394) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30394) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0154  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 (30394) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30394) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (30394) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0149  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 = 30394 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 = 30394 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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.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 = 30394 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0147  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.0147  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` = 30394 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30394
0.0149  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.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 = 17 AND e.real_date IS NOT NULL AND e.league_id = 30394 ORDER BY total DESC LIMIT 40
0.0151  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.0148  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.0148  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.0148  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 = 30394 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0148  SELECT data1, data2 FROM services_tags WHERE categoryId=210
0.0148  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 210 AND l.year = 1997 ORDER BY l.group_code ASC
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=210 AND year=1997