0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

/*
SELECT
  P.Id,
  P.ParentId,
  P.CreationDate,
  P.ViewCount,
  P.Title,
  P.Body,
  P.Tags
FROM
  Posts as P
WHERE
  LOWER(P.Tags) LIKE '%<java>%'
  AND P.CreationDate BETWEEN '2018-12-01' AND '2020-09-30'
  -- AND P.ParentId IS NOT NULL
ORDER BY
  P.ViewCount DESC;
 */
 
 /*
 SELECT COUNT(Id)
 FROM Posts
 WHERE 
 -- LOWER(P.Tags) LIKE '<javascript>'
 -- AND P.CreationDate BETWEEN '2018-12-01' AND '2020-09-30'
 -- AND P.ParentId IS NULL
 PostTypeId = 1
 -- Tags = 'java'
 */
 

SELECT pq.Id, pq.Title, pq.Body, pq.Tags, pq.ViewCount, pq.Score, pq. CreationDate, pa.Body FROM 
(
  Posts pq JOIN PostTags pt on pt.PostId = pq.Id
  JOIN Tags t on t.Id = pt.TagId
  JOIN Posts pa on pq.AcceptedAnswerId = pa.Id
)
WHERE pq.PostTypeId = 1 AND pq.AcceptedAnswerId IS NOT NULL and TagId in
(
  SELECT id from Tags where tagname LIKE 'authentication' or tagname LIKE '.htaccess' 
)
for json auto

fork query

edited nov 1 InvisibleWolf

created may 8 20 anonymous