POLi

Database Error; SQL: SELECT DISTINCT `t`.* FROM `RKnB48_posts` AS `t` LEFT JOIN `RKnB48_podsrel` AS `rel_site` ON `rel_site`.`field_id` = 94 AND `rel_site`.`item_id` = `t`.`ID` LEFT JOIN `RKnB48_posts` AS `site` ON `site`.`ID` = `rel_site`.`related_item_id` LEFT JOIN `RKnB48_podsrel` AS `rel_site_payment_option` ON `rel_site_payment_option`.`field_id` = 170 AND `rel_site_payment_option`.`item_id` = `site`.`ID` LEFT JOIN `RKnB48_posts` AS `site_payment_option` ON `site_payment_option`.`ID` = `rel_site_payment_option`.`related_item_id` LEFT JOIN `RKnB48_podsrel` AS `rel_country` ON `rel_country`.`field_id` = 999 AND `rel_country`.`item_id` = `t`.`ID` LEFT JOIN `RKnB48_posts` AS `country` ON `country`.`ID` = `rel_country`.`related_item_id` LEFT JOIN `RKnB48_podsrel` AS `rel_country_language` ON `rel_country_language`.`field_id` = 58 AND `rel_country_language`.`item_id` = `country`.`ID` LEFT JOIN `RKnB48_posts` AS `country_language` ON `country_language`.`ID` = `rel_country_language`.`related_item_id` LEFT JOIN `RKnB48_postmeta` AS `country_language_language_code` ON `country_language_language_code`.`meta_key` = 'language_code' AND `country_language_language_code`.`post_id` = `country_language`.`ID` LEFT JOIN `RKnB48_postmeta` AS `offer_type` ON `offer_type`.`meta_key` = 'offer_type' AND `offer_type`.`post_id` = `t`.`ID` LEFT JOIN `RKnB48_postmeta` AS `site_post_status` ON `site_post_status`.`meta_key` = 'post_status' AND `site_post_status`.`post_id` = `site`.`ID` WHERE ( ( `site_payment_option`.`id`= AND `country_language_language_code`.`meta_value`='en_CA' AND `offer_type`.`meta_value`='' AND `site`.`post_status`='publish' ) AND ( `t`.`post_type` = 'offer' ) ) ORDER BY `site`.`menu_order`, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date` LIMIT 0, 999; 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 `country_language_language_code`.`meta_value`='en_CA' AND `offer_type`.`m...' at line 53