Просмотр рубрики (показывать записи подрубрик)

 
            //get items SQL
            if (!isset($findsql)){
                $sql = "SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, i.price as price
                        FROM cms_uc_items i
                        LEFT JOIN cms_uc_ratings r ON r.item_id = i.id
                        WHERE i.published = 1 AND i.category_id = $id
                        GROUP BY i.id";
 

 
            if (!isset($findsql)){
    $sql = "SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, c.view_type as viewtype, i.price as price
            FROM cms_uc_items i
            LEFT JOIN cms_uc_cats c ON c.id = i.category_id
            LEFT JOIN cms_uc_ratings r ON r.item_id = i.id
            WHERE i.published = 1 AND (c.NSLeft >= {$cat['NSLeft']} AND c.NSRight <= {$cat['NSRight']})
            GROUP BY i.id  ";