| 0.0144 | SELECT type FROM routes WHERE alias = 'recopa1998' |
| 0.0291 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'recopa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0145 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1722 AND type_rel = 3 |
| 0.0147 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1722 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0147 | 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 (1156250,1009086,598084,882755,843226) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0158 | 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 = 10981 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0170 | 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 calendars1998 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 10981 ORDER BY round ASC |
| 0.0150 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 13:43:46' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0147 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 13:43:46' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0146 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 13:43:46' 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-05-05 13:43:46' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0150 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1722 AND l.year = 1998 |
| 0.0170 | SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (10981) 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.0165 | 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 (10981) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (264656,4927,265346,266710,265592,9926,264570,353788,354510,10433) ORDER BY rp.in_squad = 1 DESC |
| 0.0156 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1722 AND l.year = 1998 |
| 0.0210 | SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (10981) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0166 | 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 (10981) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (980,260357,264969,1467,10433,258663,265089,266302,266477,266710) ORDER BY rp.in_squad = 1 DESC |
| 0.0156 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1722 AND l.year = 1998 |
| 0.0203 | SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (10981) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0155 | 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 (10981) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (980,11046,179797,258159,265604,266677,354583,458491,460882,461776) ORDER BY rp.in_squad = 1 DESC |
Hapoel Beer
Legia
NK Zagreb
Ararat
Belshina
Slovan
Kilmarnock
Budapest
Progresul
APOEL
ÍBV
Boavista
Crvena
AIK Solna
Dinaburg
Luzern
Tromsø IL
Chelsea
Germinal
Stuttgart
Lokomotiv
Kocaelispor
Shakhtar
Vicenza
Real Betis
Kobenhavn
AEK Athens
Sturm Graz
Nice
Slavia
Primorje
Roda JC
Chelsea
Kilmarnock
Real Betis
Stuttgart
Legia Warszawa
Sturm Graz
AIK Solna
APOEL
Crvena Zvezda
Shakhtar Donetsk
Vicenza
Kobenhavn
Boavista
AEK Athens
Nice
Slovan Bratislava
Slavia Praha
Hapoel Beer Sheva
Lokomotiv Moskva
Roda JC
Luzern
Kocaelispor
ÍBV
Tromsø IL
Belshina Bobruisk
NK Zagreb
Ararat Yerevan
Primorje
Progresul Bucureşti
Dinaburg
Budapest BVSC
Germinal Beerschot