$wpdb->prepare("SELECT * FROM {$wpdb->posts}
                INNER JOIN {$wpdb->term_relationships} AS tr1 ON ({$wpdb->posts}.ID = tr1.object_id)
                AND tr1.term_taxonomy_id IN (%d)
                AND (({$wpdb->posts}.post_title LIKE %s)
                    OR ({$wpdb->posts}.post_excerpt LIKE %s)
                    OR ({$wpdb->posts}.post_content LIKE %s)
                )
                AND {$wpdb->posts}.post_type = %s
                AND {$wpdb->posts}.post_status NOT IN ('trash', 'auto-draft')
                WHERE {$wpdb->posts}.ID NOT IN (
                    SELECT {$wpdb->posts}.ID FROM {$wpdb->posts}
                        LEFT JOIN {$wpdb->term_relationships} AS tr2 ON ({$wpdb->posts}.ID = tr2.object_id)
                        INNER JOIN {$wpdb->term_taxonomy} AS tt ON (tt.term_taxonomy_id = tr2.term_taxonomy_id)
                            AND (tt.taxonomy = 'post_translations')
                            AND tt.description LIKE %s
                )
                LIMIT 0, %d", $lang->get_tax_prop($this->tax_language, 'term_taxonomy_id'), $search_like, $search_like, $search_like, $type, $untranslated_like, $limit)

Issues