<br>	SELECT * FROM wp_posts a
	INNER JOIN wp_term_relationships b ON a.id = b.object_id
	INNER JOIN wp_terms c ON b.term_taxonomy_id = c.term_id
	LEFT JOIN wp_post_views d ON a.id = d.post_id
	WHERE
	
	( (post_status = 'publish' AND ( post_type = 'page' OR post_type = 'post' ))  )
	AND post_title != "Auto draft"
	 AND post_name = "buying-a-property-abroad" 
	 ORDER BY post_modified DESC 
	LIMIT 12 OFFSET 0