From daa81ba14c5f9b51047ce5a05f5b286446bdd59f Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Tue, 19 Jul 2016 13:08:50 -0400 Subject: [PATCH] Update query for speed don't use the outer join --- Toolkit/Members/SearchQueryGenerator.php | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) diff --git a/Toolkit/Members/SearchQueryGenerator.php b/Toolkit/Members/SearchQueryGenerator.php index 6263221..1418b35 100644 --- a/Toolkit/Members/SearchQueryGenerator.php +++ b/Toolkit/Members/SearchQueryGenerator.php @@ -172,6 +172,7 @@ class Toolkit_Members_SearchQueryGenerator */ public function getQuery(PDO $dbh, array $sections = null) { + /* $sql = " SELECT distinct m.*, c.city_name, s.state_name AS state, s.state_abb AS state_abbr @@ -179,11 +180,18 @@ class Toolkit_Members_SearchQueryGenerator LEFT OUTER JOIN state s ON m.state_id = s.state_id LEFT OUTER JOIN city c ON m.city_id = c.city_id, exploded_members_name emn"; + */ + $sql = " + SELECT m.*, c.city_name, s.state_name AS state, s.state_abb as state_abbr + FROM member m, state s, city c"; $params = array( - "new_member <> '1'", - "active = '1'", - 'emn.mid = m.member_id'); + 'm.city_id = c.city_id', + 'm.state_id = s.state_id', + "m.new_member <> '1'", + "m.active = '1'", + //'emn.mid = m.member_id' + ); // Limit to members whose first letter starts with the letter // a user clicked in the narrow alphabetically list. if (isset($_REQUEST['alpha']) && $_REQUEST['alpha'] == '0-9') { -- 2.17.1