0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Ukrainian language

select Posts.Id,
       Score,
       Title,
       Tags.TagName,
       CONCAT( 'https://stackoverflow.com/', 
                CASE PostTypeId WHEN 1 THEN 'q' WHEN 2 THEN 'a' END,
                '/',
                Posts.Id ) AS Linkey,
       CreationDate         
FROM PostTags

JOIN Posts
ON   PostTags.PostId = Posts.Id

JOIN Tags
ON   PostTags.TagId = Tags.Id

where Tags.TagName like 'rust%'

order by CreationDate desc

fork query

edited dec 6

created dec 6 Paul.McGee