| 0.0124 | SELECT type FROM routes WHERE alias = 'coppa_italia1992' |
| 0.0253 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'coppa_italia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0125 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=296 AND type_rel = 3 |
| 0.0133 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 296 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0127 | 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 (1312313,1312243,1312248,1312066,1310874) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0125 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=296 ORDER BY order_id ASC |
| 0.0128 | 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 = 22656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0131 | 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 calendars1992 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 22656 ORDER BY round ASC |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 04:07:58' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 04:07:58' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 04:07:58' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 04:07:58' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0128 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 296 AND l.year = 1992 |
| 0.0137 | SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (22656) 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.0133 | 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 (22656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265014,10459,257235,264650,264973,265970,323971,382511,264639,264986) ORDER BY rp.in_squad = 1 DESC |
| 0.0128 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 296 AND l.year = 1992 |
| 0.0139 | SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (22656) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0130 | 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 (22656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (264918,266561,323966,1020,9757,10220,257232,264650,264982,265154) ORDER BY rp.in_squad = 1 DESC |
| 0.0126 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 296 AND l.year = 1992 |
| 0.0135 | SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (22656) AND (e.action = 3 or e.action = 4) 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 (22656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (10158,10177,258287,264646,265285,265291,265296,265306,265346,265365) ORDER BY rp.in_squad = 1 DESC |
Modena
Piacenza
Empoli
Lucchese
Venezia
Cesena
Perugia
Messina
Palermo FC
AC Monza
Taranto
Reggina
Brescia
Pescara
Virtus
Lecce
Ancona
Barletta
Bologna
Fidelis
Padova
Salernitana
Udinese
Triestina
Cagliari
Avellino
Casertana
Cosenza
Reggiana
Ascoli
Calcio
Cremonese
Roma
Napoli
Pisa SC
Genoa
Sampdoria
SSC Bari
Parma
Fiorentina
Hellas
Milan
Torino
Lazio
Atalanta
Juventus
Inter
Como
Fiorentina
Inter
Juventus
Lazio
Milan
Napoli
Roma
Torino
Sampdoria
Atalanta
Bologna
Hellas Verona
Brescia
Genoa
SSC Bari
Palermo FC
Parma
Cagliari
Udinese
AC Monza
Modena
Padova
Pescara
Pisa SC
Perugia
Cesena
Como
Reggiana
Calcio Foggia
Triestina
Lecce
Venezia
Cremonese
Taranto
Ascoli
Avellino
Salernitana
Empoli
Lucchese Libertas
Piacenza
ACR Messina
Reggina
Ancona
Casertana
Cosenza Calcio
Fidelis Andria
Barletta
Virtus Casarano