From 68aa5bd7debf535353fe3c11f2d300f018de6457 Mon Sep 17 00:00:00 2001
From: Pradeep Nayak <pradpnayak@gmail.com>
Date: Wed, 12 Jul 2017 19:33:52 +0530
Subject: [PATCH] CRM-20857, fixed report for sql_mode=only_full_group_by

----------------------------------------
* CRM-20857: Deferred Revenue report -  DB Error: unknown error
  https://issues.civicrm.org/jira/browse/CRM-20857

fixed style
---
 CRM/Report/Form/Contribute/DeferredRevenue.php | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/CRM/Report/Form/Contribute/DeferredRevenue.php b/CRM/Report/Form/Contribute/DeferredRevenue.php
index 72f5a5e324..bf1c9ad3d7 100644
--- a/CRM/Report/Form/Contribute/DeferredRevenue.php
+++ b/CRM/Report/Form/Contribute/DeferredRevenue.php
@@ -384,6 +384,13 @@ class CRM_Report_Form_Contribute_DeferredRevenue extends CRM_Report_Form {
    */
   public function groupBy() {
     $this->_groupBy = "GROUP BY {$this->_aliases['civicrm_financial_account']}.id,  {$this->_aliases['civicrm_financial_account_1']}.id, {$this->_aliases['civicrm_financial_item']}.id";
+    $this->_select = CRM_Contact_BAO_Query::appendAnyValueToSelect(
+      $this->_selectClauses,
+      array(
+        "{$this->_aliases['civicrm_financial_account_1']}.id",
+        "{$this->_aliases['civicrm_financial_item']}.id",
+      )
+    );
   }
 
   /**
-- 
2.25.1