-
SELECT DISTINCT(P.productID) AS productID,PC.productID,PC.categoryID,P.productTitle,P.seoUri,P.synopsis,P.productDescription,P.productThum,P.productImg,P.productPrice,P.isSpecial,P.discountedPrice,P.stockAvailable FROM mx_product AS P INNER JOIN mx_product_category AS PC ON P.productID=PC.productID WHERE PC.categoryID=41 AND P.status=1 GROUP BY P.productID ORDER BY P.dateAdded DESC LIMIT -12,20
SELECT DISTINCT(P.productID) AS productID,PC.productID,PC.categoryID,P.productTitle,P.seoUri,P.synopsis,P.productDescription,P.productThum,P.productImg,P.productPrice,P.isSpecial,P.discountedPrice,P.stockAvailable FROM mx_product AS P INNER JOIN mx_product_category AS PC ON P.productID=PC.productID WHERE PC.categoryID=41 AND P.status=1 GROUP BY P.productID ORDER BY P.dateAdded DESC LIMIT -12,20
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 '-12,20' at line 1