0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT COUNT(*)
FROM COMMENTS AS c
INNER JOIN
(
SELECT answer.*
FROM Posts AS question
INNER JOIN Posts AS answer 
ON answer.ParentId = question.Id AND question.Tags LIKE '%spring%'
--ORDER BY answer.ParentId
) as r
ON c.POSTID = r.ID
--offset 0 rows
--fetch next 10 rows only;


/*
SELECT distinct c.*
FROM COMMENTS c
    (
      SELECT a.*
      FROM POSTS q
      on c.POSTID = q.ID AND q.TAGS LIKE '%spring%'
      INNER JOIN POSTS a
      on a.ParentId = q.Id
    ) as r

--SELECT * FROM COMMENTS WHERE PostId = 1371705

--SELECT * FROM POSTS WHERE ID = 63560532
*/

fork query

edited jan 20

created jan 20 anonymous