public static function checkUserLinks($socservUserId) { $dbRes = UserTable::getByPrimary($socservUserId); $arUser = $dbRes->fetch(); if ($arUser) { $sql = "\nSELECT sul.ID, su_link.USER_ID\nFROM " . self::getTableName() . " sul\nLEFT JOIN " . SocservUserTable::getTableName() . " su_link ON sul.LINK_UID=su_link.XML_ID\nWHERE (1=1)\nAND sul.SOCSERV_USER_ID='" . $arUser['ID'] . "'\nAND su_link.EXTERNAL_AUTH_ID='" . $arUser['EXTERNAL_AUTH_ID'] . "'\nAND sul.LINK_USER_ID IS NULL\n"; $connection = \Bitrix\Main\Application::getConnection(); return $connection->query($sql); } else { return false; } }