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 ') AND rb_assortment_category.status = 1 ORDER BY `rb_assortment_category`.`ord' at line 1 SQL: SELECT `rb_assortment_category`.* FROM rb_assortment_category WHERE 1 AND rb_assortment_category.id IN() AND rb_assortment_category.status = 1 ORDER BY `rb_assortment_category`.`ordering` ASC