Fatal error: Uncaught Exception: 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 '(PARTITION BY p.model ORDER BY p.sort_order DESC) AS rownum, p.product_id, p.sor' at line 1<br />Error No: 1064<br />SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY p.model ORDER BY p.sort_order DESC) AS rownum, p.product_id, p.sort_order, p.model, pd.name, p.quantity, p.price, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-07-11 15:36:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-07-11 15:36:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id  AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-11 15:36:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-11 15:36:00')) ORDER BY ps.priority ASC, ps.pri in /home/d/dmironuv/alba-s.ru/public_html/system/library/db/mysqli.php on line 45