Stack Exchange Data Explorer

General Help
1

I did not know about this until seeing this bit of drama : How can we handle a user who sabotaged dozens of their old questions and answers and then deleted their account? - Meta Stack Overflow

SELECT ID AS PostID, 
       CreationDate, 
       LastEditDate, 
       ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS RN,
       CONCAT( 'https://stackoverflow.com/', 
                CASE PostTypeId WHEN 1 THEN 'q' WHEN 2 THEN 'a' END,
                '/',
                ID ) AS Linkey
FROM dbo.Posts
WHERE OwnerDisplayName = ##OwnerName:string##
ORDER by LastEditDate DESC

https://data.stackexchange.com/stackoverflow/query/1776906?OwnerName=user141302

2

eg

select Posts.Id,
       Score,
       Title,
       Tags.TagName,
       CONCAT( 'https://stackoverflow.com/', 
                CASE PostTypeId WHEN 1 THEN 'q' WHEN 2 THEN 'a' END,
                '/',
                Posts.Id ) AS Linkey
FROM PostTags

JOIN Posts
ON   PostTags.PostId = Posts.Id

JOIN Tags
ON   PostTags.TagId = Tags.Id

where Tags.TagName like 'delphi%'

order by Score desc

or

select CreationDate,
       Score,
       Title,
       Tags.TagName,
       CONCAT( 'https://stackoverflow.com/', 
                CASE PostTypeId WHEN 1 THEN 'q' WHEN 2 THEN 'a' END,
                '/',
                Posts.Id ) AS Linkey
FROM PostTags

JOIN Posts
ON   PostTags.PostId = Posts.Id

JOIN Tags
ON   PostTags.TagId = Tags.Id

where Tags.TagName = 'delphi-11-alexandria'   /* or 'firemonkey'  */

order by CreationDate desc