foobar1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT TOP 20 
    Id AS [Post ID],
    Title,
    CreationDate AS [Date Created],
    Score,
    PostTypeId,
    CASE 
        WHEN PostTypeId = 1 THEN 'Question'
        WHEN PostTypeId = 2 THEN 'Answer'
        ELSE 'Other'
    END AS [Post Type],
    OwnerUserId AS [User ID]
FROM Posts
ORDER BY CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results