Hi everyone. I have a little problem with products in subcategories. I will try to explain you.
For example I have main category with subcategories.
Main category
- Subcat 1
- Subcat 2
- Subcat 3
And when I click on “ main category” it shows tabs with subcategories.
I found this addon:
https://www.zen-cart.com/attachment....6&d=1357113131
And now when I click on “main category” it shows all products from subcategories, but doesn`t show subcategories tabs.

That what I want is to show subcategories tabs above and products from this subcategories below.
I think that part of code is the key:

if(!empty($sub_cats))
$categories_products_query = "SELECT count(*) AS total
FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "
WHERE categories_id IN ($sub_cats)";
else
// eof all_sub_cats_products
$categories_products_query = "SELECT count(*) AS total
FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "
WHERE categories_id = :categoriesID";

This code is in - includes/modules/pages/index/header_php. (line from 22 to 30)

I use ZC 1.5.0
Thanks!