diff options
| author | Christian Fowler <spider@viovio.com> | 2006-10-03 20:45:11 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2006-10-03 20:45:11 +0000 |
| commit | 9929ae7612b654b3de7623fb6a67c35922647b50 (patch) | |
| tree | 7dd31d56ec47b5d119e2bd419d52076ef9501c8c /FisheyeGallery.php | |
| parent | a7120db2ca8a060a3f25ad568ef6bfe4a3e45549 (diff) | |
| download | fisheye-9929ae7612b654b3de7623fb6a67c35922647b50.tar.gz fisheye-9929ae7612b654b3de7623fb6a67c35922647b50.tar.bz2 fisheye-9929ae7612b654b3de7623fb6a67c35922647b50.zip | |
move hits LEFT JOIN *after* INNER JOIN
Diffstat (limited to 'FisheyeGallery.php')
| -rw-r--r-- | FisheyeGallery.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FisheyeGallery.php b/FisheyeGallery.php index 30b2146..33a953f 100644 --- a/FisheyeGallery.php +++ b/FisheyeGallery.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.38 2006/09/15 02:44:57 spiderr Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.39 2006/10/03 20:45:11 spiderr Exp $ * @package fisheye */ @@ -609,8 +609,8 @@ vd( $this->mErrors ); $selectSql FROM `".BIT_DB_PREFIX."fisheye_gallery` fg INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON (fg.`content_id` = lc.`content_id`) - LEFT JOIN `".BIT_DB_PREFIX."liberty_content_hits` lch ON (lch.`content_id` = lc.`content_id`) INNER JOIN `".BIT_DB_PREFIX."users_users` uu ON (uu.`user_id` = lc.`user_id`) + LEFT JOIN `".BIT_DB_PREFIX."liberty_content_hits` lch ON (lch.`content_id` = lc.`content_id`) $mapJoin $joinSql LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content` plc ON (fg.`preview_content_id` = plc.`content_id`) $whereSql $sortSql"; |