select reverse link by [score/viewcount] in one day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Theoretical Computer Science

Q&A for theoretical computer scientists and researchers in related fields

-- SELECT pl.CreationDate, pl.PostId AS [Post Link], pl.RelatedPostId AS [Post Link], 
-- ( (tp.Score*1.0)/(tp.ViewCount+1)) as tp_qulity, ( (mp.Score*1.0)/(mp.ViewCount+1)) as mp_qulity
-- SELECT count(*)
SELECT pl.PostId as [Post Link], pl.RelatedPostId as [Post Link]
FROM PostLinks pl
JOIN Posts as tp ON tp.Id = pl.PostId
-- JOIN Users as tu ON tu.Id = tp.OwnerUserId
JOIN Posts as mp ON mp.Id = pl.RelatedPostId
-- JOIN Users as mu ON mu.Id = mp.OwnerUserId
WHERE pl.LinkTypeId = 3
AND tp.CreationDate > mp.CreationDate
-- AND ((tp.Score*1.0)/(tp.ViewCount+1)) > ( (mp.Score*1.0)/(mp.ViewCount+1))
-- AND tp.Score > mp.Score - 10
AND tp.Score > mp.Score
-- AND tp.AnswerCount > 0
-- AND pl.CreationDate > '2020-01-25 00:00:00'
-- AND pl.CreationDate < '2020-02-01 00:00:00'
ORDER BY pl.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results