From ba9d40b96bcfe823c64a1a2cf7bd5f50c4278bfc Mon Sep 17 00:00:00 2001
From: Ravish Nair <ravish.nair@webaccess.co.in>
Date: Tue, 9 Apr 2013 20:06:58 +0530
Subject: [PATCH] -- Batch transaction page minor fix(Query Syntax error)

---
 CRM/Batch/BAO/Batch.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Batch/BAO/Batch.php b/CRM/Batch/BAO/Batch.php
index 2501cc9b57..d203cbd134 100644
--- a/CRM/Batch/BAO/Batch.php
+++ b/CRM/Batch/BAO/Batch.php
@@ -710,7 +710,7 @@ LEFT JOIN civicrm_contribution_soft ON civicrm_contribution_soft.contribution_id
     }
     if (!empty($query->_where[0])) {
       $where = implode(' AND ', $query->_where[0]) .
-        "AND civicrm_entity_batch.batch_id IS NULL
+        " AND civicrm_entity_batch.batch_id IS NULL
          AND civicrm_entity_financial_trxn.entity_table = 'civicrm_contribution'";
       $searchValue = TRUE;
     }
-- 
2.25.1