select
p.pages_id,
p.sort_order,
p.status,
s.pages_title,
s.pages_html_text
from
TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id
where
p.status = 1
and
s.language_id = '2'
and
p.sort_order > 0 order by p.sort_order, s.pages_title