0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT
  q.ViewCount AS views,
  q.Title AS title,
  q.Body AS body,
  q.Tags AS tags,
  q.CreationDate AS creation_date,
  u.DisplayName AS user_display_name,
  u.Id AS user_id,
  u.Reputation AS user_reputation,
  u.Location AS user_location,
  u.WebsiteUrl AS user_website,
  a.Body AS top_answer_body,
  a.CreationDate AS top_answer_creation_date,
  q.AnswerCount,
  q.CommentCount,
  q.FavoriteCount
FROM
  Posts q
JOIN
  Users u ON q.OwnerUserId = u.Id
JOIN
  Posts a ON q.Id = a.ParentId
WHERE
  q.Tags LIKE '%android-management-api%'
  AND q.PostTypeId = 1
  AND a.PostTypeId = 2  -- Filter for answers only
  AND a.Score = (SELECT MAX(Score) FROM Posts WHERE ParentId = q.Id)  -- Filter for top answers
ORDER BY
  q.ViewCount DESC;

fork query

edited jun 8

created jun 6 anonymous