Title: WordPress database error Not unique
Last modified: August 31, 2016

---

# WordPress database error Not unique

 *  [RonaldS](https://wordpress.org/support/users/norus/)
 * (@norus)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique/)
 * I get this error message and have no idea if this is caused by Avada or from 
   WordPress.
    Anyone an idea how to solve this?
 * [17-Feb-2016 18:01:36 UTC] WordPress database error Not unique table/alias: ‘
   t’ for query SELECT wp_comments.* FROM wp_comments JOIN wp_posts ON (wp_comments.
   comment_post_ID = wp_posts.ID) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.
   post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) JOIN
   wp_icl_translations t
    ON wp_posts.ID = t.element_id AND t.element_type = CONCAT(‘
   post_’, wp_posts.post_type) JOIN wp_icl_translations t ON wp_comments.comment_post_ID
   = t.element_id AND t.element_type = ‘post_product’ AND t.language_code = ‘en’
   WHERE comment_approved = ‘1’ AND ( 0 = 1 ) AND ( wp_postmeta.meta_key = ‘total_sales’
   AND ( ( mt1.meta_key = ‘_visibility’ AND CAST(mt1.meta_value AS CHAR) IN (‘visible’,’
   catalog’) ) ) ) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status 
   = ‘publish’) AND ( ( t.language_code = ‘en’ AND wp_posts.post_type IN (‘post’,’
   page’,’attachment’,’product’,’product_variation’,’slide’,’avada_portfolio’,’avada_faq’,’
   themefusion_elastic’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’
   product’,’product_variation’,’slide’,’avada_portfolio’,’avada_faq’,’themefusion_elastic’))
   AND wp_posts.post_type NOT IN (‘shop_order’,’shop_order_refund’) AND wp_posts.
   post_type <> ‘shop_webhook’ GROUP BY wp_comments.comment_id ORDER BY comment_date_gmt
   DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts,
   WP_Query->query, WP_Query->get_posts

The topic ‘WordPress database error Not unique’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [RonaldS](https://wordpress.org/support/users/norus/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics