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:%', p.Body) as indexx 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