| 0.0145 | SELECT type FROM routes WHERE alias = 'uefa1999' |
| 0.0292 | 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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0150 | 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 = 10973 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0157 | 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 calendars1999 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 10973 ORDER BY round ASC |
| 0.0145 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:54:43' 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-28 12:54:43' 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-28 12:54:43' 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=3 AND last_update > '2024-04-28 12:54:43' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0149 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1999 |
| 0.0163 | SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (10973) 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.0148 | 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 (10973) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1204,7537,432910,1209,2567,52666,264659,11698,252430,257886) ORDER BY rp.in_squad = 1 DESC |
| 0.0148 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1999 |
| 0.0161 | SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (10973) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0148 | 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 (10973) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265509,134,264641,265561,265747,266599,432154,646,1297,2007) ORDER BY rp.in_squad = 1 DESC |
| 0.0147 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 117 AND l.year = 1999 |
| 0.0161 | SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (10973) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0148 | 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 (10973) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2007,800,1173,1297,2169,2171,6250,7193,10305,10831) ORDER BY rp.in_squad = 1 DESC |
LKS Lódz
Silkeborg
SK Brann
Werder
Argeş
Crvena
Metz
Willem II
Dinamo
Sigma
Schalke 04
Slavia
Maribor
Wisla
Litex
Grazer AK
Dinamo
Skonto Riga
Fenerbahçe
Leeds
Marítimo
Aston Villa
Stromsgodse
Újpest FC
Vitesse
AEK Athens
Anorthosis
Beitar
Servette
CSKA Sofia
Kosice
Fiorentina
Hajduk
Blackburn
Sparta
Vejle BK
Udinese
Leverkusen
Rapid Wien
Stuttgart
Feyenoord
FCSB
Valencia
FK Obilic
Vitória
Celtic
Sporting
Anderlecht
Roma
Zurich
Bologna
Real Betis
Grasshopper
Girondins
Real
Atlético
Olympique
Club Brugge
Monaco
Olympique
Rangers FC
Parma
Celta
Liverpool
Anderlecht
Aston Villa
Atlético
Blackburn Rovers
Celta
Celtic
Club Brugge
Fenerbahçe
Fiorentina
Liverpool
Rangers FC
Rapid Wien
Real Betis
Real Sociedad
Roma
Sporting CP
Valencia
Leeds United
FCSB
Olympique Lyonnais
Stuttgart
CSKA Sofia
Schalke 04
Olympique Marseille
Vitória Guimarães
Feyenoord
Bologna
Werder Bremen
Monaco
Girondins Bordeaux
B. Leverkusen
Crvena Zvezda
Parma
Udinese
AEK Athens
Sparta Praha
HNK Hajduk Split
Grasshopper
Dinamo Tbilisi
Grazer AK
Metz
Maribor
Zurich
Marítimo
Wisla Kraków
Slavia Praha
Servette
Anorthosis
SK Brann
Beitar Jerusalem