select II.ItemID, dbo.ve_GetPath(II.[ItemID]), Text from Parts PP
join Items II on II.ItemID=PP.ItemID
join Contents CC on II.ContentID = CC.ContentID

where FromType=7