4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1995
Temporada Siguiente »
Publicidad 600x120.gif
Copa Chile 1995
1994/1995

Copa Chile 1995

Información Histórica 
						

Cup 1995

Primera División:
 
Final Tables:
 
Group 1:
 1. U.Católica   16 *
 2. Cobreloa      7 *
 3. Atacama       7
 4. Antofagasta   4
 
Group 2:
 1. U. de Chile   13 *
 2. La Serena      8 *
 3. Coquimbo U.    7 
 4. U. Española    5
 
Group 3:
 1. Colo Colo     16 *
 2. Everton        8 *
 3. O’Higgins      7
 4. Palestino      1
 
Group 4:
 1. Huachipato    11 [+3]*
 2. Concepción    11 [+1]*
 3. Temuco        10
 4. Osorno         1
 
*Qualified to Second Round
 
Round 1
[Feb 11]
UC-ATA  4-0 [1247, Mondría]
            [Espinoza 24pen, Galaz 40, Hormazábal 51, 63]
UE-SER  0-1 [1353, Imperatore]
            [Julio 82]
EV-CC   1-2 [14000, Guerrero]
            [Contreras 54; Vergara 17, Espina 65]
CON-TEM 1-3 [3335, Robles]
            [Ovalle 60; De Luca 50, 54pen, 90]
            so: ; Lepe
[Feb 12]
CB-ANT  2-0 [1958, Peña]
            [Latorre 7, Cornejo 38]
CU-U    1-0 [7453, Marín]
            [Barraza 55pen]
OH-PAL  1-1 [4795, Hormazábal]
            [Avila 76; Machín 14]
OS-HUA  0-1 [1500, J.C. Lemus]
            [Moyano 59]
            so: Medina; Moyano
 
Round 2
[Feb 18]
ANT-UC  1-1 [1738, Silva]
            [Ozzán 73; López 61]
SER-U   0-0 [9340, Peña]
EV-OH   0-0 [2010, Toro]
            so: Contreras  
ATA-CB  1-1 [1020, Osorio]
            [Vener 37; Glaría 64]
            so: Correa; Bravo
UE-CU   1-0 [1212, Cruz]
            [Morales 80]
            so: ; Johnny Pérez
            lp: F. Muñoz(save Johnny Pérez)
CC-PAL  1-0 [6977, Gamboa]
            [Rubio 57]
            so: ; Machín
[Feb 19]
HUA-TEM 4-2 [2461, Héller]
            [Viveros 26, Castillo 37, Zambrano 69, O. Gómez 88; Muñoz 87, 
             Arancibia 72]
            so: ; De Luca
OS-CON  0-2 [1726, Julio]
            [Lugo 2, Contreras 88]
            so: Imilpán
 
Round 3
[Feb 25]
U-UE    1-0 [13794, Mondría]
            [Goldberg 38]
            so: Fuentes; Rojas
            lp: ; Morales(save Vargas) 
CON-HUA 2-1 [9948, Silva]
            [Mangiantini 35, Lugo 77; Zambrano 15]
            so: ; Muñoz
PAL-EV  0-1 [600, Robles]
            [R. Castillo 26]
[Feb 26]
ANT-ATA 1-2 [1592, Gamboa]
            [Caballero 53; Viera 42, Fuentes 71]
OH-CC   1-1 [15439, Sánchez]
            [Ortega 54; Vergara 20]
            so: Borghi
UC-CB   2-1 [3214, Cruz]
            [Olmos 25, Mac Niven 54; Glaría 78]
CU-SER  1-0 [1987, Julio]
            [Lopresti 48]
            so: ; Pinto
TEM-OS  2-1 [4441, Osorio]
            [Muñoz 62, De Luca 69; Ugarte 15]
 
Round 4
[Mar 4]
SER-UE  1-1 [2353, J.C. Lemus]
            [Osorio 72; Rodrigo Valenzuela 22]
            so: ; Donoso
PAL-OH  2-3 [2385, Imperatore]
            [Vallejos 13, Díaz 39; Ortega 18, J. L. Díaz 42, 86]
            so: Pajón
U-CU    5-0 [9394, Hormazábal]
            [Jara 12, 61, Ibáñez 24, 89, Quiroga 67]
[Mar 5]
ATA-UC  2-3 [5000, Peña]
            [Vener 57pen, Lobos 86; López 14, 20, Mac Niven 25]
HUA-OS  2-1 [4070, Marín]
            [Moyano 11, Castillo 71; Ugarte 45]
ANT-CB  3-1 [3601, Heller]
            [Caballero 69pen, Valz 73, Caballero 77; Latorre 79]
CC-EV   7-1 [10191, Mondría]
            [Vega 11pen, Reyes 43, F. Rojas 62, Herrera 76, 78, 82, 86;
             Rodríguez 45]
            so: Rubio; Capazzuchi  
TEM-CON 0-2 [6174, Jara]
            [Aravena 55, 78]
            so: ; Mangiantini, Lugo
 
Round 5
[Mar 11]
UC-ANT  3-0 [6077, Sánchez]
            [Acosta 10pen, 58, Gorosito 72]
PAL-CC  2-3 [3750, Osorio]
            [Lee Chong 33, González 49; Herrera 14, 80, Vega 87]
CON-OS  1-1 [6555, Robles]
            [Contreras 60; Azás 11]
OH-EV   2-2 [3109, Julio]
            [Molina 37, Brizuela 50; Rojas 31, Covarrubias 47]
            so: Brizuela; Sepúlveda  
[Mar 12]
CU-UE   1-1 [3660, Peña]
            [Cerino 43; Morales 1] 
CB-ATA  4-0 [1745, Silva]
            [Riveros 13, González 44, Alvarez 45, 88]
            so: ; Cano
U-SER   2-0 [5675, Toro]
            [Jara 68, Goldberg 73]
TEM-HUA 1-1 [2119, Hormazábal]
            [De Luca 45; Contreras 26]
 
Round 6
[Mar 18]
CB-UC   1-3 [2940, Toro]
            [Yánez 5; Ceballos 10pen, Corrales 69, 72]
UE-U    1-2 [6523, Robles]
            [Monardes 28; O.R. Acosta 47, C. Castañeda 90]
            so: Morales, Traverso; Abarca
            lp: O.R. Acosta
CC-OH   3-1 [8812, Cruz]
            [Illesca 53, Espina 60, 62; Ortega 64]
EV-PAL  3-2 [1500, J.C. Lemus]
            [Covarrubias 56, Salinas 65, 90; Robles 45pen, Riadi 82]
            so: ; Salas
[Mar 19]
HUA-CON 1-1 [8129, Sánchez]
            [Torres 79; Lugo 36]
            so: ; Riquelme]
ATA-ANT 3-2 [987, Jara]
            [Candia 27, Vener 75, 81; Muñoz 23, Caballero 78]
SER-CU  2-1 [5240, Osorio]
            [Cerino 34, Torres 68; Osorio 88]
            so: Rotunno, Biehl 
OS-TEM  0-2 [1320, Heller]
            [Enríquez 13, De Luca 66]
 
Final Tables:
 
Group 1:
 1. U.Católica   16 *
 2. Cobreloa      7 *
 3. Atacama       7
 4. Antofagasta   4
 
Group 2:
 1. U. de Chile   13 *
 2. La Serena      8 *
 3. Coquimbo U.    7 
 4. U. Española    5
 
Group 3:
 1. Colo Colo     16 *
 2. Everton        8 *
 3. O’Higgins      7
 4. Palestino      1
 
Group 4:
 1. Huachipato    11 [+3]*
 2. Concepción    11 [+1]*
 3. Temuco        10
 4. Osorno         1
 
*Qualified to Second Round
 
Segunda División:
 
Tables:
 
 Group 1:
 1. Cobresal      13 *
 2. Iquique       13
 3. Ovalle         5
 4. Arica          3
 
 Group 2:
 1. Wanderers     16 *
 2. Audax          9
 3. San Felipe     5
 4. La Calera      0
 
 Group 3:
 1. Colchagua     13 *
 2. Rangers        7
 3. Melipilla      6
 4. Santa Cruz     5
 
 Group 4:
 1. Ñublense      11 *
 2. F. Vial        9
 3. Linares        6
 4. P. Montt       4
 
Second Round: [Jun 8, 15] 
 
Second places of Primera División versus First place of Segunda División
 
 Cobresal-Cobreloa    1-1/1-2
 Wanderers-La Serena  0-2/1-2
 Colchagua-Everton    2-1/2-5
 Ñublense-Concepción  2-1/1-3
 
Qualified to Quarter Final: Cobreloa, La Serena, Everton, Ñublense
 
Quarter Final:
 
[Aug 1]
SER-UC   1-5 [4367, Gamboa]
             [Osorio 70; Mac Niven 27, López 37, Acosta 44, Barrera 65, Ceballos 90]
[Aug 2]
EV-CON   0-2 [1124, Marín]
             [F. Pérez 46, Guerra 79]
             so: Roco
CB-U     3-2 [4121, Peña]
             [Alvarez 6, Glaría 8, Jaque 81; Miguel Rojas 24, Bravo 37]
             so: ; Jara
ÑUB-CC   2-0 [Nelson Oyarzun 11522, Hormazábal]
             [Cubillos 20, Lagos 74]
 
[Aug 15]
CC-ÑUB   4-2 [15000, Robles]
             [Díaz 38og, Etcheverry 51, Illesca 52, 75; Sepúlveda 18, Lizama 67]
             so: ; Villegas
UC-SER   1-2 [4329, Imperatore]
             [Barrera 26; Julio 42, 71] 
CON-EV   4-1 [5432, Peña]
             [Guerra 12, Lugo 31, Contreras 35, 80; Pulgar 28]  
U-CB     1-1 [10000, Guerrero] 
             [Cofré 76; González 64]
 
Qualified to semifinals: Núblense (Second Level), Universidad Católica, Concepción,
                         Everton 
 
Semifinal: 
 
[Aug 22]
ÑUB-UC   1-3 [Nelson Oyarzun, Chillan 14000, Marín] 
             [Valdir 65; Acosta 4, Barrera 43, Tudor 60]
             so: ; Müller
[Aug 23]
CB-CON   3-1 [2627, Toro]
             [Glaría 39, 62, 90; Pérez 76]
             so: ; Aravena
 
[Aug 29]
CON-CB   1-0 [8436, Guerrero]]
             [Guajardo 75]
 
Qualified to final: Cobreloa   
 
[Aug 30]
UC-ÑUB   5-2 [3051, Mondría]
             [Acosta 27, 34, 36, 67, 86; Valdir 4 and 66]
 
Qualified to final: U.Católica
 
Final:
 
[Sep 14]
U.Católica 4-2 Cobreloa
   [Acosta 7, Rozental 17, Barrera 36, Rojas 66og; Miranda 22,   
    González 44]
Estadio Nacional Att: 8,328
Referee: Eduardo Gamboa
Lineups:
        U.Católica: Tapia; Espinoza, Ardiman, Lizama, López;
                    Salinas [Gómez 83], Lepe, Gorosito, Barrera [Ceballos 79]; 
                    Acosta, Rozental 
                    Coach: Manuel Pellegrini
        Cobreloa:   Berríos; Puebla; Jaque, Rojas; 
                    Donoso [Riveros 20], Moena, Miranda [Silva 72];
                    Cornejo, Gonzalez; Alvarez, Carreño 
                    Coach: Jorge Garcés
lp: González(save Tapia), after convert the goal 44
 
Universidad Católica champion Copa Chile 1995
 
Topscorers:
 Alberto Acosta    Universidad Católica       10
 Alejandro Glaría  Cobreloa                    7
 Leonel Herrera    Colo Colo                   6
 
 

Authors: Juan Pablo Andrés
(jpandres@tutopia.com)
and Luis Antonio Reyes
(luchoasis@yahoo.es)
Last updated: 13 Aug 2001

(C) Copyright Juan Pablo Andrés and RSSSF 1999/2001


  USO DE MEMORIA  
4,251,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  1.6417
Total Execution Time  1.6436
  CADENA URL  
/copa_chile1995
  GET DATOS  
$_GET['/copa_chile1995']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_chile1995'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=541 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 541 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  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 (1293929,1265675,1264553,1264369,1202281) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=2452
0.0125  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 = 30705 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='1995' WHERE c.parentId=541 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:07:30' 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-27 10:07:30' 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-27 10:07:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:07:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0138  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0137  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 1995
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30705) 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.0130  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 (30705) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 1995
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30705) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0124  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 (30705) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 1995
0.0124  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30705) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0215  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 (30705) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0242  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 1995
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30705) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (30705) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  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 = 541 AND rp.year = 1995 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0126  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 = 541 AND rp.year = 1995 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0131  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=30705 AND rel.round=9
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 = 30705 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 = 30705 AND esl.points > 0
0.0127  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30705 ORDER BY creation_date DESC LIMIT 0, 10
0.0131  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30705
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 `calendars1995` 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` = 30705 AND c.`round` = 9 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 `events1995` e INNER JOIN calendars1995 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 = 9 AND e.real_date IS NOT NULL AND e.league_id = 30705 ORDER BY total DESC LIMIT 40
0.0127  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 `events1995` e INNER JOIN calendars1995 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 = 30705 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 `tables1995` 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 = 30705 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1995` 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 = 30705 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30705 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=541
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 541 AND l.year = 1995 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=541 AND year=1995