All arXiv mentions, on posts and comments.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Language Design and Implementation

Q&A for designers and implementers of computer programming languages

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 to meta site
loading Hold tight while we fetch your results