USP_SIMPLEDATALIST_SEARCHHISTORYUSERS

                create procedure dbo.USP_SIMPLEDATALIST_SEARCHHISTORYUSERS
                as
                set nocount on;
                select distinct
                    coalesce(C.NAME,A.USERNAME) as VALUE,
                    coalesce(C.NAME,A.USERNAME) as LABEL
                from 
                    dbo.WPSEARCHHISTORY H
                inner join dbo.APPUSER A on A.ID=H.APPUSERID
                left outer join dbo.CONSTITUENT C on C.ID=A.CONSTITUENTID