instruction: Lists the most commonly used tags with empty/missing tag wiki excerpt.. Lists the most commonly used tags with empty/missing tag wiki excerpt.
response: SELECT Count, ('site://tags/' + TagName + '|' + TagName) AS TagName, ExcerptPostId AS "post_link", WikiPostId AS "post_link" FROM Tags AS t LEFT JOIN Posts AS pe ON pe.Id = t.ExcerptPostId LEFT JOIN Posts AS pw ON pw.Id = t.WikiPostId WHERE ExcerptPostId IS NULL OR LENGTH(pe.Body) = 0 ORDER BY Count DESC