Q&A for Drupal developers and administrators
select * from Posts p JOIN PostTags pt ON p.PostTypeId = 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'