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