Home › Forums › WoodMart support forum › Database Query Problem (from my host provider) › Reply To: Database Query Problem (from my host provider)
mark-aaron
We have found that the query in question is on line 267 of woodmart/inc/widgets/class-widget-price-filter.php
$query[‘join’] = ”
INNER JOIN {$wpdb->term_relationships} AS term_relationships ON {$wpdb->posts}.ID = term_relationships.object_id
INNER JOIN {$wpdb->term_taxonomy} AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN {$wpdb->terms} AS terms USING( term_id )
INNER JOIN {$wpdb->postmeta} ON ( {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id )
” . $tax_query_sql[‘join’];
Take a look here at similar probelms by other users https://wordpress.stackexchange.com/questions/283334/wordpress-database-error-not-unique-table-alias-wp-postmeta
Do you think that query needs to be re-written or if it can be safely commented out?