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 COUNT(p.Id)
FROM Posts p
JOIN PostTags pt on pt.PostId = p.Id
JOIN Tags t on t.Id = pt.TagId
WHERE TagId in
(
  SELECT id from Tags where tagname LIKE 'https' or tagname LIKE 'authentication'
) AND p.PostTypeId = 1

fork query

edited nov 1 InvisibleWolf

created may 8 20 anonymous