Biztalk : Listing all BizTalk Pipeline using T SQL script

SELECT E.Name,E.FullyQualifiedName, * 

FROM BizTalkMgmtDb.dbo.bts_component AS A,

BizTalkMgmtDb.dbo.bts_stage_config AS B,

BizTalkMgmtDb.dbo.bts_pipeline_stage AS C,

BizTalkMgmtDb.dbo.bts_pipeline_config AS D,

BizTalkMgmtDb.dbo.BTS_Pipeline AS E

WHERE A.id=B.CompId                              

AND B.stageId=C.id                              

AND  C.id=D.StageId

AND D.PipeLineId=E.id                                 

--AND A.Name like  ('%ESB%')