Oh, I'm sorry, missed a detail, try this:
[php]$page_query = tep_db_query("select
p.pages_id,
p.sort_order,
p.status,
s.pages_title,
s.pages_html_text,
s.intorext,
s.externallink,
s.link_target
from
" . TABLE_PAGES . " p LEFT JOIN " .TABLE_PAGES_DESCRIPTION . " s on p.pages_id = s.pages_id
where
p.status = 1
and
p.page_type != 1
and
s.language_id = '" . (int)$languages_id . "'
order by
p.sort_order, s.pages_title LIMIT 5");[/php]





