select
p.pages_id,
p.sort_order,
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
p.site_id = "2"
and
s.language_id = "2"
and
p.sort_order < 1000
order by
p.sort_order, s.pages_title