spSiteImages

            CREATE procedure [dbo].[spSiteImages]
            (
                @ClientSitesID int
            )
            as
                select * 
                FROM dbo.SiteImages IMG
                INNER JOIN dbo.SiteFolders F ON F.FolderID = IMG.FolderID
                WHERE IMG.ClientSitesID=@ClientSitesID AND IMG.Deleted=0
                ORDER BY F.FolderName, IMG.Name