| 0.0105 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=470 ORDER BY order_id ASC |
| 0.0106 | SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2016 AS c WHERE c.league_id='17854' ORDER BY c.id ASC |
| 0.0106 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:03:56' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0106 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:03:56' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0107 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 22:03:56' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0108 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 22:03:56' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0114 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2016 e ON e.player_id = p.id AND e.league_id = 17854 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17854 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 LIMIT 10 |
| 0.0118 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2016 e ON e.player_id = p.id AND e.league_id = 17854 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17854 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10 |
| 0.0107 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2016 e ON e.player_id = p.id AND e.league_id = 17854 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17854 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10 |
| 0.0222 | SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016_base` as t
INNER JOIN teams as team ON team.id = t.team
INNER JOIN datateams as dt ON team.teamId = dt.id
WHERE t.league_id = 17854
AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC |
Sevilla Sub 12
AD San José Sub 12
CD Antonio Puerta Sub 12
La Liara Sub 12
Montequinto Sub 12
Real Betis Sub 12
Coria Sub 12
El Pilar
Sededos
Utrera Sub 12
Asociación Nervion Sub 12 B
Betisevilla
CD Alcala
C.D. BORMUJOS S.M.
Tomares
Lora C.F