0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT p.Id, p.Title, tt.Count as TagsCount
FROM Posts AS p
LEFT JOIN (SELECT st.PostId, st.TagId, t.Id, t.Count
           FROM PostTags AS st 
           LEFT Join Tags AS t ON st.TagId = t.Id
           WHERE t.Count = '5') AS tt
           ON p.Id = tt.PostId
LEFT JOIN (SELECT Name, Id FROM PostTypes WHERE Name ='question') AS pt 
           ON p.Id = pt.Id
           ORDER BY NEWID()       
OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY

fork query

edited nov 30

created nov 30 anonymous