diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-01-19 21:18:34 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-01-19 21:18:34 +0000 |
| commit | 982bc009b6879ea78d0fd1eec6469c713be2f1dc (patch) | |
| tree | 791dfa8fc38e5286c19cca894843a4a30f502ed7 /include/functions_category.inc.php | |
| parent | b81a4dbc62f9746b5861fd2d472b79f8a410c8dd (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.php | 4 |
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.= ';'; |