Category query is select * from wp_biz_listings bl left join wp_biz_categories bc on bl.category_id=bc.category_id WHERE bl.category_id = 'Vanity_Mansion.php' AND status= 1 AND ( REPLACE(REPLACE(REPLACE(REPLACE(company_name,'(',''),')',''),'&','and'),'@','at')='78' || REPLACE(company_name,'&','and')='78')