1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

SELECT Posts.Id, Posts.Title, 
    Posts.PostTypeId, 
    Posts.ParentId
   
FROM Posts
    LEFT OUTER JOIN POSTS parents ON Posts.ParentId = parents.Id
    INNER JOIN PostTags 
        ON PostTags.PostId = Posts.Id OR PostTags.PostId = parents.Id
    --INNER JOIN Tags ON PostTags.TagId = Tags.Id
WHERE
    PostTags.TagId = 59148 AND
    --Tags.tagname = 'rust' AND
    --(VoteTypeId = 2 OR VoteTypeId = 3) AND
    Posts.CreationDate > '2013-01-01' AND
    Posts.CreationDate < '2013-02-02'

view current version

edited jun 21

created jun 21 Lukas.Kalbertodt