WordPress database error: [Unknown column 'rF1Yszj_term_relationships.term_taxonomy_id' in 'GROUP BY']SELECT rF1Yszj_posts.ID
FROM rF1Yszj_posts INNER JOIN rF1Yszj_postmeta ON ( rF1Yszj_posts.ID = rF1Yszj_postmeta.post_id ) LEFT JOIN rF1Yszj_wc_product_meta_lookup wc_product_meta_lookup ON rF1Yszj_posts.ID = wc_product_meta_lookup.product_id LEFT JOIN rF1Yszj_postmeta as oc_posttba ON (rF1Yszj_posts.post_parent = oc_posttba.post_id )
WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM rF1Yszj_term_relationships
WHERE term_taxonomy_id IN (179,168,211,121,207)
AND object_id = rF1Yszj_posts.ID
) = 5
AND
rF1Yszj_posts.ID NOT IN (
SELECT object_id
FROM rF1Yszj_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
) AND (
( rF1Yszj_postmeta.meta_key = '_stock_status' AND rF1Yszj_postmeta.meta_value != 'outofstock' )
) AND ((rF1Yszj_posts.post_type = 'product' AND (rF1Yszj_posts.post_status = 'publish')) OR (rF1Yszj_posts.post_type = 'product_variation' AND (rF1Yszj_posts.post_status = 'publish'))) AND 0 = (select count(*) as totalpart from rF1Yszj_posts as oc_posttb where oc_posttb.post_parent = rF1Yszj_posts.ID and oc_posttb.post_type= 'product_variation') AND (
rF1Yszj_posts.post_parent IN (
SELECT ID
FROM rF1Yszj_posts
WHERE post_type = 'product'
AND post_status = 'publish'
)
)
GROUP BY rF1Yszj_term_relationships.term_taxonomy_id, rF1Yszj_posts.post_parent
ORDER BY wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC /* americandiscountuniform.com/shop/?filter_color=carnation-pink%2Cdesert-coral%2Cpink-topaz%2Cquiet-grey%2Cvibrance-pink request_id: b99766e22e98025d9ccd740589aa0230 */
WordPress database error: [Unknown column 'rF1Yszj_term_relationships.term_taxonomy_id' in 'GROUP BY']SELECT SQL_CALC_FOUND_ROWS rF1Yszj_posts.ID
FROM rF1Yszj_posts INNER JOIN rF1Yszj_postmeta ON ( rF1Yszj_posts.ID = rF1Yszj_postmeta.post_id ) LEFT JOIN rF1Yszj_wc_product_meta_lookup wc_product_meta_lookup ON rF1Yszj_posts.ID = wc_product_meta_lookup.product_id LEFT JOIN rF1Yszj_postmeta as oc_posttba ON (rF1Yszj_posts.post_parent = oc_posttba.post_id )
WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM rF1Yszj_term_relationships
WHERE term_taxonomy_id IN (179,168,211,121,207)
AND object_id = rF1Yszj_posts.ID
) = 5
AND
rF1Yszj_posts.ID NOT IN (
SELECT object_id
FROM rF1Yszj_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
) AND (
( rF1Yszj_postmeta.meta_key = '_stock_status' AND rF1Yszj_postmeta.meta_value != 'outofstock' )
) AND ((rF1Yszj_posts.post_type = 'product' AND (rF1Yszj_posts.post_status = 'publish')) OR (rF1Yszj_posts.post_type = 'product_variation' AND (rF1Yszj_posts.post_status = 'publish'))) AND 0 = (select count(*) as totalpart from rF1Yszj_posts as oc_posttb where oc_posttb.post_parent = rF1Yszj_posts.ID and oc_posttb.post_type= 'product_variation') AND (
rF1Yszj_posts.post_parent IN (
SELECT ID
FROM rF1Yszj_posts
WHERE post_type = 'product'
AND post_status = 'publish'
)
)
GROUP BY rF1Yszj_term_relationships.term_taxonomy_id, rF1Yszj_posts.post_parent
ORDER BY wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC
LIMIT 0, 24 /* americandiscountuniform.com/shop/?filter_color=carnation-pink%2Cdesert-coral%2Cpink-topaz%2Cquiet-grey%2Cvibrance-pink request_id: b99766e22e98025d9ccd740589aa0230 */
