From 99c00f76e68c37f0a11ee3968bcb79d71e5b88fa Mon Sep 17 00:00:00 2001
From: Dave Greenberg <dave@civicrm.org>
Date: Sun, 20 Dec 2015 18:36:34 -0800
Subject: [PATCH] CRM-15967 - Fix profile state/province sort.

----------------------------------------
* CRM-15967: profile: cannot sort state/province
  https://issues.civicrm.org/jira/browse/CRM-15967
---
 CRM/Contact/BAO/Query.php | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php
index 327903ca48..2eb403bbd7 100644
--- a/CRM/Contact/BAO/Query.php
+++ b/CRM/Contact/BAO/Query.php
@@ -4598,6 +4598,9 @@ civicrm_relationship.is_permission_a_b = 0
     // CRM-15231
     $this->_sort = $sort;
 
+    //CRM-15967
+    $this->includePseudoFieldsJoin($sort);
+
     list($select, $from, $where, $having) = $this->query($count, $sortByChar, $groupContacts, $onlyDeleted);
 
     if ($additionalWhereClause) {
-- 
2.25.1