Home Forums WoodMart support forum Database Query Problem (from my host provider) Reply To: Database Query Problem (from my host provider)

#102347

mark-aaron
Participant

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?