| 0.0108 | SELECT type FROM routes WHERE alias = 'copa_danesa2016' |
| 0.0225 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_danesa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0106 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=604 AND type_rel = 3 |
| 0.0110 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 604 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0113 | 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 (1143504,914462,856898,854282,635949) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0107 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=604 ORDER BY order_id ASC |
| 0.0108 | SELECT
max(l.year) as max_year, min(l.year) as min_year
FROM leagues l WHERE categoryID = 604
GROUP BY l.categoryId |
| 0.0109 | SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=604 GROUP BY l.year ORDER BY l.year DESC |
| 0.0120 | 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 = 16622 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0124 | 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 calendars2016 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 16622 ORDER BY round ASC |
| 0.0107 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 02:50:14' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0108 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 02:50:14' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0107 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 02:50:14' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0107 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 02:50:14' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0109 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 604 AND l.year = 2016 |
| 0.0123 | SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (16622) 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.0115 | 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 (16622) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (141715,215826,219454,228938,5198,102406,148966,215250,228951,229311) ORDER BY rp.in_squad = 1 DESC |
| 0.0110 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 604 AND l.year = 2016 |
| 0.0115 | SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (16622) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0118 | 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 (16622) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (174592,230518,2085,5012,27061,66147,66487,204191,213639,229311) ORDER BY rp.in_squad = 1 DESC |
| 0.0111 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 604 AND l.year = 2016 |
| 0.0114 | SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (16622) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0114 | 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 (16622) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2085,204191,213627,228936,230146,281637,850209) ORDER BY rp.in_squad = 1 DESC |
Birkelse
Aalborg
Skjold
Thisted
Aars
DGL 2000
Kjellerup
Skanderborg
Aabyhøj
Fuglebakken
Tjørring
Marslev
Tarup-Paaru
Middelfart
Vejle BK
Morud
Marienlyst
Saedding
Kolding
Kalundborg
Frem
LUIF
1973 Herlev
Søllerød
FA 2000
Frederikssu
GVI
Helsinge
Avedøre
Hillerød
Herlev
Føroyar
Bornholm
Sundby
B93
Ledoeje-Smo
Frem 1886
Fremad
Virum
Nykøbing
Hellerup
Jammerbugt
Vendsyssel
Aulum
Brabrand
IF Lyseng
Viby
VSK Aarhus
Ringkøbing
Odder
B 1913
Svendborg
Esbjerg
Sydvest
Varde
Langeskov
Nyborg
Lundtoft
Næsby BK
Søhus
Årslev
Bjæverskov
Døllefjeld
Avarta
B 1908
Fremad
Frederiksbe
Skjold
Jaegersborg
Vanløse
Tårnby FF
Holstebro
Akademisk
Nordsjaella
Herlufsholm
Greve IF
Hvidovre
KFUM
Viborg FF
Rishøj
Brønshøj
Fredericia
Odense BK
Silkeborg
AGF Aarhus
Vejgaard B
SonderjyskE
Kolding IF
Skive
Fredensborg
Helsingør
Næstved
Midtjylland
HB Køge
AC Horsens
Lystrup
Aalborg BK
Lyngby BK
Esbjerg
Vestsjælla
Kobenhavn
Sønderborg
Randers
Holbæk
Brøndby
Roskilde
Hobro
Kobenhavn
Brøndby IF
Midtjylland
Odense BK
AGF Aarhus
Aalborg BK
Silkeborg IF
Lyngby BK
Randers
Esbjerg
Nordsjaelland
Vejle BK
Viborg FF
Akademisk Boldklub
AC Horsens
SonderjyskE
Frem 1886
Hvidovre IF
Næstved
B93
Fredericia
Hobro
Brønshøj
Fremad Amager
Vendsyssel
Skive
Brabrand
FC Helsingør
Jammerbugt
Thisted
Hellerup IK
Nykøbing FC
Kolding IF
Næsby BK
Roskilde
Avarta
Holstebro
Vanløse
Middelfart
VSK Aarhus
Greve IF
HB Køge
Marienlyst
Kjellerup
B 1913
Odder
Ringkøbing
Herlev
IF Lyseng
B 1908