Select l.Id, l.PostId AS q1Id, r.Title AS q1Title, r.Body...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantitative Finance

Q&A for finance professionals and academics

Select l.Id, l.PostId AS q1Id, r.Title AS q1Title, r.Body AS q1Body,r.PostTypeId, l.RelatedPostId AS q2Id, p.Title AS q2Title, p.Body AS q2Body,p.PostTypeId, LinkTypeId AS type from PostLinks AS l
JOIN Posts r ON r.Id = l.PostId 
JOIN Posts p ON p.Id = l.RelatedPostId
AND l.Id>1
WHERE p.Tags LIKE '%<##java##>%' AND r.Tags LIKE '%<##java##>%'
order by l.Id asc

Enter Parameters

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