add pListHash['join_sql'] to getContentList

1 files changed, 5 insertions, 1 deletions

diff --git a/includes/classes/LibertyContent.php b/includes/classes/LibertyContent.php
index 4c148df..4fe00b2 100644
--- a/includes/classes/LibertyContent.php
+++ b/includes/classes/LibertyContent.php
@@ -2522,6 +2522,7 @@ class LibertyContent extends LibertyBase implements BitCacheable {
 
 		$hashSql = array('select'=>array(), 'join'=>array(),'where'=>array() );
 		$hashBindVars = array('select'=>array(), 'where'=>array(), 'join'=>array());
+
 		if( !empty( $pListHash['content_type_guid'] ) && is_array( $pListHash['content_type_guid'] )) {
 			foreach( $pListHash['content_type_guid'] as $contentTypeGuid ) {
 				$this->getFilter( $contentTypeGuid, $hashSql, $hashBindVars, $pListHash );
@@ -2536,6 +2537,10 @@ class LibertyContent extends LibertyBase implements BitCacheable {
 			$selectSql = '';
 		}
 		$joinSql = implode( ' ', $hashSql['join'] );
+		if( !empty( $pListHash['join_sql'] ) ) {
+			$joinSql .= $pListHash['join_sql'];
+		}
+
 		$whereSql = '';
 		if( empty( $hashBindVars['join'] )) {
 			$bindVars = array();
@@ -2773,7 +2778,6 @@ class LibertyContent extends LibertyBase implements BitCacheable {
 			$pListHash['offset'] = $pListHash['max_records'] * $lastPageNumber;
 		}
 
-
 		if( !empty( $hashBindVars['select'] ) ) {
 			$bindVars = array_merge($hashBindVars['select'], $bindVars);
 		}