[BNM] mysql grouping and ordering and limiting

[Ali]

Hi

 

Hopefully this is a quickie for someone, my first efforts are duds and
googling is a pain...

 

$q="select authorId, count(*) FROM blog WHERE 1 GROUP authorId";

 

Now I want to limit to, say 10 authors and order by count(*) descending -
can anyone indulge me with the syntax?

 

Ali