PROC_GenericPagingProcedure '[RESI].[dbo].[BLOGS_Posts] ','BLOGPOSTID','CAST(ISNULL(PublishDate, GETDATE()) AS DATETIME) DESC, BLOGPOSTID DESC','1','10','BLOGPOSTID,[MetaDescription],[MetaKeywords],PublishDate,PublishTime,Title,Post,GalleryID,ParentBlogPostId ','(USERNAME = ''0704355'') AND Published = ''1'' AND EXISTS (SELECT ''x'' FROM BLOGS_X_Labels INNER JOIN BLOGS_Labels ON BLOGS_X_Labels.LabelID = BLOGS_Labels.LabelID WHERE BLOGS_X_Labels.BlogPostID = BLOGS_Posts.BlogPostID AND BLOGS_Labels.Label LIKE ''OCEANA%BAL%HARBOUR'') ',NULL,NULL