tigidig

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

SELECT 	TOP 5000 
		'http://stackoverflow.com/users/' + CAST(p.OwnerUserId AS VARCHAR(10)) AS OwnerLink,
		'http://stackoverflow.com/questions/' + CAST(p.ID AS VARCHAR(10)) AS QuestionLink,
		p.Score,
		p.ViewCount,
		p.FavoriteCount,
		p.Title,
		LEN(p.Title) AS TitleLength,
		LEN(p.Body) AS BodyLength,
		p.Tags,
		p.CreationDate,
		CASE WHEN CHARINDEX('<code>', p.Body) > 0 THEN 'True' ELSE 'False' END ContainsCodeBlock
FROM 	Posts AS p
		INNER JOIN PostTags AS pt
			ON 	pt.PostId = p.Id
WHERE 	p.PostTypeId = 1 								-- <<== Questions
		AND p.CommunityOwnedDate IS NULL  				-- <<== not WIKI
		AND pt.TagId = 17								-- <<== JAVA
		AND p.OwnerUserId IS NOT NULL					-- <<== user is not deleted
ORDER 	BY p.ViewCount DESC

Enter Parameters

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