1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

--select SUM(p.ViewCount)
--from posts p
--where (p.tags like '%<##tag?itext##>%') or 
--(p.tags like '%<##tag1?itext7##>%') or 
--(p.tags like '%<##tag6?itext##>%') or 
--(p.tags like '%<##tag2?itextsharp##>%') or
--(p.tags like '%<##tag3?itextpdf##>%') or
--(p.tags like '%<##tag4?itextg##>%') or
--(p.tags like '%<##tag5?xmlworker##>%')
--and p.posttypeid in (1) -- questions



select SUM(q.ViewCount)
from posts as q
INNER JOIN PostTags AS P ON P.PostId = Q.Id
INNER JOIN Tags AS T ON T.Id = P.TagId
where T.TagName = 'itext'
or T.TagName = 'xmlworker'
or T.TagName = 'itext7'
or T.TagName = 'itextpdf'
or T.TagName = 'itextsharp'
or T.TagName = 'itextg'
and q.posttypeid in (1)

fork query

edited jul 15

created sep 5 23 Andr.Lemos