Questions with Possible Java Exception Logs and Accepted Answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

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:%', 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

Enter Parameters

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