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 IN (SELECT MAX(ViewCount)
                        FROM Posts)

fork query

edited mar 20

created mar 20 anonymous