SQL ERROR:
SQLSTATE[HY000]: General error: 126 Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-2429d8-1be7e-56b0.MAI'

select p.products_image, p.products_image_med, p.products_image_lrg, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_family_name 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 "%|81_831|%" AND fclc.filter_collection LIKE "%|36_312|%" AND fclc.filter_collection LIKE "%|60_1439|%" AND fclc.filter_collection LIKE "%|36_311|%" AND fclc.filter_collection LIKE "%|104_1286|%" and fclc.products_id = p.products_id and pd.language_id = '1' and p2c.categories_id in (910,592,861,864,583,866,169) 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 group by p.products_family_name order by p.products_date_added DESC,p.products_family_name, p.products_model , pd.products_name