0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators, end users, developers and designers for Craft CMS

SELECT
  post.Id,
  post.Title,
  post.OwnerUserId,
  post.CreationDate,
  post.LastActivityDate,
  post.AcceptedAnswerId
  --resposta.OwnerUserId
FROM
  Posts as post
  --inner join Posts as resposta on Post.AcceptedAnswerId = Posts.Id
  inner join PostTags on PostTags.PostId = post.Id
  inner join Tags on Tags.Id = PostTags.TagId
Where
  post.PostTypeId = 1 
    and
  Tags.TagName like 'express'
    and
  post.CreationDate > 2019-04-01

fork query

edited may 12 20

created may 3 20 anonymous