select page0_.CONTENTID as CONTENTID, page0_.CHILD_POSITION as CHILD_P16_, page0_.PARENTID as PARENTID, page0_.SPACEID as SPACEID, page0_.HIBERNATEVERSION as HIBERNAT3_, page0_.TITLE as TITLE, page0_.LOWERTITLE as LOWERTITLE, page0_.VERSION as VERSION, page0_.CREATOR as CREATOR, page0_.CREATIONDATE as CREATION8_, page0_.LASTMODIFIER as LASTMODI9_, page0_.LASTMODDATE as LASTMOD10_, page0_.VERSIONCOMMENT as VERSION11_, page0_.PREVVER as PREVVER, page0_.CONTENT_STATUS as CONTENT13_, page0_.PAGEID as PAGEID from CONTENT page0_, SPACES space1_ where page0_.CONTENTTYPE='PAGE' and ((page0_.PREVVER is null )and(page0_.CONTENT_STATUS='current' )and(space1_.SPACEKEY!='linefkit' and page0_.SPACEID=space1_.SPACEID)and(page0_.CONTENTID in(select distinct page2_.PREVVER from CONTENT page2_ where page2_.CONTENTTYPE='PAGE' and ((page2_.TITLE='Home' )and(page2_.PREVVER is not null )and(page2_.CONTENT_STATUS='current' ))))and(exists(select spacepermi3_.PERMID from SPACEPERMISSIONS spacepermi3_ 
where (page0_.SPACEID=spacepermi3_.SPACEID )and(((spacepermi3_.PERMUSERNAME='8a00579747b961f80147b967563611f6' )or(spacepermi3_.PERMGROUPNAME in('group1' , 'group2' , 'group3' , 'group4' , 'group5' , 'group6' , 'group7' , 'group8' , 'group9' , 'group10' , 'group11' , 'group12' , 'group13' , 'group14' , 'group15' , 'group16' , 'group17' , 'group18' , 'group19' , 'group20' , 'group21' , 'group22' , 'group23' , 'group24' , 'group25' , 'group26' , 'group27' , 'group28' , 'group29' , 'group30' , 'group31'))or(spacepermi3_.PERMALLUSERSSUBJECT='authenticated-users' )or((spacepermi3_.PERMUSERNAME is null )and(spacepermi3_.PERMGROUPNAME is null )and(spacepermi3_.PERMALLUSERSSUBJECT is null )))and(spacepermi3_.PERMTYPE='VIEWSPACE' ))))) 
order by page0_.LASTMODDATE desc limit 50;