Table './c2ducart/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 t2.tag_id=t1.id AND t2.object_type="product"
WHERE ( ( t1.name LIKE '%ÑÑÑÑйнÑе%') AND categoryID<>1 AND enabled=1) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 0,10