導航

SELECT
	* 
FROM
	(
	SELECT
		order_number AS number,
		count( order_number ) AS count 
	FROM
		( SELECT order_number FROM xx_orders WHERE use_status = 2 AND order_type != 4 ) AS ordery 
	WHERE
		order_number LIKE 'XD%' 
	GROUP BY
		order_number 
	) AS ordert 
WHERE
	ordert.count = 1