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=166 AND p.public=1 AND p.id IN (322,323,324,326,327,329,330,331,332,333,335,336,337,2634,2635,2639,30642,30643) GROUP BY p.id 
				  ORDER BY k2p.position
				  LIMIT 12
				  OFFSET -24