To retrieve all article IDs for article type 'news'E from the ECE database, use this SQL:

SELECT art.articleId
FROM ArticleMetaContent art
WHERE art.articleId IN (
	SELECT DISTINCT art.articleId
	FROM ArticleMetaContent art, Section sec, ArticleSection artsec, ArticleType arttyp, Publication pub
	WHERE art.codeID = arttyp.codeId
	AND arttyp.codeText = 'news'
	AND artsec.articleId = art.articleId
	AND sec.sectionID = artsec.sectionID
	AND sec.referenceId = pub.referenceId
	AND pub.publicationName = 'YOURPUBLICATION NAME'
	AND sec.codeId in (2, 3)
	AND art.art_codeId = 2
	)
ORDER BY art.publishDate DESC