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 cast(CreationDate as date)
from Posts P
  inner join PostTags PT
    on P.Id = PT.PostId
  inner join Tags T
    on PT.TagId = T.Id
  inner join PostTypes PTy
    on P.PostTypeId = PTy.Id
where T.TagName = 'data.table'
      --and PTy.Name = 'Answer'
      
 --select * from PostTypes where Name = 'Answer'

fork query

edited apr 14 19

created apr 14 19 anonymous