From 982bc009b6879ea78d0fd1eec6469c713be2f1dc Mon Sep 17 00:00:00 2001 From: z0rglub Date: Mon, 19 Jan 2004 21:18:34 +0000 Subject: 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 --- include/functions_category.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include/functions_category.inc.php') 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.= ';'; -- cgit v1.2.3