0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

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 '%/i.stack.imgur.com/%'
ORDER BY p.Id ASC;

fork query

edited feb 2

created feb 2 b_jonas