#0 SQL->sqlDie(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 '223,1356,1404,1447,1448,1899,1927)) GROUP BY `resourceId` ORDER BY `resourcecrea' at line 1, ) called at [/data02/c7212592/public_html/glass-study.org/biblio/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 (,223,1356,1404,1447,1448,1899,1927)) 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 (,223,1356,1404,1447,1448,1899,1927)) 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 [/data02/c7212592/public_html/glass-study.org/biblio/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 (,223,1356,1404,1447,1448,1899,1927)) 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 [/data02/c7212592/public_html/glass-study.org/biblio/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 (,223,1356,1404,1447,1448,1899,1927)) 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 [/data02/c7212592/public_html/glass-study.org/biblio/core/modules/list/LISTSOMERESOURCES.php:607] #4 LISTSOMERESOURCES->categoryProcess() called at [/data02/c7212592/public_html/glass-study.org/biblio/index.php:127]
\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '223,1356,1404,1447,1448,1899,1927)) GROUP BY `resourceId` ORDER BY `resourcecrea' at line 1