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 (556))) AND ( PrdOptVal0.optionID=17 AND ( ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` IN ('Roncato¶m_18[]=Modo Jupiter')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` IN ('Roncato¶m_18[]=Modo Jupiter')) OR ( PrdOptVal0.option_type=1 AND PrdOptValVar0.`option_value_ru` REGEXP ('#Roncato¶m_18[]=Modo Jupiter')) OR ( PrdOptVal0.option_type=0 AND PrdOptVal0.`option_value_ru` REGEXP ('#Roncato¶m_18[]=Modo Jupiter')) ) )