BPMediaAlbumimporter::get_remaining_comments PHP Method

    function get_remaining_comments()
    {
        global $wpdb;
        $bp_album_table = $wpdb->base_prefix . 'bp_album';
        $activity_table = $wpdb->base_prefix . 'bp_activity';
        if ($this->table_exists($bp_album_table)) {
            // @codingStandardsIgnoreStart
            return $wpdb->get_var("SELECT SUM( b.count ) AS total\n                                        FROM (\n                                            SELECT (\n                                                SELECT COUNT( a.id )\n                                                FROM {$activity_table} a\n                                                WHERE a.item_id = activity.id\n                                                AND a.component =  'activity'\n                                                AND a.type =  'activity_comment'\n                                            ) AS count\n                                            FROM {$activity_table} AS activity\n                                            INNER JOIN {$bp_album_table} AS album ON ( album.id = activity.item_id )\n                                            WHERE activity.component =  'album'\n                                            AND activity.type =  'bp_album_picture'\n                                            AND album.import_status =0\n                                        )b");
            // @codingStandardsIgnoreEnd
        }
        return 0;
    }