Changeset 1971
- Timestamp:
- Apr 22, 2007, 6:19:16 PM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/category_cats.inc.php
r1970 r1971 164 164 MAX(date_creation) AS date_creation_max 165 165 FROM '.IMAGE_CATEGORY_TABLE.' 166 INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.' 167 ON category_id = cat_id and user_id = '.$user['id'].' 166 168 INNER JOIN '.IMAGES_TABLE.' ON image_id = id 167 169 WHERE category_id IN ('.implode(',', $category_ids).') 170 '.get_sql_condition_FandF 171 ( 172 array 173 ( 174 'visible_categories' => 'category_id', 175 'visible_images' => 'image_id' 176 ), 177 'AND' 178 ).' 168 179 GROUP BY category_id 169 180 ;';
Note: See TracChangeset
for help on using the changeset viewer.