Title: Database Error “Not unique table/alias: price_query”
Last modified: October 18, 2017

---

# Database Error “Not unique table/alias: price_query”

 *  Resolved [sunny13](https://wordpress.org/support/users/sunny13/)
 * (@sunny13)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias-price_query/)
 * Hello there,
 * first of all – thanks for your the great woocommerce plugin.
 * Unfortunately something weird happened. We migrated our Woocommerce from 2.6.2
   to the latest version (3.2.1) as well as our WordPress (4.8.2) version. The result
   is documented below:
 * WordPress-Database-Error Not unique table/alias: ‘price_query’ für Abfrage SELECT
   SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN ( SELECT post_id, min(
   meta_valu+0 ) price FROM wp_postmeta WHERE meta_key=’_price’ GROUP BY post_id)
   as price_query ON wp_posts.ID = price_query.post_id INNER JOIN ( SELECT post_id,
   min( meta_value+0 ) price FROM wp_postmeta WHERE meta_key=’_price’ GROUP BY post_id)
   as price_query ON wp_posts.ID = price_query.post_id WHERE 1=1 AND (
    wp_posts.
   ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id
   IN (17746) ) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships
   WHERE term_taxonomy_id IN (17746) ) ) AND wp_posts.post_type = ‘product’ AND (
   wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) GROUP BY
   wp_posts.ID ORDER BY price_query.price ASC LIMIT 0, 12 von require(‘wp-blog-header.
   php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
 * ————-
    Due to this error, no products are rendered in categories and shop overview.
   We assume that there is some kind of problem with the new version of woocommerce?.
   Could you please provide some help?
 * Kind Regards,
    sunny
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-not-unique-table-alias-price_query%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [izumrudnij](https://wordpress.org/support/users/izumrudnij/)
 * (@izumrudnij)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias-price_query/#post-9615235)
 * I Got same error in site dijewellery.ru
 * Please help us!!!
 *  [dougaitken](https://wordpress.org/support/users/dougaitken/)
 * (@dougaitken)
 * Automattic Happiness Engineer
 * [8 years, 5 months ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias-price_query/#post-9797854)
 * Hi there [@sunny13](https://wordpress.org/support/users/sunny13/)
 * Looking at your site, it seems you got this fixed?
 * [@izumrudnij](https://wordpress.org/support/users/izumrudnij/) were you able 
   to get this resolved?
 * I’m going to mark this as resolved – if you have any further questions, you can
   start a new thread.
 * Thanks,

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

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

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [dougaitken](https://wordpress.org/support/users/dougaitken/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/database-error-not-unique-table-alias-price_query/#post-9797854)
 * Status: resolved