Got error -1 from storage engine
SELECT SQL_CALC_FOUND_ROWS p.*, name_ru AS _name_sort FROM SC_products p LEFT JOIN SC_product_options_values PrdOptVal0 ON p.productID=PrdOptVal0.productID LEFT JOIN SC_product_options_set PrdOptSet0 ON p.productID=PrdOptSet0.productID LEFT JOIN SC_products_opt_val_variants PrdOptValVar0 ON PrdOptSet0.optionID=PrdOptValVar0.optionID AND PrdOptSet0.variantID=PrdOptValVar0.variantID WHERE categoryID not in (1) and ((( (p.productID IN (678,680,683,684,693,695,719,769,1984,2000,2138,2214,2691,2846,2955,3031,3069,3212,3373,3374,3402,3587,4751,4794,5775,6174,6175,6176,6177,6178,6212,6366,6370,6690,6698,6883,6886,6889,6968,7010,7197,7198,7219,7331,7332,7333,7334,7335,7336,7337,7338,7373,7505,7576,7577,7616,7665,7702,7703,7824,7896,8041,8046,8054,8119,8173,8593,8811,8820,8821,8973,8974,9556,9748,9965,10085,10127,10134,10542,10543,10601,10692,11392,11422,12071,12073,14426,14782,15005,15149,15213,15251,15697,16396,17810,17892,17930,17931,17932,18009,18069,18077,18474)) OR (categoryID IN (556,560,564,565,566,571,574,580,581,614,557,558,559,561,562,563,567,568,569,570,572,573,575,576,578,579,582,583,584,585,586,587,588,594,597,610,615,616,617,622,623,625,636,637,638,639,644,642,649,650,651,595,596,598,599,600,601,606,631,634,635,640,645,647,1)) ) AND ( enabled=1)) AND ( PrdOptVal0.optionID=23 AND ( ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` = ". $search_name .") OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` = "Special Hobby" )))) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 0,12