144 Table './Sql104643_3/zen_products' is marked as crashed and last (automatic?) repair failed
[select distinct c.categories_id as id, cd.categories_name as name
from zen_products p, zen_products_to_categories p2c, zen_categories c, zen_categories_description cd
where p.products_status = 1
and p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and p2c.categories_id = cd.categories_id
and cd.language_id = '2'
and p.manufacturers_id = '28'
order by cd.categories_name]