Title: WordPress database error Not unique table/alias
Last modified: March 22, 2017

---

# WordPress database error Not unique table/alias

 *  Resolved [George](https://wordpress.org/support/users/subscriptiongroup/)
 * (@subscriptiongroup)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique-tablealias-2/)
 * Hello,
 * We often get the following notice on our logs:
 *     ```
       WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT  DISTINCT wp_posts.* FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND (
         ( wp_postmeta.meta_key = '_wpas_status' AND wp_postmeta.meta_value = 'open' )
       ) AND wp_posts.post_type = 'ticket' AND ((wp_posts.post_status = 'queued' OR wp_posts.post_status = 'processing' OR wp_posts.post_status = 'hold')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC  made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), WP_Hook->do_action, WP_Hook->apply_filters, wpas_tickets_count, wpas_get_tickets, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query
       ```
   
 * I’m not sure if that’s caused solely by your plugin or maybe an incompatibility
   with W3TC DB cache, but i believe it’s somehow related to your plugin as the 
   query returns a list of tickets.
 * This bug can be fixed by adding an alias on the query and we haven’t noticed 
   any issues so far, so it’s probably a low priority.
 * Thanks
 * p.s. Even though we’ve got a few licences with you, your site will not allow 
   me to submit a ticket as CloudFlare appears to be blocking my IP, so i’m forced
   to post here.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [awesomesupport](https://wordpress.org/support/users/awesomesupport/)
 * (@awesomesupport)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique-tablealias-2/#post-8946015)
 * Hi George:
 * Can you use the contact form on our website to give us your ip address so we 
   can white-list it for you> Also please include the email address your product
   is registered under and we’ll open a ticket with the information in this post
   for you.
 * Thanks very much!
 *  Plugin Author [awesomesupport](https://wordpress.org/support/users/awesomesupport/)
 * (@awesomesupport)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique-tablealias-2/#post-8965214)
 * We’re handling this via our ticket system so marking this closed.

Viewing 2 replies - 1 through 2 (of 2 total)

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

 * ![](https://ps.w.org/awesome-support/assets/icon-256x256.png?rev=1849681)
 * [Awesome Support - WordPress HelpDesk & Support Plugin](https://wordpress.org/plugins/awesome-support/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/awesome-support/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/awesome-support/)
 * [Active Topics](https://wordpress.org/support/plugin/awesome-support/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/awesome-support/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/awesome-support/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [awesomesupport](https://wordpress.org/support/users/awesomesupport/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-not-unique-tablealias-2/#post-8965214)
 * Status: resolved