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,574,602,603,692,758,645,755,577,653,556,582,648,765,609,606,593,679,674,604,611,614,600,767,768,760,691,759,605,762,589,763,753,599,684,688,690,685,580,654,766,657,769,581,608,695,697,673,627,626,698,703,704,705,706,686,764,727,725,741,722,638,718,723,575,560,757,752,562,663,712,619,584,632,620,715,669,729,621,664,622,557,720,714,771,675,681,678,672,623,670,667,671,665,666,624,625,699,701,702,710,735,724,719,655,643,615,617,618,616,707,743,559))) AND ( PrdOptVal0.optionID=17 AND ( ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` IN ('Tong¶m_15[]=all')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` IN ('Tong¶m_15[]=all')) OR ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` REGEXP ('#Tong¶m_15[]=all')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` REGEXP ('#Tong¶m_15[]=all')) ) )