1021 Disk full (/tmp/#sql_a69_0); waiting for someone to free some space...
in:
[SELECT c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id FROM zen_categories c, zen_categories_description cd WHERE c.parent_id = 662 AND c.categories_id = cd.categories_id AND cd.language_id = 1 AND c.categories_status= '1' ORDER BY sort_order, cd.categories_name]