0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT *
  FROM Posts p INNER JOIN Users u
  ON p.OwnerUserId = u.Id
  WHERE p.CreationDate BETWEEN '2023-01-01' AND '2023-12-31'
  AND p.ViewCount = 
           (SELECT MAX(ViewCount)
           FROM Posts);

fork query

edited mar 20

created mar 20 anonymous