Answers on questions with at least 5 upvotes in specific topic

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

--Answers on posts with specifc topic and at least 5 upvotes--

DECLARE @UserId int = ##UserId##
DECLARE @Topic varchar = ##TagName##

SELECT --top 20 
  *
FROM 
  posts
  join
  posts p on p.Id = posts.parentId
  
WHERE
  posts.OwnerUserId = @UserId
  and 
  p.score >= 5
  and
  p.tags like concat('%',@Topic,'%')

Enter Parameters

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