Discography |
|
2007
|
Split Album
|
HOH017
|
Database Error; SQL: SELECT
DISTINCT
`t`.*, `d`.*
FROM `bmt_posts` AS `t`
LEFT JOIN `bmt_podsrel` AS `rel_album_role_album` ON
`rel_album_role_album`.`field_id` = 314
AND `rel_album_role_album`.`item_id` = `t`.`ID`
LEFT JOIN `bmt_posts` AS `album_role_album` ON
`album_role_album`.`ID` = `rel_album_role_album`.`related_item_id`
LEFT JOIN `bmt_podsrel` AS `rel_album_role_band` ON
`rel_album_role_band`.`field_id` = 562
AND `rel_album_role_band`.`item_id` = `t`.`ID`
LEFT JOIN `bmt_posts` AS `album_role_band` ON
`album_role_band`.`ID` = `rel_album_role_band`.`related_item_id`
LEFT JOIN `bmt_podsrel` AS `rel_album_role_person` ON
`rel_album_role_person`.`field_id` = 121
AND `rel_album_role_person`.`item_id` = `t`.`ID`
LEFT JOIN `bmt_posts` AS `album_role_person` ON
`album_role_person`.`ID` = `rel_album_role_person`.`related_item_id`
LEFT JOIN `bmt_pods_album_role` AS `d` ON `d`.`id` = `t`.`ID`
WHERE ( ( `album_role_album`.`id` IN (444) AND album_role_role = 'Main' AND `album_role_band`.`id` = 445 AND `album_role_person`.`id` NOT IN () ) AND ( `t`.`post_type` = "album_role" ) AND ( `t`.`post_status` IN ( "publish" ) ) )
ORDER BY `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`; Response: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) AND ( `t`.`post_type` = "album_role" ) AND ( `t`.`post_status` IN ( "publ...' at line 31