<b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>735</b><b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>749</b><b>Warning</b>: Undefined array key "text" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/controller/product/category.php</b> on line <b>124</b><b>Warning</b>: Undefined array key "text" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/controller/product/category.php</b> on line <b>145</b><b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>735</b><b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>749</b><b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>735</b><b>Warning</b>: Undefined array key "attr_name" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>749</b><b>Warning</b>: Undefined array key "attribute_id" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>547</b><b>Warning</b>: Undefined array key "value" in <b>/var/www/u1797524/data/www/san-master.ru/catalog/model/catalog/category.php</b> on line <b>549</b><b>Exception</b>: Error: 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 pa.text = afv.attribute_value
        where pth.path_id = 48
          and p' at line 22<br/>Error No: 1064<br/>
        select distinct
            oad.attribute_id attr_id,
            af.name attr_filter_name,
            oad.name as attr_name,
            afv.value as attr_filter_val,
            pa.text as attr_val,
            af.sort_order as filter_order,
            afv.sort_order as filter_value_order,
            af.is_list,
            af.is_checkbox
        from oc_product p
                 inner join oc_product_to_category ptc on ptc.product_id = p.product_id
                 inner join oc_category_path pth ON pth.category_id = ptc.category_id
                 inner join oc_category cat on cat.category_id = pth.path_id
                 inner join oc_attribute_filter af on af.category_id = cat.category_id
                 inner join oc_attribute_filter_value afv on af.attribute_filter_id = afv.attribute_filter_id
                 inner join oc_attribute at on at.attribute_id = af.attribute_id
                 inner join oc_attribute_description oad on at.attribute_id = oad.attribute_id
                 inner join oc_product_attribute pa on pa.product_id = p.product_id
                    and pa.attribute_id = at.attribute_id
                    INNER JOIN oc_product_attribute fast_pr_attr on fast_pr_attr.product_id = p.product_id and fast_pr_attr.attribute_id =
                    and pa.text = afv.attribute_value
        where pth.path_id = 48
          and p.price > 0 AND fast_pr_attr.text = '' AND oad.attribute_id = 88
        order by af.sort_order, afv.sort_order, afv.value
 in <b>/var/www/u1797524/data/www/san-master.ru/system/library/db/mysqli.php</b> on line <b>48</b>