Publicidad 600x120.gif
Fase Previa Europa League 1996
1995/1996

Fase Previa Europa League 1996

Resultados
 
08 Ago 95
14:00 Finalizado
FC Kapaz FC Kapaz 0-4 Austria Wien Austria Wien más información Jugadas destacadas ...
0-1 31' Mons Ivar Mjelde
0-2 39' Stojan Belajic
0-3 50' T. Flögel
0-4 85' P. Pacult
 
22 Ago 95
20:20 Finalizado
Austria Wien Austria Wien 5-1 FC Kapaz FC Kapaz más información Jugadas destacadas ...
10' Mons Ivar Mjelde 1-0
17' A. Ogris 2-0
2-1 26' Imamyar Suleymanov
29' Mons Ivar Mjelde 3-1
42' A. Ogris 4-1
64' René Glatzer 5-1
79' Faig Jabbarov
Global
FC Kapaz 1 - 9 Austria Wien
 
08 Ago 95
17:00 Finalizado
Zimbru Chişinău Zimbru Chişinău 2-0 Hapoel Tel Aviv Hapoel Tel Aviv más información Jugadas destacadas ...
18' Vadim Gavriliuc 1-0
70' Rebeja 2-0
 
22 Ago 95
17:00 Finalizado
Hapoel Tel Aviv Hapoel Tel Aviv 0-0 Zimbru Chişinău Zimbru Chişinău más información ...
Global
Zimbru 2 - 0 Hapoel Aviv
 
08 Ago 95
17:00 Finalizado
FC Universitatea Craiova Universitatea Craiova 0-0 Dinamo Minsk Dinamo Minsk más información ...
 
22 Ago 95
18:00 Finalizado
Dinamo Minsk Dinamo Minsk (3) 0-0 (1) FC Universitatea Craiova Universitatea Craiova más información ...
Global Pen. (1-3)
Universitate 0 - 0 Dinamo Minsk
 
08 Ago 95
17:00 Finalizado
KF Tirana KF Tirana 0-1 Hapoel Beer Sheva Hapoel Beer Sheva más información Jugadas destacadas ...
0-1 1' A. Zeiberlins
 
22 Ago 95
18:00 Finalizado
Hapoel Beer Sheva Hapoel Beer Sheva 2-0 KF Tirana KF Tirana más información Jugadas destacadas ...
19' Serhiy Gusev 1-0
22' Amir Avigdor 2-0
90' N. Dede
Global
KF Tirana 0 - 3 Hapoel Beer
 
08 Ago 95
17:00 Finalizado
Dinamo Bucureşti Dinamo Bucureşti 0-1 Levski Sofia Levski Sofia más información Jugadas destacadas ...
30' Constantin Varga
 
22 Ago 95
19:00 Finalizado
Levski Sofia Levski Sofia 1-1 Dinamo Bucureşti Dinamo Bucureşti más información Jugadas destacadas ...
0-1 70' D. Lupu
108' I. Vasilev 1-1
Global
Dinamo 1 - 2 Levski Sofia
 
08 Ago 95
17:00 Finalizado
Zaglebie Lubin Zaglebie Lubin 0-0 Shirak Shirak más información Jugadas destacadas ...
82' H. Artoyan
 
22 Ago 95
16:00 Finalizado
Shirak Shirak 0-1 Zaglebie Lubin Zaglebie Lubin más información Jugadas destacadas ...
0-1 22' Stefan Machaj
Global
Zaglebie 1 - 0 Shirak
 
08 Ago 95
17:30 Finalizado
TPV Tampere TPV Tampere 0-4 Viking Stavanger Viking Stavanger más información Jugadas destacadas ...
0-1 48' Ingve Bøe
0-2 58' E. Østenstad
66' Marko Granholm
0-3 73' Rune Medalen
0-4 86' G. Sorloth
 
22 Ago 95
19:00 Finalizado
Viking Stavanger Viking Stavanger 3-1 TPV Tampere TPV Tampere más información Jugadas destacadas ...
4' Tommy Bergersen 1-0
41' Tommy Bergersen 2-0
62' G. Sorloth 3-0
3-1 88' J. Wiss
Global
TPV Tampere 1 - 7 Viking
 
08 Ago 95
17:30 Finalizado
Skonto Riga Skonto Riga 1-0 Maribor Maribor más información Jugadas destacadas ...
12' V. Babicevs 1-0
60' Sašo Lukič
 
22 Ago 95
18:00 Finalizado
Maribor Maribor 2-0 Skonto Riga Skonto Riga más información Jugadas destacadas ...
15' Emil Šterbal 1-0
20' Alojz Fricelj 2-0
53' I. Troickis
Global
Skonto Riga 1 - 2 Maribor
 
08 Ago 95
18:00 Finalizado
Botev Plovdiv Botev Plovdiv 1-0 Dinamo Tbilisi Dinamo Tbilisi más información Jugadas destacadas ...
43' Veselin Gerov 1-0
 
22 Ago 95
17:00 Finalizado
Dinamo Tbilisi Dinamo Tbilisi 0-1 Botev Plovdiv Botev Plovdiv más información Jugadas destacadas ...
0-1 89' K. Vidolov
89' L. Kobiashvili
Global
Botev 2 - 0 Dinamo
 
08 Ago 95
18:15 Finalizado
Sturm Graz Sturm Graz 0-1 Slavia Praha Slavia Praha más información Jugadas destacadas ...
0-1 83' Radek Bejbl
 
22 Ago 95
18:00 Finalizado
Slavia Praha Slavia Praha 1-1 Sturm Graz Sturm Graz más información Jugadas destacadas ...
45' Martin Hyský 1-0
1-1 54' M. Haas
Global
Sturm Graz 1 - 2 Slavia Praha
 
08 Ago 95
18:30 Finalizado
Slovan Bratislava Slovan Bratislava 4-0 NK Osijek NK Osijek más información Jugadas destacadas ...
8' D. Tittel 1-0
15' Štefan Rusnák 2-0
40' Štefan Rusnák 3-0
88' Ľ. Faktor 4-0
 
22 Ago 95
19:45 Finalizado
NK Osijek NK Osijek 0-2 Slovan Bratislava Slovan Bratislava más información Jugadas destacadas ...
0-1 54' Štefan Rusnák
67' Mirko Lulić
0-2 86' Fabinho
Global
Slovan 6 - 0 NK Osijek
 
08 Ago 95
18:30 Finalizado
Slavia Sofia Slavia Sofia 0-2 Olympiacos Piraeus Olympiacos Piraeus más información Jugadas destacadas ...
0-1 83' Ivic
0-2 89' Andrzej Juskowiak
 
22 Ago 95
20:00 Finalizado
Olympiacos Piraeus Olympiacos Piraeus 1-0 Slavia Sofia Slavia Sofia más información Jugadas destacadas ...
10' Ivic 1-0
Global
Slavia Sofia 0 - 3 Olympiacos
 
08 Ago 95
19:00 Finalizado
Orebro SK Orebro SK 0-0 Avenir Beggen Avenir Beggen más información ...
 
22 Ago 95
19:30 Finalizado
Avenir Beggen Avenir Beggen (3) 1-1 (0) Orebro SK Orebro SK más información Jugadas destacadas ...
20' L. Holtz 1-0
52' Markus Krahen
1-1 88' H. Birgisson
Global Pen. (0-3)
Orebro SK 1 - 1 Avenir
 
08 Ago 95
19:00 Finalizado
Lillestrom SK Lillestrom SK 4-0 FC Flora FC Flora más información Jugadas destacadas ...
43' Stein Arne Ingelstad 1-0
60' K. Ingebrigtsen 2-0
69' Tom Gulbrandsen 3-0
87' Tom Gulbrandsen 4-0
 
22 Ago 95
17:00 Finalizado
FC Flora FC Flora 1-0 Lillestrom SK Lillestrom SK más información Jugadas destacadas ...
54' Otar Korgalidze 1-0
Global
Lillestrom 4 - 1 FC Flora
 
08 Ago 95
19:00 Finalizado
Omonia Nicosia Omonia Nicosia 3-0 Sliema Wanderers Sliema Wanderers más información Jugadas destacadas ...
21' Sandro Zammit Fava
21' Dragan Đukanović
39' S. Valentin 1-0
51' S. Valentin 2-0
75' K. Malekkos 3-0
 
22 Ago 95
20:00 Finalizado
Sliema Wanderers Sliema Wanderers 1-2 Omonia Nicosia Omonia Nicosia más información Jugadas destacadas ...
43' H. Suda 1-0
1-1 59' S. Valentin
1-2 88' P. Xiourouppas
Global
Omonia 5 - 1 Sliema
 
08 Ago 95
19:00 Finalizado
Fenerbahçe Fenerbahçe 2-0 Partizani Tirana Partizani Tirana más información Jugadas destacadas ...
71' Elvir Bolić 1-0
87' B. Uygun 2-0
 
22 Ago 95
16:30 Finalizado
Partizani Tirana Partizani Tirana 0-4 Fenerbahçe Fenerbahçe más información Jugadas destacadas ...
0-1 14' B. Uygun
0-2 24' K. Şentürk
0-3 60' Elvir Bolić
0-4 86' Aygün Taskiran
Global
Fenerbahçe 6 - 0 Partizani
 
08 Ago 95
19:30 Finalizado
Jeunesse d'Esch Jeunesse d'Esch 0-0 FC Lugano FC Lugano más información ...
 
23 Ago 95
20:30 Finalizado
FC Lugano FC Lugano 4-0 Jeunesse d'Esch Jeunesse d'Esch más información Jugadas destacadas ...
18' T. Erceg 1-0
35' Esposito 2-0
45' T. Erceg 3-0
54' T. Erceg 4-0
Global
Jeunesse 0 - 4 FC Lugano
 
08 Ago 95
20:00 Finalizado
Bangor City Bangor City 0-4 Widzew Łódź Widzew Łódź más información Jugadas destacadas ...
0-1 25' R. Czerwiec
0-2 42' R. Czerwiec
0-3 51' Marek Koniarek
0-4 90' Marek Koniarek
 
22 Ago 95
17:00 Finalizado
Widzew Łódź Widzew Łódź 1-0 Bangor City Bangor City más información Jugadas destacadas ...
83' Bogdan Pikuta 1-0
Global
Bangor City 0 - 5 Widzew
 
08 Ago 95
20:00 Finalizado
Brøndby IF Brøndby IF 3-0 Inkaras Kaunas Inkaras Kaunas más información Jugadas destacadas ...
12' Hansen 1-0
42' O. Bjur 2-0
82' Sand 3-0
 
22 Ago 95
18:00 Finalizado
Inkaras Kaunas Inkaras Kaunas 0-3 Brøndby IF Brøndby IF más información Jugadas destacadas ...
30' A. Mika
0-1 53' Peter Møller
0-2 62' Jens Risager
0-3 65' Peter Møller
Global
Brøndby IF 6 - 0 Inkaras
 
08 Ago 95
20:00 Finalizado
Sparta Praha Sparta Praha 3-1 Galatasaray SK Galatasaray SK más información Jugadas destacadas ...
17' P. Nedved 1-0
22' V. Lokvenc 2-0
2-1 56' Dean Saunders
73' P. Nedved 3-1
 
22 Ago 95
19:00 Finalizado
Galatasaray SK Galatasaray SK 1-1 Sparta Praha Sparta Praha más información Jugadas destacadas ...
4' Dean Saunders 1-0
1-1 22' P. Nedved
Global
Sparta Praha 4 - 2 Galatasaray
 
08 Ago 95
20:00 Finalizado
Vardar Skopje Vardar Skopje 1-0 Samtredia Samtredia más información Jugadas destacadas ...
9' I. Nikolovski 1-0
 
22 Ago 95
15:00 Finalizado
Samtredia Samtredia 0-2 Vardar Skopje Vardar Skopje más información Jugadas destacadas ...
0-1 19' Ž. Serafimovski
0-2 39' G. Petreski
Global
Vardar 3 - 0 Samtredia
 
08 Ago 95
20:00 Finalizado
Crvena Zvezda Crvena Zvezda 0-1 Neuchâtel Xamax Neuchâtel Xamax más información Jugadas destacadas ...
0-1 85' Charles Wittl
 
22 Ago 95
20:00 Finalizado
Neuchâtel Xamax Neuchâtel Xamax 0-0 Crvena Zvezda Crvena Zvezda más información ...
Global
Crvena 0 - 1 Neuchâtel
 
08 Ago 95
20:00 Finalizado
Hibernians Hibernians 2-5 Chornomorets Odessa Chornomorets Odessa más información Jugadas destacadas ...
0-1 15' Timerlan Guseinov
0-2 23' Andrey Gashkin
27' George Lawrence 1-2
1-3 40' Volodimir Musolitin
1-4 48' Vasyl Kardash
1-5 53' Volodimir Musolitin
87' Konrad Sultana 2-5
 
22 Ago 95
18:00 Finalizado
Chornomorets Odessa Chornomorets Odessa 2-0 Hibernians Hibernians más información Jugadas destacadas ...
34' Olexandr Kozakevych 1-0
75' Volodimir Musolitin 2-0
Global
Hibernians 2 - 7 Chornomorets
 
08 Ago 95
19:00 Finalizado
FC VSS Kosice FC VSS Kosice 0-1 Újpest FC Újpest FC más información Jugadas destacadas ...
0-1 39' Tamás Tiefenbach
 
22 Ago 95
19:00 Finalizado
Újpest FC Újpest FC 2-1 FC VSS Kosice FC VSS Kosice más información Jugadas destacadas ...
56' Bálazs Bérczy 1-0
80' Károly Szanyó 2-0
2-1 85' V. Weiss
Global
Kosice 1 - 3 Újpest FC
 
08 Ago 95
20:30 Finalizado
Afan Lido Afan Lido 1-2 FS Jelgava FS Jelgava más información Jugadas destacadas ...
15' Vasiliy Ivanov
0-1 19' Jurijs Karašausks
29' Adam Moore 1-1
1-2 64' Valerijs Bogdan
 
22 Ago 95
17:00 Finalizado
FS Jelgava FS Jelgava 0-0 Afan Lido Afan Lido más información ...
Global
Afan Lido 1 - 2 FS Jelgava
 
08 Ago 95
20:30 Finalizado
Raith Rovers Raith Rovers 4-0 GÍ Gøta GÍ Gøta más información Jugadas destacadas ...
21' Jason Dair 1-0
47' A. Rougier 2-0
75' Mcanespie 3-0
78' C. Cameron 4-0
 
22 Ago 95
19:30 Finalizado
GÍ Gøta GÍ Gøta 2-2 Raith Rovers Raith Rovers más información Jugadas destacadas ...
0-1 30' Danny Lennon
80' H. Jarnskor 1-1
1-2 82' S. Crawford
88' M. Jarnskor 2-2
Global
Raith Rovers 6 - 2 GÍ Gøta
 
08 Ago 95
20:30 Finalizado
Glenavon Glenavon 0-0 FH Hafnarfjordur FH Hafnarfjordur más información ...
 
23 Ago 95
20:00 Finalizado
FH Hafnarfjordur FH Hafnarfjordur 0-1 Glenavon Glenavon más información Jugadas destacadas ...
0-1 64' Sammy Johnstone
Global
Glenavon 1 - 0 Hafnarfjordu
 
08 Ago 95
20:45 Finalizado
Motherwell Motherwell 1-3 MYPA MYPA más información Jugadas destacadas ...
8' Shaun Mcskimming 1-0
1-1 12' N. Grönholm
1-2 30' P. Tiainen
1-3 56' S. Mahlio
 
22 Ago 95
17:30 Finalizado
MYPA MYPA 0-2 Motherwell Motherwell más información Jugadas destacadas ...
0-1 29' A. Burns
0-2 69' Dougie Arnott
Global
Motherwell 3 - 3 MYPA
 
08 Ago 95
20:15 Finalizado
Apollon Smyrnis Apollon Smyrnis 1-0 NK Olimpija Ljubljana NK Olimpija Ljubljana más información Jugadas destacadas ...
41' Bledar Kola 1-0
 
22 Ago 95
17:30 Finalizado
NK Olimpija Ljubljana NK Olimpija Ljubljana 3-1 Apollon Smyrnis Apollon Smyrnis más información Jugadas destacadas ...
0-1 2' Bledar Kola
9' K. Bozgo 1-1
66' K. Bozgo 2-1
79' S. Zulič 3-1
Global
Apollon 2 - 3 Olimpija
 
08 Ago 95
21:00 Finalizado
Crusaders Crusaders 1-2 Silkeborg IF Silkeborg IF más información Jugadas destacadas ...
0-1 15' Heine Fernandez
0-2 47' M. Larsen
66' Glenn Hunter 1-2
 
22 Ago 95
19:00 Finalizado
Silkeborg IF Silkeborg IF 4-0 Crusaders Crusaders más información Jugadas destacadas ...
8' M. Larsen 1-0
51' Heine Fernandez 2-0
68' Kenni Sommer 3-0
82' Kenni Sommer 4-0
Global
Crusaders 1 - 6 Silkeborg
 
09 Ago 95
20:45 Finalizado
Dundalk Dundalk 0-2 Malmö FF Malmö FF más información Jugadas destacadas ...
0-1 1' J. Pettersson
0-2 10' A. Andersson
 
23 Ago 95
19:00 Finalizado
Malmö FF Malmö FF 2-0 Dundalk Dundalk más información Jugadas destacadas ...
22' A. Andersson 1-0
50' Jens Fjellström 2-0
Global
Dundalk 0 - 4 Malmö FF
 
08 Ago 95
20:45 Finalizado
Shelbourne Shelbourne 0-3 ÍA Akranes ÍA Akranes más información Jugadas destacadas ...
0-1 21' Bjarki Gunnlaugsson
62' Ray Duffy
0-2 83' A. Gunnlaugsson
0-3 84' Kári Reynisson
 
23 Ago 95
20:00 Finalizado
ÍA Akranes ÍA Akranes 3-0 Shelbourne Shelbourne más información Jugadas destacadas ...
41' Vinny Arkins
45' Siggi Jónsson 1-0
58' O. Thordarson 2-0
69' Alan Byrne
90' Ólafur Pétursson 3-0
Global
Shelbourne 0 - 6 ÍA Akranes
JUGADORES DESTACADOS

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,995,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2205
Total Execution Time  0.2226
  CADENA URL  
/previa_europa_league1996/grupo1
  GET DATOS  
$_GET['/previa_europa_league1996/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'previa_europa_league1996'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' 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.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 674 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1275465,1275183,1273994,1273871,1272678) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = 42396 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=117 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 21:25:50' 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-03-28 21:25:50' 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-03-28 21:25:50' 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-03-28 21:25:50' 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 = 'previa_europa_league' 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 l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1996
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (42396) 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.0027  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 (42396) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1121,260194,355119,406208,420385,512156,257932,258205,259028,264989,265722,320029,353290,353654,355185,355342,355503,355738,405947,459123) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1996
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (42396) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024  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 (42396) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (259033,265194,266118,324248,350457,352890,355185,420879,458376,459219,514125,514212,514691,597171,597424,597633,597747,245,376,1121) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1996
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (42396) AND (e.action IN (3,4) ) 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 (42396) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2094,352113,353326,355128,420885,514141,514673,514845,515029,516206,524237,587932,596382,597192,597355) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1996
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (42396) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0335  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 (42396) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0273  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 = 674 AND rp.year = 1996 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0020  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 = 674 AND rp.year = 1996 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
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=42396 AND rel.round=1
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 = 42396 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 = 42396 AND esl.points > 0
0.0032  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-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 42396 ORDER BY creation_date DESC LIMIT 0, 10
0.0090  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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 42396
0.0062  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` = 42396 AND c.`round` = 1 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0021  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1996 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1996 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 42396 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (40236,40295,40237,40274,40238,40281,40239,40283,40240,40288,40241,40269,40242,40284,40243,40279,40244,40275,40245,40280,40246,40291,40247,40292,40248,40289,40249,40272,40250,40293,40252,40270,40253,40299,40254,40271,40255,40278,40256,40286,40257,40268,40258,40294,40259,40282,40251,40287,40261,40273,40262,40290,40263,40298,40264,40276,40260,40277,40266,40285,40267,40296,40265,40297) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0020  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 = 1 AND e.real_date IS NOT NULL AND e.league_id = 42396 ORDER BY total DESC LIMIT 40
0.0019  SELECT distinct(shedule), round FROM `calendars1996` as c WHERE c.`league_id` = 42396 AND shedule >= '1995/08/01' AND shedule < '1995/09/01' ORDER BY shedule ASC
0.0023  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-03-28 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 42396 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=674
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=674 AND year=1996