4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1991
Temporada Siguiente »
Publicidad 600x120.gif
Copa México - Apertura 1991
1990/1991

Copa México - Apertura 1991

Información Histórica 
						
Copa México 1990-91 (Cup Tournament)

Week 1
[Aug 22]
Monterrey 2 Atlas 1
  [Mario Mota Souza 2, Germán Martellotto 79; Mauricio González 70]
Necaxa 0 Toluca 0
UAG 3 Irapuato 0
  [Guillermo Vázquez 49pen, Jorge Martínez 66, Fernando Sánchez Limón 86
UAT 1 Cruz Azul 0
  [René Mendieta 72]
Cobras Cd. Juárez 1 UNAM 1
  [Francisco Chávez 12; Ricardo Ferreti 68pen]
León 3 Puebla 1
  [Víctor García Reza 3, Rafael Bautista 18, José Luis González China 46; Jorge Aravena 78pen]
Santos Laguna 2 Guadalajara 1
  [Luis Enrique Calix 9pen, Juan Flores 70; Heriberto López 74og]
Atlético Morelia 1 Veracruz 0                 [in Estadio Venustiano Carranza]
  [Juan Gutiérrez 24]
Bye: Querétaro, UANL, U de G, América

Week 2
[Aug 25]
Cruz Azul 1 UAG 0
  [Pedro Duana 60]
UANL 2 UAT 0
Veracruz 2 Santos Laguna 0
  [Elías Ledezma 22, Jorge Comas 50pen]
[Aug 26]
Querétaro 1 Monterrey 2
  [Sergio Almaguer 1; Antonio González 22pen, Germán Martellotto 70]
Atlas 1 Necaxa 2                              [in Tepic]
  [Hugo Ortiz 7; Javier Ferreira 21pen 55]
U de G 0 León 0                               [in Estadio Olímpico U de G]
Puebla 1 Cobras Cd. Juárez 0
América 1 Atlético Morelia 0
  [Isaac Terrazas 43]
Bye: Toluca, Irapuato, UNAM, Guadalajara

Week 3
[Aug 29]
Toluca 4 Querétaro 0
  [Juan Antonio Pizzi, Roberto Depietri, Horacio Humoller, Gonzalo Hernández pen]
Monterrey 2 Necaxa 3
  [José Enrique Vaca 26og, Carlos Hermosillo 30; Ivo Basay 16, Ricardo Peláez 20, 43]
UAT 1 UAG 0
  [Marco Antonio Sánchez Tovar 68]
Irapuato 3 UANL 2
  [Fernando Bernal 4, 50, Ángel David Comizzo 30og; Sergio Lira 11, Álvaro Rodríguez 46]
UNAM 1 U de G 1
  [Jorge Campos 25; Octavio Mora 86]
León 0 Cobras Cd. Juárez 0
Guadalajara 0 América 1                        [in Zapopan]
  [Eduardo Antonio dos Santos 72]
Atlético Morelia 2 Santos Laguna 1             [in Estadio Venustiano Carranza]
  [Sergio Nelson González 45+pen 61; Juan Flores 76]
Bye: Atlas, Cruz Azul, Puebla, Veracruz

Week 4
[Sep 1]
Monterrey 4 Toluca 0
  [Germán Martellotto 36, Misael Espinosa 60, 86, Carlos Hermosillo 63]
Querétaro 1 Atlas 0
  [Omar Sánchez 51]
UANL 0 Cruz Azul 2
  [Luis Flores 46, Mario Ordiales 88]
UAT 4 Irapuato 0
  [Juan Manuel Villareal 12pen, 57, Luis Heimen 70, Jorge Contreras 78]
León 1 UNAM 1
  [José Luis González China 45; Jorge Campos 14]
[Sep 2]
U de G 1 Puebla 1
[Octavio Mora 29pen; Bruno Mendoza 9]           [in Estadio Olímpico U de G]
Atlético Morelia 1 Guadalajara 3                [in Estadio Venustiano Carranza]
[Manuel Vidrio 8og; Javier Aguirre 55, Paúl René Moreno 63, Benjamín Galindo 83pen]
América 1 Veracruz 1
  [Luis Roberto Alves 59; Jorge Luis Gabrich 87]
Bye: Necaxa, UAG, Cobras Cd. Juárez, Santos Laguna

Week 5
[Sep 5]
Toluca 3 Atlas 1
  [Víctor Rosete 55, Armando Romero 60pen, Juan Antonio Pizzi 67; Gastón Obledo 44]
Irapuato 0 Cruz Azul 1
  [Santiago Ostolaza 25]
Cobras 0 U de G 1
  [Daniel Guzmán 71]
UNAM 2 Puebla 1
  [Luis García 47, Claudio Suárez 65; Alí Fernández 1]
Guadalajara 2 Veracruz 0                        [in Zapopan]
[Mario Arteaga 44, Omar Arellano 47]
Santos Laguna 3 América 3
  [Dolmo Flores 11, Ramón Ramírez 38, Juan Flores 65; Antonio Carlos Santos 20, Luis Roberto Alves 30, 82]
[Sep 6]
Necaxa 2 Querétaro 0
  [Ivo Basay 39, Javier Ferreira 43]
UAG 4 UANL 1
  [Julio César Uribe 10, Guillermo Vázquez 52, Fernando Sánchez Limón 72, Jorge Martínez 89; Mariano Varela 62]
Bye: Monterrey, UAT, León, Atlético Morelia

Week 6
[Sep 8]
Atlas 1 Monterrey 1                             [in Zapopan]
  [Martín Hernández 68og; Francisco Javier Cruz 79pen]
Cruz Azul 3 UAT 0
  [Santiago Ostolaza 37, Mario Ordiales 43, Ramiro Romero 78]
Puebla 0 León 0
Veracruz 1 Atlético Morelia 1
  [Edgardo Bauza 90pen; Sergio Nelson González 20pen]
[Sep 9]
Toluca 0 Necaxa 0
Irapuato 0 UAG 0
UNAM 0 Cobras Cd. Juárez 1
  [José Ángel Galván 60]
Guadalajara 1 Santos Laguna 0                   [in Zapopan]
  [Mario Arteaga 29]
Bye: Querétaro, UANL, U de G, América

Week 7
[Sep 12]
Monterrey 4 Querétaro 3
  [Germán Martellotto 16, 35, Francisco Javier Cruz 61, Mario Mota Souza 80; Sergio Almaguer 22, 32, Omar Sánchez 62]
UAG 1 Cruz Azul 2
  [Almir Ernani 34; Ramiro Romero 27, Fabián Rosas 70]
UAT 2 UANL 1
  [Jorge Patiño 40og, Luis Heimen 70pen; Sergio Almirón 72pen]
León 0 U de G 1
  [Luis Alberto Flores 65]
Cobras Cd. Juárez 1 Puebla 1
  [Oscar Rodríguez 65; Roberto Ruiz Esparza 14]
Atlético Morelia 0 América 2
  [Joaquín Hernández 2, Luis Roberto Alves 75]
Santos Laguna 0 Veracruz 2
  [Jorge Luis Gabrich, Elías Ledesma]
[Sep 13]
Necaxa 4 Atlas 2
  [Marcial Mendoza 11, Ivo Basay 24, Alex Aguinaga 49, Ricardo Peláez 59; Hugo Ortiz 46, Sergio Pacheco 84pen]
Bye: Toluca, Irapuato, UNAM, Guadalajara

Week 8
[Sep 15]
UAG 3 UAT 0
  [Julio César Uribe 10pen 82, Juan Parra 75]
[Sep 16]
Querétaro 1 Toluca 1
  [Rubén Omar Romano 64pen; Juan Mendoza 30]
Necaxa 1 Monterrey 0
  [Ricardo Peláez 30]
UANL 2 Irapuato 0
  [Sergio Almirón 61pen 68]
U de G 4 UNAM 1                              [in Estadio Olímpico U de G]
  [Hugo Aparecido 14, Rafael Gutiérrez Aldaco 32, Luis Alberto Flores 39, 88; Jorge Campos 17]
Cobras Cd. Juárez 0 León 1
  [Carlos Turrubiates 47]
América 2 Guadalajara 1
  [Alfredo Tena 69, Luis Roberto Alves 74; Benjamín Galindo 90pen]
Santos Laguna 1 Atlético Morelia 2
  [Andrés Carranza 86; Ricardo Campos 28, Sergio Nelson González 46]
Bye: Atlas, Cruz Azul, Puebla, Veracruz

Week 9
[Sep 19]
Veracruz 3 América 4
  [Horacio Rocha 4, Gustavo Gaytán 7, Elías Ledesma 29; Luis Roberto Alves 49, 58, Eduardo Antonio dos Santos 61pen, 63]
Toluca 0 Monterrey 1
  [Martín Hernández 51]
Cruz Azul 2 UANL 1
  [Porfirio Jiménez 43pen, Mario Ordiales 63; Sergio Almirón 60]
Irapuato 2 UAT 1
  [Luis Américo Scatolaro 39, Pérez 42; Roberto Contreras 58]
Guadalajara 2 Atlético Morelia 0              [in Zapopan]
  [Javier Aguirre 45, Omar Arellano 90]
[Sep 20]
Atlas 2 Querétaro 1                           [in Zapopan]
  [Sergio Pacheco 2, 15pen; Rubén Omar Romano 40pen]
Puebla 3 U de G 1
  [Jorge Aravena 61, Bruno Mendoza 68, José María Higareda 75og; Luis Alberto Flores 31]
UNAM 5 León 2                                 [in Estadio Azulgrana]
  [Alberto García Aspe 2, 36pen, 52, Claudio Suárez 27, David Patiño 98; Francisco Uribe 96, Geraldo dos Santos 96]
Bye: Necaxa, UAG, Cobras Cd. Juárez, Santos Laguna 

Week 10
[Sep 22]
Atlas 0 Toluca 1                              [in Zapopan]
  [Narciso Cuevas 88]
UANL 2 UAG 2
  [Mario Hernández 21, Víctor Manuel Escalera 45; Ricardo Chávez Medrano 37, Julio César Uribe 52]
Cruz Azul 2 Irapuato 1
  [Pedro Duana 22, Ramiro Romero 78; Marcelo Fabián Espina 56]
Veracruz 3 Guadalajara 1
  [Elías Ledesma 20, 28, Horacio Rocha 49; Gerardo Silva 80]
[Sep 23]
Querétaro 1 Necaxa 1
  [Omar Sánchez 28; Ivo Basay 33]
Puebla 2 UNAM 2
  [Carlos Poblete 72, Jorge Aravena 78; Ricardo Ferreti 42, Jorge Campos 68]
U de G 1 Cobras Cd. Juárez 0                  [in Estadio Olímpico U de G]
[Luis Alberto Flores 34]
América 2 Santos Laguna 0
  [Eduardo Antonio dos Santos 18, Luis Roberto Alves 86]
Bye: Monterrey, UAT, León, Atlético Morelia

Group 1
Necaxa			8	5	3	0	13:6	+7	13 [qualified]
Monterrey		8	5	1	2	16:10	+6	11
Toluca			8	3	3	2	9:7	+2	 9
Querétaro		8	1	2	5	8:16	-8	 4
Atlas			8	1	1	6	8:15	-7	 3

Group 2
Cruz Azul		8	7	0	1	13:4	+9	14 [qualified]
UAG			8	3	2	3	13:7	+6	 8
UAT			8	4	0	4	9:11	-2	 8
UANL			8	2	1	5	11:15	-4	 5
Irapuato		8	2	1	5	6:15	-9	 5

Group 3
U de G			8	4	3	1	10:6	+4	11 [qualified]
UNAM			8	2	4	2	13:13	 0	 8
León			8	2	4	2	7:8	-1	 8
Puebla			8	2	4	2	10:10	 0	 8
Cobras			8	1	3	4	3:6	-3	 5

Group 4
América			8	6	2	0	16:8	+8	14 [qualified]
Veracruz		8	3	2	3	12:10	+2	 8
Guadalajara		8	4	0	4	11:9	+2	 8
Atlético Morelia	8	3	1	4	7:11	-4	 7
Santos Laguna		8	1	1	6	7:15	-8	 3

Semifinals
First Legs
[Oct 24]
U de G 2 Necaxa 0
  [Luis Alberto Flores 24, Daniel Guzmán 92pen]
Cruz Azul 1 América 4
  [Santiago Ostolaza 34; Eduardo Antonio dos Santos 2, 26, Antonio Carlos Santos 19, Juan Hernández 72]

Second Legs
[Oct 31]
América 2 Cruz Azul 0
  [Luis Roberto Alves 45, 68]
[Nov 1]
Necaxa 1 U de G 2
  [Sergio Carlos Díaz 52pen; Hugo Aparecido 20pen, Luis Alberto Flores 32]

Final
First Leg
[Jan 16, 1991]
U de G 1 América 0
  [Víctor Manuel Rodríguez 59]

Second Leg
[Jan 23]
América 0 U de G 0



Author: Erik Francisco Lugo
(eaglelugo@yahoo.com.mx)

Last updated: 2 Oct 2009

(C) Copyright Erik Francisco Lugo and RSSSF 1995/2009


  USO DE MEMORIA  
4,254,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1661
Total Execution Time  0.1679
  CADENA URL  
/copa_mexico_apertura1991
  GET DATOS  
$_GET['/copa_mexico_apertura1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_mexico_apertura1991'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_mexico_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=2061
0.0020  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 = 30322 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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='1991' WHERE c.parentId=695 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-28 06:01:30' 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-28 06:01:30' 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=4 AND last_update > '2024-04-28 06:01:30' 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=3 AND last_update > '2024-04-28 06:01:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_mexico_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1991
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (30322) 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.0022  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 (30322) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1991
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (30322) 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 (30322) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1991
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (30322) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0076  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 (30322) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0096  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1991
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (30322) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0510  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 (30322) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT SUM(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.category_id = 695 AND rp.year = 1991 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0017  SELECT SUM(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.category_id = 695 AND rp.year = 1991 AND rp.events > 0 GROUP BY p.id ORDER BY total 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=30322 AND rel.round=8
0.0019  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 = 30322 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 = 30322 AND esl.points > 0
0.0019  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` = 30322 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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` = 30322
0.0020  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 `calendars1991` 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` = 30322 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1991` e INNER JOIN calendars1991 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 = 8 AND e.real_date IS NOT NULL AND e.league_id = 30322 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 `events1991` e INNER JOIN calendars1991 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 = 30322 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0019  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 `tables1991` 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 = 30322 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1991` 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 = 30322 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 30322 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=695
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 695 AND l.group_code = 1 ORDER BY l.year DESC
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 695 AND l.year = 1991 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=695 AND year=1991