Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY reduction DESC, p.price ASC, LCASE(pd.name) ASC LIMIT 36, 12' at line 53<br />Error No: 1064<br />
SELECT
p.product_id,
(
SELECT AVG(rating) total
FROM `oc_review` r1
WHERE
r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) rating,
(
SELECT price
FROM `oc_product_discount` pd2
WHERE
pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
) discount,
(
SELECT price
FROM `oc_product_special` ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) special,
(
SELECT (1 - price/p.price)
FROM `oc_product_special` ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = '0'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) reduction,
p.viewed as `p.viewed`,
if (p.quantity, 1, 0) in_stock
FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.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 pd.language_id = '1'
AND p2c.category_id = '150' GROUP BY p.product_id ORDER BY ORDER BY reduction DESC, p.price ASC, LCASE(pd.name) ASC LIMIT 36, 12 in /home/rockut2/storage/modification/system/library/db/mysqli.php:52
Stack trace:
#0 /home/rockut2/storage/modification/system/library/db.php(55): DB\MySQLi->query('\n\t\t\t\tSELECT \n\t\t...')
#1 /home/rockut2/storage/modification/catalog/model/journal3/filter.php(973): DB->query('\n\t\t\t\tSELECT \n\t\t...')
#2 /home/rockut2/storage/modification/system/engine/loader.php(248): ModelJournal3Filter->getProducts(Array)
#3 /home/rockut2/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/rockut2/public_html/catalog/controller/journal3/event/products.php(46): Proxy->__call('getProducts', Array)
#5 /home/rockut2/storage/modification/system/engine/action.php(79): ControllerJournal3EventProducts->model_catalog_product_getProducts_after('catalog/product...', Array, Array)
#6 /home/rockut2/public_html/system/engine/event.php(62): Action->execute(Object(Registry), Array)
#7 /home/rockut2/storage/modification/system/engine/loader.php(255): Event->trigger('model/catalog/p...', Array)
#8 /home/rockut2/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#9 /home/rockut2/storage/modification/catalog/controller/product/category.php(169): Proxy->__call('getProducts', Array)
#10 /home/rockut2/storage/modification/system/engine/action.php(79): ControllerProductCategory->index()
#11 /home/rockut2/public_html/catalog/controller/startup/router.php(25): Action->execute(Object(Registry))
#12 /home/rockut2/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index()
#13 /home/rockut2/storage/modification/system/engine/router.php(77): Action->execute(Object(Registry))
#14 /home/rockut2/storage/modification/system/engine/router.php(66): Router->execute(Object(Action))
#15 /home/rockut2/public_html/system/framework.php(169): Router->dispatch(Object(Action), Object(Action))
#16 /home/rockut2/public_html/system/startup.php(104): require_once('/home/rockut2/p...')
#17 /home/rockut2/public_html/index.php(19): start('catalog')
#18 {main}
thrown in /home/rockut2/storage/modification/system/library/db/mysqli.php on line 52