Q&A about the site for serious players and enthusiasts of poker
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 NOT EXISTS( SELECT Id FROM PostHistory WHERE ph.PostHistoryTypeId = 10 AND ph.PostId = p.Id ) -- not closed GROUP BY p.Id ORDER by p.Id DESC