0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT
    TOP 100
    Posts.Id AS [Post Link],
    ViewCount
FROM
    Posts
WHERE 
    PostTypeId=1 and CommunityOwnedDate is null

order by ViewCount desc

fork query

created jan 28 11 AcidZombie24