select posts.id , posts.owneruserid , posts.body into #po...

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select posts.id
     , posts.owneruserid
     , posts.body
into #posts
from Users 
inner join posts on posts.owneruserid = users.id
WHERE Users.Reputation < 100
and posttypeid = 2

--and posts.body like '%stackoverflow%'
--and (posts.body like '%http:%' 
-- or posts.body like '%https:%')

Enter Parameters

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