0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

Select count(*) as Post_count FROM Posts p WHERE p.id in (
select pt.PostId from PostTags pt
inner join Posts p on pt.PostId = p.Id
inner join Tags t on pt.TagId = t.Id
where p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=1386)
AND p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=75599)
GROUP BY p.title, pt.PostId) AND p.creationdate between '2022/01/01' and '2023/01/01'


-- 75599 Kotlin
-- 17 Java

fork query

edited may 31 23

created oct 1 14 anonymous