"Thorsten Froehlich" <tho### [at] trf de>
> > 2. In the list of countris in community section number of povers in each
> > country could be displayed directly with name of country instead of on embeded
> > page to decrease number of generated pages. Sorting according to number of
> > povers in country could be possible.
>
> I know. We are using mySQL as database, and unfortunately it doe not
> support subselects. Performing a separate request via the script for each
> country would add too much load, so until mySQL finally gains subselect
> capability or I manage to invent another quick way of collecting these
> statistics (I have a few workarounds like updating the numbers only once per
> day) there won't be any.
select
country_id,
count(country_id) as nr
from pov_world_users
order by nr
group by country_id;
??
Post a reply to this message
|