SELECT SQL_NO_CACHE orders date orders phone FROM SELECT FROM_UNIXTIME

SELECT
	SQL_NO_CACHE
	orders.date,
	orders.phone
FROM
	(
		SELECT
			FROM_UNIXTIME(orders.otime, "%Y%m%d") as date,
			orders.phone as phone,
			COUNT(DISTINCT orders.state) as q,
			GROUP_CONCAT(DISTINCT orders.state SEPARATOR ",") as states
		FROM
			orders
		WHERE
			FROM_UNIXTIME(orders.otime, "%Y%m%d") BETWEEN "20140101" AND "20150101"
		GROUP BY
			FROM_UNIXTIME(orders.otime, "%Y%m%d"),
			orders.phone
	) as orders
WHERE
	orders.q > 1
		AND
	FIND_IN_SET(99, orders.states) > 0
GROUP BY
	orders.date,
	orders.phone