Unable to read database.
SELECT MAX(`downloadRatio`) AS `max` FROM (SELECT ROUND(AVG(`resourceattachmentsDownloads` / DATEDIFF(CURDATE(), `resourceattachmentsTimestamp`)), 3) AS `downloadRatio` FROM `wkx_resource_attachments` GROUP BY `resourceattachmentsResourceId`) AS `wkx_t`SELECT DISTINCT `resourcecreatorCreatorSurname` AS `creatorSurname`, `resourcemiscId` FROM (SELECT DISTINCT `resourceId`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTitleSort`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscAccesses`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcemiscAccessesPeriod` FROM `wkx_resource_misc` LEFT JOIN `wkx_resource_creator` ON `resourcecreatorResourceId` = `resourcemiscId` LEFT JOIN `wkx_resource` ON `resourceId` = `resourcemiscId` ORDER BY `resourceTitleSort` ASC LIMIT 360, 20) AS `wkx_t1` LEFT JOIN `wkx_resource_creator` ON `resourcecreatorResourceId` = `resourcemiscId` LEFT JOIN `wkx_resource_year` ON `resourceyearId` = `resourcemiscId` ORDER BY `resourceTitleSort` ASC, `creatorSurname` ASC, CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN (`resourceyearYear2`) ELSE `resourceyearYear1` END ASC LIMIT 0, 20--> (Expression #1 of ORDER BY clause is not in SELECT list, references column 'wkx_t1.resourceTitleSort' which is not in SELECT list; this is incompatible with DISTINCT)