Q&A for Drupal developers and administrators
select ParentId from Posts p JOIN PostTags pt ON p.Id = pt.PostId --JOIN Posts AS po ON po.ParentId = p.Id 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.Id in ('64140663', '64185563', '64155665') --64129493 --64129691 --SELECT a.* FROM Posts a WHERE a.ParentId = '64140663'