0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in governments, policies, and political processes

SELECT DISTINCT 
  p.Id,
  p.Title,
  p.Tags,
  p.Body,
  p.CreationDate
FROM 
Posts p 
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE
(UPPER(t.TagName) LIKE UPPER('jax')) OR (UPPER(t.TagName) LIKE UPPER('next.js'))
AND
(p.CreationDate > '2018-01-01')

fork query

created may 20 dynamicwebpaige