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
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
Stackoverflow Queries related to Delphi (2012-2023) by month
There was some duplication in results … more in the earlier years … but the shape is the same.
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,
CreationDate
FROM PostTags
JOIN Posts
ON PostTags.PostId = Posts.Id
JOIN Tags
ON PostTags.TagId = Tags.Id
where Tags.TagName like 'delphi%'
order by CreationDate desc
I wonder if there is a dataset for Delphi jobs. There are close to zero anywhere in the world at present, which considering the retirement age of many Delphi devs isn’t a positive sign
Just for comparison … Rust. Same period.
