select brand,  count(*) from part_urls 
group by brand order by count desc