How many products in a specific category?

This maybe not the most efficient way but I have that working. <cfloop query="ShowCategories"> <cfquery name="getProducts" datasource="#request.DSN#">                    SELECT             *                   FROM                products                   WHERE  categoryID = #ShowCategories.categoryID#                 </cfquery>