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

Liga Eslovaquia 1996

Información Histórica 
						
Playoffs:

[Regular season follows below]

Group A

 1.SK Slovan Bratislava         32 22  9  1  79-20 75  Champions
 2.1.FC Kosice                  32 21  2  9  62-33 65  UEFA Cup
 3.FC Spartak Trnava            32 19  6  7  54-32 63
 4.FC Dukla Banska Bystrica     32 12 11  9  39-36 47
 5.FC Tatran Presov             32 12  7 13  34-36 43
 6.BSC JAS Bardejov             32 13  3 16  38-42 42

Group B

 7.FC Chemlon Humenne           32 13  5 14  50-44 44  CWC
 8.FK Lokomotiva Kosice         32 13  2 17  37-49 41
 9.ASK Inter Slovnaft B'lava    32 11  7 14  42-45 40
10.FC DAC Dunajska Streda       32 10  3 19  41-76 33
11.FC Nitra                     32  7  5 20  30-59 26
12.MFK Prievidza                32  7  4 21  31-65 25

[No team relegated; 4 promoted, namely Petrzalka, Zilina, Rimavska Sobota,
 and Spartak Dubnica.]

Round 23
Group A:
BARDEJOV - SLOVAN            1:2
TRNAVA - FC KOSICE           0:0
BANSKA BYSTRICA - PRESOV     1:0  (not 1:1)
Group B:
D. STREDA - HUMENNE          3:1
LOKO KOSICE - PRIEVIDZA      0:3
INTER - NITRA                1:0

Round 24:
Group A:
FC KOSICE - SLOVAN           0:2
TRNAVA - BANSKA BYSTRICA     2:0
PRESOV - BARDEJOV            1:0
Group B:
INTER - DUNAJSKA STREDA      3:2
HUMENNE - LOKO KOSICE        2:0
NITRA - PRIEVIDZA            1:0

Round 25:
Group A:
B. BYSTRICA - FC KOSICE      1:3
BARDEJOV - TRNAVA            0:1
SLOVAN - PRESOV              3:1
Group B:
D. STREDA - NITRA            1:2
LOKO KOSICE - INTER          1:0
PRIEVIDZA - HUMENNE          3:0

Round 26
Group A:
FC KOSICE - PRESOV           2:1
BANSKA BYSTRICA - BARDEJOV   1:1
TRNAVA - SLOVAN              0:1
Group B:
NITRA - HUMENNE              2:0
D. STREDA - LOKO KOSICE      0:1
INTER - PRIEVIDZA            2:1

Round 27
Group A:
BARDEJOV - FC KOSICE        0:3
PRESOV - TRNAVA             1:3
SLOVAN - B. BYSTRICA        0:0
Group B:
LOKO KOSICE - NITRA         3:0
HUMENNE - INTER             1:0
PRIEVIDZA - D. STREDA       3:0

Round 28
Group A:
BANSKA BYSTRICA - TRNAVA    2:2
SLOVAN - FC KOSICE          1:0
BARDEJOV - PRESOV           1:0
Group B :
NITRA - INTER               1:1
HUMENNE - DUNAJSKA STREDA   0:1
PRIEVIDZA - LOKO KOSICE     0:0

Round 29
Group A:
SLOVAN - BARDEJOV           3:0
FC KOSICE - TRNAVA          1:0
PRESOV - BANSKA BYSTRICA    1:1
Group B:
LOKO KOSICE - HUMENNE       0:3
PRIEVIDZA - NITRA           3:0
DUNAJSKA STREDA - INTER     0:4

Round 30
Group A:
FC KOSICE - B. BYSTRICA         3:1
TRNAVA - BARDEJOV               3:0
PRESOV - SLOVAN                 0:0
Group B:
HUMENNE - PRIEVIDZA             4:2
NITRA - D. STREDA               0:1
INTER - LOKO KOSICE             3:0

Round 31
GROUP A:
PRESOV - FC KOSICE      1:0
SLOVAN - TRNAVA         5:2
BARDEJOV - B. BYSTRICA  0:0
GROUP B:
HUMENNE - NITRA         1:0
PRIEVIDZA - INTER       2:1
LOKO KOSICE - D. STREDA 5:1

Round 32
GROUP A:
B. BYSTRICA - SLOVAN    0:0
TRNAVA - PRESOV         1:0
FC KOSICE - BARDEJOV    3:1
Group B:
D. STREDA - PRIEVIDZA   3:1
NITRA - LOKO KOSICE     4:1
INTER - HUMENNE         0:0

Group A

 1.SK Slovan Bratislava         32 22  9  1  79-20 75  Champions
 2.1.FC Kosice                  32 21  2  9  62-33 65  UEFA Cup
 3.FC Spartak Trnava            32 19  6  7  54-32 63  
 4.FC Dukla Banska Bystrica     32 12 11  9  39-36 47
 5.FC Tatran Presov             32 12  7 13  34-36 43
 6.BSC JAS Bardejov             32 13  3 16  38-42 42

Group B

 7.FC Chemlon Humenne           32 13  5 14  50-44 44  CWC
 8.FK Lokomotiva Kosice         32 13  2 17  37-49 41
 9.ASK Inter Slovnaft B'lava    32 11  7 14  42-45 40
10.FC DAC Dunajska Streda       32 10  3 19  41-76 33
11.FC Nitra                     32  7  5 20  30-59 26
12.MFK Prievidza                32  7  4 21  31-65 25

[No team relegated; 4 promoted, namely Petrzalka, Rimavska Sobota, Zilina,
 and Spartak Dubnica.]

Regular season:

Round 1
INTER BRATISLAVA - BARDEJOV     2:0
1. FC KOSICE - TRNAVA           3:0
HUMENNE - NITRA                 2:2
PRIEVIDZA - SLOVAN BRATISLAVA   0:0
B. BYSTRICA - DUNAJSKA STREDA   2:1
PRESOV - LOKOMOTIVA             2:1

Round 2
NITRA - PRIEVIDZA               1:1
DUNAJSKA STREDA - HUMENNE       4:0
LOKOMOTIVA KOSICE - TRNAVA      1:2
BARDEJOV - BANSKA BYSTRICA      3:1
PRESOV - INTER BRATISLAVA       1:0
SLOVAN BRATISLAVA - FC KOSICE   3:1

Round 3
INTER BRATISLAVA - LOKO KOSICE     0:3
HUMENNE - BARDEJOV                 3:1
BANSKA BYSTRICA - PRESOV           0:0
PRIEVIDZA - DUNAJSKA STREDA        2:3
FC KOSICE - NITRA                  2:0
TRNAVA - SLOVAN BRATISLAVA         1:1

Round 4
Lok Kosice  1-0 Slovan
Nitra       0-2 Trnava
D Streda    0-2 Kosice
Bardejov    2-0 Prievidza
Presov      0-0 Humenne
Inter       2-2 B Bystrica

Round 5
B. BYSTRICA - LOKO KOSICE    4:0
PRIEVIDZA - PRESOV           0:2
1. FC KOSICE - BARDEJOV      1:0
HUMENNE - INTER BRATISLAVA   1:2
TRNAVA - DUNAJSKA STREDA     5:1
SLOVAN - NITRA               6:1

Round 6
DUNAJSKA STREDA - SLOVAN           2:4
BANSKA BYSTRICA - HUMENNE          1:0
LOKOMOTIVA KOSICE - NITRA          4:0
BARDEJOV - TRNAVA                  0:0
PRESOV - 1. FC KOSICE              2:0
PRIEVIDZA - INTER                  2:2

Round 7
SLOVAN - BARDEJOV            2:0
HUMENNE - LOKO KOSICE        2:0
NITRA - DUNAJSKA STREDA      4:0
FC KOSICE - INTER            5:1
PRIEVIDZA - BANSKA BYSTRICA  1:2
TRNAVA - PRESOV              5:2

Round 8
Loko Kosice   3-1 D Streda
Bardejov      1-0 Nitra
Presov        0-0 Slovan
B Bystrica    3-1 FC Kosice
Humenne       5-0 Prievidza
Inter         1-2 Trnava

Round 9
Prievidza     0-2 Loko Kosice
FC Kosice     2-0 Humenne
Trnava        2-0 B Bystrica
Slovan        1-1 Inter
Nitra         2-1 Presov
D Streda      2-3 Bardejov

Round 10
LOKO KOSICE - BARDEJOV       0:1
PRIEVIDZA - FC KOSICE        0:4
B. BYSTRICA - SLOVAN BRAT.   0:0
PRESOV - DUNAJSKA STREDA     3:0
INTER BRATISLAVA - NITRA     1:0
HUMENNE - TRNAVA             1:2

Round 11
DUNAJSKA STREDA - INTER      3:2
TRNAVA - PRIEVIDZA           3:1
NITRA - BANSKA BYSTRICA      2:2
BARDEJOV - PRESOV            1:0
SLOVAN - HUMENNE             3:1
FC KOSICE - LOKO KOSICE      2:1

Round 12
LOKO KOSICE - PRESOV         0:1
BARDEJOV - INTER             2:1
NITRA - HUMENNE              2:1
D. STREDA - B. BYSTRICA      4:0
SLOVAN - PRIEVIDZA           5:0
TRNAVA - FC KOSICE           5:1

Round 13
TRNAVA - LOKO KOSICE         3:1
INTER - PRESOV               3:2
B. BYSTRICA - BARDEJOV       3:0
HUMENNE - D. STREDA          6:0
PRIEVIDZA - NITRA            3:1
FC KOSICE - SLOVAN           2:5

Round 14
SLOVAN - TRNAVA              3:0
LOKO KOSICE - INTER          0:2
PRESOV - B. BYSTRICA         0:1
BARDEJOV - HUMENNE           4:0
D. STREDA - PRIEVIDZA        2:0
NITRA - FC KOSICE            1:3

Round 15
HUMENNE - PRESOV             4:1
B. BYSTRICA - INTER          3:0
FC KOSICE - D. STREDA        4:0
TRNAVA - NITRA               3:0
SLOVAN - LOKO KOSICE         3:0
PRIEVIDZA - BARDEJOV         0:3

Round 16
Lok Kosice   1-0 B Bystrica
Inter        2-3 Humenne
Presov       4-0 Prievidza
Bardejov     1-2 Kosice
D Streda     0-0 Trnava
Nitra        0-4 Slovan

Round 17
TRNAVA - BARDEJOV            1:0
HUMENNE - BANSKA BYSTRICA    1:1
1. FC KOSICE - PRESOV        1:2
NITRA - LOKOMOTIVA KOSICE    1:2
PRIEVIDZA - INTER            1:0
SLOVAN - DUNAJSKA STREDA     7:1

Round 18
PRESOV - TRNAVA              1:1  
BARDEJOV - SLOVAN            1:2
BANSKA BYSTRICA - PRIEVIDZA  2:0
INTER - FC KOSICE            1:1
DUNAJSKA STREDA - NITRA      2:0
LOKO KOSICE - HUMENNE        3:2

Round 19
NITRA - BARDEJOV             3:4
FC KOSICE - BANSKA BYSTRICA  1:0
TRNAVA - INTER BRATISLAVA    1:0
D. STREDA - LOKO KOSICE      1:1
PRIEVIDZA - HUMENNE          1:2
SLOVAN BRATISLAVA - PRESOV   4:0

Round 20
INTER - SLOVAN               1:3
PRESOV - NITRA               1:0
HUMENNE - FC KOSICE          0:1
B. BYSTRICA - TRNAVA         1:0
LOKO KOSICE - PRIEVIDZA      2:0
BARDEJOV - D. STREDA         4:0

Round 21
FC KOSICE - PRIEVIDZA        5:0
TRNAVA - HUMENNE             0:3 (not 0:0)
BARDEJOV - LOKO KOSICE       3:0
D. STREDA - PRESOV           1:1
NITRA - INTER                0:0
SLOVAN - B. BYSTRICA         5:2

Round 22
LOKO KOSICE - FC KOSICE      0:3
PRIEVIDZA - TRNAVA           1:2
B. BYSTRICA - NITRA          2:0
INTER - DUNAJSKA STREDA      3:1
PRESOV - BARDEJOV            2:0
HUMENNE - SLOVAN             1:1


Table:

 1.SK Slovan Bratislava         22 15  6  1  62-16 51
 2.1.FC Kosice                  22 15  1  6  47-25 46
 3.FC Spartak Trnava            22 14  4  4  40-22 46
 4.FC Dukla Banska Bystrica     22 11  5  6  32-24 38
 5.BSC JAS Bardejov             22 12  1  9  34-25 37
 6.FC Tatran Presov             22 10  5  7  28-24 35
-----------------------------------------------------
 7.FC Chemlon Humenne           22  8  4 10  38-33 28
 8.FK Lokomotiva Kosice         22  9  1 12  26-33 28
 9.ASK InterSlovnaft B'lava     22  6  5 11  27-37 23
10.FC DAC Dunajska Streda       22  6  3 13  29-56 21
11.FC Nitra                     22  3  4 15  20-47 13
12.MFK Prievidza                22  2  3 17  13-54  9




Authors: Jiri Novotny
(novotny@ftknw.upol.cz)
and Peter Surin 
(surin@sportpress.sk).

Last updated: 26 Jul 1999

(C) Copyright Jiri Novotny, Peter Surin and RSSSF 1999


  USO DE MEMORIA  
4,250,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.0928
Total Execution Time  0.0963
  CADENA URL  
/eslovaquia1996
  GET DATOS  
$_GET['/eslovaquia1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'eslovaquia1996'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'eslovaquia' 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.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=1846
0.0018  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 = 30109 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='1996' WHERE c.parentId=35 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 35 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:21:42' 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-27 06:21:42' 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-27 06:21:42' 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-27 06:21:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'eslovaquia' 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 e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30109) 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 (30109) 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 events1996 e WHERE e.league_id IN (30109) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (30109) 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 events1996 e WHERE e.league_id IN (30109) AND (e.action IN (3,4) ) 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 (30109) 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 events1996 e WHERE e.league_id IN (30109) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (30109) 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 = 30109 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 = 30109 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=30109 AND rel.round=32
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 = 30109 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 30109 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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30109 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-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30109
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 `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` = 30109 AND c.`round` = 32 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 `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 = 32 AND e.real_date IS NOT NULL AND e.league_id = 30109 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 `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 = 30109 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 = 30109 AND t.round = 30 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 `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 = 30109 AND t.round = 32 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30109 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=35
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 35 AND l.year = 1996 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=35 AND year=1996