0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT 

    TOP ##TopCount:INT?100## -- optional 100


    ROW_NUMBER() OVER (ORDER BY p.CreationDate ASC) AS 'ID',
    p.Id AS [Post Link],
    --p.PostTypeId AS 'TID',
    IIF(p.Parentid IS NULL, a.Title, p.Title) AS 'Title',
    IIF(p.Parentid IS NULL, a.Id, p.Id) AS 'PID',
    IIF(p.Parentid IS NULL, a.PostTypeId, p.PostTypeId) AS 'PTID',
    p.OwnerUserId AS 'UID',
    p.CreationDate AS 'Created'
    
FROM Posts AS p
JOIN Posts AS a ON p.Id = a.Parentid

WHERE p.PostTypeId = 1
AND YEAR(p.CreationDate) >= 2008
AND YEAR(p.CreationDate) <= 2012
AND p.Tags LIKE '%<vba>%'

ORDER BY p.CreationDate ASC

view current version

edited feb 29

created feb 29 VBasic2008