SELECT linkurl,pageid,linktext,archive,deleteAble,MJ_pages.siteid,title,hits,created,updated,published,rang,relnr,startpage,childpage,isHere,linktext2 FROM MJ_pages,MJ_sitestructure WHERE MJ_pages.siteid=67 and archive=0 and relaktiv<>0 AND pageID=childpage AND parentpage in (1947,1948,2050,2558,2559,0) ORDER BY parentpage,isHere desc,rang,title