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 results to the top 100 topics for easy review
    Id AS [Post Link], 
    Title, 
    ViewCount, 
    CreationDate 
FROM Posts 
WHERE 
    Tags LIKE '%<java>%' -- Searches for posts tagged with Java (JVM-related topics)
    AND Title LIKE '%exception%' -- Filters for questions with "exception" in the title
    AND ViewCount >= 10000 -- Includes only questions with at least 10,000 views
    AND CreationDate BETWEEN '2010-01-01' AND '2014-12-31' -- Restricts the time range to between 2010 and 2014
    AND PostTypeId = 1 -- Ensures only questions are selected (excludes answers and other posts)
ORDER BY ViewCount DESC; -- Orders the results by view count in descending order

fork query

created dec 1 anonymous