Missing join: webform_submissions node

[alanmels]

Through everything on UI looks good and is working just fine for me:

I have the following Views page giving the error in title:

{
    "_config_name": "views.view.calendar",
    "name": "calendar",
    "description": "",
    "tag": "default",
    "disabled": false,
    "base_table": "node",
    "human_name": "Calendar",
    "core": "1.21.4",
    "display": {
        "default": {
            "display_title": "Master",
            "display_plugin": "default",
            "display_options": {
                "query": {
                    "type": "views_query",
                    "options": []
                },
                "access": {
                    "type": "role",
                    "role": {
                        "administrator": "administrator"
                    }
                },
                "cache": {
                    "type": "none"
                },
                "exposed_form": {
                    "type": "basic"
                },
                "pager": {
                    "type": "full",
                    "options": {
                        "items_per_page": "10"
                    }
                },
                "style_plugin": "table",
                "row_plugin": "fields",
                "fields": {
                    "sid": {
                        "id": "sid",
                        "table": "webform_submissions",
                        "field": "sid"
                    },
                    "completed": {
                        "id": "completed",
                        "table": "webform_submissions",
                        "field": "completed",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "Completed",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "date_format": "short",
                        "custom_date_format": "",
                        "timezone": ""
                    },
                    "value": {
                        "id": "value",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "Title",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "9",
                        "webform_datatype": "string"
                    },
                    "value_1": {
                        "id": "value_1",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "10",
                        "webform_datatype": "string"
                    },
                    "value_2": {
                        "id": "value_2",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "Address",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "custom",
                        "webform_nid": "10",
                        "webform_cid": "7",
                        "webform_datatype": "string"
                    },
                    "value_3": {
                        "id": "value_3",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "15",
                        "webform_datatype": "string"
                    },
                    "value_4": {
                        "id": "value_4",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "24",
                        "webform_datatype": "string"
                    },
                    "value_5": {
                        "id": "value_5",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "25",
                        "webform_datatype": "string"
                    },
                    "value_6": {
                        "id": "value_6",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "11",
                        "webform_datatype": "string"
                    },
                    "value_7": {
                        "id": "value_7",
                        "table": "webform_submissions",
                        "field": "value",
                        "relationship": "webform_submission",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": 1,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "format": "html",
                        "custom_label": "default",
                        "webform_nid": "10",
                        "webform_cid": "12",
                        "webform_datatype": "string"
                    }
                },
                "filters": {
                    "status": {
                        "value": 1,
                        "table": "node",
                        "field": "status",
                        "id": "status",
                        "expose": {
                            "operator": false
                        },
                        "group": 1
                    },
                    "type": {
                        "id": "type",
                        "table": "node",
                        "field": "type",
                        "value": {
                            "webform": "webform"
                        }
                    }
                },
                "sorts": {
                    "created": {
                        "id": "created",
                        "table": "node",
                        "field": "created",
                        "order": "DESC"
                    }
                },
                "title": "Calendar",
                "relationships": {
                    "webform_submission": {
                        "id": "webform_submission",
                        "table": "node",
                        "field": "webform_submission",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "Webform Submission",
                        "required": 0
                    }
                },
                "style_options": {
                    "grouping": [],
                    "row_class": "",
                    "default_row_class": 1,
                    "row_class_special": 1,
                    "override": 1,
                    "sticky": 0,
                    "caption": "",
                    "summary": "",
                    "columns": {
                        "sid": "sid",
                        "completed": "completed",
                        "value": "value",
                        "value_1": "value_1",
                        "value_2": "value_2",
                        "value_3": "value_3",
                        "value_4": "value_3",
                        "value_5": "value_5",
                        "value_6": "value_6",
                        "value_7": "value_7"
                    },
                    "info": {
                        "sid": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "completed": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_1": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_2": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_3": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": " - ",
                            "empty_column": 0
                        },
                        "value_4": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_5": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_6": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        },
                        "value_7": {
                            "sortable": 0,
                            "default_sort_order": "asc",
                            "align": "",
                            "separator": "",
                            "empty_column": 0
                        }
                    },
                    "default": "-1",
                    "empty_table": 0
                },
                "arguments": {
                    "nid": {
                        "id": "nid",
                        "table": "node",
                        "field": "nid",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "default_action": "default",
                        "exception": {
                            "value": "all",
                            "title_enable": 0,
                            "title": "All"
                        },
                        "title_enable": 0,
                        "title": "",
                        "breadcrumb_enable": 0,
                        "breadcrumb": "",
                        "default_argument_type": "fixed",
                        "default_argument_options": {
                            "argument": "10"
                        },
                        "default_argument_skip_url": 0,
                        "summary_options": {
                            "base_path": "",
                            "count": "1",
                            "items_per_page": "25",
                            "override": 0
                        },
                        "summary": {
                            "sort_order": "asc",
                            "number_of_records": "0",
                            "format": "default_summary"
                        },
                        "specify_validation": 0,
                        "validate": {
                            "type": "none",
                            "fail": "not found"
                        },
                        "validate_options": [],
                        "break_phrase": 0,
                        "not": 0
                    }
                }
            }
        },
        "page": {
            "display_title": "Page",
            "display_plugin": "page",
            "display_options": {
                "query": {
                    "type": "views_query",
                    "options": []
                },
                "path": "calendar"
            }
        },
        "block_1": {
            "display_title": "Block",
            "display_plugin": "block",
            "display_options": {
                "query": {
                    "type": "views_query",
                    "options": []
                }
            }
        }
    }
}