SELECT p.id FROM posts p, comments c, users u, badges b
WHERE c.postid = p.id
  AND u.id = p.owneruserid AND u.id = b.userid
  AND u.upvotes IN (SELECT MAX(upvotes) FROM users u WHERE u.creationdate > p.creationdate)
  AND EXISTS (SELECT 1 FROM postlinks l WHERE l.relatedpostid > p.id)
  AND (b.name LIKE 'Research Assistant');