0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

select top 10000 p.Id, SUBSTRING(p.Body,CHARINDEX('<pre',p.Body),CHARINDEX('</pre>',p.Body)-CHARINDEX('<pre',p.Body)) as Logs, PATINDEX('<pre%.%Exception:%</pre>', p.Body) as indexx, CHARINDEX('<pre%.%Exception:%</pre>',p.Body) as test
from Posts p
join Posts a on p.AcceptedAnswerid = a.Id
where p.PostTypeId = 1
and p.Body like '%<pre%'
and p.Body like '%.%Exception:%'
and p.Tags like '%java%'
and p.Tags not like '%javascript%'
and p.Title like '%Exception%'
and p.Score > 0

fork query

edited jun 18

created jun 18 anonymous