0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Tridion developers and administrators

SELECT 
    TOP 100 -- Limits the output to the top 100 results
    Id AS [Post Link], 
    Title, 
    ViewCount, 
    CreationDate 
FROM Posts 
WHERE 
    Tags LIKE '%<sql>%' -- Searches for posts tagged with SQL
    AND (
        Title LIKE '%index%' OR -- Includes questions explicitly mentioning "index"
        Title LIKE '%indexed%' OR -- Includes questions about "indexed" data
        Title LIKE '%indexing%' -- Includes questions about "indexing" techniques
    )
    AND ViewCount >= 10000 -- Ensures only questions with at least 10,000 views are included
    AND CreationDate BETWEEN '2010-01-01' AND '2014-12-31' -- Restricts results to posts created between 2010 and 2014
    AND PostTypeId = 1 -- Ensures only questions are included (excludes answers and other posts)
ORDER BY ViewCount DESC; -- Sorts the results by view count in descending order

fork query

edited dec 1

created dec 1 anonymous