SELECT DISTINCT W.FullURL as WebURL, D.DirName,
D.LeafName, tp_ID As WebPartSK ,WP.tp_WebPartTypeId
FROM dbo.Docs D WITH (nolock)
INNER JOIN dbo.Webs W WITH (nolock) ON D.WebID = W.Id
INNER JOIN dbo.WebParts WP WITH (nolock) ON D.Id = WP.tp_PageUrlID
WHERE WP.tp_WebPartTypeId = (GUID)
No comments:
Post a Comment