select * from publishedarticle where active=1 order by id desc