1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

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

fork query

edited jul 26 22

created jul 26 22 anonymous