instruction: Show all comments and post id's for a question. http://meta.stackoverflow.com/questions/319386/question-appearing-twice-in-google-search-results/319389#319389
response: SELECT 'Q', Id AS id FROM Posts WHERE Id = '##question:int##' AND PostTypeId = 1 UNION SELECT 'A', Id AS id FROM Posts WHERE ParentId = '##question:int##' AND PostTypeId = 2 UNION SELECT 'CQ', Id FROM Comments WHERE PostId = '##question:int##' UNION SELECT 'CA', c.Id FROM Comments AS c INNER JOIN Posts AS p ON c.PostId = p.Id WHERE p.ParentId = '##question:int##'