MediaWiki API questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

DECLARE @year int = ##Year?0##

SELECT
  Posts.Id as [Post Link],
  Posts.AnswerCount,
  Posts.ViewCount,
  Posts.Score,
  Users.Reputation as 'Asker reputation',
  CAST(COALESCE(Posts.AcceptedAnswerId, 0) as BIT) as 'Has accepted answer',
  Posts.CreationDate
FROM
  Posts
  JOIN PostTags ON PostTags.PostId = Posts.Id
  JOIN Tags ON PostTags.TagId = Tags.Id
  JOIN Users ON Users.Id = Posts.OwnerUserId
WHERE
  Tags.TagName = 'mediawiki-api'
  AND (@year = 0 OR @year = YEAR(posts.CreationDate))
;

Enter Parameters

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