From f9568db166555882e740016913dcf6a282878f55 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 14 Apr 2017 14:48:36 -0400
Subject: [PATCH] add distinct to help query

Seems to be taking a long time on dev55
---
 setup/adminHooks.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/setup/adminHooks.php b/setup/adminHooks.php
index a5c26ae..fd4bc74 100644
--- a/setup/adminHooks.php
+++ b/setup/adminHooks.php
@@ -83,7 +83,7 @@ add_filter('glm-member-db-admin-search-query', function() {
                 $field_name = preg_replace( '/[ -]/', '_', strtolower( $field['field_name'] ) );
                 if ( isset( $_REQUEST[$field_name] ) && filter_var( $_REQUEST[$field_name], FILTER_VALIDATE_BOOLEAN ) ) {
                     $queryParts[] = " T.id IN (
-                        SELECT member
+                        SELECT distinct(member)
                           FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_info
                          WHERE id IN (
                         SELECT ref_dest
-- 
2.17.1