Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT Id As [Post Link], CreationDate, Score, AnswerCount, ViewCount, Tags, Title, CASE PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' WHEN 3 THEN 'Orphaned tag wiki' WHEN 4 THEN 'Tag wiki excerpt' WHEN 5 THEN 'Tag wiki' WHEN 6 THEN 'Moderator nomination' WHEN 7 THEN 'Wiki placeholder' WHEN 8 THEN 'Privilege wiki' END FROM Posts WHERE (OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId?9072##)) AND (PostTypeId IN (##types?1,2##)) ---1=questions ---2=answer ---1,2=both ORDER BY CreationDate DESC