If we look at the error log below, the error happen in this page hushhush.com/brand/laura-gulshani/ . This page is delivered by certain page template in the theme, which I could not tell from the outside.
2019/01/19 01:57:56 [error] 18811#18811: *380809 FastCGI sent in stderr: “PHP message: WordPress database error Not unique table/alias: ‘term_relationships’ for query SELECT COUNT( DISTINCT posts.ID ) as term_count, terms.term_id as term_count_id FROM posts
GROUP BY terms.term_id made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/woodmart/woocommerce/archive-product.php’), do_action(‘woocommerce_sidebar’), WP_Hook->do” while reading response header from upstream, client: 178.154.200.26, server: http://www.hushhush.com, request: “GET /brand/laura-gulshani/ HTTP/1.0”, upstream: “fastcgi://unix:/var/run/php7.2-fpm-hushhush.sock:”, host: “www.hushhush.com”
AND terms.term_id IN (24,136,17837,17838,147,377,85)
)
term_relationships.term_taxonomy_id IN (1163)
AND
)
WHERE term_taxonomy_id IN (8)
FROM term_relationships
SELECT object_id
posts.ID NOT IN (
AND (
AND posts.post_status = ‘publish’
WHERE posts.post_type IN ( ‘product’ )
LEFT JOIN term_relationships ON (posts.ID = term_relationships.object_id)
INNER JOIN terms AS terms USING( term_id )
INNER JOIN term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN term_relationships AS term_relationships ON posts.ID = term_relationships.object_id
.
