From 50f5c4ca3f59d1aad98ab2ab50bfd2bfca5fb888 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 11 Jun 2018 15:57:51 -0400 Subject: [PATCH] Fix issue on mapItems for members without regions. Using left outer join on region table. --- 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 58412b18..56600ed4 100644 --- a/classes/data/dataMemberInfo.php +++ b/classes/data/dataMemberInfo.php @@ -820,14 +820,13 @@ class GlmDataMemberInfo extends GlmDataAbstract T.logo, T.short_descr FROM - ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "member_info T, + ".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, - ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "regions R + ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "cities C WHERE M.id = T.member AND C.id = T.city - AND R.id = T.region "; if ($where != '') { $sql .= "AND $where"; -- 2.17.1