0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created feb 6 jon.doe34463