WordPress database error: [Not unique table/alias: 'wpml_translations']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (wp_posts.ID = '39') AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_careerlearning' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_estateshouses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_list' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_place' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'gd_shopsservices' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wpi-pending' OR wp_posts.post_status = 'wpi-processing' OR wp_posts.post_status = 'wpi-onhold' OR wp_posts.post_status = 'wpi-cancelled' OR wp_posts.post_status = 'wpi-refunded' OR wp_posts.post_status = 'wpi-failed' OR wp_posts.post_status = 'wpi-renewal' OR wp_posts.post_status = 'wpi-quote-pending' OR wp_posts.post_status = 'wpi-quote-accepted' OR wp_posts.post_status = 'wpi-quote-declined' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','gd_place','gd_shopsservices','gd_event','gd_careerlearning','gd_estateshouses','bp-email' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','gd_place','gd_shopsservices','gd_event','gd_careerlearning','gd_estateshouses','bp-email' ) ) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','gd_place','gd_shopsservices','gd_event','gd_careerlearning','gd_estateshouses','bp-email' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','gd_place','gd_shopsservices','gd_event','gd_careerlearning','gd_estateshouses','bp-email' ) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 16