Insights

We keep close to the latest digital marketing trends

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  JOIN wp_icl_translations t
							ON wp_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', wp_posts.post_type)  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND ( ( ( t.language_code = 'en' OR (
					t.language_code = 'en'
					AND wp_posts.post_type IN ( 'post','attachment' )
					AND ( ( 
			( SELECT COUNT(element_id)
			  FROM wp_icl_translations
			  WHERE trid = t.trid
			  AND language_code = 'en'
			) = 0
			 ) OR ( 
			( SELECT COUNT(element_id)
				FROM wp_icl_translations t2
				JOIN wp_posts p ON p.id = t2.element_id
				WHERE t2.trid = t.trid
				AND t2.language_code = 'en'
				AND (
					p.post_status = 'publish' OR 
					p.post_type='attachment' AND p.post_status = 'inherit'
				)
			) = 0 ) ) 
				) ) AND wp_posts.post_type  IN ('post','page','attachment','project','service','testimonial' )  ) OR wp_posts.post_type  NOT  IN ('post','page','attachment','project','service','testimonial' )  )  ORDER BY wp_posts.menu_order, wp_posts.post_date DESC LIMIT 0, 10
Load more