Changeset 2324 for trunk/admin/cat_options.php

Timestamp:

May 1, 2008, 3:12:34 AM (16 years ago)

Author:

rvelices

Message:

• move #categories.date_last and nb_images to #user_cache_categories

File:

• trunk/admin/cat_options.php (modified) (1 diff)

trunk/admin/cat_options.php

@@ -287 +287 @@
 ;';
     $query_false = '
-SELECT id,name,uppercats,global_rank
-  FROM '.CATEGORIES_TABLE.'
-  WHERE nb_images != 0
-    AND representative_picture_id IS NULL
+SELECT DISTINCT id,name,uppercats,global_rank
+  FROM '.CATEGORIES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id=category_id
+  WHERE representative_picture_id IS NULL
 ;';
     $template->assign(