Error Layout: Ошибка БД: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))  AND b.`brand` IS NOT NULL AND b.`brand`!=''  ORDER BY `brand`' at line 21 [SQL: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =690 ] [Params: Array
(
    [sql] => SELECT

        DISTINCT      
        b.`brand`,
        b.id   `id`    
        FROM `catalog` c
            LEFT JOIN `brands` b ON c.`brand_id`=b.`id`
        WHERE ((SELECT
            COUNT(*) cnt
        FROM `catalog_avail` cda
        WHERE cda.`date_in` !='' AND cda.`date_in` IS NOT NULL AND  cda.`id_good`=c.`id` AND cda.`id_shop` IN (SELECT `id` FROM `catalog_shops` WHERE 1=1 AND `is_opt`=1 ))>0 
        OR (
        
            (SELECT p_vl.`price` price_vl FROM `catalog_price` p_vl WHERE c.`id`=p_vl.`id_good` AND p_vl.`id_discount_group`=5)>0 
    
        OR 
        
        (SELECT p_krs.`price` price_krs FROM `catalog_price` p_krs WHERE c.`id`=p_krs.`id_good` AND p_krs.`id_discount_group`=14)>0
        
        
        )) AND c.`is_delete`=0 AND ( c.`is_sale`=1 OR  c.`id_group` IN (SELECT `id` FROM `catalog_groups` WHERE `is_sale`=1))   AND  ( c.`id_group` IN (690)  OR c.`id_group` IN ())  AND b.`brand` IS NOT NULL AND b.`brand`!=''  ORDER BY `brand`
)
]