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