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_en as name,p.code,p.short_en as short,p.teaser_en as teaser,p.description_en as description,p.id,p.public_en as public,hydro,
		p.seo_title_en as seo_title,p.seo_keywords_en as seo_keywords,p.seo_description_en 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=56 AND p.public_en=1 AND p.id IN (30679,30680,30681,30682,30683,30684,30685,30686,30687,30688,30689,30690,30712,30713,30714,30715) GROUP BY p.id 
				  ORDER BY k2p.position
				  LIMIT 12
				  OFFSET -24