Fatal error: Uncaught exception 'ErrorException' with message 'Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'osotov_lfr.m.sort_order' which is not in SELECT list; this is incompatible with DISTINCT<br />Error No: 3065<br />SELECT DISTINCT m.`manufacturer_id`, m.`name` FROM `oc_manufacturer` m LEFT JOIN oc_product p ON(p.manufacturer_id=m.`manufacturer_id`) LEFT JOIN oc_product_to_category p2c ON(p.product_id=p2c.product_id) LEFT JOIN oc_product_to_store p2s ON(p.product_id=p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = 0 AND p2c.category_id = '60' ORDER BY m.sort_order, m.name' in /home/osotov/web/lekarstvafarma.ru/public_html/system/database/mysqli.php:40 Stack trace: #0 /home/osotov/web/lekarstvafarma.ru/public_html/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SELECT DISTINCT...') #1 /home/osotov/web/lekarstvafarma.ru/public_html/catalog/model/module/filterpro.php(122): DB->query('SELECT DISTINCT...') #2 /home/osotov/web/lekar in /home/osotov/web/lekarstvafarma.ru/public_html/system/database/mysqli.php on line 40