I've disabled the blacklist module. Does not help.

In my opinion is the problem here:

INNER JOIN `sys_profiles` ON 
  `sys_profiles` .`content_id`=`bx_persons_data`.`id` 
INNER JOIN `bx_persons_meta_locations` ON 
  `bx_persons_meta_locations`.`object_id`=`bx_persons_data`.`id` 
INNER JOIN `sys_profiles` ON 
  `sys_profiles`.`id`=ABS(`bx_persons_data`.`author`)

The sys_profiles table is joined two times without defining an alias for them. This results in a "confusion" when then later in the WHERE clause (for example)

`sys_profiles`.`status` ='active'

mentioned. The table is joined two times and the DB does not know from which joined table the data should be taken.