Die on dbQ execute
Query: SELECT * FROM ( SELECT `dudetype`, `recordtype`, `filtertype`, `cnt` FROM ( (SELECT 'author' AS `dudetype`, `kentavr-books`.`book`.`booktype` AS `recordtype`, `kentavr-books`.`book`.`cleanvalue`, CONCAT_WS('@', `kentavr-books`.`book`.`booktype`, 'author') AS `filtertype`, COUNT(*) AS `cnt` FROM `kentavr-books`.`book` INNER JOIN `kentavr-books`.`author2book` ON (`kentavr-books`.`book`.`url` = `kentavr-books`.`author2book`.`url-book`) INNER JOIN `kentavr-books`.`author` ON (`kentavr-books`.`author2book`.`url-author` = `kentavr-books`.`author`.`url` AND `kentavr-books`.`author`.`url` = ? ) WHERE ( `kentavr-books`.`book`.`booktype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') ) AND `kentavr-books`.`book`.`url` > '' GROUP BY `filtertype` ) AS `author-records-books`) UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, `cnt` FROM ( (SELECT 'creator' AS `dudetype`, `kentavr-books`.`book`.`booktype` AS `recordtype`, `kentavr-books`.`book`.`cleanvalue`, CONCAT_WS('@', `kentavr-books`.`book`.`booktype`, 'creator') AS `filtertype`, COUNT(*) AS `cnt` FROM `kentavr-books`.`book` INNER JOIN `kentavr-books`.`creator2book` ON (`kentavr-books`.`book`.`url` = `kentavr-books`.`creator2book`.`url-book`) INNER JOIN `kentavr-books`.`creator` ON (`kentavr-books`.`creator2book`.`url-creator` = `kentavr-books`.`creator`.`url` AND `kentavr-books`.`creator`.`url` = ? ) WHERE ( `kentavr-books`.`book`.`booktype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') ) AND `kentavr-books`.`book`.`url` > '' GROUP BY `filtertype` ) AS `creator-records-books`) GROUP BY `filtertype` UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, `cnt` FROM ( (SELECT 'person' AS `dudetype`, `kentavr-books`.`book`.`booktype` AS `recordtype`, `kentavr-books`.`book`.`cleanvalue`, CONCAT_WS('@', `kentavr-books`.`book`.`booktype`, 'person') AS `filtertype`, COUNT(*) AS `cnt` FROM `kentavr-books`.`book` INNER JOIN `kentavr-books`.`person2book` ON (`kentavr-books`.`book`.`url` = `kentavr-books`.`person2book`.`url-book`) INNER JOIN `kentavr-books`.`person` ON (`kentavr-books`.`person2book`.`url-person` = `kentavr-books`.`person`.`url` AND `kentavr-books`.`person`.`url` = ? ) WHERE `kentavr-books`.`book`.`url` > '' AND ( `kentavr-books`.`book`.`booktype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') ) GROUP BY `filtertype` ) AS `person-records-books`) GROUP BY `filtertype` UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, COUNT(*) AS `cnt` FROM ( (SELECT 'author' AS `dudetype`, `kentavr-opera`.`opus`.`opustype` AS `recordtype`, `kentavr-opera`.`opus`.`cleanvalue`, CONCAT_WS('@', `kentavr-opera`.`opus`.`opustype`, 'author') AS `filtertype` FROM `kentavr-opera`.`opus` INNER JOIN `kentavr-opera`.`author2opus` ON (`kentavr-opera`.`author2opus`.`url-opus` = `kentavr-opera`.`opus`.`url`) INNER JOIN `kentavr-opera`.`author` ON (`kentavr-opera`.`author2opus`.`url-author` = `kentavr-opera`.`author`.`url` AND `kentavr-opera`.`author`.`url` = ?) WHERE `kentavr-opera`.`opus`.`opustype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') GROUP BY `kentavr-opera`.`opus`.`cleanopustitle` ) AS `author-records-opera`) GROUP BY `filtertype` UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, COUNT(*) AS `cnt` FROM ( (SELECT 'creator' AS `dudetype`, `kentavr-opera`.`opus`.`opustype` AS `recordtype`, `kentavr-opera`.`opus`.`cleanvalue`, CONCAT_WS('@', `kentavr-opera`.`opus`.`opustype`, 'creator') AS `filtertype` FROM `kentavr-opera`.`opus` INNER JOIN `kentavr-opera`.`creator2opus` ON (`kentavr-opera`.`creator2opus`.`url-opus` = `kentavr-opera`.`opus`.`url`) INNER JOIN `kentavr-opera`.`creator` ON (`kentavr-opera`.`creator2opus`.`url-creator` = `kentavr-opera`.`creator`.`url` AND `kentavr-opera`.`creator`.`url` = ?) WHERE `kentavr-opera`.`opus`.`opustype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') GROUP BY `kentavr-opera`.`opus`.`cleanopustitle` ) AS `creator-records-opera`) GROUP BY `filtertype` UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, COUNT(*) AS `cnt` FROM ( (SELECT 'person' AS `dudetype`, `kentavr-opera`.`opus`.`opustype` AS `recordtype`, `kentavr-opera`.`opus`.`cleanvalue`, CONCAT_WS('@', `kentavr-opera`.`opus`.`opustype`, 'person') AS `filtertype` FROM `kentavr-opera`.`opus` INNER JOIN `kentavr-opera`.`person2opus` ON (`kentavr-opera`.`person2opus`.`url-opus` = `kentavr-opera`.`opus`.`url`) INNER JOIN `kentavr-opera`.`person` ON (`kentavr-opera`.`person2opus`.`url-person` = `kentavr-opera`.`person`.`url` AND `kentavr-opera`.`person`.`url` = ?) WHERE `kentavr-opera`.`opus`.`opustype` IN ('book', 'book-series', 'diss', 'aref', 'diafilm', 'opus-real', 'opus-thesis', 'opus-pseudo') GROUP BY `kentavr-opera`.`opus`.`cleanopustitle` ) AS `person-records-opera`) GROUP BY `filtertype` -- 2020-02-20 // INTERVIEW UNION ALL SELECT `dudetype`, `recordtype`, `filtertype`, COUNT(*) AS `cnt` FROM ( (SELECT 'interview' AS `dudetype`, `kentavr-opera`.`opus`.`opustype` AS `recordtype`, `kentavr-opera`.`opus`.`cleanvalue`, CONCAT_WS('@', `kentavr-opera`.`opus`.`opustype`, 'interview') AS `filtertype` FROM `kentavr-opera`.`opus` INNER JOIN `kentavr-opera`.`interview2opus` ON (`kentavr-opera`.`interview2opus`.`url-opus` = `kentavr-opera`.`opus`.`url`) INNER JOIN `kentavr-opera`.`interview` ON (`kentavr-opera`.`interview2opus`.`url-interview` = `kentavr-opera`.`interview`.`url` AND `kentavr-opera`.`interview`.`url` = ?) WHERE `kentavr-opera`.`opus`.`opustype` IN ('opus-interview') GROUP BY `kentavr-opera`.`opus`.`cleanopustitle` ) AS `interview-interview-records-opera`) GROUP BY `filtertype` ) AS `records-combined` WHERE `cnt` > 0 ORDER BY `dudetype` = 'person', `dudetype` = 'creator', `dudetype` = 'interview', `dudetype` = 'author'
Error Message: MDB2 Error: unknown error
Query Values: korolev_v_a, korolev_v_a, korolev_v_a, korolev_v_a, korolev_v_a, korolev_v_a, korolev_v_a
Params: text, text, text, text, text, text, text