KX CORT

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=13 OR c.parent_ID=13) GROUP BY b.ID_brand ORDER BY brand ASC LIMIT 1000