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"*/