1021 - Disk full (/var/mysql_tmp/#sql-temptable-e7b-800ec7-746ba.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
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
