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=39 AND p.public=1 AND p.id IN (2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2360,2361,2362,2363,2364,2365,2430,30625) GROUP BY p.id 
				  ORDER BY k2p.position
				  LIMIT 12
				  OFFSET -24