0

Please login or register to vote for this query.

(click on this box to dismiss)

Find me the 100 most upvoted questions related to the regex tag

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Regexii
-- Find me the 100 most upvoted questions related to the regex tag

SELECT TOP 100
   ('http://stackoverflow.com/questions/' + CONVERT(varchar(10), posts.id)) AS LINK,
   posts.title as TITLE,
   posts.score as SCORE,
   tags as TAGS
FROM posts JOIN posttags ON posts.id = posttags.postid
           JOIN tags AS regextag on posttags.tagid = regextag.id
           JOIN tags AS javatag on posttags.tagid = javatag.id    

WHERE (regextag.tagname LIKE 'regex')  AND (javatag.tagname LIKE 'java') AND
      posts.CommunityOwnedDate IS NULL

fork query

created jul 6 11 anonymous