Index: openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	8 Nov 2010 23:09:10 -0000	1.8
+++ openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	30 May 2018 15:44:09 -0000	1.9
@@ -3,22 +3,6 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="get_states">      
-      <querytext>
-      select u.email_verified_p as email_verified_p_old,
-          mr.member_state as member_state_old,
-          per.first_names || ' ' || per.last_name as name,
-          part.email, mr.rel_id
-      from users u
-      JOIN parties part on (part.party_id = u.user_id)
-        JOIN persons per on (per.person_id = u.user_id)
-      LEFT JOIN membership_rels mr on (mr.rel_id = u.user_id)
-      where u.user_id = :user_id
-      
-      </querytext>
-</fullquery>
-
-
 <fullquery name="approve_email">
 	<querytext>
 	select acs_user__approve_email (:user_id);