From e123585dde33f8ec3be13e788eea6fc10041920f Mon Sep 17 00:00:00 2001 From: rvelices Date: Mon, 17 Jan 2011 21:16:42 +0000 Subject: bug 2105 : Browsing tags is slow if tags contains many photos git-svn-id: http://piwigo.org/svn/trunk@8726 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/section_init.inc.php | 15 --------------- 1 file changed, 15 deletions(-) (limited to 'include/section_init.inc.php') diff --git a/include/section_init.inc.php b/include/section_init.inc.php index 02b1f83ab..7f0cbf96d 100644 --- a/include/section_init.inc.php +++ b/include/section_init.inc.php @@ -321,21 +321,6 @@ else $items = get_image_ids_for_tags($page['tag_ids']); - // permissions depends on category, so to only keep images that are - // reachable to the connected user, we need to check category - // associations - if (!empty($items) ) - { - $query = ' -SELECT DISTINCT image_id - FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON image_id=id - WHERE image_id IN ('.implode(',', $items).') - '.$forbidden. - $conf['order_by'].' -;'; - $items = array_from_query($query, 'image_id'); - } - $page = array_merge( $page, array( -- cgit v1.2.3