[ХАК] Вывод подкатегорий в категории, если в ней есть товары

if ($result != false) {

if (isset($current_category_id) && $current_category_id != '0')
{
    $group_check = (GROUP_CHECK == 'true') ? " AND c.group_permission_".$_SESSION['customers_status']['customers_status_id']." = 1 " : '';

    $categories_query = "
    SELECT
        cd.categories_description, c.categories_id, cd.categories_name, cd.categories_heading_title, c.categories_image, c.parent_id
    FROM
        ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd
    WHERE
        c.categories_status = '1' AND c.parent_id = '".$current_category_id."' AND c.categories_id = cd.categories_id ".$group_check." AND cd.language_id = '".(int)$_SESSION['languages_id']."'
    ORDER BY
        sort_order, cd.categories_name
    ";

    $categories_query = osDBquery($categories_query);

    while ($categories = os_db_fetch_array($categories_query, true))
    {
        $image = '';
        if ($categories['categories_image'] != '' && is_file( dir_path('images').'categories/'.$categories['categories_image']))
            $image = http_path('images').'categories/'.$categories['categories_image'];
        else
            $image = http_path('images').'product_images/noimage.gif';

        $categories_content[] = array (
            'CATEGORIES_NAME' => $categories['categories_name'],
            'CATEGORIES_HEADING_TITLE' => $categories['categories_heading_title'],
            'CATEGORIES_IMAGE' => $image,
            'CATEGORIES_LINK' => os_href_link(FILENAME_DEFAULT, os_category_link($categories['categories_id'], $categories['categories_name'])),
            'CATEGORIES_DESCRIPTION' => $categories['categories_description']
        );
    }

    $module->assign('cat_content', $categories_content);
}

{if $CATEGORIES_NAME}
    {if $cat_content}
    {foreach name=aussen item=module_data from=$cat_content}
    <div class="main-category-item">
        {if $module_data.CATEGORIES_IMAGE}
            <a href="{$module_data.CATEGORIES_LINK}"><img src="{$module_data.CATEGORIES_IMAGE}" alt="{$module_data.CATEGORIES_NAME}" /></a>
        {/if}
        <div class="cat-list-desc">
            <a href="{$module_data.CATEGORIES_LINK}">{$module_data.CATEGORIES_NAME}</a><br />
            {$module_data.CATEGORIES_DESCRIPTION}
        </div>
    </div>
    {/foreach}
    {/if}
{/if}