Q&A for people studying math at any level and professionals in related fields
SELECT DISTINCT p.Id as [Post Link], v.Id, v.CreationDate FROM VOTES v LEFT JOIN Posts p on p.Id = v.PostId INNER JOIN ( SELECT dv.Id AS dupVoteId, pv.OwnerUserId, pv.ID FROM Votes dv INNER JOIN Posts pv ON dv.PostId = pv.ID WHERE dv.VoteTypeId = 2 AND dv.CreationDate != CAST(pv.CreationDate as DATE) ) dvOut ON dvOut.OwnerUserId = p.OwnerUserId AND v.Id <> dvOut.dupVoteId AND dvOut.Id <> p.ParentId AND (v.Id / 1000) = (dvOut.dupVoteId / 1000) INNER JOIN Users u ON u.Id = p.OwnerUserId WHERE ( v.VoteTypeId = 2 ) AND v.CreationDate != CAST(p.CreationDate as DATE) AND p.OwnerUserId = ##UID:int## ORDER BY v.CreationDate DESC