SELECT pidors id pidors2 id pidors2 user pidors2 date pidors2 phone DI

SELECT
	/*pidors.id, pidors2.id, pidors2.user, pidors2.date, pidors2.phone*/
	DISTINCT pidors2.user
FROM
	(
	SELECT
			/*DISTINCT orders.user as users,*/
			orders.id as id,
			orders.`user` as `user`,
			FROM_UNIXTIME(orders.otime, "%Y%m%d") as date,
			orders.phone as phone,
			COUNT(DISTINCT orders.state) as q,
			COUNT(orders.id) as c
			/*DISTINCT orders.state 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
	ORDER BY q DESC
	) as pidors
JOIN (
	SELECT
			orders.id as id,
			orders.`user` as `user`,
			FROM_UNIXTIME(orders.otime, "%Y%m%d") as date,
			orders.phone as phone
		FROM
			orders
		WHERE
			FROM_UNIXTIME(orders.otime, "%Y%m%d") BETWEEN "20140101" AND "20150101"
	) as pidors2 ON (pidors.date = pidors2.date AND pidors.phone = pidors2.phone)
WHERE pidors.q>1
ORDER BY pidors.phone
/*LEFT JOIN orders o ON (FROM_UNIXTIME(o.otime, "%Y%m%d") = pidors.date AND o.phone = pidors.phone)
WHERE FROM_UNIXTIME(o.otime, "%Y%m%d") BETWEEN "20150101" AND "20150107"*/