0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
P.Id AS [Post Link],
P.Title,
P.AnswerCount, -- the number of undeleted answers (only present if PostTypeId = 1)
P.AcceptedAnswerId,
P.Tags,
P.ViewCount,
P.Score
FROM Posts AS P
INNER JOIN PostTags AS PT_android ON P.Id = PT_android.PostId
INNER JOIN Tags AS T_android ON PT_android.TagId = T_android.Id
INNER JOIN PostTags AS PT_security ON P.Id = PT_security.PostId
INNER JOIN Tags AS T_security ON PT_security.TagId = T_security.Id
WHERE
T_android.TagName = 'android'
AND T_security.TagName = 'securlty'
AND P.PostTypeId = 1 --仅选择问题
AND P.AcceptedAnswerId IS NOT NULL --AcceptedAnswerId不为空
ORDER BY P.ViewCount DESC;

fork query

edited nov 19

created nov 19 anonymous