0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select top 10000 p.Id, p.Title, p.Score, p.Body as Question, a.Body as Answer
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.Body like '%Caused By:%'
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 19

created jun 18 19 anonymous