[Exception]: [42601] [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ")" was found following "D C.CATEGORY_ID IN (". Expected tokens may include: "<value_expr_body>". SQLSTATE=42601 [Info: SELECT ID, NAME, ROW_NUMBER FROM (SELECT ARTIST.ID, ARTIST.NAME, ROWNUMBER() OVER (ORDER BY ARTIST.NAME) AS ROW_NUMBER FROM STORE_ARTIST_ITEM AS A,STORE_RELATION_ITEM_CATEGORY AS C,STORE_ARTIST AS ARTIST WHERE A.MERCHANT_ID=1 AND C.MERCHANT_ID=1 AND ARTIST.MERCHANT_ID=1 AND A.ITEM_ID=C.ITEM_ID AND A.ARTIST_ID=ARTIST.ID AND C.CATEGORY_ID IN () AND ARTIST.ID NOT IN (38044,39027,149084,43106,152397,154388,155373,58707,68934,73895,93477) GROUP BY ARTIST.ID, ARTIST.NAME ORDER BY ARTIST.NAME FETCH FIRST 28 ROWS ONLY) WHERE ROW_NUMBER BETWEEN 1 AND 28 WITH UR]
/home/www/htdocs/desian/src/contrib/php.d.lib/classes/db/adapter/DBAdapterDB2.php [line:331]
DBAdapterDB2::getRows("SELECT ID, NAME, ROW_N...");
/home/www/htdocs/desian/src/applications/frontend/classes/templates/components/navigation/SFCArtistList.php[line:172]
SFCArtistList::action();
/home/www/htdocs/desian/src/applications/frontend/classes/templates/components/container/AbstractSFContainer.php[line:44]
AbstractSFContainer::action();
/home/www/htdocs/desian/src/applications/frontend/classes/templates/components/container/SFCBox.php[line:53]
SFCBox::action();
/home/www/htdocs/desian/src/applications/frontend/classes/templates/components/container/AbstractSFContainer.php[line:44]
AbstractSFContainer::action();
/home/www/htdocs/desian/src/applications/frontend/classes/templates/pages/AbstractSFPage.php[line:881]
AbstractSFPage::componentContainerAction();
/home/www/htdocs/desian/src/applications/frontend/classes/templates/pages/merch/SFPMerchHome.php[line:102]
SFPMerchHome::action();
/home/www/htdocs/desian/src/applications/frontend/sites/abella/classes/templates/layout/default/DLayoutDefault.php[line:247]
DLayoutDefault::action();
/home/www/htdocs/desian/src/applications/frontend/classes/application/SFApplication.php[line:411]
SFApplication::run();
/home/www/htdocs/desian/src/applications/frontend/sites/abella/www/index.php[line:11]