Issue Tags count 2022

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stellar Meta

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

SELECT p.CreationDate, p.Id, p.Score, p.viewCount, 
p.AnswerCount, p.Title, v.postid AS [Post Link], t.tagName 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 = 'tensorflow'
or t.TagName = 'tensorflow2.0'
or t.TagName = 'tensorflow-lite'
or t.TagName = 'tensorflow-datasets'
or t.TagName = 'tensorflow.js'
or t.TagName = 'tensorflow-serving'
or t.TagName = 'tensorflow-estimator'
or t.TagName = 'tensorflow-gpu'
or t.TagName = 'tensorflow-federated'
or t.TagName = 'tensorflow-probability'
or t.TagName = 'tensorflow-hub'
or t.TagName = 'tensorflow2.x'
or t.TagName = 'tensorflowjs-converter'
or t.TagName = 'tensorflow-slim'
or t.TagName = 'tensorflow-model-garden'
or t.TagName = 'tensorflow1.15'
or t.TagName = 'tensorflow-transform'
or t.TagName = 'tensorflow-xla'
or t.TagName = 'tensorflow2'
or t.TagName = 'tensorflow-data-validation'
or t.TagName = 'tensorflow-agents'
or t.TagName = 'tensorflow-model-analysis'
or t.TagName = 'tensorflow-gradient'
or t.TagName = 'tensorflow-ssd'
or t.TagName = 'tensorflow-c++'
or t.TagName = 'tensorflowsharp'
or t.TagName = 'distributed-tensorflow'
or t.TagName = 'tensorflowjs'
or t.TagName = 'tensorflow-quantum'
or t.TagName = 'tensorflow-android'
or t.TagName = 'swift-for-tensorflow'
or t.TagName = 'tensorflow-extended'
or t.TagName = 'tensorflow-layers'
or t.TagName = 'tensorflow-addons'
or t.TagName = 'tensorflow.net'
or t.TagName = 'intel-tensorflow' )



 /*   and p.AnswerCount = 0 */
and p.creationDate >= '2022-05-01' 
and p.creationDate <= '2022-05-31'
and p.PostTypeId = 1
/*    and p.Score > 0 */
--GROUP BY p.Id, p.title,p.AnswerCount, p.CreationDate,p.deletionDate, p.Score, p.Tags, t.TagName, v.postid, p.viewcount
--ORDER BY  p.CreationDate DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results