SELECT TOP 5000 'http://stackoverflow.com/users/' + CAST...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT 	TOP 5000 
		'http://stackoverflow.com/users/' + CAST(OwnerUserId AS VARCHAR(10)) AS OwnerLink,
		'http://stackoverflow.com/questions/' + CAST(ID AS VARCHAR(10)) AS QuestionLink,
		Score,
		ViewCount,
		FavoriteCount,
		Title,
		LEN(Title) AS TitleLength,
		LEN(Body) AS BodyLength,
		Tags,
		CreationDate
FROM 	Posts
WHERE 	PostTypeId = 1 								-- <<== Questions
		AND CommunityOwnedDate IS NULL  			-- <<== not WIKI
ORDER 	BY ViewCount DESC

Enter Parameters

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