select p.pages_id, p.status, p.sort_order, p.page_type, s.link_target, s.pages_id, s.pages_title, s.pages_uitlog, s.pages_html_text, s.pages_meta_title, s.pages_meta_description, s.pages_meta_keywords, s.externallink, s.intorext from pages p, pages_description s where p.pages_id = s.pages_id and s.language_id = '4' and p.page_type = '6' and p.status = '1' order by p.sort_order ASC
