0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

/* URL changed from "http://www2.stetson.edu/~efriedma/" to "https://erich-friedman.github.io/" */

SELECT 'site://a/' + CAST(p.Id AS NVARCHAR) + '/' + CAST(m.Id AS NVARCHAR) + 
'|' + COALESCE(p.Title, q.Title) AS ptl,
COALESCE(p.Tags, q.Tags) AS qta,
COALESCE('site://users/' + CAST(p.OwnerUserId AS NVARCHAR) + '|' + u.DisplayName, p.OwnerDisplayName) AS pus,
p.Score AS psc,
p.CreationDate AS pda
FROM Posts AS p
LEFT JOIN Posts AS q ON p.ParentId = q.Id
LEFT JOIN Users AS u ON u.Id = p.OwnerUserId
LEFT JOIN Users AS m ON m.AccountId = 1192385
WHERE p.Body LIKE '%/~efriedma/%'
ORDER BY p.Id DESC;

fork query

edited dec 7 20

created dec 6 20 b_jonas