CREATE   PROCEDURE [dbo].[usp_GetSECUserRegistrations]

AS

Select 
       Registered,
       a.UserID_Pk,
       Username,
       UserStatusID_FK
 FROM  sec_user a,
       sec_userproperties b,
       sec_userstatus c
 WHERE a.userid_pk = b.userid_pk
   AND a.userstatusid_fk = c.userstatusid_pk
   AND a.UserStatusID_FK = '3'
GO