Strat replacement DIMARZIO

error on qArray_no_cache: Table './pianoshop/goods' is marked as crashed and should be repaired

SELECT b.*,count(*) as brand_count FROM goods g LEFT JOIN brands b ON b.ID_brand=g.brand_ID LEFT JOIN categories c ON c.ID_category=g.category_ID WHERE (c.ID_category=172 OR c.parent_ID=172) GROUP BY b.ID_brand ORDER BY brand ASC LIMIT 1000