Непойманое исключение

SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) ORDER BY `lft` ASC' at line 1

Problem in query: SELECT `node`.`id`, `node`.`name`, `node`.`url`, `node`.`lvl`, (SELECT `rc_catalog_rubrics`.`id` FROM `rc_catalog_rubrics` WHERE (node.`lft` BETWEEN `lft`+1 AND `rgt`) ORDER BY `lft` DESC LIMIT 1) AS `parent` FROM `rc_catalog_rubrics` AS `node` WHERE (id IN ()) ORDER BY `lft` ASC

Stack trace