0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT   TOP ##top## a.body AS AnswerBody,
         a.score            AS AnswerScore,
         a.lasteditdate     AS AnswerLastEditDate,
         a.creationdate     AS AnswerCreationDate,
         q.id AS QuestionId,
         q.creationdate AS QuestionCreationDate,
         q.lasteditdate AS QuestionLastEditDate,
         q.score AS QuestionScore,
         q.viewcount AS QuestionViewCount,
         q.title AS QuestionTitle,
         q.body AS QuestionBody,
         q.favoritecount AS QuestionFavoriteCount,
         q.answercount AS QuestionAnswerCount,
         q.lastactivitydate AS QuestionLastActivityDate,
         q.tags AS QuestionTags
FROM     posts AS q
JOIN     posts AS a
ON       q.id=a.parentid
-- WHERE    q.acceptedanswerid=a.id
--AND    
WHERE q.tags LIKE '%##tag1##%' --##tag2##%'
-- OR       a.tags LIKE '%##tag2##%##tag1##%'
ORDER BY q.score DESC, a.score DESC

fork query

edited jul 10 20

created jul 9 20 anonymous