SELECT DISTINCT paper.papername, paper.pubname, ad3.pubmonth, ad3.pubday, ad3.pubyear, ad3.xmladid, ad3.adid, ad3.file_name FROM ad3, event, eventadlink, paper, slave WHERE slave.slave ~~* 'y' AND eventadlink.eventid = event.eventid AND ad3.adid=eventadlink.adid AND  event.slaveid = slave.slaveid AND paper.paperid = ad3.paperid AND event.checked ~~* 'o' ORDER BY ad3.pubyear, ad3.pubmonth, ad3.pubday LIMIT  OFFSET 0