diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2005-11-03 16:08:54 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2005-11-03 16:08:54 +0000 |
| commit | 290783fc4afa2bb8571f77ad1077039ec35a841d (patch) | |
| tree | 2a38584889c11416f66e08795d501e592c973914 /Pigeonholes.php | |
| parent | 0865333b00c4eaeb4d96109dfb14a9b3de54f7a9 (diff) | |
| download | pigeonholes-290783fc4afa2bb8571f77ad1077039ec35a841d.tar.gz pigeonholes-290783fc4afa2bb8571f77ad1077039ec35a841d.tar.bz2 pigeonholes-290783fc4afa2bb8571f77ad1077039ec35a841d.zip | |
add parenthesis for DISTINCT()
Diffstat (limited to 'Pigeonholes.php')
| -rw-r--r-- | Pigeonholes.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Pigeonholes.php b/Pigeonholes.php index 8aa1fb8..5c65342 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.9 2005/10/28 19:08:19 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.10 2005/11/03 16:08:54 squareing Exp $ * * +----------------------------------------------------------------------+ * | Copyright ( c ) 2004, bitweaver.org @@ -17,7 +17,7 @@ * Pigeonholes class * * @author xing <xing@synapse.plus.com> - * @version $Revision: 1.9 $ + * @version $Revision: 1.10 $ * @package pigeonholes */ @@ -180,7 +180,7 @@ class Pigeonholes extends LibertyAttachable { $bindVars = array(); if( !$pIncludeMembers ) { - $where .= "WHERE tc.`content_id` NOT IN ( SELECT DISTINCT `content_id` FROM `".BIT_DB_PREFIX."bit_pigeonhole_members` )"; + $where .= "WHERE tc.`content_id` NOT IN ( SELECT DISTINCT( `content_id` ) FROM `".BIT_DB_PREFIX."bit_pigeonhole_members` )"; } if( !empty( $pListHash['find'] ) && is_string( $pListHash['find'] ) ) { |