0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

select top 1000 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
  u.reputation
from posts p, users u, Tags
where p.owneruserid = u.id
  and p.answercount < 5
  and u.reputation <= 100
  and p.tags IN ('swift')
order by p.creationdate desc
--limit 1000

fork query

edited mar 20 anonymous

created jan 23 14 Chloe