United States Affiliates

  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'

select 'Client.'+Security_Filters.SECURITY_MODE+
Security_Tables.TABLE_NAME TABLE_SECURITY,TABLE_ACCESSIBLE,TABLE_FILTER
from Security_Filters,Security_Tables
where UPPER(Security_Filters.SECURITY_GROUP) = ?
and Security_Filters.TABLE_NAME = Security_Tables.TABLE_NAME

select MEMBERSHIPLEVEL,MEETINGSLEVEL,SYSTEMLEVEL,DUESLEVEL,ORDERENTRYLEVEL,COMMUNITIESLEVEL,SECURITY_SEQ
from Security_Groups
where UPPER(SECURITY_GROUP) = ?

select isnull(datediff(s,last_Login, getdate()),1000) as LoginSeconds 
	from Name_Security where ID=''
	and '' > ''

		SELECT nd.last_updated
		FROM name_demographics nd
		WHERE nd.ID = ''
	

			SELECT ID
			FROM name_demographics
			WHERE
				ID = '' AND
				occupation = '' AND
				institute_type = '' AND
				interests = '' AND
				scope = '' AND
				sector = '' AND
				platform = '' AND
				handheld_computer = 0 AND
				hardware_decision = '' AND
				software_decision = '' AND
				age = '' AND
				gender = '' AND
				income = '' AND
				years_in_profession = '' AND
				home_zipcode = '' AND
				birth_year = 0
		

    SELECT a.*, b.Keywords, b.Description, b.MembersOnlyFlag
      FROM Content_HTML a, Content b
     WHERE a.ContentID = b.ContentID
       AND a.ContentID = ?