We do not share your personal details with anyone.
SELECT SQL_CALC_FOUND_ROWS sj_posts.ID FROM sj_posts LEFT JOIN sj_term_relationships ON (sj_posts.ID = sj_term_relationships.object_id) LEFT JOIN sj_icl_translations wpml_translations
ON sj_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', sj_posts.post_type) WHERE 1=1 AND (
sj_posts.ID NOT IN (
SELECT object_id
FROM sj_term_relationships
WHERE term_taxonomy_id IN (27)
)
AND
sj_term_relationships.term_taxonomy_id IN (59)
) AND sj_posts.post_type = 'product' AND (sj_posts.post_status = 'publish' OR sj_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND sj_posts.post_type IN ( 'product' )
AND ( (
( SELECT COUNT(element_id)
FROM sj_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM sj_icl_translations t2
JOIN sj_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND sj_posts.post_type IN ('post','page','attachment','wp_block','product','product_variation' ) ) OR sj_posts.post_type NOT IN ('post','page','attachment','wp_block','product','product_variation' ) ) GROUP BY sj_posts.ID ORDER BY sj_posts.menu_order ASC, sj_posts.post_title ASC LIMIT 0, 50
