Title: Not unique table/alias…
Last modified: October 13, 2016

---

# Not unique table/alias…

 *  Resolved [jamesvg](https://wordpress.org/support/users/jamesvg/)
 * (@jamesvg)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/not-unique-tablealias/)
 * Following is written to log when viewing the custom menu page. Hotfix possible?
 * Admin > Users > Approve New Users
 * [13-Oct-2016 20:31:26 UTC] WordPress database error Not unique table/alias: ‘
   wp_usermeta’ for query SELECT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER
   JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta
   wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND (
    ( wp_usermeta.
   meta_key = ‘pw_user_status’ AND wp_usermeta.meta_value = ‘pending’ ) ) AND ( (
   wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR)
   = ‘pending’) ) ORDER BY user_login ASC made by require_once(‘wp-admin/admin.php’),
   require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘
   admin_menu’), call_user_func_array, pw_new_user_approve_user_list->pending_users_bubble,
   pw_new_user_approve->get_user_statuses, pw_new_user_approve->_get_user_statuses,
   WP_User_Query->__construct, WP_User_Query->query [13-Oct-2016 20:31:26 UTC] WordPress
   database error Not unique table/alias: ‘wp_usermeta’ for query SELECT DISTINCT
   SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.
   ID = wp_usermeta.user_id ) LEFT JOIN wp_usermeta AS mt1 ON (wp_users.ID = mt1.
   user_id AND mt1.meta_key = ‘pw_user_status’ ) INNER JOIN wp_usermeta wp_usermeta
   ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( ( wp_usermeta.meta_key
   = ‘pw_user_status’ AND wp_usermeta.meta_value = ‘approved’ ) OR mt1.user_id IS
   NULL ) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value
   AS CHAR) = ‘pending’) ) ORDER BY user_login ASC made by require_once(‘wp-admin/
   admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.
   php’), do_action(‘admin_menu’), call_user_func_array, pw_new_user_approve_user_list-
   >pending_users_bubble, pw_new_user_approve->get_user_statuses, pw_new_user_approve-
   >_get_user_statuses, WP_User_Query->__construct, WP_User_Query->query [13-Oct-
   2016 20:31:26 UTC] WordPress database error Not unique table/alias: ‘wp_usermeta’
   for query SELECT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta
   ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta wp_usermeta ON(
   wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( ( wp_usermeta.meta_key = ‘
   pw_user_status’ AND wp_usermeta.meta_value = ‘denied’ ) ) AND ( (wp_usermeta.
   meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’))
   ORDER BY user_login ASC made by require_once(‘wp-admin/admin.php’), require(‘
   wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’),
   call_user_func_array, pw_new_user_approve_user_list->pending_users_bubble, pw_new_user_approve-
   >get_user_statuses, pw_new_user_approve->_get_user_statuses, WP_User_Query->__construct,
   WP_User_Query->query

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

 *  [Josh Harrison](https://wordpress.org/support/users/picklewagon/)
 * (@picklewagon)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/not-unique-tablealias/#post-8304903)
 * I am working on a fix for this right now. Trying to get an updated version out
   in the next few days.
 *  Thread Starter [jamesvg](https://wordpress.org/support/users/jamesvg/)
 * (@jamesvg)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/not-unique-tablealias/#post-8314517)
 * Thank you for your continued efforts on this plugin.

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

The topic ‘Not unique table/alias…’ is closed to new replies.

 * ![](https://ps.w.org/new-user-approve/assets/icon-128x128.gif?rev=2544141)
 * [New User Approve](https://wordpress.org/plugins/new-user-approve/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/new-user-approve/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/new-user-approve/)
 * [Active Topics](https://wordpress.org/support/plugin/new-user-approve/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/new-user-approve/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/new-user-approve/reviews/)

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