Проблема не работает JoomShopping Smart Filter

Купил модуль, установил, и сразу же столкнулся с проблемой при фильтрации

Код (CODE):

1. HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR 'ORDER BY QFLAG DESC, NAME ASC LIMIT 0, 50' AT LINE 21 SQL=SELECT SQL_CALC_FOUND_ROWS PROD.PRODUCT_ID, PR_CAT.CATEGORY_ID, PROD.`NAME_RU-RU` AS NAME, PROD.`SHORT_DESCRIPTION_RU-RU` AS SHORT_DESCRIPTION, PROD.PRODUCT_EAN, PROD.IMAGE, PROD.PRODUCT_PRICE, PROD.CURRENCY_ID, PROD.PRODUCT_TAX_ID AS TAX_ID, PROD.PRODUCT_OLD_PRICE, PROD.PRODUCT_WEIGHT, PROD.AVERAGE_RATING, PROD.REVIEWS_COUNT, PROD.HITS, PROD.WEIGHT_VOLUME_UNITS, PROD.BASIC_PRICE_UNIT_ID, PROD.LABEL_ID, PROD.PRODUCT_MANUFACTURER_ID, PROD.MIN_PRICE, PROD.PRODUCT_QUANTITY, PROD.DIFFERENT_PRICES, PROD.UNLIMITED, IF(PROD.PRODUCT_QUANTITY>0,1,0) AS QFLAG, PROD.`PRODUCT_PRICE` AS PR, CR.`CURRENCY_VALUE` AS CURR, PROD.`PRODUCT_PRICE` / CR.`CURRENCY_VALUE` AS PRICE FROM `#__JSHOPPING_PRODUCTS` AS PROD LEFT JOIN `#__JSHOPPING_PRODUCTS_TO_CATEGORIES` AS PR_CAT ON PR_CAT.`PRODUCT_ID` = PROD.`PRODUCT_ID` LEFT JOIN `#__JSHOPPING_CATEGORIES` AS CAT ON PR_CAT.`CATEGORY_ID` = CAT.`CATEGORY_ID` LEFT JOIN `#__JSHOPPING_MANUFACTURERS` AS MNF ON ( PROD.`PRODUCT_MANUFACTURER_ID` = MNF.`MANUFACTURER_ID` ) LEFT JOIN `#__JSHOPPING_CURRENCIES` AS CR ON ( PROD.`CURRENCY_ID` = CR.`CURRENCY_ID` ) WHERE PROD.`PRODUCT_PUBLISH` = 1 AND PROD.PRODUCT_ID IN ( 1722,4,5,8,10,217,6,7,9,11,2120,2119,2141) AND PROD.ACCESS IN (1,1,5) AND CAT.ACCESS IN (1,1,5) GROUP BY PROD.`PRODUCT_ID` ORDER BY ORDER BY QFLAG DESC, NAME ASC LIMIT 0, 50

техподдержка игнорит, форум уже не работает, кто-нибудь сталкивался с такой ошибкой? как ее исправить?

версия джумлы последняя, php 5.6, mysql 5.5.54