All questions joined with all answers on Dataflow tag (qs without answers also shown)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

SELECT
    Questions.Id as 'Question',
    Questions.CreationDate as 'QuestionDate',
    Questions.ViewCount as 'ViewCount',
    Answers.CreationDate as 'AnswerDate',
    Answers.Id as 'AnswerId',
    Answers.Score as 'AnswerScore',
    ROW_NUMBER() OVER (PARTITION BY Questions.Id ORDER BY Answers.Score DESC) as 'AnswerNum',
    CONCAT('https://stackoverflow.com/questions/', Questions.Id) as 'Link',
    Questions.Tags as 'Tags'
  FROM
    Posts as Questions
    LEFT OUTER JOIN Posts as Answers ON Answers.ParentId = Questions.Id
  WHERE
    (Questions.Tags LIKE '%google-cloud-dataflow%')
  ORDER BY Questions.CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results