Biztalk SQL Queries: Get List of send ports details by send port uri ( location )

select

   app.nvcName as ApplicationName,
   sp.nvcName as SendPortName,
   sptp.nvcAddress as SPUri,
   sp.nvcFilter

from bts_sendport as  sp

inner join bts_sendport_transform as spt on  spt.nSendPortID =sp.nID
left join bts_sendport_transport  as sptp on sptp.nSendPortID = sp.nID
inner join bts_application as app on app.nID = sp.nApplicationID

where

sptp.nvcAddress like '%url%'