You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND
`pixilink_mlsr`.`mlsr_listings`.`status` = 'Active' AND
`pixilink_m...' at line 6
SELECT
COUNT(*) as count
FROM
mlsr_listings
WHERE
`pixilink_mlsr`.`mlsr_listings`.`building_id` IN () AND
`pixilink_mlsr`.`mlsr_listings`.`status` = 'Active' AND
`pixilink_mlsr`.`mlsr_listings`.`reciprocity` = 'Yes'