SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, pt.slug, p.price, i.image, p.ref_num, pt.meta_description, p.promo, p.price_promo, p.created_at,
          			pt.price as actual_price, pub.name as publisher, p.new, p.top, p.action, p.soon, p.promo
          	     FROM products p
          	     INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
          	     INNER JOIN product_categories pc ON p.id = pc.product_id AND pc.relation_id IN (  )
          	     LEFT JOIN products_images i ON p.id = i.page_id
          	     LEFT JOIN pages_text pub ON p.publisher_id = pub.page_id AND pub.language_id = 1
          	     WHERE 1
          	     AND p.status != 'deleted'
          	     GROUP BY p.id
          	     ORDER BY p.id
                 LIMIT 12
	     
      	    

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
          	     LEFT JOIN products_images i ON p.id = i.page_id
          	   ' at line 5

file -
line -