RE: Query question

[Ed Lazor]

Thanks, Shawn.  I didn't think count would just limit to the items being
grouped - very handy =) 

-Ed

> SELECT URL, count(1) as popularity
> FROM yourtablename
> GROUP BY URL
> ORDER BY popularity DESC
> LIMIT 50;