0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT 

    --TOP 100 

    p.Id AS [Post Link], 
    u.Id AS [User Link], 
    p.CreationDate, 
    p.AnswerCount, 
    p.Score

FROM Posts as p
JOIN Users u ON p.OwnerUserId=u.Id

WHERE p.Tags LIKE '%<vba>%'
AND p.PostTypeId = 1 --question
AND p.AnswerCount >= 10

ORDER BY p.AnswerCount DESC, p.Score DESC, p.CreationDate DESC

fork query

edited feb 28

created feb 24 VBasic2008