4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
The season consists of a Torneo Apertura and a Torneo Clausura.  Both
winners qualify for the Copa Libertadores 1997.  The champion is
determined in a playoff between the two winners.  If one team wins
both, it automatically wins the championship 1996.


Torneo Apertura
---------------

Final Table:

 1.Nacional               22 15  5  2  42-16  50   [Quito]
 2.Emelec                 22 14  4  4  50-19  46   [Guayaquil]
 3.Barcelona              22 13  3  6  36-16  42   [Guayaquil]
 4.Deportivo Quito        22  9  8  5  39-26  35   [Quito]
 5.Deportivo Cuenca       22  9  7  6  25-20  34   [Cuenca]
 6.Olmedo                 22  9  4  9  22-27  31   [Riobamba]
 7.Espoli                 22  7  8  7  23-26  29   [Quito]
 8.LDU Quito              22  7  4 11  30-32  25   [Quito]
 9.Tecnico Universitario  22  7  4 11  25-42  25   [Ambato]
10.Green Cross            22  6  2 14  18-41  20   [Manta]
11.Aucas                  22  3  6 13  16-29  15   [Quito]
12.LDU Portoviejo         22  4  3 15  21-53  15   [Portoviejo]

Round 1
LDU Quito-Barcelona 0-1
Nacional-Aucas 2-0
Cuenca-Green Cross 3-0,
Olmedo-Dep Quito 0-2
Emelec-Espoli 4-0
LDU Portoviejo-Tecnico Univ 0-2

Round 2
Barcelona-Nacional 1-0
Espoli-Olmedo 1-1
Aucas-LDU Portoviejo 3-1
Dep Quito-LDU Quito 2-2
Green Cross-Emelec 0-2
Tecnico U-Cuenca 1-1

Round 3
Olmedo-Barcelona 2-1
Espoli-Tecnico U 2-0
Nacional-Green Cross 4-0,
Cuenca-Dep Quito 0-0
Emelec-Aucas 2-1
LDU Portoviejo-LDU Quito 2-4

Round 4
Dep Quito-Emelec 1-2
Green Cross-Espoli 2-1
LDU Quito-Cuenca 0-1
Aucas-Olmedo 0-2
Tecnico U-Nacional 0-2
Barcelona-LDU Portoviejo 5-0

Round 5
Nacional-LDU Quito 1-0
Emelec-Tecnico U 7-0
Olmedo-Green Cross 2-0
LDU Portoviejo-Dep Quito 3-3
Cuenca-Barcelona 1-0
Aucas-Espoli 1-2

Round 6
Tecnico U-LDU Quito 0-2
Dep Quito-Nacional 2-2
Olmedo-Cuenca 0-0
Green Cross-Aucas 2-1
Espoli-LDU Portoviejo 3-0
Barcelona-Emelec 1-0

Round 7
Cuenca-Espoli 1-0
Dep Quito-Tecnico U 6-2
LDU Quito-Olmedo 5-0
LDU Portoviejo-Green Cross 2-1
Emelec-Nacional 2-1
Aucas-Barcelona 1-1

Round 8
Barcelona-Dep Quito 1-1
Aucas-LDU Quito 1-1
Espoli-Nacional 1-1
Olmedo-Emelec 1-0
LDU Portoviejo-Cuenca 2-5
Tecnico U-Green Cross 4-1

Round 9
Tecnico U-Barcelona 2-0
Nacional-Olmedo 2-1
Espoli-Dep Quito 1-0,
Cuenca-Aucas 3-0
Emelec-LDU Portoviejo 4-1
Green Cross-LDU Quito 2-0

Round 10
Green Cross-Barcelona 0-3
Nacional-LDU Portoviejo 6-0
Dep Quito-Aucas 2-1
LDU Quito-Espoli 0-1
Olmedo-Tecnico U 2-1
Emelec-Cuenca 2-0

Round 11
Barcelona-Espoli 2-0
LDU Quito-Emelec 4-3
Dep Quito-Green Cross 6-0
Cuenca-Nacional 0-0
Portoviejo-Olmedo 3-0
Tecnico U-Aucas 2-1

Round 12
Espoli-Barcelona 0-2
Emelec-LDU Quito 5-0
Green Cross-Dep Quito 0-1
Nacional-Cuenca 1-1
Olmedo-LDU Portoviejo 1-0
Aucas-Tecnico U 1-1

Round 13
Barcelona-Green Cross 1-0
LDU Portoviejo-Nacional 0-3
Aucas-Dep Quito 0-1
Espoli-LDU Quito 0-0
Tecnico U-Olmedo 2-1
Cuenca-Emelec 1-1

Round 14
Barcelona-Tecnico 6-1
Olmedo-Nacional 1-2
Dep Quito-Espoli 1-1
Aucas-Cuenca 2-0
Portoviejo-Emelec 0-1
LDU Quito-G Cross 1-1

Round 15
Dep Quito-Barcelona 1-0
LDU Quito-Aucas 1-0
Nacional-Espoli 2-2
Emelec-Olmedo 3-1
Cuenca-LDU Portoviejo 0-1
Green Cross-Tecnico U 0-0

Round 16
Espoli-Cuenca 4-1
Tecnico U-Dep Quito 3-1
Olmedo-LDU Quito 3-1
Green Cross-LDU Portoviejo 1-0
Nacional-Emelec 1-0
Barcelona-Aucas 1-1

Round 17
LDU Quito-Tecnico U 2-0
Nacional-Dep Quito 2-0
Cuenca-Olmedo 1-1
Aucas-Green Cross 1-0
LDU Portoviejo-Espoli 0-0
Emelec-Barcelona 2-1

Round 18
LDU Quito-Nacional 1-2
Tecnico U-Emelec 0-3
Green Cross-Olmedo 0-0
Dep Quito-LDU Portoviejo 3-0
Barcelona-Cuenca 1-0
Espoli-Aucas 1-0

Round 19
Emelec-Dep Quito 1-1
Espoli-Green Cross 2-1
Cuenca-LDU Quito 1-0
Olmedo-Aucas 1-0
Nacional-Tecnico U 2-1
LDU Portoviejo-Barcelona 2-5

Round 20
Barcelona-Olmedo 1-0
Tecnico U-Espoli 2-1
Green Cross-Nacional 1-2
Dep Quito-Cuenca 1-2
Aucas-Emelec 1-1
LDU Quito-LDU Portoviejo 2-0

Round 21
Nacional-Barcelona 1-0
Olmedo-Espoli 1-0
LDU Portoviejo-Aucas 3-0
LDU Quito-Dep Quito 2-2
Emelec-Green Cross 4-1
Cuenca-Tecnico U 1-0

Round 22
Barcelona-LDU Quito 2-1
Aucas-Nacional 0-1
Green Cross-Cuenca 3-0
Dep Quito-Olmedo 3-1
Espoli-Emelec 1-1
Tecnico U-LDU Portoviejo 1-1.

Final Table:

 1.Nacional               22 15  5  2  42-16  50   [Quito]
 2.Emelec                 22 14  4  4  50-19  46   [Guayaquil]
 3.Barcelona              22 13  3  6  36-16  42   [Guayaquil]
 4.Deportivo Quito        22  9  8  5  39-26  35   [Quito]
 5.Deportivo Cuenca       22  9  7  6  25-20  34   [Cuenca]
 6.Olmedo                 22  9  4  9  22-27  31   [Riobamba]
 7.Espoli                 22  7  8  7  23-26  29   [Quito]
 8.LDU Quito              22  7  4 11  30-32  25   [Quito]
 9.Tecnico Universitario  22  7  4 11  25-42  25   [Ambato]
10.Green Cross            22  6  2 14  18-41  20   [Manta]
11.Aucas                  22  3  6 13  16-29  15   [Quito]
12.LDU Portoviejo         22  4  3 15  21-53  15   [Portoviejo]

Torneo Clausura
---------------

Round 1
Nacional     2-0 Green Cross
Olmedo       3-2 LDU Quito
Cuenca       1-0 Emelec
Portoviejo   1-0 Espoli
Barcelona    2-2 Dep Quito
Aucas        2-2 Tecnico Univ

Round 2
Green Cross  1-2 Olmedo 
Nacional     2-0 LDU Quito 
Emelec       5-0 Portoviejo 
Espoli       1-1 Cuenca 
Aucas        1-0 Dep Quito
Tecnico Univ 2-0 Barcelona 

Round 3
LDU Quito    3-1 Green Cross 
Olmedo       1-0 Nacional 
Espoli       2-0 Emelec 
Cuenca       1-0 Portoviejo 
Dep Quito    3-2 Tecnico Univ
Barcelona    4-3 Aucas 

Round 4
Olmedo       1-0 Green Cross
LDU Quito    0-3 Nacional
Cuenca       0-0 Espoli
Portoviejo   1-2 Emelec
Aucas        0-2 Dep Quito
Barcelona    2-0 Tecnico Univ

Round 5
Green Cross  0-0 LDU Quito
Nacional     2-1 Olmedo
Emelec       3-0 Espoli
Portoviejo   2-3 Cuenca
Tecnico Univ 2-3 Dep Quito
Aucas        0-0 Barcelona

Round 6
LDU Quito    1-0 Olmedo
Green Cross  3-2 Nacional
Emelec       3-1 Cuenca 
Espoli       3-0 Portoviejo
Dep Quito    1-0 Barcelona 
Tecnico Univ 0-0 Aucas

Standings 

Group 1
 1.Nacional                6  4  0  2 11- 5  12
 2.Olmedo                  6  4  0  2  8- 6  12
-----------------------------------------------
 3.LDU Quito               6  2  1  3  6- 9   7
 4.Green Cross             6  1  1  4  5-10   4

Group 2
 1.Emelec                  6  4  0  2 13- 5  12
 2.Deportivo Cuenca        6  3  2  1  7- 6  11
-----------------------------------------------
 3.Espoli                  6  2  2  2  6- 5   8
 4.LDU Portoviejo          6  1  0  5  4-14   3

Group 3
 1.Deportivo Quito         6  4  1  1 11- 7  13
 2.Barcelona               6  2  2  2  8- 8   8
-----------------------------------------------
 3.Aucas                   6  1  3  2  6- 8   6
 4.Tecnico Universitario   6  1  2  3  8-10   5

Nacional, Olmedo, Cuenca, Emelec, Barcelona and Deportivo Quito
qualified for Hexagonal Final.


Hexagonal para Copa Libertadores de America
===========================================
Round 1
Nacional     3-1 Emelec
Barcelona    4-0 Olmedo
Cuenca       0-0 Dep Quito

Round 2
Olmedo       0-0 Nacional
Dep Quito    4-2 Barcelona
Emelec       5-1 Cuenca

Round 3
Barcelona    1-0 Nacional
Dep Quito    2-1 Emelec
Cuenca       1-1 Olmedo

Round 4
Nacional     3-1 Cuenca
Olmedo       0-1 Dep Quito
Emelec       1-0 Barcelona

Round 5
Nacional     2-0 Dep Quito
Emelec       2-2 Olmedo
Cuenca       1-2 Barcelona

Round 6
Dep Quito    2-2 Nacional
Olmedo       1-1 Emelec
Barcelona    2-2 Cuenca

Round 7
Cuenca       2-2 Nacional
Dep Quito    1-1 Olmedo
Emelec       3-0 Barcelona

Round 8
Nacional     0-0 Barcelona
Olmedo       0-1 Cuenca
Emelec       7-0 Dep Quito

Round 9
Nacional     4-1 Olmedo
Cuenca       1-0 Emelec
Dep Quito    0-3 Barcelona

Round 10
Dep Quito    3-0 Cuenca
Olmedo       0-2 Barcelona
Emelec       3-0 Nacional

Table:

 1.Emelec                 10  5  2  3  24-10  19  (2)
 2.Nacional               10  4  4  2  16-11  19  (3 bonus points)
 3.Barcelona              10  5  2  3  16-11  17
 4.Deportivo Quito        10  4  3  3  13-18  15
 5.Deportivo Cuenca       10  2  4  4  10-18  10
 6.Olmedo                 10  0  5  5   6-17   5

Emelec Clausura Champions; play off with Apertura Championship Nacional
for the championship 1996 (see below).

Hexagonal para el no descenso de categoría
==========================================

Round 1
Tecnico Univ 2-1 Green Cross
Portoviejo   2-2 LDU Quito
Aucas        1-1 Espoli

Round 2
Green Cross  1-1 Portoviejo
Aucas        1-1 LDU Quito
Tecnico Univ 1-1 Espoli

Round 3
Aucas        3-0 Portoviejo
Green Cross  1-2 Espoli
Tecnico Univ 2-0 LDU Quito

Round 4
Aucas        2-0 Green Cross
LDU Quito    2-2 Espoli
Portoviejo   2-0 Tecnico Univ

Round 5
Espoli       2-1 Portoviejo
Green Cross  2-1 LDU Quito
Tecnico Univ 2-1 Aucas

Round 6
Portoviejo   1-2 Espoli
LDU Quito    4-1 Green Cross
Aucas        3-0 Tecnico Univ

Round 7
Espoli       0-0 LDU Quito
Green Cross  2-1 Aucas
Tecnico Univ 3-0 Portoviejo

Round 8
Espoli       1-0 Green Cross
LDU Quito    1-0 Tecnico Univ
Portoviejo   0-0 Aucas

Round 9
Aucas        0-0 LDU Quito
Tecnico Univ 0-0 Espoli
Portoviejo   4-1 Green Cross

Round 10
Aucas        4-1 Espoli
LDU Quito    6-0 Portoviejo
Green Cross  1-2 Tecnico Univ

Table:

 1.Tecnico Universitario  10  5  2  3  12-10  17
 2.Espoli                 10  4  5  1  12-11  17
 3.Aucas                  10  4  4  2  16- 7  14  (-2 bonus points)
 4.LDU Quito              10  3  5  2  17-10  14
------------------------------------------------
 5.Green Cross            10  2  1  7  10-20   7
 6.LDU Portoviejo         10  2  3  5  11-20   6  (-3 bonus points)

Green Cross and LDU Portoviejo relegated.


1996 Championship Final
=======================

Nacional     2-1 Emelec
 [3' Augustin Delgado, 51' José Guerrero; 87' Em. Graciani]

Dec 22
Nacional     2-0 Emelec
 [24' Oswaldo dela Cruz, 89' Kleber Chalá, att: 41,207]


Nacional champions of Ecuador 1996.


Authors:
 Rudolf Ringger Carbo
(rringger@gu.pro.ec)
and Mikael Jönsson
(mikael.joensson@tordata.se)

Last updated: 4 Aug 1999

(C) Copyright Rudolf Ringger Carbo,
Mikael Jönsson and RSSSF 1999

INFORMACIÓN

La Serie A de Ecuador que por motivos de patrocinio es llamada desde 2013 con el nombre de Copa Pilsener, es el torneo oficial de fútbol de primera división realizado por la Federación Ecuatoriana de Fútbol.


  USO DE MEMORIA  
4,332,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0751
Total Execution Time  0.0769
  CADENA URL  
/ecuador1996
  GET DATOS  
$_GET['/ecuador1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'ecuador1996'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ecuador' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0034  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 43 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1297904,1299685,1289627,1269214,1269123) ORDER BY n.cover_points DESC, update_date DESC
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 = 28749 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=189 ORDER BY l.group_code ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 21:59:46' 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-04-26 21:59:46' 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=4 AND last_update > '2024-04-26 21:59:46' 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-04-26 21:59:46' 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 = 'ecuador' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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=28749 AND rel.round=22
0.0018  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 = 28749 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 28749 AND esl.points > 0
0.0018  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28749 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28749
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 `calendars1996` 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` = 28749 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events1996` e INNER JOIN calendars1996 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 28749 ORDER BY total DESC LIMIT 40
0.0019  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 `events1996` e INNER JOIN calendars1996 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 = 28749 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables1996` 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 = 28749 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1996` 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 = 28749 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 28749 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1996