Regexii

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

Motor Vehicle Maintenance and Repair Meta

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,
   posts.tags as TAGS
FROM posts JOIN posttags ON posts.id = posttags.postid
           JOIN tags on posttags.tagid = tags.id

WHERE (posts.tags LIKE 'regex') AND (posts.tags LIKE 'java') AND
      posts.CommunityOwnedDate IS NULL

Enter Parameters

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