126 - Incorrect key file for table './JesperD_aob/products_description.MYI'; try to repair it
select count(p.products_id) as total from products p
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4'
left join specials s on p.products_id = s.products_id
LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id
LEFT JOIN categories c ON p2c.categories_id = c.categories_id
where pd.products_name like '%' AND p.products_status='1' AND c.categories_status='1'