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 (342)
		  AND pd.language_id = '1' AND p.status = '1'
		   AND p.date_available <= NOW() 

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 (4802,4803,3231,3232,6889,6892,6889,6892)
		  AND pd.language_id = '1' AND p.status = '1'
		   AND p.date_available <= NOW()