| 0.0018 | SELECT type FROM routes WHERE alias = 'liga_campeones_caf2007' |
| 0.0042 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_campeones_caf' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1508 AND type_rel = 3 |
| 0.0022 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1508 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0021 | 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 (1294603,1261193,1261058,1249805,1249793) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0018 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1508 ORDER BY order_id ASC |
| 0.0020 | SELECT
max(l.year) as max_year, min(l.year) as min_year
FROM leagues l WHERE categoryID = 1508
GROUP BY l.categoryId |
| 0.0019 | 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=1508 GROUP BY l.year ORDER BY l.year DESC |
| 0.0023 | 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 = 12269 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0029 | 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 calendars2007 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 12269 ORDER BY round ASC |
| 0.0018 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 19:51:08' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0019 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 19:51:08' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0019 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 19:51:08' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0018 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 19:51:08' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0021 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2007 |
| 0.0025 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (12271,12269,12270) 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.0028 | 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 (12271,12269,12270) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (43383,538834,125047,541824,139020,403782,2985,20844,187587,360562) ORDER BY rp.in_squad = 1 DESC |
| 0.0021 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2007 |
| 0.0025 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (12271,12269,12270) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0023 | 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 (12271,12269,12270) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2985,20844,43383,81160,123929,125047,187687,360585,381213,405306) ORDER BY rp.in_squad = 1 DESC |
| 0.0022 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2007 |
| 0.0025 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (12271,12269,12270) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0025 | 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 (12271,12269,12270) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (34555,162032,162185,360585,403751,404706,404918,818370) ORDER BY rp.in_squad = 1 DESC |
Mogas 90
Renaissance
Balantas
Highlanders
Pamplemouss
Royal
Faso/Yennen
Diaraf
Saint-Eloi
APR FC
USM Alger
Petro
Civics FC
ASGNN
Zamalek
Vital'O
AS Polisi
Fello Star
Sporting
Canon
Mauritel
Stade
Douanes
Ocean Boys
FC Kallon
Likhopo
Zanaco
Renacimient
Ashanti
Police XI
AS Adema
Anse
Primeiro
Mangasport
Uganda
Séwé
Mighty
Asante
Gambia
Desportivo
Kedus
ES Tunis
Young
Mamelodi
Al-Ahly
Nasarawa
Al-Hilal
Maranatha
Etoile
Étoile
Ittihad
ASEC
Wydad
TP Mazembe
FAR Rabat
Cotonsport
JS Kabylie
Al-Ahly
Mamelodi Sundowns
Wydad Casablanca
ES Tunis
Etoile Sahel
Zamalek
FAR Rabat
TP Mazembe
Al-Hilal Omdurman
JS Kabylie
USM Alger
ASEC Mimosas
Cotonsport
Stade Malien
AS Faso/Yennenga
Primeiro de Agosto
Asante Kotoko
Kedus St George
Zanaco
APR FC
Royal Leopards
Uganda Revenue Authority
Saint-Eloi Lupopo
Canon Yaoundé
Al Ittihad Tripoli
Mangasport
Vital'O
Ashanti Gold
ASGNN
Anse Reunion
AS Adema
Étoile Du Congo
Gambia Ports Authority FC
Nasarawa United
Sporting Praia
Petro Atletico
AS des Douanes
Séwé
Highlanders
Pamplemousses
Fello Star
Civics FC
FC Kallon
Maranatha
Desportivo Maputo
Likhopo
Police XI
Mighty Barolle
AS Polisi
Mogas 90