0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT 
      p.Id, 
      p.PostTypeId, 
      p.AcceptedAnswerId, 
      p.CreationDate, 
      p.ViewCount, 
      p.AnswerCount, 
      p.CommentCount, 
      p.Score,
      p.Title,
      p.Body,
      p.Tags,
      a.Body AS 'Answer Body'
FROM Posts AS p join Posts AS a ON p.AcceptedAnswerId=a.Id
WHERE
      (p.tags LIKE '%<tensorflow>%' OR
      p.tags LIKE '%<pytorch>%' OR
      p.tags LIKE '%<scikit-learn>%' OR
      p.tags LIKE '%<keras>%' OR
      p.tags LIKE '%<nltk>%' OR
      p.tags LIKE '%<huggingface>%' OR
      p.tags LIKE '%<spark-ml>%') AND
      p.AcceptedAnswerId is not null AND
      p.creationDate > '2020-12-29 00:00:00'
ORDER BY p.CreationDate DESC

fork query

edited jan 31

created jan 29 anonymous