Table '.\swimmings\sc_products' is marked as crashed and should be repaired
SELECT SQL_CALC_FOUND_ROWS p.*, name_ru AS _name_sort FROM SC_products p LEFT JOIN SC_tagged_objects t2 ON p.productID=t2.object_id LEFT JOIN SC_tags t1 ON AND t2.object_type="product" WHERE ( ( LIKE '%tyr%') AND categoryID<>1 AND enabled=1) OR (categoryID<>1 and enabled=1 AND (( ( `name_ru` LIKE '%tyr%' OR `description_ru` LIKE '%tyr%' OR `brief_description_ru` LIKE '%tyr%') ) OR ( (product_code LIKE '%tyr%')))) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 0,24