Got error 'brackets ([ ]) not balanced' from regexp
SELECT COUNT(DISTINCT p.productID) as cnt 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 IN (677,675,681,678,727,619,620,664,672,623,611,670,621,667,671,665,666,669,624,625,699,701,702,622,714,710,722,715,735,724,719,758,648,603,653,657,602,582,764,755,605,762,654,691,604,608,655,643,763,673,674,663,759,679,645,614,615,589,617,618,616,707,609,765,593,760,575,627,712,743,706,606,584,574,559))) AND ( PrdOptVal0.optionID=17 AND ( ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` IN ('Doppler¶m_15[]=ÐаÑниÑа')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` IN ('Doppler¶m_15[]=ÐаÑниÑа')) OR ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` REGEXP ('#Doppler¶m_15[]=ÐаÑниÑа')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` REGEXP ('#Doppler¶m_15[]=ÐаÑниÑа')) ) )