Code:
select
p.client_id,
p.skill,
p.ratio,
c.name,
c.group_bits
from xlr_playerstats p
inner join clients c on p.client_id = c.id
where group_bits >= 16
order by skill desc;
takes 0.062 seconds for the machine to answer it.
even better then yuna
Attachment:
dswp_skill1.png
Attachment:
dswp_skill2.png
btw this is offtopic?