0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT p.Id AS [Post Link]
FROM Posts AS p
LEFT JOIN Posts AS q ON p.ParentId = q.Id
LEFT JOIN Posts AS pq ON q.ParentId = pq.Id
WHERE p.Body LIKE '%'##URL:string##'%' COLLATE SQL_Latin1_General_Cp1_CI_AS

fork query

edited may 4 23 Jeff Schaller

created may 4 23 galacticninja