skip to Main Content
Back To Top
×Close search
Search
  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We do not share your personal details with anyone.
    SELECT   sj_posts.* FROM sj_posts  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.post_name = 'green-house-cover-inch-rounded1-unitecm53-inch-x-inch-rounded1-unitecm26-inch-x-inch-rounded1-unitecm18-inch' AND sj_posts.ID = 5219 AND sj_posts.post_type = 'product' 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' )  )  ORDER BY sj_posts.post_date DESC