<% categories = Product.listable.joins(:category).select("categories.id, name, count(products.id) as product_count").group("categories.id, name").order("name") %>

• All products <%=Product.listable.count%>
<% categories.each do |cat| %> <%# annoying bootstrap wants the badge within the anchor tag. %>
• <%=cat.name%> <%=cat.product_count%>
<% end %>