Got error 28 from storage engine

SELECT `categories`.*
, '' as `num_clips`
, `domain_categories`.`domain_category_id`
FROM `categories`
LEFT JOIN `domain_categories` ON (`domain_categories`.`category_id` = `categories`.`category_id`)
WHERE `domain_categories`.`domain_id` = '1'
ORDER BY `categories`.`order`