Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT q.Id AS QuestionId, q.Title AS QuestionTitle, q.Body AS QuestionBody, q.CreationDate AS QuestionCreationDate, q.Tags AS QuestionTags, q.AcceptedAnswerId, a.Id AS AnswerId, a.Body AS AnswerBody, a.CreationDate AS AnswerCreationDate, a.Score AS AnswerScore FROM Posts AS q LEFT JOIN Posts AS a ON q.AcceptedAnswerId = a.Id WHERE q.Tags LIKE '%<tibco>%' ORDER BY q.CreationDate DESC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY;