SELECT DISTINCT
  PR.ProductCategory
FROM 
  taClientBranchProducts AS BP
    LEFT JOIN taClientBranches AS CB ON (CB.ClientBranchID = BP.ClientBranchID)
    LEFT JOIN taClientProducts AS CP ON (CP.ClientProductID = BP.ClientProductID)
    LEFT JOIN taClients AS CS ON (CS.ClientID = CB.ClientID)
    LEFT JOIN taProducts AS PR ON (PR.ProductID = CP.ProductID)
WHERE
  (CS.ClientStatus = 1) AND
  (CB.BranchStatus = 1) AND
  (CP.Status = 1) AND
  (BP.Status = 1)
ORDER BY 
  PR.ProductCategory
