Tags without short description

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

SELECT T.Id
     , tagname
     -- man, I hate that bug ...
     , concat('site://','tags/', T.TagName, '/info|', T.tagname) [Tag info Page]
     , p.body
FROM tags t
left outer JOIN posts AS p
ON P.Id = T.ExcerptPostId
WHERE p.id is null
or len(p.body) = 0

Enter Parameters

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