SELECT
	DISTINCT(id)
FROM
	test1
WHERE
	date = '2016-10-16 00:00:00'
AND id IN (
	SELECT
		id
	FROM
		test1
	GROUP BY
		id
	HAVING
		min(date) < '2016-10-16 00:00:00'
)
ORDER BY id