0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for apps, scripts, and development with the Stack Exchange API

select
  qs.Id,
  qs.Title, 
  qs.Body, 
  qs.AcceptedAnswerId, 
  qs.CreationDate, 
  qs.Score, 
  qs.ViewCount, 
  qs.AnswerCount, 
  qs.ClosedDate, 
  qs.Tags,
  qs.FavoriteCount,
  (select CreationDate from Posts ps where ps.Id=qs.AcceptedAnswerId) as AnswerCreationDate
from Posts qs
where (qs.tags like '%<machine-learning>%' OR qs.tags like '%<machine-learning-model>%') 
      and qs.PostTypeId = 1

fork query

edited dec 12 19

created dec 12 19 anonymous