Questions using Stack Snippets without JS / CSS / HTML tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top ##MaxRows:int?100##  -- avoid timeouts :(
  Post.Id as [Post Link],
  Post.OwnerUserId as [User Link],
  Post.Score,
  Post.CreationDate,
  Post.ViewCount,
  Post.Tags
from Posts as Post
where Post.PostTypeId = 1 -- questions
  and Post.Score between ##MinScore:int?0## and ##MaxScore:int?99999##
  and Post.CreationDate between ##MinDate:string?2012-01-01## and ##MaxDate:string?2016-01-01##
  and Post.Tags not like '%html%'
  and Post.Tags not like '%css%'
  and Post.Tags not like '%javascript%'
  and Post.Tags not like '%js%'
  and Post.Tags not like '%jquery%'
  and Post.Tags not like '%ajax%'  
  and Post.Body like '%<div class="snippet"%'
order by Post.Score desc

Enter Parameters

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