From d41525393f820206a7a16c1838688ba59d63bd42 Mon Sep 17 00:00:00 2001
From: Web Access <rohan.katkar@webaccessglobal.com>
Date: Wed, 17 Feb 2016 18:53:30 +0530
Subject: [PATCH] CRM-17121: Advanced Search on Event Type OR Address returns
 only Event results

---
 CRM/Event/BAO/Query.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/CRM/Event/BAO/Query.php b/CRM/Event/BAO/Query.php
index 88b2d4c0b8..29dd6eab1b 100644
--- a/CRM/Event/BAO/Query.php
+++ b/CRM/Event/BAO/Query.php
@@ -466,7 +466,8 @@ class CRM_Event_BAO_Query {
         break;
 
       case 'civicrm_event':
-        $from = " INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id ";
+        //CRM-17121
+        $from = " LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id ";
         break;
 
       case 'event_type':
-- 
2.25.1