| 0.0125 | SELECT type FROM routes WHERE alias = 'copa_austria2012' |
| 0.0258 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_austria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0126 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1562 ORDER BY order_id ASC |
| 0.0132 | 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 = 20740 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0149 | 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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20740 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-01 13:42:09' 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=2 AND last_update > '2024-05-01 13:42:09' 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-01 13:42:09' 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-01 13:42:09' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0147 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1562 AND l.year = 2012 |
| 0.0137 | SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (20740) 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.0129 | 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 (20740) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (109080,67350,5419,61564,488862,3763,5429,29691,47020,5317) ORDER BY rp.in_squad = 1 DESC |
| 0.0129 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1562 AND l.year = 2012 |
| 0.0131 | SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (20740) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0128 | 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 (20740) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (13713,15171,68033,86682,214719,557510,585829,1727,5344,5396) ORDER BY rp.in_squad = 1 DESC |
| 0.0131 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1562 AND l.year = 2012 |
| 0.0126 | SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (20740) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0128 | 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 (20740) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (15131,15134,29872,46775,199419,214719,216362,216405,216514,288385) ORDER BY rp.in_squad = 1 DESC |
Baumgarten
Admira
Gratkorn
SC Retz
Austria
LASK Linz
Stinatz
Grödig II
Brunn
Kapfenberge
SCR Altach
Vorwarts
SW Bregenz
Neumarkt
Sollenau
Austria
Grieskirche
Kagran
WSG Tirol
Schwaz
Wiener SC
Vöcklamark
Donau Linz
Kundl
Leoben
Sturm Graz
Post Wien
ATSV
Polten
Stegersbach
Wiener
First
Union
Blau-Weiß
Parndorf
Admira
Austria
LASK
Götzendorf
SV Ried
SV Villach
Hartberg
Amstetten
Lustenau
Vöslau
Rapid Wien
Klagenfurt
Salzburg
Reichenau
Kapfenberge
Weiz
Sturm Graz
Juniors
Mattersburg
Allerheilig
Austria
Margarethen
Wacker
Dornbirn
Grödig
Rapid Wien
Sankt
Union
Austria
Austria Wien
Rapid Wien
Salzburg
Sturm Graz
Wiener SC
First Vienna
Admira
LASK
SV Ried
Leoben
Kapfenberger SV
WSG Tirol
Vorwarts Steyr
Blau-Weiß Linz
Austria Lustenau
SW Bregenz
SCR Altach
TSV Hartberg
Wacker Innsbruck
SKN St. Polten
Mattersburg
Dornbirn
Wiener Neustadt
Grödig
Parndorf
Austria Salzburg
SAK Klagenfurt
Schwaz
Allerheiligen
Austria Klagenfurt
SKU Amstetten
Austria Wien II
Reichenau
Vöcklamarkt
Union St. Florian
Weiz
Sturm Graz II
SC Retz
ATSV Wolfsberg
FC Lustenau
Kundl
Gratkorn
Rapid Wien II
Admira Wacker II
St. Margarethen
TSV Neumarkt
Donau Linz
SV Stegersbach
Grieskirchen
RB Juniors Salzburg