0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

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,
		CASE WHEN CHARINDEX('<code>', Body) > 0 THEN 'True' ELSE 'False' END ContainsCodeBlock
FROM 	Posts
WHERE 	PostTypeId = 1 								-- <<== Questions
		AND CommunityOwnedDate IS NULL  			-- <<== not WIKI
		AND OwnerUserId IS NOT NULL					-- <<== user is not deleted
ORDER 	BY ViewCount DESC

fork query

edited feb 3 14

created feb 3 14 anonymous