SELECT chapter.id as chapterId, chapter.quote_imgAlt as chapterQuote_imgAlt, chapter.screenshot_imgAlt as chapterScreenshot_imgAlt, chapter.number_imgAlt as chapterNumber_imgAlt, chapter.name as chapterName, chapter.description as chapterDescription,chapter.relatedPollIds as chapterRelatedPollIds, chapter.relatedVideoIds as chapterRelatedVideoIds, chapter.relatedOtherIds as chapterRelatedOtherIds, chapter.relatedEvent_discussionIds as chapterRelatedEvent_discussionIds, page.id as pageId, page.name as pageName, page.longDescription as pageLongDescription, page.filmstripAlt as pageFilmstripAlt, page.mp3 as pageMp3 FROM chapter, page where chapter.id = page.chapterID and chapter.id < 9 ORDER BY chapter.thisOrder desc, chapter.id asc, page.thisOrder desc, page.id