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 (4431,5071,4996,1652,2572,319,228,219,4099,65,6225,5676,453,455,434,803,798,4018,4034,77,1492,1534,1536,5543,812,468,2359,1177,1200,78,76,1540,190,795,1178,251,1473,218,128,132)
		  AND pd.language_id = '1' AND p.status = '1'
		   AND p.date_available <= NOW()