CRITICAL ERROR: Could not run query, SQL: SELECT `member`.`memberID`, `member`.`member_name`, `member`.`member_pict_small`, `member`.`member_pict_med`, `member`.`member_pict_large`, `member`.`member_url`, CASE WHEN `manhattan`.`member_addressID` IS NOT NULL THEN '1' ELSE '0' END AS `member_manhattan`, CASE WHEN `non_manhattan`.`member_addressID` IS NOT NULL THEN '1' ELSE '0' END AS `member_non_manhattan` FROM `equipe_member` AS `member` LEFT JOIN `equipe_member_address` AS `manhattan` ON `member`.`memberID` = `manhattan`.`memberID` AND `manhattan`.`recordStatus` = '1' AND `manhattan`.`member_address_city` = 'New York' LEFT JOIN `equipe_member_address` AS `non_manhattan` ON `member`.`memberID` = `non_manhattan`.`memberID` AND `non_manhattan`.`recordStatus` = '1' AND `non_manhattan`.`member_address_city` != 'New York' WHERE `member`.`recordStatus` = '1' GROUP BY `member`.`memberID` ORDER BY `member`.`memberID` ASC