0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

SELECT
 -- Posts.*
count(*)
FROM Tags
INNER JOIN PostTags ON PostTags.TagId = Tags.id
INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
WHERE
Posts.CreationDate >= '2020-01-01 00:00:00' AND Posts.CreationDate <'2021-01-01 00:00:00'
AND Tags.TagName='java'
AND Posts.DeletionDate IS NULL
AND Posts.ClosedDate IS null
AND Posts.PostTypeId=2
AND Posts.Body LIKE '%<pre><code>%'
--ORDER BY Posts.CreationDate ASC
--OFFSET 0 ROWS
--FETCH NEXT 20 ROWS ONLY;
;

fork query

edited nov 30

created nov 30 anonymous