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=41 AND p.public=1 AND p.id IN (2390,2393,2394,2395,2396,2398,2399,2400,2406,2410,30629,30630,30631) GROUP BY p.id 
				  ORDER BY k2p.position
				  LIMIT 12
				  OFFSET -24