select * from Posts Q, Posts A where Q.PostTypeId = 1 and...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select * from Posts Q, Posts A
where Q.PostTypeId = 1
and A.PostTypeID = 2
and Q.Id = A.ParentId
and Q.Tags like '%<java>%'
and Q.AcceptedAnswerId > 0
and Q.CreationDate <= '2018-12-31 11:11:59'
order by Q.Id asc

Enter Parameters

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