From 9472466ddfb3d6faf25bb5a52ddea87a94a66f89 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 11 Jun 2018 16:04:07 -0400 Subject: [PATCH] Update to use outer join on city Put city into outer join --- classes/data/dataMemberInfo.php | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/classes/data/dataMemberInfo.php b/classes/data/dataMemberInfo.php index 56600ed4..ed583356 100644 --- a/classes/data/dataMemberInfo.php +++ b/classes/data/dataMemberInfo.php @@ -821,12 +821,11 @@ class GlmDataMemberInfo extends GlmDataAbstract T.short_descr FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "member_info T - LEFT OUTER JOIN ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "regions R ON (R.id = T.region), - ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "members M, - ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "cities C + LEFT OUTER JOIN ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "regions R ON (R.id = T.region) + LEFT OUTER JOIN ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "cities C ON (C.id = T.city), + ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "members M WHERE M.id = T.member - AND C.id = T.city "; if ($where != '') { $sql .= "AND $where"; -- 2.17.1