Title: Database Error “Not unique table/alias”
Last modified: May 12, 2023

---

# Database Error “Not unique table/alias”

 *  [deadmanwalker](https://wordpress.org/support/users/deadmanwalker/)
 * (@deadmanwalker)
 * [3 years ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias/)
 * When enabling the setting “Enable seamless integration”, and calling Better_Search_Query(
   $args) in my custom code identically to the code inside better-search/templates/
   template.php, I get several of the following error:
 * **WordPress-Datenbank-Fehler:** [Not unique table/alias: ‘bsq_meta’]
   `SELECT 
   DISTINCT (MATCH(wp_posts.post_title) AGAINST ('mitglied' ) * 10 ) + (MATCH(wp_posts.
   post_content) AGAINST ('mitglied' ) * 1 ) as score FROM wp_posts LEFT JOIN wp_postmeta
   AS bsq_meta ON (wp_posts.ID = bsq_meta.post_id) LEFT JOIN wp_postmeta AS bsq_meta
   ON (wp_posts.ID = bsq_meta.post_id) LEFT JOIN wp_postmeta AS bsq_meta ON (wp_posts.
   ID = bsq_meta.post_id) WHERE 1=1 AND ( wp_posts.post_date <= '2023-05-12 16:42:
   03' ) AND ((MATCH(wp_posts.post_title) AGAINST ('mitglied' ) * 10 ) + (MATCH(
   wp_posts.post_content) AGAINST ('mitglied' ) * 1 ) OR ( ((wp_posts.post_excerpt
   LIKE '%mitglied%') OR (bsq_meta.meta_value LIKE '%mitglied%')) ) ) AND (wp_posts.
   post_password = '') AND wp_posts.post_type IN ('post', 'page') AND ((wp_posts.
   post_status = 'publish' OR wp_posts.post_status = 'inherit')) ORDER BY score 
   DESC LIMIT 0,1`

The topic ‘Database Error “Not unique table/alias”’ is closed to new replies.

 * ![](https://ps.w.org/better-search/assets/icon-256x256.png?rev=2988729)
 * [Better Search - Relevant search results for WordPress](https://wordpress.org/plugins/better-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-search/)
 * [Active Topics](https://wordpress.org/support/plugin/better-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-search/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [deadmanwalker](https://wordpress.org/support/users/deadmanwalker/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias/)
 * Status: not resolved