Q&A about the site for music historians, critics, and fans
SELECT p.id as [Post Link] FROM Posts p JOIN Comments c ON c.PostId = p.Id JOIN PostHistory ph on ph.PostId = p.Id WHERE DATEDIFF(day, p.LastEditDate, c.CreationDate) >= 0 AND c.Text LIKE '%##KeywordsInComment##%' AND ph.PostHistoryTypeId <> 10 -- not closed GROUP BY p.Id