4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						

Table:
                          G AW HW  D  L  F  A Pt    
 1.SK Tirana             34  7 12 10  5 52-22 55
 2.Teuta Durrës          34  4 16 10  4 50-22 54
 3.Partizani Tiranë      34  5 11  9  9 43-24 46
 4.Flamurtari Vlorë      34  5 12  6 11 42-35 45
 5.Olimpik Tiranë        34  3 12  8 11 42-30 41
 6.Apolonia Fier         34  4  8  9 13 46-44 37
 7.Besa Kavajë           34  2 10  9 13 29-31 35
 8.Sopoti Librazhd       34  3  8  9 14 35-47 34
 9.Shkumbini Peqin       34  0 12  9 13 43-40 33
10.Vllaznia Shkodër      34  1  8 13 12 30-36 32 
11.Albpetrol Patos       34  1 11  7 15 30-48 32    
12.KS Laçi               34  1 12  4 17 49-53 31 
13.SK Elbasani           34  1  9 10 14 35-41 31   
14.Tomori Berat          34  0 11  9 14 34-40 31 
15.Shqiponja Gjirokastër 34  3 10  6 17 34-41 31   
16.Skënderbeu Korçë      34  2 11  3 18 35-49 31 
17.Kastrioti Krujë       34  2  9  6 17 30-40 30
18.Besëlidhja Lezhë      34  0  9  9 16 24-40 27

Note: home wins count for two points, away wins for three.
Dinamo Tiranë changed name to Olimpik Tiranë during the summer of 1995.


Round 1
Albpetrol           2-1 Teuta
Shkumbini           2-1 Sopoti
Vllaznia            1-1 Tomori
Apolonia            3-0 Beselidhja
Partizani           4-2 Kastrioti
Skenderbeu          3-0 Olimpik
Besa                1-0 Flamurtari
Laci                2-3 Tirana
Shqiponja           0-0 Elbasani

Round 2
Tirana              1-0 Besa
Kastrioti           2-0 Laci
Beselidhja          1-0 Partizani
Tomori              1-1 Skenderbeu
Elbasani            0-0 Shkumbini
Sopoti              1-0 Albpetrol
Flamurtari          3-0 Vllaznia
Teuta               3-1 Shqiponja
Olimpik             2-0 Apolonia

Round 3
Kastrioti           1-1 Olimpik
Shkumbini           2-2 Flamurtari
Vllaznia            0-2 Tirana
Tomori              1-0 Sopoti
Apolonia            0-0 Albpetrol
Partizani           0-2 Elbasani
Skenderbeu          2-1 Beselidhja
Laci                3-3 Teuta
Shqiponja           0-0 Besa

Round 4
Tirana              1-2 Partizani
Albpetrol           2-1 Shkumbini
Beselidhja          0-1 Shqiponja
Elbasani            0-1 Vllaznia
Sopoti              1-0 Skenderbeu
Flamurtari          1-0 Tomori
Teuta               4-2 Kastrioti
Olimpik             4-0 Laci
Besa                2-2 Apolonia

Round 5
Kastrioti           1-0 Beselidhja
Shkumbini           4-1 Skenderbeu
Vllaznia            1-0 Apolonia
Tomori              0-0 Tirana
Elbasani            1-0 Albpetrol
Flamurtari          0-1 Teuta
Partizani           3-1 Sopoti
Laci                0-1 Besa
Shqiponja           0-2 Olimpik

Round 6
Albpetrol           2-1 Laci
Beselidhja          1-0 Tomori
Sopoti              2-1 Kastrioti
Apolonia            0-1 Flamurtari
Teuta               2-0 Tirana
Olimpik             0-0 Vllaznia
Skenderbeu          2-0 Elbasani
Besa                1-0 Shkumbini
Shqiponja           1-2 Partizani

Round 7
Tirana              4-0 Beselidhja
Kastrioti           0-0 Shkumbini
Vllaznia            0-0 Besa
Tomori              2-1 Olimpik
Elbasani            1-1 Sopoti
Flamurtari          1-0 Albpetrol
Partizani           3-0 Skenderbeu
Teuta               1-1 Apolonia
Laci                1-0 Shqiponja

Round 8
Albpetrol           0-0 Partizani
Shkumbini           1-0 Vllaznia
Beselidhja          1-0 Teuta
Sopoti              0-1 Tirana
Apolonia            0-0 Laci
Olimpik             3-0 Elbasani
Skenderbeu          1-0 Kastrioti
Besa                2-1 Tomori
Shqiponja           0-1 Flamurtari

Round 9
Tirana              1-1 Kastrioti
Albpetrol           1-1 Beselidhja
Vllaznia            3-0 Skenderbeu
Tomori              1-1 Shkumbini
Elbasani            1-0 Besa
Sopoti              4-2 Shqiponja
Flamurtari          3-1 Laci
Partizani           6-1 Apolonia
Teuta               3-0 Olimpik

Round 10
Kastrioti           2-2 Vllaznia
Shkumbini           0-0 Teuta
Apolonia            3-1 Elbasani
Skenderbeu          1-1 Tirana
Olimpik             5-1 Albpetrol
Besa                2-0 Partizani
Laci                2-0 Sopoti
Shqiponja           3-0 Tomori
Beselidhja          0-0 Flamurtari

Round 11
Tirana              1-0 Shkumbini
Albpetrol           0-2 Shqiponja
Beselidhja          0-1 Olimpik
Tomori              2-0 Laci
Elbasani            1-0 Kastrioti
Flamurtari          5-1 Skenderbeu
Partizani           0-0 Vllaznia
Teuta               2-0 Besa    
Sopoti              1-0 Apolonia

Round 12
Tirana              2-1 Elbasani
Kastrioti           2-1 Tomori
Shkumbini           0-1 Partizani
Vllaznia            2-0 Sopoti
Olimpik             2-0 Flamurtari
Skenderbeu          0-1 Teuta
Besa                1-0 Albpetrol
Laci                1-1 Beselidhja
Apolonia            2-1 Shqiponja

Round 13
Beselidhja          1-1 Sopoti
Albpetrol           1-0 Kastrioti
Flamurtari          2-1 Elbasani
Shqiponja           1-0 Shkumbini
Teuta               3-1 Vllaznia
Laci                1-0 Skenderbeu
Apolonia            2-1 Tirana
Tomori              1-0 Partizani
Olimpik             2-1 Besa

Round 14
Tirana              3-0 Flamurtari
Kastrioti           1-0 Shqiponja
Shkumbini           2-1 Laci
Vllaznia            1-2 Albpetrol
Elbasani            2-2 Tomori
Sopoti              0-1 Teuta
Partizani           1-0 Olimpik
Skenderbeu          2-1 Apolonia
Besa                4-0 Beselidhja

Round 15
Albpetrol           5-1 Skenderbeu
Beselidhja          1-0 Elbasani
Flamurtari          0-1 Kastrioti
Apolonia            7-1 Shkumbini
Teuta               1-0 Tomori
Olimpik             0-1 Tirana
Besa                0-0 Sopoti
Laci                3-0 Partizani
Shqiponja           2-0 Vllaznia

Round 16
Tirana              1-1 Shqiponja
Elbasani            0-0 Teuta
Shkumbini           0-0 Beselidhja
Tomori              2-0 Albpetrol
Skenderbeu          0-1 Besa
Vllaznia            2-1 Laci
Sopoti              0-0 Olimpik
Partizani           0-0 Flamurtari
Kastrioti           Awd Apolonia     [awarded 0-2 to Apolonia]

Round 17
Teuta               1-0 Partizani
Olimpik             1-0 Shkumbini
Flamurtari          1-2 Sopoti
Besa                2-0 Kastrioti
Albpetrol           0-0 Tirana
Shqiponja           2-1 Skenderbeu
Beselidhja          0-0 Vllaznia
Apolonia            1-1 Tomori
Laci                4-1 Elbasani

Round 18
Beselidhja          0-2 Apolonia 
Elbasani            2-0 Shqiponja  
Olimpik             4-2 Skenderbeu 
Kastrioti           0-1 Partizani 
Sopoti              0-0 Shkumbini 
Teuta               1-0 Albpetrol 
Tirana              2-0 Laci  
Tomori              1-0 Vllaznia  
Flamurtari          3-2 Besa     

Round 19
Besa                1-0 Tirana
Laci                2-1 Kastrioti
Partizani           0-0 Beselidhja
Skenderbeu          0-0 Tomori
Shkumbini           1-0 Elbasani
Albpetrol           1-0 Sopoti
Vllaznia            1-2 Flamurtari   [corrected from 2-3]
Shqiponja           0-0 Teuta
Apolonia            1-0 Olimpik

Round 20
Olimpik             1-0 Kastrioti
Flamurtari          1-0 Shkumbini
Tirana              4-1 Vllaznia
Sopoti              4-1 Tomori       [corrected from 3-1]
Albpetrol           0-0 Apolonia
Elbasani            0-0 Partizani
Beselidhja          2-0 Skenderbeu
Teuta               3-0 Laci
Besa                0-1 Shqiponja

Round 21
Apolonia            1-1 Besa
Shkumbini           4-0 Albpetrol
Shqiponja           1-0 Beselidhja
Vllaznia            2-1 Elbasani
Skenderbeu          0-1 Sopoti
Tomori              2-0 Flamurtari
Kastrioti           2-1 Teuta
Laci                2-0 Olimpik
Partizani           0-2 Tirana

Round 22
Albpetrol           1-0 Elbasani  
Apolonia            2-2 Vllaznia  
Besa                1-0 Laci  
Beselidhja          1-0 Kastrioti   
Olimpik             0-0 Shqiponja 
Skenderbeu          Awd Shkumbini   [awarded 2-0 to Skenderbeu]  
Sopoti              0-0 Partizani     
Teuta               3-1 Flamurtari 
Tirana              1-1 Tomori  

Round 23
Laci                0-0 Albpetrol
Tomori              1-1 Beselidhja
Kastrioti           0-2 Sopoti
Flamurtari          3-0 Apolonia
Tirana              1-1 Teuta
Vllaznia            1-0 Olimpik
Elbasani            1-0 Skenderbeu
Shkumbini           2-0 Besa
Partizani           3-1 Shqiponja

Round 24
Beselidhja          0-1 Tirana
Shkumbini           2-1 Kastrioti    [also reported as 1-0]
Besa                2-2 Vllaznia
Olimpik             1-0 Tomori
Sopoti              1-1 Elbasani
Albpetrol           0-0 Flamurtari
Skenderbeu          1-0 Partizani
Apolonia            1-1 Teuta
Shqiponja           1-0 Laci

Round 25
Partizani           6-0 Albpetrol
Vllaznia            0-0 Shkumbini
Teuta               1-0 Beselidhja
Tirana              4-1 Sopoti
Elbasani            2-2 Olimpik
Kastrioti           1-0 Skenderbeu
Tomori              1-0 Besa
Flamurtari          3-0 Shqiponja
Laci                3-2 Apolonia

Round 26
Kastrioti           0-0 Tirana
Beselidhja          2-0 Albpetrol
Skenderbeu          1-0 Vllaznia
Shkumbini           2-0 Tomori
Besa                2-1 Elbasani
Shqiponja           5-0 Sopoti
Laci                4-0 Flamurtari
Apolonia            0-1 Partizani
Olimpik             0-0 Teuta

Round 27
Vllaznia            2-1 Kastrioti
Teuta               2-1 Shkumbini 
Elbasani            2-1 Apolonia  
Tirana              3-1 Skenderbeu 
Albpetrol           1-0 Olimpik 
Partizani           0-0 Besa
Sopoti              2-0 Laci                
Tomori              2-1 Shqiponja  
Flamurtari          1-0 Beselidhja

Round 28
Skhumbini           0-0 Tirana  
Shqiponja           4-1 Albpetrol  
Olimpik             1-1 Beselidhja         
Laci                3-1 Tomori   
Kastrioti           1-1 Elbasani
Skenderbeu          0-1 Flamurtari         
Vllaznia            0-0 Partizani
Besa                0-0 Teuta 
Apolonia            3-2 Sopoti             

Round 29
Elbasani            0-0 Tirana
Tomori              2-1 Kastrioti
Partizani           3-1 Shkumbini
Sopoti              0-0 Vllaznia
Shqiponja           1-3 Apolonia
Flamurtari          0-0 Olimpik
Teuta               3-1 Skenderbeu
Albpetrol           3-0 Besa
Beselidhja          0-1 Laci

Round 30
Albpetrol           2-1 Vllaznia
Apolonia            0-1 Skenderbeu
Beselidhja          3-1 Besa
Flamurtari          2-0 Tirana
Laci                5-3 Shkumbini
Olimpik             2-1 Partizani
Shqiponja           0-1 Kastrioti
Teuta               3-1 Sopoti
Tomori              2-0 Elbasani

Round 31
Besa                0-1 Olimpik
Elbasani            3-0 Flamurtari
Kastrioti           2-1 Albpetrol
Partizani           2-1 Tomori
Shkumbini           3-1 Shqiponja
Skenderbeu          2-1 Laci
Sopoti              1-0 Beselidhja
Tirana              2-0 Apolonia
Vllaznia            0-0 Teuta

Round 32
Elbasani            2-0 Beselidhja
Kastrioti           1-0 Flamurtari
Partizani           3-0 Laci
Shkumbini           3-0 Apolonia
Skenderbeu          3-1 Albpetrol
Sopoti              1-1 Besa 
Tirana              3-1 Olimpik
Tomori              1-2 Teuta
Vllaznia            0-0 Shqiponja

Round 33
Albpetrol           2-1 Tomori
Apolonia            2-0 Kastrioti
Besa                0-1 Skenderbeu
Beselidhja          5-4 Shkumbini
Flamurtari          0-0 Partizani
Laci                2-0 Vllaznia
Olimpik             5-0 Sopoti
Shqiponja           0-1 Tirana
Teuta               2-1 Elbasani

Round 34
Elbasani            6-5 Laci
Kastrioti           2-0 Besa
Partizani           1-0 Teuta
Shkumbini           3-0 Olimpik
Sopoti              4-5 Flamurtari
Skenderbeu          4-1 Shqiponja
Tirana              5-1 Albpetrol
Tomori              1-3 Apolonia
Vllaznia            4-1 Beselidhja

Table:
                          G AW HW  D  L  F  A Pt
 1.SK Tirana             34  7 12 10  5 52-22 55
 2.Teuta Durrës          34  4 16 10  4 50-22 54
 3.Partizani Tiranë      34  5 11  9  9 43-24 46
 4.Flamurtari Vlorë      34  5 12  6 11 42-35 45
 5.Olimpik Tiranë        34  3 12  8 11 42-30 41
 6.Apolonia Fier         34  4  8  9 13 46-44 37
 7.Besa Kavajë           34  2 10  9 13 29-31 35
 8.Sopoti Librazhd       34  3  8  9 14 35-47 34
 9.Shkumbini Peqin       34  0 12  9 13 43-40 33
10.Vllaznia Shkodër      34  1  8 13 12 30-36 32
11.Albpetrol Patos       34  1 11  7 15 30-48 32
12.KS Laçi               34  1 12  4 17 49-53 31
13.SK Elbasani           34  1  9 10 14 35-41 31
14.Tomori Berat          34  0 11  9 14 34-40 31
15.Shqiponja Gjirokastër 34  3 10  6 17 34-41 31
16.Skënderbeu Korçë      34  2 11  3 18 35-49 31
------------------------------------------------
17.Kastrioti Krujë       34  2  9  6 17 30-40 30
18.Besëlidhja Lezhë      34  0  9  9 16 24-40 27
 
Note: home wins count for two points, away wins for three.
Dinamo Tiranë changed name to Olimpik Tiranë during the summer of 1995.

Promoted: FK Lushnja and Bylis (Ballshi) 


Author: RSSSF
(rsssf_request@topica.com)
Last updated: 20 Jun 2001

(C) Copyright RSSSF 1999/2001


  USO DE MEMORIA  
4,308,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.6569
Total Execution Time  0.6605
  CADENA URL  
/superliga_albania1996
  GET DATOS  
$_GET['/superliga_albania1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0163  SELECT type FROM routes WHERE alias = 'superliga_albania1996'
0.0303  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'superliga_albania' 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.0187  SELECT text_es as historical_text FROM leagues_text WHERE id=2292
0.0166  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 = 30535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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=182 GROUP BY c.id ORDER BY c.order_id ASC
0.0153  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:11:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:11:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:11:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0156  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:11:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'superliga_albania' 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.0165  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30535) 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.0175  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 (30535) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30535) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30535) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30535) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30535) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0151  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30535) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (30535) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 30535 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 30535 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0177  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=30535 AND rel.round=34
0.0158  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 = 30535 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0152  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 = 30535 AND esl.points > 0
0.0145  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` = 30535 ORDER BY creation_date DESC LIMIT 0, 10
0.0162  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` = 30535
0.0146  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` = 30535 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0144  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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 30535 ORDER BY total DESC LIMIT 40
0.0148  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 = 30535 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0148  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 = 30535 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 30535 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 30535 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0148  SELECT data1, data2 FROM services_tags WHERE categoryId=182
0.0148  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 182 AND l.year = 1996 ORDER BY l.group_code ASC
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=182 AND year=1996