Q&A about the site 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