1021 - Disk full (/tmp/#sql-temptable-46e4-1ae6b88-266ec3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select cd.categories_description, c.categories_id, cd.categories_name, cd.categories_heading_title, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.parent_id = '9' and c.categories_id = cd.categories_id and cd.language_id = '2' order by sort_order, cd.categories_name

[XT SQL Error]