WordPress database error Not unique table/alias

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.