From 1d8bcac7cca8d02d8705038928fff14a7e3859b4 Mon Sep 17 00:00:00 2001 From: Max Kremmel Date: Wed, 1 Feb 2006 19:01:49 +0000 Subject: unify table aliases --- Pigeonholes.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'Pigeonholes.php') diff --git a/Pigeonholes.php b/Pigeonholes.php index fb042ea..c1ce0f6 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ - * @version $Revision: 1.34 $ + * @version $Revision: 1.35 $ * @package pigeonholes */ @@ -125,8 +125,8 @@ class Pigeonholes extends LibertyAttachable { if( !empty( $pListHash['title'] ) && is_string( $pListHash['title'] ) ) { $where .= empty( $where ) ? ' WHERE ' : ' AND '; - $where .= " pig.`content_id` = tc2.`content_id` AND UPPER( tc2.`title` ) = ?"; - $join = ", `".BIT_DB_PREFIX."liberty_content` tc2"; + $where .= " pig.`content_id` = lc2.`content_id` AND UPPER( lc2.`title` ) = ?"; + $join = ", `".BIT_DB_PREFIX."liberty_content` lc2"; $bindVars[] = strtoupper( $pListHash['title'] ); } -- cgit v1.3