| 0.0019 | SELECT type FROM routes WHERE alias = 'copa_kazajistan2013' |
| 0.0043 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_kazajistan' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0019 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1698 AND type_rel = 3 |
| 0.0020 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1698 ORDER BY order_id ASC |
| 0.0024 | 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 = 23123 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0024 | 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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 23123 ORDER BY round ASC |
| 0.0019 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:03:43' 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-04-27 23:03:43' 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-04-27 23:03:43' 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-04-27 23:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0028 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1698 AND l.year = 2013 |
| 0.0022 | SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (23123) 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.0024 | 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 (23123) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (371602,451466,144129,185724,196286,229860,295069,821424,45424,62606) ORDER BY rp.in_squad = 1 DESC |
| 0.0026 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1698 AND l.year = 2013 |
| 0.0022 | SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (23123) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0035 | 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 (23123) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (296526,65188,144134,155809,226660,227537,233207,274000,287287,288479) ORDER BY rp.in_squad = 1 DESC |
| 0.0024 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1698 AND l.year = 2013 |
| 0.0020 | SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (23123) AND (e.action = 3 or e.action = 4) 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 (23123) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (65188) ORDER BY rp.in_squad = 1 DESC |
Kaspiy
Gefest
Ak-Bulak
CSKA Almaty
Spartak
Kaysar
Astana-1964
Tobol
Ili-Saulet
AEPB Roche
Ordabasy
Kyzylzhar
Taraz
Kyran
Zhetysu
Okzhetpes
Kairat
Zhetysu
Ekibastuzet
Bayterek
Aktobe Jas
Bolat
Atyrau
Biik
Shakhter
Lashyn
Akzhayik
Irtysh
Bulat-AMT
FC Aktobe
Astana
Vostok
Kairat Almaty
Astana
Tobol Kostanay
FC Aktobe
Shakhter Karagandy
Ordabasy
Taraz
Kaysar Kyzylorda
Zhetysu Taldykorgan
Atyrau
FC Kyzylzhar
Okzhetpes Kokshetau
Akzhayik
Kaspiy Aktau
Vostok
Ekibastuzets
Spartak Semey
FC Astana-1964
Kyran Shymkent
Aktobe Jas
Bulat-AMT
CSKA Almaty
Zhetysu - Sunkar
Bolat Temirtau
Irtysh Pavlodar
Ili-Saulet
Gefest Qaraghandi
Ak-Bulak Talgar
Bayterek Astana
FK Biik Shymkent
FK Mahtaaral
Lashyn Karatau