| 0.0129 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2071 AND type_rel = 3 |
| 0.0138 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2071 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0136 | 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 (1281521,748241) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0129 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=2071 ORDER BY order_id ASC |
| 0.0142 | 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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51053 ORDER BY round ASC |
| 0.0130 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 06:16:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0129 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 06:16:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0130 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 06:16:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0130 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 06:16:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0131 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2020 |
| 0.0142 | SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51053) 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.0131 | 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 (51053) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (375035,427022,427088,645349,684620,693465,884318,424404,424898,427013) ORDER BY rp.in_squad = 1 DESC |
| 0.0129 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2020 |
| 0.0130 | SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51053) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0132 | 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 (51053) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (684620,693178,427002,427295,583402,626689,692389,692811,692920,693115) ORDER BY rp.in_squad = 1 DESC |
| 0.0127 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2020 |
| 0.0128 | SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51053) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0134 | 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 (51053) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (684620,693264,852037,619474,692389,692805,693184,693189,693530,693573) ORDER BY rp.in_squad = 1 DESC |
Genoa
Empoli
Virtus
Cittadella
Brescia
Spezia
Sampdoria
Milan
Sassuolo
Pisa
Livorno
Bologna
Parma
Cremonese
Perugia
Salernitana
Benevento
Crotone
Juve Stabia
Lecce
Trapani
Lazio
Napoli
Nuova
Ascoli
Venezia
Udinese
Frosinone
SPAL
Hellas
Pescara
Pordenone
Torino
Juventus
Chievo
Atalanta
Roma
Cagliari
Inter
Fiorentina
Juventus Sub 19
Inter Sub 19
Roma Sub 19
Fiorentina Sub 19
Milan Sub 19
Atalanta Sub 19
Empoli Sub 19
Torino Sub 19
Genoa Sub 19
Lazio Sub 19
Napoli Sub 19
Sampdoria Sub 19
Parma Sub 19
Sassuolo Sub 19
Udinese Sub 19
Bologna Sub 19
Cagliari Sub 19
Spezia Sub 19
Hellas Verona Sub 19
Chievo Verona Sub 19
Ascoli Sub 19
Brescia Sub 19
Pescara Sub 19
Crotone Sub 19
Virtus Entella Sub 19
Frosinone Sub 19
Lecce Sub 19
Cittadella Sub 19
Livorno Sub 19
Perugia Sub 19
Benevento Sub 19
Salernitana Sub 19
SPAL Sub 19
Pisa SC Sub 19
Venezia Sub 19
Cremonese Sub 19
Nuova Cosenza Sub 19
Juve Stabia Sub 19
Trapani Sub 19
Pordenone Sub 19