0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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(p.Body) LIKE UPPER('testing web pages'))
AND
(p.CreationDate > '2023-01-01')

fork query

created may 22 anonymous