search TeX


Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

declare @symbolsearch nvarchar(200) = ##symbol:string##
--declare @tag nvarchar(35) = ##tag:string?r##

set @symbolsearch = replace(@symbolsearch,'[', '[[]');
set @symbolsearch = replace(@symbolsearch,'_', '[_]');
set @symbolsearch = replace(@symbolsearch,'\n', concat(char(13), char(10)));
set @symbolsearch = replace(@symbolsearch,'%', '[%]');

tagposts as (
from posts p
inner join posttags pt on pt.postid = coalesce(p.parentid,
inner join tags t on = pt.tagid
where tagname = @tag
posthistoryedits as (
  select ph.postid
       , max( [latestid]
  from posthistory ph 
  --inner join tagposts tp on = ph.postid
  where posthistorytypeid in (2,5)
  group by ph.postid
posthistorytext as (
  select ph.postid
       , ph.text
  from posthistory ph
  inner join posthistoryedits phe on phe.latestid =

select  top 200
       -- count(*) as [Post Link]
     , p.posttypeid
     , p.score
     , p.creationdate
     , p.tags
     , pht.text
--from tagposts tp  inner join posts p on =
from posts p
inner join posthistorytext pht on pht.postid =
--where pht.text like concat('%', @symbolsearch, '%')
--and ( pht.text like '%below%' or pht.text like '%under%')
and pht.text like '%compat=1.11%'
--where pht.text like '%rgb[\]}]{[0-9][0-9]%' escape '\'   
order by p.score desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results