0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

SELECT DISTINCT
    Questions.Id AS QuestionId,
    Questions.Title,
    Questions.Score,
    Questions.CreationDate,
    Questions.Body
FROM Posts AS Questions
JOIN Posts AS Answers ON Questions.Id = Answers.ParentId
WHERE (Questions.PostTypeId = 1
    AND(LOWER(Questions.Body) LIKE '%arxiv%'
    OR LOWER(Questions.Title) LIKE '%arxiv%')
    )
    OR (Answers.PostTypeId = 2
    AND(LOWER(Answers.Body) LIKE '%arxiv%'
    OR LOWER(Answers.Title) LIKE '%arxiv%'))
ORDER BY Questions.Score DESC

fork query

edited sep 16

created sep 16 anonymous