Table 'trustper.#' doesn't exist SQL=SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM sb6wd_jdownloads_categories as c LEFT JOIN sb6wd_jdownloads_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN `#` AS files ON files.`cat_id` = c.id AND files.published = 1 LEFT JOIN sb6wd_users AS u on u.id = files.created_id LEFT JOIN sb6wd_users AS u2 on u2.id = files.modified_id LEFT JOIN sb6wd_menu AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id,'%') AND menu.published = 1 AND menu.access IN (1,1,5) WHERE c.access IN (1,1,5) AND c.published = 1 AND s.id=4 GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots, c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id ORDER BY c.lft