SELECT Posts.* FROM Tags INNER JOIN PostTags ON PostTags....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

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;
;

Enter Parameters

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