USP_DATALIST_IMAGEFOLDERS

create procedure dbo.USP_DATALIST_IMAGEFOLDERS
(
    @ClientSitesID int
)
as
    set nocount on;

    select FolderID, FolderName, ParentFolderID, Guid 
    from dbo.SiteFolders
    where 
      ClientSitesID = @ClientSitesID 
      and Type = 2 
      and deleted = 0