select
p.pages_id,
p.sort_order,
p.status,
s.pages_title,
s.pages_html_text,
s.intorext,
s.externallink,
s.link_target
from
pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id
where
p.status = 1
and
p.page_type != 1
and
s.language_id = '1'
order by
p.sort_order, s.pages_title
