private function enqueue_all_posts()
 {
     global $wpdb;
     $this->set_status('posts', 0);
     $post_type_sql = Jetpack_Sync_Defaults::get_blacklisted_post_types_sql();
     $this->enqueue_all_ids_as_action('jetpack_full_sync_posts', $wpdb->posts, 'ID', $post_type_sql, 'posts');
     $this->set_status('posts', 100);
 }
    public function posts_checksum()
    {
        global $wpdb;
        $post_type_sql = Jetpack_Sync_Defaults::get_blacklisted_post_types_sql();
        $query = <<<ENDSQL
\t\t\tSELECT CONV(BIT_XOR(CRC32(CONCAT(ID,post_modified))), 10, 16) 
\t\t\t\tFROM {$wpdb->posts}
\t\t\t\tWHERE {$post_type_sql}
ENDSQL;
        return $wpdb->get_var($query);
    }