Skip to content

Instantly share code, notes, and snippets.

@hanssens

hanssens/NopCommerce.TopUsedManufacturers.sql

Created January 24, 2012 12:22
Show Gist options
  • Save hanssens/1669974 to your computer and use it in GitHub Desktop.
Save hanssens/1669974 to your computer and use it in GitHub Desktop.
Download ZIP
[SQL] Nopcommerce - Top used Manufacturers
Raw
NopCommerce.TopUsedManufacturers.sql
-- Nopcommerce - Top used Manufacturers
-- Must remember to implement a storedproc or something ;)
select COUNT(*) as Aantal, ManufacturerId
from Product_Manufacturer_Mapping
group by ManufacturerId
order by Aantal desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment