#0  SQL->sqlDie(Unknown column 'resourceId' in 'field list', ) called at [/home/wikindx/www/gameaudio/core/libs/SQL.php:2829]
#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`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT  `rId`,ROUND( `count` / DATEDIFF(CURRENT_DATE, `resourcetimestampTimestampAdd`), 4) AS `index` FROM (SELECT  SUM(`statisticsresourceviewsCount`) AS `count`, `resourcetimestampTimestampAdd`, `statisticsresourceviewsResourceId` AS rId FROM wkx_statistics_resource_views   LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `statisticsresourceviewsResourceId` GROUP BY `statisticsresourceviewsResourceId`)  AS wkx_t   ORDER BY `index`  DESC  LIMIT 0, 20)  AS wkx_t1  LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` 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 GROUP BY `resourceId` ORDER BY `index`  DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`)  DESC, `resourceTitleSort`  DESC,  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, '{', ''), '}', '')  DESC, ) called at [/home/wikindx/www/gameaudio/core/libs/SQL.php:261]
#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`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT  `rId`,ROUND( `count` / DATEDIFF(CURRENT_DATE, `resourcetimestampTimestampAdd`), 4) AS `index` FROM (SELECT  SUM(`statisticsresourceviewsCount`) AS `count`, `resourcetimestampTimestampAdd`, `statisticsresourceviewsResourceId` AS rId FROM wkx_statistics_resource_views   LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `statisticsresourceviewsResourceId` GROUP BY `statisticsresourceviewsResourceId`)  AS wkx_t   ORDER BY `index`  DESC  LIMIT 0, 20)  AS wkx_t1  LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` 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 GROUP BY `resourceId` ORDER BY `index`  DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`)  DESC, `resourceTitleSort`  DESC,  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, '{', ''), '}', '')  DESC, 1) called at [/home/wikindx/www/gameaudio/core/lists/LISTCOMMON.php:185]
#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`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT  `rId`,ROUND( `count` / DATEDIFF(CURRENT_DATE, `resourcetimestampTimestampAdd`), 4) AS `index` FROM (SELECT  SUM(`statisticsresourceviewsCount`) AS `count`, `resourcetimestampTimestampAdd`, `statisticsresourceviewsResourceId` AS rId FROM wkx_statistics_resource_views   LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `statisticsresourceviewsResourceId` GROUP BY `statisticsresourceviewsResourceId`)  AS wkx_t   ORDER BY `index`  DESC  LIMIT 0, 20)  AS wkx_t1  LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` 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 GROUP BY `resourceId` ORDER BY `index`  DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`)  DESC, `resourceTitleSort`  DESC,  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, '{', ''), '}', '')  DESC, list) called at [/home/wikindx/www/gameaudio/core/modules/list/LISTRESOURCES.php:182]
#4  LISTRESOURCES->processGeneral() called at [/home/wikindx/www/gameaudio/core/modules/list/LISTRESOURCES.php:125]
#5  LISTRESOURCES->__construct() called at [/home/wikindx/www/gameaudio/index.php:106]
Unknown column 'resourceId' in 'field list'