0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT 
  PP.Id,
  PP.ParentId,
  PP.CreationDate,
  P.ViewCount,
  P.Title, 
  PP.Body, 
  P.Tags,
  PP.PostTypeId
FROM 
  Posts as P
JOIN 
  Posts PP ON PP.ParentId = P.Id
WHERE
  -- Set your specific query parameters here
  PP.PostTypeId = 2 AND P.tags LIKE '%<comment-conventions>%'
ORDER BY
  P.ViewCount DESC;

fork query

edited nov 15 19

created nov 13 18 anonymous