0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select top 100 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
  u.reputation
from posts p, users u 
where p.owneruserid = u.id
  and p.answercount = 0
  and u.reputation <= 100
  and p.deletiondate is null
  and p.creationdate < GETDATE() - 2
  AND(
      p.tags like '%angular%' OR
      p.tags like '%google-api%' OR 
      p.tags like '%google-people%' OR
      p.tags like '%google-photos-api%')
order by p.creationdate desc

fork query

created mar 31 20 anonymous