All arXiv mentions, on posts and comments.

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

SELECT * FROM (
SELECT TOP 10000 
  Posts.Id AS [Post Link],
  NULL AS [Comment Link],
  PostTypes.Name AS Type,
  Posts.CreationDate AS 'Date'
FROM Posts
JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id
WHERE LOWER(Body) LIKE '%arxiv%'
ORDER BY CreationDate DESC
) AS P

UNION ALL

SELECT * FROM (
SELECT TOP 10000
  PostId AS [Post Link],
  Id AS [Comment Link],
  'Comment' AS Type,
  CreationDate AS 'Date'
FROM COMMENTS
WHERE LOWER(Text) LIKE '%arxiv%'
ORDER BY CreationDate DESC
) AS C

ORDER BY Date DESC

Enter Parameters

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