100% Match Bonus

Database Error; SQL: SELECT DISTINCT `t`.* FROM `p5O0H7JLg9_posts` AS `t` LEFT JOIN `p5O0H7JLg9_podsrel` AS `rel_currency` ON `rel_currency`.`field_id` = 3200 AND `rel_currency`.`item_id` = `t`.`ID` LEFT JOIN `p5O0H7JLg9_posts` AS `currency` ON `currency`.`ID` = `rel_currency`.`related_item_id` LEFT JOIN `p5O0H7JLg9_postmeta` AS `currency_currency_code` ON `currency_currency_code`.`meta_key` = 'currency_code' AND `currency_currency_code`.`post_id` = `currency`.`ID` LEFT JOIN `p5O0H7JLg9_postmeta` AS `deposit_bonus` ON `deposit_bonus`.`meta_key` = 'deposit_bonus' AND `deposit_bonus`.`post_id` = `t`.`ID` LEFT JOIN `p5O0H7JLg9_postmeta` AS `offer_type` ON `offer_type`.`meta_key` = 'offer_type' AND `offer_type`.`post_id` = `t`.`ID` LEFT JOIN `p5O0H7JLg9_podsrel` AS `rel_site` ON `rel_site`.`field_id` = 14 AND `rel_site`.`item_id` = `t`.`ID` LEFT JOIN `p5O0H7JLg9_posts` AS `site` ON `site`.`ID` = `rel_site`.`related_item_id` WHERE ( ( `currency_currency_code`.`meta_value`='GBP' AND `deposit_bonus`.`meta_value` = '100' AND `offer_type`.`meta_value` IN ('','alt') AND `site`.`ID` !='' AND `offer`.`post_status`='publish' ) AND ( `t`.`post_type` = 'offer' ) ) GROUP BY t.id ORDER BY `site`.`menu_order`, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date` LIMIT 0, 26; Response: Unknown column 'offer.post_status' in 'where clause'