SELECT DISTINCT(p.Id), v.postid AS [Post Link], p.Score, ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi Meta

Q&A about the site for users and developers of hardware and software for Raspberry Pi

SELECT DISTINCT(p.Id), v.postid AS [Post Link], p.Score, p.viewCount, p.AnswerCount, p.title, p.creationDate
FROM Posts p
INNER JOIN votes v on p.Id=v.postid
INNER JOIN PostTags pt ON pt.PostId = p.Id
INNER JOIN Tags t ON t.Id = pt.TagId

WHERE ( t.TagName = 'conv-neural-network' or t.TagName = 'rnn' or 
    t.TagName = 'lstm' or t.TagName = 'deep-learning' or 
    t.TagName = 'machine-learning' or t.TagName = 'keras' or
    t.TagName = 'neural-network' or t.TagName = 'tensorflow-datasets'
    or t.TagName = 'resnet' or t.TagName = 'recurrent-neural-network'
    or t.TagName = 'cnn'
    and t.TagName != 'tensorflow2.0' and t.TagName != 'tf.keras' and 
    t.TagName != 'tensorflow')
    and p.AnswerCount = 0 
    and p.creationDate > '2020-01-01'
    and p.Score > 0
GROUP BY p.Id, p.title,p.AnswerCount, p.CreationDate, p.Score, p.Tags, t.TagName, v.postid, p.viewcount
ORDER BY  p.CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results