Query to check for double published feeds:

select  f.id,f.name,a.language,sum(a.published) from ARTICLE a, FEED f where f.id = a.feed_id group by a.feed_id,a.language having sum(a.published) > 1

Query to see the publication list:

select id,title,language,feed_id from ARTICLE where current = 1 and modificationdate > 0;

Query to check which feeds are archived:

  select id,name,archivetype,archivedate from FEED where archivetype = 1;