SELECT b.id, b.status, b.published_date, b.expiry
FROM Articles b
WHERE b.id IN
(
	SELECT DISTINCT parent_article_id as id
	FROM ArticleHasArticle
	WHERE article_schema_rel_id = 2
	AND child_article_id IN
	(
		SELECT art.id
		FROM Articles art
		WHERE art.published_date BETWEEN GETDATE()-7 AND GETDATE()
		AND art.article_schema_id=10
		AND art.id NOT IN
		(
			SELECT DISTINCT child_article_id as id
			FROM ArticleHasArticle
			WHERE article_schema_rel_id = 2
			AND child_article_id IN
			(
				SELECT b.id
				FROM Articles b
				WHERE b.published_date BETWEEN GETDATE()-7 AND GETDATE()
				AND b.article_schema_id=10
			)
			AND parent_article_id IN
			(
				SELECT * FROM ArticleIsAvailable
			)
		)
	)
)
ORDER BY b.id ASC