0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT CONCAT(
           'site://q/'
         , Posts.Id
         , '|'
         , CASE WHEN Posts.PostTypeId = 1 THEN 'Q' ELSE 'A' END
         , ' - '
         , Questions.Title) linkje
         , Comments.Id
         , Comments.text 
FROM Comments 
INNER JOIN
    Posts ON Posts.Id = Comments.PostId
INNER JOIN 
    Posts Questions ON Questions.Id = COALESCE(Posts.ParentId, Posts.Id)
WHERE Comments.text like '%thanks%'
AND len(Comments.text) < 20
  AND Posts.PostTypeId = 2
ORDER BY Comments.Id DESC

fork query

edited oct 23 MdoubleDash

created aug 8 22 anonymous