True blue

1

Please login or register to vote for this query.

(click on this box to dismiss)

Movies and TV

Q&A for movie and tv enthusiasts

with originallyVulgar as
(
  select CreationDate, PostId
  from PostHistory
  where PostHistoryTypeId=2 -- initial body
  -- six root words you can't say on TV
  and ( Text like '%shit%' 
    or Text like '%piss%' 
    or Text like '%fuck%' 
    or Text like '%cunt%'
    or Text like '%cocksuck%'
    or Text like '%tits%' )
    
  and CreationDate between ##Start:string## and ##End:string##
),

stillVulgar as
(
  select Id, iif(Body like '%<blockquote>%', 1, 0) HasQuotes
  from Posts
  where Id in (select PostId from originallyVulgar)
  and DeletionDate is null
  -- six root words you can't say on TV
  and ( Body like '%shit%' 
    or Body like '%piss%' 
    or Body like '%fuck%' 
    or Body like '%cunt%'
    or Body like '%cocksuck%'
    or Body like '%tits%' )
)

select (select count(*) from originallyVulgar) PostedBlue,
(select count(*) from stillVulgar) StillBlue,
(select count(*) from stillVulgar where HasQuotes=0) StillBlueNoQuotes

Enter Parameters

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