SELECT
		DATE_FORMAT( a.ob_enddate_0081, '%Y-%m-%d' ) ob_enddate_0081,
		a.f001n_0081,
		ROUND((
			SELECT
				ClosePrice 
			FROM
				ctb_Quotation 
			WHERE
				Stockcode IN ('873843')
				AND TradeDate <= a.ob_enddate_0081 
				AND ClosePrice != '' 
			ORDER BY
				TradeDate DESC 
				LIMIT 1 
				),
			2 
		) ClosePrice 
	FROM
		ctb_company_0081 a 
	WHERE
		a.ob_orgid_0081 IN ('873843')
		AND a.f001n_0081 IS NOT NULL