1

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 TOP 100
Questions.Id 
AS [Post Link],
Questions.Title,
Questions.CreationDate,
Questions.ViewCount,
Questions.Tags


FROM Posts as Questions

WHERE 
Questions.CreationDate >= DATEADD(dd, -7, GETDATE())

/* and Questions.Tags like '%html%' */

/* AND Questions.CreationDate > '2022-05-05 00:00:00' */
 /* AND Questions.CreationDate < '2022-02-21 00:00:00' */

/* and (Questions.Tags like '%c++%' OR Questions.Tags like '%C%' OR Questions.Tags like '%oop%') */


ORDER BY ViewCount DESC

view current version

edited may 20

created may 2 codename