select * from Users as u , (select * from Posts) a , (se...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--'##PostTypeId##'

select * from Users as u ,
(select * from Posts) a ,
 (select * from Posts where tags like '%youtube-api%' 
 and PostTypeId like '%1%' 
 and Body like '%##Question_Body##%') q where 
 a.ParentId = q.Id and 
 u.Id = q.OwnerUserId   
 
 -- q refer to parent (questions) and a refer to answers

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results