HP ALM Query required

I need a HP ALM SQL query for extracting all Test Cases from a Folder in Test lab along with execution status, Folder path , test cycle name and LINKED DEFECT (if any)