a

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results