Another SQL error...

This error happens when I use the search - looking for function:

Database error in

Query:

SELECT COUNT(DISTINCT IF( `Profiles`.`Couple`=0, `Profiles`.`ID`, IF( `Profiles`.`Couple`>`Profiles`.`ID`, `Profiles`.`ID`, `Profiles`.`Couple` ) )) AS "Cnt" FROM `Profiles`  WHERE `Profiles`.`LookingFor' AND ( FIND_IN_SET( 'Citizen', `Profiles`.`LocalTownStatus` ) ) AND `Profiles`.`Status` = 'Active' AND (`Profiles`.`Couple`='0' OR `Profiles`.`Couple`>`Profiles`.`ID`)

Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Profiles`.`LocalTownStatus` ) ) AND `Profiles`.`Status` = 'Active' AND (`Profile' at line 1

Found error in the file '/var/www/vhosts/localtown.ca/httpdocs/cms8/templates/base/scripts/BxBaseProfileView.php' at line 881.
Called 'db_value' function with erroneous argument #0.

Any ideas?