0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jul 25

created jun 27 jon.doe31697