From c8484da9e9d80f76689a2d47a0397a60c283dd71 Mon Sep 17 00:00:00 2001
From: "Donald A. Lobo" <lobo@civicrm.org>
Date: Fri, 19 Apr 2013 07:39:14 -0700
Subject: [PATCH] CRM-12385

----------------------------------------
* CRM-12385: SQL error in Payment Express Payment processing module
  http://issues.civicrm.org/jira/browse/CRM-12385
---
 extern/pxIPN.php | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/extern/pxIPN.php b/extern/pxIPN.php
index 25f5913172..ebc563912f 100644
--- a/extern/pxIPN.php
+++ b/extern/pxIPN.php
@@ -24,9 +24,10 @@ $config = CRM_Core_Config::singleton();
  */
 
 $query = "
-SELECT  url_site, password, user_name, signature 
-FROM    civicrm_payment_processor 
-WHERE   payment_processor_type = 'Payment_Express' 
+SELECT  url_site, password, user_name, signature
+FROM    civicrm_payment_processor
+LEFT JOIN civicrm_payment_processor_type ON civicrm_payment_processor_type.id = civicrm_payment_processor.payment_processor_type_id
+WHERE   civicrm_payment_processor_type.name = 'Payment_Express'
 AND     user_name = %1
 ";
 $params = array(1 => array($_GET['userid'], 'String'));
-- 
2.25.1