:
select id, UNIX_TIMESTAMP(time) as time, author, subject, email, parent, is_parent, subs, level, views, attach from articles where forum = 0 and moderation_state != 1 order by time desc limit , 35