SQL ERROR:
SQLSTATE[HY000]: General error: 126 Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-2f3b17-13324f-105940.MAI'

select count(distinct p.products_family_name) as total from (products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c , products_filter_collection fclc where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_stock_type not in (9) and fclc.filter_collection like "%|106_1338|%" and fclc.filter_collection like "%|3_716|%" and fclc.filter_collection like "%|60_1316|%" and fclc.filter_collection like "%|104_1314|%" and fclc.products_id = p.products_id and pd.language_id = '1' and p2c.categories_id in (595,857) and (p.products_group_access like "%,g,%" or p.products_group_access like "g,%" or p.products_group_access like "%,g" or p.products_group_access="g") and p.products_parent_id = 0