Posts using Stack Snippets without JS / CSS / HTML tags

2

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select top ##MaxRows:int?100##  -- avoid timeouts :(
  Post.Id as [Post Link],
  PostTypes.Name as [Type],
  Post.OwnerUserId as [User Link],
  Post.Score,
  Post.CreationDate,
  coalesce(Post.ViewCount, Parent.ViewCount) as [Views],
  coalesce(Post.Tags, Parent.Tags) as [Tags]
from Posts as Post
  join PostTypes on Post.PostTypeId = PostTypes.Id
  left join Posts as Parent on Post.ParentId = Parent.Id
  left join (
    PostTags join Tags on Tags.Id = PostTags.TagId and (
      TagName like '%html%'
      or TagName like '%css%'
      or TagName like '%javascript%'
      or TagName like '%js%'
      or TagName like '%jquery%'
      or TagName like '%jq%'
      or TagName like '%ajax%'
    )
  ) on PostTags.PostId in (Post.Id, Post.ParentId)
where PostTags.PostId is null
  and Post.Body like '%<div class="snippet"%'
  and Post.Score between ##MinScore:int?-9999## and ##MaxScore:int?99999##
  and Post.CreationDate between ##MinDate:string?1900-01-01## and ##MaxDate:string?9999-12-31##

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results