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

Ascenso MX - Apertura 1999

Información Histórica 
						
Mexico Second Level 1998/99 Primera División A

Winter 1998

Round 1 [Jul 26]
U Curtidores     3-1 Aguascalientes
S Luis           2-0 Atl Mexiquense
Tigrillos        5-0 Cruz Azul Hid
Zacatepec        2-2 Saltillo
Cuautitlan       4-2 Atl S Francisco
Yucatan          2-0 Chivas Tijuana
RS Zacatecas     2-1 Jaguares Colima
Correcaminos UAT 2-0 Veracruz
La Piedad        3-1 Queretaro
bye: Irapuato and Bachilleres

Round 2 [Aug 2]
Chivas Tijuana   3-0 U Curtidores     
Queretaro        2-2 RS Zacatecas   
Cruz Azul Hid    5-1 Yucatan   
Atl S Francisco  1-1 Zacatepec  
Veracruz         1-2 Cuautitlan 
Irapuato         5-2 Bachilleres
Atl Mexiquense   2-2 Tigrillos   
Saltillo         0-6 La Piedad  
Jaguares Colima  2-1 S Luis      
bye: Aguascalientes and Correcaminos UAT

Round 3 [Aug 9]
U Curtidores     1-1 Cruz Azul Hid
S Luis           2-2 Queretaro
Tigrillos        2-2 Jaguares Colima
Zacatepec        2-2 Veracruz
Aguascalientes   2-0 Chivas Tijuana
Yucatan          5-2 Atl Mexiquense
RS Zacatecas     1-1 Saltillo
Correcaminos UAT 0-2 Irapuato
La Piedad        0-1 Atl S Francisco
bye: Bachilleres and Cuautitlan 

Round 4 [Aug 16]
Bachilleres      2-2 Correcaminos UAT
Cruz Azul Hid    1-1 Aguascalientes
Queretaro        1-1 Tigrillos   
Atl S Francisco  2-3 RS Zacatecas   
Veracruz         6-0 La Piedad  
Irapuato         5-2 Cuautitlan 
Atl Mexiquense   1-2 U Curtidores     
Saltillo         1-1 S Luis      
Jaguares Colima  1-2 Yucatan   
bye: Chivas Tijuana and Zacatepec  

Round 5 [Aug 19]
Zacatepec        7-3 Irapuato
Cuautitlan       0-2 Bachilleres
Aguascalientes   2-1 Atl Mexiquense
Chivas Tijuana   2-1 Cruz Azul Hid
U Curtidores     1-2 Jaguares Colima
Yucatan          1-1 Queretaro
RS Zacatecas     5-2 Veracruz
S Luis           1-2 Atl S Francisco
Tigrillos        2-2 Saltillo
bye: Correcaminos UAT and La Piedad

Round 6 [Aug 23]
Atl Mexiquense   1-1 Chivas Tijuana
Queretaro        1-2 U Curtidores
Atl S Francisco  2-1 Tigrillos
Veracruz         1-1 S Luis
Irapuato         4-1 La Piedad
Bachilleres      2-2 Zacatepec
Correcaminos UAT 1-0 Cuautitlan
Saltillo         3-4 Yucatan
Jaguares Colima  0-2 Aguascalientes
bye: Cruz Azul Hid and RS Zacatecas

Round 7 [Aug 30]
Chivas Tijuana   2-1 Jaguares Colima
U Curtidores     1-2 Saltillo
Tigrillos        1-0 Veracruz
Cruz Azul Hid    2-1 Atl Mexiquense
Zacatepec        0-2 Correcaminos UAT
Aguascalientes   2-2 Queretaro
Yucatan          2-0 Atl S Francisco
RS Zacatecas     1-3 Irapuato
La Piedad        0-0 Bachilleres
bye: Cuautitlan and S Luis

Round 8 [Sep 6]
Bachilleres      2-2 RS Zacatecas
Queretaro        0-0 Chivas Tijuana
Atl S Francisco  2-2 U Curtidores
Veracruz         2-0 Yucatan
Irapuato         3-3 S Luis
Correcaminos UAT 3-2 La Piedad
Saltillo         4-0 Aguascalientes
Cuautitlan       5-1 Zacatepec
Jaguares Colima  0-1 Cruz Azul Hid
bye: Atl Mexiquense and Tigrillos

Round 9 [Sep 13]
Chivas Tijuana   1-1 Saltillo
U Curtidores     3-3 Veracruz
Tigrillos        1-1 Irapuato
Cruz Azul Hid    1-1 Queretaro
Atl Mexiquense   3-1 Jaguares Colima
Aguascalientes   2-1 Atl S Francisco
RS Zacatecas     1-2 Correcaminos UAT
S Luis           3-1 Bachilleres
La Piedad        3-1 Cuautitlan
bye: Zacatepec and Yucatan

Round 10 [Sep 16]
Zacatepec        3-1 La Piedad
Cuautitlan       2-2 RS Zacatecas
Queretaro        1-1 Atl Mexiquense
Correcaminos UAT 2-2 S Luis
Veracruz         2-1 Aguascalientes
Irapuato         3-2 Yucatan
Atl S Francisco  1-2 Chivas Tijuana
Bachilleres      1-0 Tigrillos
Saltillo         0-1 Cruz Azul Hid
bye: Jaguares Colima and U Curtidores

Round 11 [Sep 20]
U Curtidores     3-3 Irapuato
S Luis           3-2 Cuautitlan
Tigrillos        2-3 Correcaminos UAT
Yucatan          3-2 Bachilleres
RS Zacatecas     3-2 Zacatepec
Chivas Tijuana   3-4 Veracruz
Cruz Azul Hid    1-1 Atl S Francisco
Atl Mexiquense   2-2 Saltillo
Jaguares Colima  1-1 Queretaro
bye: La Piedad and Aguascalientes

Round 12 [Sep 27]
Bachilleres      1-0 U Curtidores
Zacatepec        2-1 S Luis
Atl S Francisco  1-1 Atl Mexiquense
Veracruz         2-1 Cruz Azul Hid
Irapuato         1-2 Aguascalientes
Correcaminos UAT 2-2 Yucatan
Saltillo         1-2 Jaguares Colima
Cuautitlan       0-0 Tigrillos
La Piedad        2-1 RS Zacatecas
bye: Queretaro and Chivas Tijuana

Round 13 [Oct 4]
Chivas Tijuana   2-1 Irapuato
U Curtidores     4-2 Correcaminos UAT
S Luis           5-0 La Piedad
Tigrillos        1-0 Zacatepec
Aguascalientes   3-3 Bachilleres
Queretaro        2-1 Saltillo
Yucatan          1-0 Cuautitlan
Atl Mexiquense   3-2 Veracruz
Jaguares Colima  3-2 Atl S Francisco
bye: RS Zacatecas and Cruz Azul Hid

Round 14 [Oct 11]
Bachilleres      1-2 Chivas Tijuana
Zacatepec        5-3 Yucatan
Atl S Francisco  1-1 Queretaro
Veracruz         3-1 Jaguares Colima
RS Zacatecas     2-2 S Luis
Irapuato         1-1 Cruz Azul Hid
Correcaminos UAT 1-3 Aguascalientes
Cuautitlan       2-1 U Curtidores
La Piedad        2-0 Tigrillos
bye: Saltillo and Atl Mexiquense

Round 15 [Oct 14]
Cruz Azul Hid    6-2 Bachilleres
Aguascalientes   1-3 Cuautitlan
Queretaro        3-3 Veracruz
Chivas Tijuana   1-1 Correcaminos UAT
U Curtidores     1-1 Zacatepec
Yucatan          2-2 La Piedad
Tigrillos        2-0 RS Zacatecas
Saltillo         0-1 Atl S Francisco
Atl Mexiquense   0-2 Irapuato
bye: S Luis and Jaguares Colima

Round 16 [Oct 18]
S Luis           3-1 Tigrillos
Zacatepec        4-2 Aguascalientes
Veracruz         4-1 Saltillo
RS Zacatecas     1-2 Yucatan
Irapuato         2-0 Jaguares Colima
Bachilleres      2-0 Atl Mexiquense
Correcaminos UAT 2-2 Cruz Azul Hid
Cuautitlan       4-1 Chivas Tijuana
La Piedad        0-0 U Curtidores
bye: Atl S Francisco and Queretaro

Round 17 [Oct 25]
Chivas Tijuana   2-2 Zacatepec               [0-2?]
U Curtidores     4-1 RS Zacatecas
Cruz Azul Hid    2-0 Cuautitlan
Atl Mexiquense   2-1 Correcaminos UAT
Aguascalientes   2-1 La Piedad               [2-0?]
Queretaro        1-4 Irapuato
Atl S Francisco  0-0 Veracruz
Yucatan          3-2 S Luis
Jaguares Colima  1-2 Bachilleres
bye: Tigrillos and Saltillo

Round 18 [Nov 1]
S Luis           1-2 U Curtidores
Tigrillos        0-0 Yucatan
Zacatepec        1-1 Cruz Azul Hid
RS Zacatecas     1-2 Aguascalientes
Irapuato         2-1 Saltillo
Bachilleres      1-2 Queretaro
Correcaminos UAT 1-0 Jaguares Colima
Cuautitlan       1-3 Atl Mexiquense
La Piedad        2-2 Chivas Tijuana
bye: Veracruz and Atl S Francisco

Round 19 [Nov 8]
Chivas Tijuana   1-2 RS Zacatecas
U Curtidores     1-1 Tigrillos
Cruz Azul Hid    3-1 La Piedad
Atl Mexiquense   4-4 Zacatepec
Aguascalientes   2-1 S Luis
Queretaro        2-2 Correcaminos UAT
Atl S Francisco  1-0 Irapuato
Saltillo         0-1 Bachilleres
Jaguares Colima  5-2 Cuautitlan
bye: Yucatan and Veracruz

Round 20 [Nov 15]
Bachilleres      2-0 Atl S Francisco
S Luis           2-1 Chivas Tijuana
Tigrillos        1-2 Aguascalientes
Zacatepec        1-2 Jaguares Colima
Yucatan          1-0 U Curtidores
RS Zacatecas     3-4 Cruz Azul Hid
Irapuato         2-2 Veracruz
Correcaminos UAT 1-1 Saltillo
Cuautitlan       1-1 Queretaro
La Piedad        3-3 Atl Mexiquense

Round 21 [Nov 22]
Chivas Tijuana   1-0 Tigrillos
Cruz Azul Hid    0-4 S Luis
Atl Mexiquense   1-3 RS Zacatecas
Aguascalientes   1-0 Yucatan
Queretaro        1-1 Zacatepec
Atl S Francisco  1-0 Correcaminos UAT
Veracruz         1-0 Bachilleres
Saltillo         2-1 Cuautitlan
Jaguares Colima  2-1 La Piedad
bye: U Curtidores and Irapuato

Tables:

Group 1
 1.CD Veracruz              19  8  6  5 40-31 30  Qualified
 2.Correcaminos UAT         19  7  7  5 30-29 28  Qualified
 3.Jaguares Colima          19  7  2 10 27-32 23
 4.Tigrillos UNL            19  4  8  7 23-23 20
 5.Querétaro                19  2 14  3 26-30 20

Group 2
 1.CD Irapuato              19 10  5  4 47-32 35  Qualified
 2.Yucatán                  19 10  4  5 36-32 34  Qualified
 3.Chivas Tijuana           19  7  6  6 27-28 27  Playoff 
 4.Unión de Curtidores      19  6  7  6 31-29 25
 5.Real Sociedad Zacatecas  19  6  5  8 36-39 23

Group 3
 1.Aguascalientes           19 11  3  5 33-30 36  Qualified
 2.San Luis FC              19  7  6  6 40-29 27  Qualified
 3.Bachilleres Guadalajara  19  7  5  7 29-32 26
 4.Cuautitlán               19  6  3 10 32-37 21
 5.Atlético Mexiquense      19  4  7  8 31-39 19

Group 4
 1.Cruz Azul Hidalgo        19  8  7  4 34-29 31  Qualified
 2.CD Zacatepec             19  5  9  5 41-39 24  Playoff 
 3.Atlético San Francisco   19  6  6  7 22-26 24
 4.CF La Piedad             19  5  5  9 30-39 20
 5.CD Saltillo              19  3  7  9 25-35 16

NB: Tampico-Madero FC withdrew before the start of the championship.

Playoff [Reclasificacion] (second placed teams worse than third placed teams)
First Leg [Nov 25]
Zacatepec        2-0 Chivas Tijuana
Second Leg [Nov 28]
Chivas Tijuana   2-0 Zacatepec
  Chivas Tijuana on better season record

Quarterfinals 
First Legs [Dec 2]
Chivas Tijuana   1-0 Aguascalientes
S Luis           0-0 Irapuato
Correcaminos UAT 2-0 Yucatan
Veracruz         2-1 Cruz Azul Hid    
Second Legs [Dec 6]
Aguascalientes   0-0 Chivas Tijuana
Irapuato         5-0 S Luis
Yucatan          2-0 Correcaminos UAT
  Yucatan on better season record
Cruz Azul Hid    2-2 Veracruz

Semifinals [Dec 9 and 13]
Chivas Tijuana   0-1 Irapuato
Irapuato         0-2 Chivas Tijuana
Veracruz         1-1 Yucatan
Yucatan          2-0 Veracruz

Final [Dec 17 and 20]  
Chivas Tijuana   0-0 Yucatan
Yucatan          1-0 Chivas Tijuana

Yucatán won the Invierno and will play off against the Verano winners
for promotion.



Authors: José de Jesus Mora Rivera, Erik Francisco Lugo
and
Roberto Lahsen

Last updated: 29 Jan 2009

(C) Copyright José de Jesus Mora Rivera, Erik Francisco Lugo,
Roberto Lahsen and RSSSF 1999/2009

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,263,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.6111
Total Execution Time  0.6133
  CADENA URL  
/apertura_liga_de_ascenso1999
  GET DATOS  
$_GET['/apertura_liga_de_ascenso1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0124  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso1999'
0.0254  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=210 AND type_rel = 3
0.0130  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.0129  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.0128  SELECT text_es as historical_text FROM leagues_text WHERE id=2124
0.0126  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 = 30393 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1999' WHERE c.parentId=210 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 210 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 15:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 15:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 15:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 15:56:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30393) 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.0126  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 (30393) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30393) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30393) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30393) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (30393) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30393) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (30393) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 30393 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 30393 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 210 GROUP BY l.categoryId
0.0125  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=210 GROUP BY l.year ORDER BY l.year DESC
0.0128  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=30393 AND rel.round=19
0.0127  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 = 30393 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0127  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 = 30393 AND esl.points > 0
0.0126  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` = 30393 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 30393
0.0126  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1999` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 30393 AND c.`round` = 19 ORDER BY shedule ASC LIMIT 200
0.0125  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1999` e INNER JOIN calendars1999 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 19 AND e.real_date IS NOT NULL AND e.league_id = 30393 ORDER BY total DESC LIMIT 40
0.0130  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1999` e INNER JOIN calendars1999 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 30393 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 30393 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 30393 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 30393 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0128  SELECT data1, data2 FROM services_tags WHERE categoryId=210
0.0128  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 210 AND l.year = 1999 ORDER BY l.group_code ASC
0.0128  SELECT group_code, extraName from `leagues` WHERE categoryId=210 AND year=1999