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

Ascenso MX - Apertura 2000

Información Histórica 
						
(Second Level)

Winter Season


Round 1 (Aug 8)

At. Mexiquense 1-0 Puebla 
CA Hidalgo     2-0 Nacional 
Yucatán        1-2 Bachilleres
Veracruz       2-0 Queretaro 
Aguascalientes 1-0 Irapuato
Zacatepec      8-0 Saltillo 
Jaguares       1-1 Lobos 
RS Zacatecas   2-1 San Luis 
Correcaminos   4-0 Durango 
La Piedad      4-0 Tigres Ciudad Juarez
  
Round 2 (Aug 15)

Bachilleres    2-1 Correcaminos  
Nacional       3-2 At.Mexiquense 
Durango        0-0 Jaguares 
Saltillo       3-3 RS Zacatecas 
Queretaro      1-4 La Piedad
Puebla         1-1 Zacatepec 
Tigres CJ      1-1 Aguascalientes 
Irapuato       6-1 Yucatán 
San Luis       2-0 Veracruz 
Lobos          2-2 CA Hidalgo
  
Round 3 (Aug 22)

At.Mexiquense  3-1 Lobos 
CA Hidalgo     4-2 Durango 
Yucatán        1-1 Tigres CJ 
Veracruz       3-1 La Piedad 
Zacatepec      1-0 Nacional
Aguascalientes 4-3 Queretaro 
Jaguares       2-0 Bachilleres 
RS Zacatecas   1-1 Puebla 
San Luis       4-1 Saltillo 
Correcaminos   3-2 Irapuato

Round 4 (Aug 29)

Bachilleres    1-1 CA Hidalgo  
Nacional       2-1 RS Zacatecas  
Durango        1-1 At.Mexiquense 
Saltillo       5-1 Veracruz 
Queretaro      4-5 Yucatán
Puebla         0-3 San Luis 
Irapuato       5-0 Jaguares 
Tigres CJ      1-1 Correcaminos 
Lobos          3-2 Zacatepec
La Piedad      1-3 Aguascalientes
  
Round 5 (Sep 1)

At.Mexiquense  1-0 Bachilleres 
CA Hidalgo     2-0 Irapuato 
Saltillo       1-1 Puebla
Zacatepec      2-1 Durango 
Jaguares       2-0 Tigres Cd.Juarez
RS Zacatecas   2-1 Lobos 
San Luis       4-0 Nacional 
Yucatan        1-1 La Piedad 
Correcaminos   3-1 Queretaro 
Veracruz       4-1 Aguascalientes
  
Round 6 (Sep 5)

Aguascalientes 1-2 Yucatan 
Queretaro      1-0 Jaguares 
Puebla         2-0 Veracruz 
Irapuato       4-5 At.Mexiquense  
Tigres CJ      1-1 CA Hidalgo
Nacional       1-1 Saltillo 
Durango        1-3 RS Zacatecas 
Bachilleres    2-2 Zacatepec 
Lobos          0-1 San Luis 
La Piedad      0-2 Correcaminos

Round 7 (Sep 12)

At.Mexiquense  1-1 Tigres CJ  
CA Hidalgo     2-2 Queretaro  
Saltillo       3-3 Lobos 
Veracruz       5-0 Yucatan 
Zacatepec      2-2 Irapuato
Jaguares       2-1 La Piedad 
Puebla         4-1 Nacional 
RS Zacatecas   1-3 Bachilleres 
San Luis       1-1 Durango 
Correcaminos   2-2 Aguascalientes

Round 8 (Sep 19)

Bachilleres    3-2 San Luis 
Nacional       2-1 Veracruz 
Queretaro      2-2 At.Mexiquense
Durango        2-0 Saltillo 
Yucatan        2-0 Correcaminos
Aguascalientes 2-2 Jaguares 
Irapuato       3-1 RS Zacatecas 
Tigres CJ      1-1 Zacatepec 
Lobos          0-1 Puebla 
La Piedad      2-1 CA Hidalgo

Round 9 (Sep 25)

Nacional       2-1 Lobos 
At.Mexiquense  1-2 La Piedad 
CA Hidalgo     1-1 Aguascalientes 
Saltillo       3-1 Bachilleres 
Veracruz       0-1 Correcaminos
Zacatepec      3-1 Queretaro 
Jaguares       2-0 Yucatan 
Puebla         1-1 Durango 
RS Zacatecas   7-2 Tigres CJ 
San Luis       3-3 Irapuato
  
Round 10 (Sep 29)

La Piedad      0-0 Zacatepec 
Aguascalientes 0-2 At.Mexiquense 
Queretaro      1-1 RS Zacatecas 
Tigres CJ      1-2 San Luis 
Lobos          3-1 Veracruz
Irapuato       3-0 Saltillo 
Yucatan        2-1 CA Hidalgo 
Durango        1-1 Nacional 
Correcaminos   2-0 Jaguares 
Bachilleres    1-2 Puebla
  
Round 11 (Oct 3)

At.Mexiquense  1-2 Yucatan 
CA Hidalgo     2-1 Correcaminos 
Saltillo       1-1 Tigres CJ 
Veracruz       3-2 Jaguares 
Zacatepec      2-1 Aguascalientes
Puebla         4-2 Irapuato 
RS Zacatecas   1-0 La Piedad 
Nacional       3-2 Bachilleres 
San Luis       1-0 Queretaro 
Lobos          3-3 Durango
  
Round 12 (Oct 10)

Bachilleres    2-0 Lobos 
Durango        1-0 Veracruz 
Yucatan        0-1 Zacatepec
Aguascalientes 1-3 RS Zacatecas 
Queretaro      5-1 Saltillo  
Jaguares       1-1 CA Hidalgo 
Tigres CJ      0-2 Puebla 
Irapuato       5-1 Nacional 
Correcaminos   3-0 At.Mexiquense 
La Piedad      3-2 San Luis
  
Round 13 (Oct 17)

Nacional       2-3 Tigres CJ 
Durango        0-0 Bachilleres 
At.Mexiquense  2-0 Jaguares
Saltillo       2-3 La Piedad 
Veracruz       0-2 CA Hidalgo
Zacatepec      1-0 Correcaminos 
Puebla         2-1 Queretaro 
RS Zacatecas   2-0 Yucatan 
San Luis       8-1 Aguascalientes 
Lobos          4-0 Irapuato
  
Round 14 (Oct 24)

Bachilleres    3-2 Veracruz 
At.Mexiquense  3-4 CA Hidalgo 
Yucatan        3-0 San Luis
Aguascalientes 1-2 Saltillo 
Queretaro      3-3 Nacional  
Jaguares       2-5 Zacatepec 
Tigres CJ      2-1 Lobos 
Irapuato       3-1 Durango 
Correcaminos   3-1 RS Zacatecas 
La Piedad      2-3 Puebla
  
Round 15 (Oct 27)

Saltillo       4-2 Yucatan 
Zacatepec      4-2 CA Hidalgo 
Puebla         1-1 Aguascalientes 
Nacional       2-1 La Piedad 
RS Zacatecas   3-0 Jaguares
San Luis       2-2 Correcaminos 
Veracruz       2-0 At.Mexiquense
Durango        2-1 Tigres CJ
Bachilleres    1-3 Irapuato 
Lobos          3-1 Queretaro
  
Round 16 (Oct 31)

At.Mexiquense  0-0 Zacatepec 
CA Hidalgo     1-2 RS Zacatecas 
Yucatan        0-1 Puebla
Aguascalientes 3-3 Nacional 
Jaguares       1-2 San Luis 
Irapuato       5-1 Veracruz 
Tigres CJ      1-1 Bachilleres 
Queretaro      2-3 Durango 
Correcaminos   5-2 Saltillo
La Piedad      4-4 Lobos
  
Round 17 (Nov 7)

Bachilleres    1-0 Queretaro 
Nacional       2-2 Yucatan 
Durango        1-3 La Piedad 
Saltillo       1-2 Jaguares  
Veracruz       3-2 Zacatepec
Puebla         2-2 Correcaminos 
Irapuato       2-1 Tigres CJ 
RS Zacatecas   1-1 At.Mexiquense  
San Luis       1-1 CA Hidalgo 
Lobos          3-0 Aguascalientes
  
Round 18 (Nov 14) 

CA Hidalgo     4-1 Saltillo 
At. Mexiquense 2-2 San Luis 
Yucatan        0-2 Lobos 
Veracruz       4-1 Tigres CJ 
Aguascalientes 1-2 Durango
Zacatepec      1-0 RS Zacatecas 
Queretaro      0-2 Irapuato 
Jaguares       1-0 Puebla 
Correcaminos   1-1 Nacional 
La Piedad      0-0 Bachilleres

Round 19 (Nov 20)

Bachilleres    2-0 Aguascalientes  
Nacional       1-4 Jaguares  
Durango        0-0 Yucatan 
Saltillo       1-1 At.Mexiquense  
Angeles        1-2 CA Hidalgo
Irapuato       3-0 La Piedad  
RS Zacatecas   2-1 Veracruz  
San Luis       3-1 Zacatepec 
Lobos          3-3 Correcaminos  
Tigres CJ      5-1 Queretaro 

Tables:

Group A
 1.Angeles de Puebla    19  9  6  4 29-21 33  Qualified
 2.La Piedad            19  7  4  8 32-32 25  Recalificacion
 3.Nacional de Tijuana  19  6  6  7 30-42 24
 4.Saltillo             19  4  6  9 32-51 18
 5.Queretaro            19  2  4 13 29-47 10

Group B
 1.Irapuato             19 11  2  6 53-31 35  Qualified
 2.RS Zacatecas         19 10  4  5 37-26 34  Qualified
 3.Correcaminos         19  9  6  4 39-24 33  Recalificacion
 4.Atletico Mexiquense  19  6  7  6 29-29 25
 5.Veracruz             19  8  0 11 33-35 24

Group C 
 1.Zacatepec            19 10  6  3 39-22 36  Qualified
 2.Cruz Azul Hidalgo    19  8  7  4 37-28 31  Qualified
 3.Bachilleres          19  8  5  6 27-25 28  Recalificacion
 4.Lobos UAP            19  6  6  7 38-33 24
 5.Tigres Ciudad Juarez 19  3  8  8 24-37 17  

Group D 
 1.Real San Luis        19 10  5  4 44-25 35  Qualified
 2.Jaguares Colima      19  7  4  8 24-30 25  Recalificacion
 3.Durango              19  5  8  6 23-30 23
 4.Yucatán              19  6  4  9 24-36 22
 5.Aguascalientes       19  3  6 10 25-44 15
  
Group winners qualify for playoff;
runners-up qualify for playoff if better then all numbers 3;
other runners-up play off against best third-placed teams
  
Recalificacion 

First Legs [Nov 24]
Jaguares       4-2 Correcaminos  
La Piedad      1-0 Bachilleres

Second Legs [Nov 27]
Correcaminos   3-1 Jaguares  
Bachilleres    1-3 La Piedad

Quarterfinals

First Leg [Dec 1]
La Piedad      1-1 Irapuato
CA Hidalgo     2-0 Zacatepec
Angeles Puebla 2-2 San Luis
Correcaminos   0-2 RS Zacatecas

Second Legs [Dec 4]
Irapuato       2-0 La Piedad
Zacatepec      2-0 CA Hidalgo 
San Luis       3-0 Angeles de Puebla 
RS Zacatecas   4-2 Correcaminos       

Semifinals

First Legs [Dec 8]
RS Zacatecas   0-1 Irapuato
San Luis       0-1 Zacatepec

Second Legs [Dec 11]
Irapuato       1-1 RS Zacatecas
Zacatepec      2-1 San Luis

Final

First Leg [Dec 15]
Zacatepec      1-3 Irapuato

Second Leg [Dec 18]
Irapuato       2-2 Zacatepec

Irapuato qualified for promotion playoff.



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

Last updated: 19 Feb 2010

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

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,293,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1026
Total Execution Time  0.1046
  CADENA URL  
/apertura_liga_de_ascenso2000
  GET DATOS  
$_GET['/apertura_liga_de_ascenso2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso2000'
0.0043  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=210 AND type_rel = 3
0.0027  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.0022  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.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=2123
0.0019  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 = 30392 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='2000' WHERE c.parentId=210 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 210 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 07:33:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 07:33:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 07:33:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 07:33:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30392) 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.0018  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 (30392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30392) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (30392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30392) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (30392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30392) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (30392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30392 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30392 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=30392 AND rel.round=19
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30392 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 30392 AND esl.points > 0
0.0022  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` = 30392 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 30392
0.0019  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 `calendars2000` 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` = 30392 AND c.`round` = 19 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events2000` e INNER JOIN calendars2000 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 = 30392 ORDER BY total DESC LIMIT 40
0.0020  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 `events2000` e INNER JOIN calendars2000 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 = 30392 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2000` 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 = 30392 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 30392 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 30392 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=210
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 210 AND l.year = 2000 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=210 AND year=2000