subcategory now using joins