-- Total Products by Category
-- Description Total Products broken down by category for a specific location
-- FILTER: {
--   filter: "class",
--   column: "total",
--   params: {
--     class: "text-right"
--   }
-- 

SELECT DISTINCT dc.first_global_brand_category_id,
  (SELECT ddc.name from simplebrsprod.deal_dealcategory ddc WHERE ddc.id = dc.first_global_brand_category_id)
FROM simplebrsprod.deal_cartitem dc
WHERE dc.location_id = 5358688477118464;