0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more

SELECT
Posts.Title,
Posts.CreationDate,
Posts.Score,
Posts.ViewCount,
Posts.AnswerCount
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE Tags.TagName IN ('rental')
-- AND Posts.PostTypeId = 1
-- AND Posts.Score > 5
ORDER BY Posts.Score DESC;

fork query

edited dec 11

created dec 11 anonymous