aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-01-19 21:18:34 +0000
committerz0rglub <z0rglub@piwigo.org>2004-01-19 21:18:34 +0000
commit982bc009b6879ea78d0fd1eec6469c713be2f1dc (patch)
tree791dfa8fc38e5286c19cca894843a4a30f502ed7 /include/functions_category.inc.php
parentb81a4dbc62f9746b5861fd2d472b79f8a410c8dd (diff)
Performances improved : replacing the useless LEFT JOIN by INNER JOIN
git-svn-id: http://piwigo.org/svn/branches/release-1_3@301 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'include/functions_category.inc.php')
-rw-r--r--include/functions_category.inc.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index b46f57ddc..dec7a7bf8 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -494,7 +494,7 @@ function initialize_category( $calling_page = 'category' )
$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_images';
$query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic';
+ $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category AS ic';
$query.= ' ON id = ic.image_id';
$query.= $page['where'];
$query.= ';';
@@ -528,7 +528,7 @@ function initialize_category( $calling_page = 'category' )
$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_images';
$query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic';
+ $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category AS ic';
$query.= ' ON id = ic.image_id';
$query.= $page['where'];
$query.= ';';