Am I involved in voting fraud?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results