SELECT p.product_id, p.image, p.model, p.sku, p.mpn, 
				p.price,  p.date_available, p.weight, p.weight_class_id, p.length, p.minimum, p.width, p.height, 
				p.sort_order, p.status, p.viewed, pd.name AS name, pd.description, pd.meta_title, pd.meta_description
		 FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
		 WHERE p.product_id IN (214,1695,2382,4120,5479,1136,1086,1093,1438,577,956,1035,970,1082,1436,1440,1446,999,1016,1097,459,1744,1422,1421,1667,3555,6948,5681,5680,255,45,429,963,1745,1142,5772,2605,27,28,559)
		  AND pd.language_id = '1' AND p.status = '1'
		   AND p.date_available <= NOW()