Q&A for active researchers, academics and students of physics
SELECT * 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 pl.CreationDate > '2021-02-15 00:00:00' AND pl.CreationDate < '2021-02-22 00:00:00' ORDER BY pl.CreationDate DESC