USP_GET_USERLOGINPARTINFO_BYPAGEID

        create procedure USP_GET_USERLOGINPARTINFO_BYPAGEID(@PAGEID int)
        as
        begin
            if exists(select 1 from dbo.SitePages where ID = @PAGEID and DELETED <>1)
            begin
                select SIP.FORGOTTENPWDTEMPLATEID ForgottenPWDTemplateID, SIP.NEWUSERTEMPLATEID NewUserTemplateID
                from dbo.PAGECONTENT as PC
                inner join dbo.SITECONTENT as SC on SC.ID = PC.SITECONTENTID
                inner join dbo.SIGNINPROPERTIES as SIP on SIP.CONTENTID = SC.ID
                where PC.SITEPAGESID =@PAGEID and SC.CONTENTTYPESID =33 and SC.DELETED <>1
                order by SC.ID desc
            end
        end