SELECT TOP 500 Posts.Id AS [Post Link] FROM Posts LEFT JO...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT TOP 500 Posts.Id AS [Post Link] FROM Posts LEFT JOIN Posts Q ON Posts.ParentId = Q.Id WHERE Posts.Body LIKE '%http://%' AND LEN(Posts.Body) < 140 AND Q.ClosedDate IS NULL AND Q.CommunityOwnedDate IS NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results