skip to Main Content

I nostri dettagli di contatto

Segreto Jardin – Agomoon SPRL
Drève de la Courte au bois, 5
7170 Manage, Belgio
Tel. : +32 2 652 37 82

contattaci

Saremo lieti di sentire da voi. Si prega di compilare il modulo qui sotto, il nostro team si assicurerà di entrare in contatto con voi il più presto possibile.

Questa informazione è solo per noi.
Consulta le nostre note legalisui dati personali.

Back To Top
×Close search
Cerca
  • 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.ID = '6619') AND sj_posts.post_type = 'page' AND ( ( ( wpml_translations.language_code = 'it' 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 = 'it'
			) = 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 = 'it'
				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