MySQL[1194]:Table 'spr_tmc' is marked as crashed and should be repaired<br /><br />
SELECT cpv.`id` AS `category_id`, p.`rwurl`, pe.`value` AS `id`, ev.`value` AS `full_name`
FROM `spr_property_enum` pe
LEFT JOIN `spr_properties` p ON p.`id`=pe.`id`
LEFT JOIN `spr_enum_values` ev ON ev.`id`=pe.`value` AND ev.`lang`="ru"
LEFT JOIN `spr_category_property_values` cpv ON cpv.`property`=pe.`id` AND cpv.`value`=pe.`value`
WHERE pe.`id` IN (123, 168, 322) AND p.`rwurl`<>"" AND pe.`tmc` IN (SELECT t.`id` FROM `spr_tmc` t WHERE t.`renabled`=1) AND cpv.`id` IN (SELECT c.`id` FROM `spr_tmc_categories` c WHERE c.`enabled`=1 AND c.`products_count`>0 AND c.`rwurl`<>"" AND c.`id` NOT IN (374,375,376,377,378,383,470,379,380,385,384,386,390,395,396,397,398,399,400,409,490,411,412,431)) AND IFNULL(cpv.`filters_expanded`, 0)=1
GROUP BY cpv.`id`, pe.`value`
ORDER BY cpv.`id` ASC, IFNULL(cpv.`filters_sort_order`, 0) DESC, ev.`value` ASC