- Error
-
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR category.parent_id = AND `category`.`section`="com_simplelists" AND category' at line 7 SQL=SELECT `category`.*, `usergroup`.`name` AS `accesslevel`, `user`.`name` AS `editor`, `parent`.`title` AS `parent_title`, `parent`.`checked_out` AS `parent_checked_out`,
CASE WHEN CHAR_LENGTH(`category`.`alias`) THEN CONCAT_WS(':', `category`.`id`, `category`.`alias`) ELSE `category`.`id` END AS `slug`
FROM `jos_categories` AS `category`
LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `category`.`parent_id`
LEFT JOIN `jos_groups` AS `usergroup` ON `usergroup`.`id`=`category`.`access`
LEFT JOIN `jos_users` AS `user` ON `user`.`id`=`category`.`checked_out`
WHERE category.id = OR category.parent_id = AND `category`.`section`="com_simplelists" AND category.published = 1
ORDER BY `category`.ordering, category.ordering
LIMIT 0,15
