How could I retrieve a list if one or more conditions exist? One and more accounts have the same street address OR One and more accounts has the same first and last name OR One and more accounts has the same email address Either through amember v4 filters or SQL query.
Here is query which you can use: select * from am_user where concat(name_f, name_l) in (select q.name from (select concat(u.name_f, u.name_l) as name, count(u.user_id) as count from am_user u group by name having count >1) as q) union select * from am_user where street in (select q1.street from (select u1.street, count(u1.user_id) as count from am_user u1 group by street having count >1) as q1) union select * from am_user where email in (select q2.email from (select u2.email, count(u2.user_id) as count from am_user u2 group by email having count >1) as q2)