0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

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 23

created jun 6 23 anonymous