1021 - Disk full (/tmp/#sql_1bb5_49.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select c.has_header_pic, c.products_image, c.categories_image, c.categories_id, c.parent_id, cd.meta_keywords, cd.meta_title, cd.meta_description, cd.description, cd.categories_seo_url, cd.show_in_this_lang, cd.categories_menu_name, (select count(subc.categories_id) from categories subc, categories_description subcd where subcd.show_in_this_lang = 1 and subc.categories_id = subcd.categories_id and subcd.language_id = 4 and subc.parent_id = c.categories_id) children from categories c, categories_description cd where cd.show_in_this_lang = 1 and parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '4' order by sort_order, cd.categories_menu_name

[TEP STOP]