Results for Alli (dream Girls:1139 - Got error 'parentheses not balanced' from regexp
select count(*) as total from products p, products_description pd, dvd_info di where p.products_status = '1' and di.dvd_products_id = p.products_id and p.products_id = pd.products_id and (pd.products_name regexp '(^|[^a-z])Alli (dream Girls($|[^a-z])' or pd.products_description regexp '(^|[^a-z])Alli (dream Girls($|[^a-z/-])' or di.dvd_titre2 regexp '(^|[^a-z])Alli (dream Girls($|[^a-z])')