Dotaz:
SELECT SQL_CALC_FOUND_ROWS P.id, PL.name, PL.uri, P.vat, P.category_id, HL.uri AS category_uri, P.status_2, P.status_3, P.status_4, P.status_9, P.status_10, P.size, PL.description, PL.description2, P.total_stock_quantity
FROM product P
INNER JOIN product_lang PL ON PL.product_id = P.id
INNER JOIN htree H ON H.id = P.category_id
INNER JOIN htree_lang HL ON HL.category_id = H.id
LEFT JOIN product_multicategory PM ON P.id = PM.product_id
WHERE P.category_id NOT IN (0) AND H.active = 1 AND P.active = 1 AND P.deleted = 0 AND PL.forbidden = 0 AND PL.shop_id = 2 AND HL.forbidden = 0 AND HL.shop_id = 2 AND P.id IN (31929,31944,31955,31958,31959,31971,31976,31977,31978,31981,31982,31982,31983,31983,31984,31984,31985,31985,31986,31986,31987,31988,31989,31990,31991,31992,31993,31994,31994,31995,31996,31997,31998,31998,31999,32000,32001,32001,32002,32002,32003,32003,32004,32004,32005,32006,32007,32007,36269,36270,36270,36270,36271,36361,42928,42929,42930,42931,42932,42933,44153,44153,44153,44153,44154,44154,44154,44154,44155,44155,44155,44155,44156,44156,44156,44156,44157,44157,44157,44157,44347,44347,44347,44347,44352,44352,44352,44352)
GROUP BY P.id
ORDER BY
P.status_9,
P.total_stock_quantity DESC
LIMIT -252, 28
Chyba: 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 '-252, 28' at line 13