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 '-24' at line 9 - SELECT p.name as name,p.code,p.short as short,p.teaser as teaser,p.description as description,p.id,p.public as public,hydro,
		p.seo_title as seo_title,p.seo_keywords as seo_keywords,p.seo_description as seo_description, p.imgtitles 		
				  FROM shop_product p 
				  LEFT JOIN shop_product_feature_to_product  spfp ON p.id = spfp.product_id
				  JOIN shop_product_to_category k2p ON k2p.product_id = p.id
				  WHERE k2p.category_id=311 AND p.public=1 AND p.id IN (30789,30790,30791,30792,30793,30794,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823) GROUP BY p.id 
				  ORDER BY k2p.position
				  LIMIT 12
				  OFFSET -24