| 0.0020 | SELECT type FROM routes WHERE alias = 'uefa1989' |
| 0.0083 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uefa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0022 | 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 = 10956 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0028 | SELECT 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, dt1.stadium as stadium_name FROM calendars1989 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 10956 ORDER BY round ASC |
| 0.0028 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:40:34' 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-28 11:40:34' 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-28 11:40:34' 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-28 11:40:34' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0020 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1989 |
| 0.0034 | SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (10956) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0034 | 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 (10956) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (359729,410384,266472,266576,421128,436909,252461,252497,265147,267105) ORDER BY rp.in_squad = 1 DESC |
| 0.0023 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1989 |
| 0.0070 | SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (10956) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 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 (10956) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (463260,469164) ORDER BY rp.in_squad = 1 DESC |
| 0.0042 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1989 |
| 0.0042 | SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (10956) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0053 | 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 (10956) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (264973,265298,266009,266472,325752,353866,355899,359730,382627,402884) ORDER BY rp.in_squad = 1 DESC |
Tatabánya
Antwerp
Legia
Leverkusen
Belenenses
Nürnberg
Atlético
Aarau
Lokomotive
Patrick's
Zalgiris
Austria
Sporting
Ajax
Dukla Praha
Union
IK Brage
Akranes
Újpest FC
Rangers FC
Katowice
Aberdeen
Dnipro
Osters IF
DAC
Linfield
Molde FK
Waregem
Malmö FF
Torpedo
First
Ikast FS
Oțelul
APOEL
AEK Athens
Athletic
Montpellier
Benfica
Sliema
PAOK
Partizan
Slavia
Servette
Sturm Graz
Botev
Dinamo
Beşiktaş
Dinamo
Bayern
Inter
Real
Köln
Groningen
Stuttgart
Heart
Velež
Girondins
Napoli
Dynamo
Roma
RFC Liège
Juventus
Victoria
TPS
Aberdeen
Ajax
Athletic
Atlético
Austria Wien
Bayern München
Benfica
Heart of Midlothian
Inter
Juventus
Napoli
Rangers FC
Real Sociedad
Roma
Sporting CP
Beşiktaş
Malmö FF
Stuttgart
Dinamo Zagreb
Legia Warszawa
Sturm Graz
Girondins Bordeaux
B. Leverkusen
Os Belenenses
Köln
Antwerp
APOEL
ÍA Akranes
First Vienna
Nürnberg
Partizan Belgrade
PAOK
AEK Athens
Linfield
Molde FK
Servette
Groningen
Botev Plovdiv
Slavia Sofia
Dinamo Minsk
Montpellier
Dynamo Dresden
St Patrick's
Újpest FC
RFC Liège
Sliema Wanderers
Zalgiris Vilnius
TPS
Osters IF
Aarau