0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts whose titles are of the form "Tag: Blah blah blah", where "Tag" is already one of the tags on that post.

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

SELECT Id AS [Post Link], 
       Title 
FROM   Posts 
WHERE  Title LIKE '%:%' 
       AND LEFT(Title, Charindex(':', Title) - 1) IN 
           (SELECT Tags.TagName 
            FROM   PostTags 
                   INNER JOIN Tags 
                           ON PostTags.TagId = Tags.Id 
            WHERE  PostTags.PostId = Posts.Id)
ORDER BY CreationDate DESC

fork query

edited jul 30 12 Jeremy Banks

created jul 30 12 jadarnel27