select id from issue where status ='1' order by issuedate asc limit 1 select id from issue where status ='1' and id != 814 and id < 814 order by issuedate desc limit 1
08 June, 2012 Issue
select id from issue where status ='1' order by issuedate desc limit 1
select a.contentid,a.headline1,a.headline2,a.commentcount,a.contypeid,a.sectionparent,a.section, a.summary,a.writername,a.publishdate,a.guid,a.sectionid,b.subsectionid from contentmanagement a,content b where a.publish = '1' AND b.id = a.contentid and a.ismagzineflag=1 and a.issueid=814 and a.sectionid=b.subsectionid group by a.contentid order by a.publishdate desc limit 0,10