Grow Equipment

Showing all 13 results

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 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 (61)
) 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