SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.slug, p.price,p.publisher_id,
			-- i.image, 
			p.ref_num, p.promo, p.price_promo, p.created_at, pt.meta_description, p.new, 
			pub.name as publisher, p.top, p.action, p.soon, p.promo, 
			pt.price as actual_price, p.most_sold, pt.piece_price

	     FROM products p
	     INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
	     
	     INNER JOIN products_params pp ON pp.product_id = p.id
	     LEFT JOIN pages_text pub ON p.publisher_id = pub.page_id AND pub.language_id = 1
	     
	     WHERE p.status != 'deleted'
	    
	     
	     
	     
	     
	     
	     
	      AND ( p.new = 'yes' ) 
	     
	     
	     
	     
	     
	     
	     -- 
      
	     
	    
	     GROUP BY p.id
	     ORDER BY pc.order_id
	     LIMIT 18 OFFSET 0
	    

Unknown column 'pc.order_id' in 'order clause'

file -
line -