#0  SQL->sqlDie(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTit' at line 1, ) called at [/var/www/html/public/vharmony/public/wikindx/core/sql/SQL.php:3106]
#1  SQL->internalQuery(SELECT  `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscAccesses`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcemiscAccessesPeriod`, `resourcecreatorCreatorSurname` FROM wkx_resource   LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`)  ELSE (`resourcemiscAddUserIdResource`) END WHERE (`resourceId`  IN ()) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTitleSort` ,  REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3`  ELSE (`resourceyearYear1`) END, '{', ''), '}', '')  LIMIT 0, 20, , SELECT  `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscAccesses`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcemiscAccessesPeriod`, `resourcecreatorCreatorSurname` FROM wkx_resource   LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`)  ELSE (`resourcemiscAddUserIdResource`) END WHERE (`resourceId`  IN ()) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTitleSort` ,  REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3`  ELSE (`resourceyearYear1`) END, '{', ''), '}', '')  LIMIT 0, 20) called at [/var/www/html/public/vharmony/public/wikindx/core/sql/SQL.php:239]
#2  SQL->query(SELECT  `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscAccesses`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcemiscAccessesPeriod`, `resourcecreatorCreatorSurname` FROM wkx_resource   LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`)  ELSE (`resourcemiscAddUserIdResource`) END WHERE (`resourceId`  IN ()) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTitleSort` ,  REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3`  ELSE (`resourceyearYear1`) END, '{', ''), '}', '')  LIMIT 0, 20, 1) called at [/var/www/html/public/vharmony/public/wikindx/core/lists/LISTCOMMON.php:197]
#3  LISTCOMMON->display(SELECT  `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscAccesses`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcemiscAccessesPeriod`, `resourcecreatorCreatorSurname` FROM wkx_resource   LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`)  ELSE (`resourcemiscAddUserIdResource`) END WHERE (`resourceId`  IN ()) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTitleSort` ,  REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3`  ELSE (`resourceyearYear1`) END, '{', ''), '}', '')  LIMIT 0, 20, list) called at [/var/www/html/public/vharmony/public/wikindx/core/modules/list/LISTSOMERESOURCES.php:574]
#4  LISTSOMERESOURCES->typeProcess() called at [/var/www/html/public/vharmony/public/wikindx/index.php:127]

\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY `resourceId` ORDER BY `resourcecreatorCreatorSurname` , `resourceTit' at line 1