0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of hardware and software for Raspberry Pi

select *
from
  Posts p
  JOIN PostTags pt ON p.Id = pt.PostId
  JOIN Tags t ON pt.TagId = t.Id
  JOIN Comments c ON c.PostId = p.Id
  where p.CreationDate > '2020-09-30' AND p.CreationDate < '2020-10-01' 
  AND p.Score > 0 AND p.ParentId in ('64185563', '64155665')

--64129493
--64129691

--SELECT  a.* FROM    Posts a WHERE   a.ParentId = '64140663'

fork query

edited oct 24 20 anonymous

created jun 16 10 lukasz.lew