-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy path6000000.sql
186 lines (186 loc) · 19 KB
/
6000000.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
SELECT `userid` FROM `acknowledges` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `eventid` FROM `acknowledges` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `actionid` FROM `alerts` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `eventid` FROM `alerts` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `userid` FROM `alerts` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `mediatypeid` FROM `alerts` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `p_eventid` FROM `alerts` WHERE `p_eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `acknowledgeid` FROM `alerts` WHERE `acknowledgeid` NOT IN (SELECT `acknowledgeid` FROM `acknowledges`);
SELECT `proxy_hostid` FROM `autoreg_host` WHERE `proxy_hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `actionid` FROM `conditions` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `correlationid` FROM `corr_condition` WHERE `correlationid` NOT IN (SELECT `correlationid` FROM `correlation`);
SELECT `corr_conditionid` FROM `corr_condition_group` WHERE `corr_conditionid` NOT IN (SELECT `corr_conditionid` FROM `corr_condition`);
SELECT `corr_conditionid` FROM `corr_condition_tag` WHERE `corr_conditionid` NOT IN (SELECT `corr_conditionid` FROM `corr_condition`);
SELECT `corr_conditionid` FROM `corr_condition_tagpair` WHERE `corr_conditionid` NOT IN (SELECT `corr_conditionid` FROM `corr_condition`);
SELECT `corr_conditionid` FROM `corr_condition_tagvalue` WHERE `corr_conditionid` NOT IN (SELECT `corr_conditionid` FROM `corr_condition`);
SELECT `correlationid` FROM `corr_operation` WHERE `correlationid` NOT IN (SELECT `correlationid` FROM `correlation`);
SELECT `templateid` FROM `dashboard` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `dashboardid` FROM `dashboard_page` WHERE `dashboardid` NOT IN (SELECT `dashboardid` FROM `dashboard`);
SELECT `dashboardid` FROM `dashboard_user` WHERE `dashboardid` NOT IN (SELECT `dashboardid` FROM `dashboard`);
SELECT `userid` FROM `dashboard_user` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `dashboardid` FROM `dashboard_usrgrp` WHERE `dashboardid` NOT IN (SELECT `dashboardid` FROM `dashboard`);
SELECT `usrgrpid` FROM `dashboard_usrgrp` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `druleid` FROM `dchecks` WHERE `druleid` NOT IN (SELECT `druleid` FROM `drules`);
SELECT `druleid` FROM `dhosts` WHERE `druleid` NOT IN (SELECT `druleid` FROM `drules`);
SELECT `dhostid` FROM `dservices` WHERE `dhostid` NOT IN (SELECT `dhostid` FROM `dhosts`);
SELECT `dcheckid` FROM `dservices` WHERE `dcheckid` NOT IN (SELECT `dcheckid` FROM `dchecks`);
SELECT `eventid` FROM `event_recovery` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `r_eventid` FROM `event_recovery` WHERE `r_eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `c_eventid` FROM `event_recovery` WHERE `c_eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `eventid` FROM `event_suppress` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `maintenanceid` FROM `event_suppress` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `eventid` FROM `event_tag` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `regexpid` FROM `expressions` WHERE `regexpid` NOT IN (SELECT `regexpid` FROM `regexps`);
SELECT `itemid` FROM `functions` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `triggerid` FROM `functions` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `graphid` FROM `graph_discovery` WHERE `graphid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `templateid` FROM `graphs` WHERE `templateid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `graphid` FROM `graphs_items` WHERE `graphid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `itemid` FROM `graphs_items` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `groupid` FROM `group_discovery` WHERE `groupid` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `hostid` FROM `group_prototype` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `group_prototype` WHERE `templateid` NOT IN (SELECT `group_prototypeid` FROM `group_prototype`);
SELECT `hostid` FROM `host_discovery` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `host_inventory` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `host_tag` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `hostmacro` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `hosts` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `hosts_groups` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `groupid` FROM `hosts_groups` WHERE `groupid` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `hostid` FROM `hosts_templates` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `hosts_templates` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `httptestid` FROM `httpstep` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httpstepid` FROM `httpstep_field` WHERE `httpstepid` NOT IN (SELECT `httpstepid` FROM `httpstep`);
SELECT `httpstepid` FROM `httpstepitem` WHERE `httpstepid` NOT IN (SELECT `httpstepid` FROM `httpstep`);
SELECT `itemid` FROM `httpstepitem` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `hostid` FROM `httptest` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `httptest` WHERE `templateid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httptestid` FROM `httptest_field` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httptestid` FROM `httptest_tag` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httptestid` FROM `httptestitem` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `itemid` FROM `httptestitem` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `iconmapid` FROM `icon_mapping` WHERE `iconmapid` NOT IN (SELECT `iconmapid` FROM `icon_map`);
SELECT `hostid` FROM `interface` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `interfaceid` FROM `interface_discovery` WHERE `interfaceid` NOT IN (SELECT `interfaceid` FROM `interface`);
SELECT `parent_interfaceid` FROM `interface_discovery` WHERE `parent_interfaceid` NOT IN (SELECT `interfaceid` FROM `interface`);
SELECT `interfaceid` FROM `interface_snmp` WHERE `interfaceid` NOT IN (SELECT `interfaceid` FROM `interface`);
SELECT `itemid` FROM `item_condition` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_discovery` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `parent_itemid` FROM `item_discovery` WHERE `parent_itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_parameter` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_preproc` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_rtdata` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_tag` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `hostid` FROM `items` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `items` WHERE `templateid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `master_itemid` FROM `items` WHERE `master_itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `lld_macro_path` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `lld_override` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `lld_overrideid` FROM `lld_override_condition` WHERE `lld_overrideid` NOT IN (SELECT `lld_overrideid` FROM `lld_override`);
SELECT `lld_override_operationid` FROM `lld_override_opdiscover` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_overrideid` FROM `lld_override_operation` WHERE `lld_overrideid` NOT IN (SELECT `lld_overrideid` FROM `lld_override`);
SELECT `lld_override_operationid` FROM `lld_override_ophistory` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_opinventory` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_opperiod` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_opseverity` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_opstatus` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_optag` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_optemplate` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `lld_override_operationid` FROM `lld_override_optrends` WHERE `lld_override_operationid` NOT IN (SELECT `lld_override_operationid` FROM `lld_override_operation`);
SELECT `maintenanceid` FROM `maintenance_tag` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `maintenanceid` FROM `maintenances_groups` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `groupid` FROM `maintenances_groups` WHERE `groupid` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `maintenanceid` FROM `maintenances_hosts` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `hostid` FROM `maintenances_hosts` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `maintenanceid` FROM `maintenances_windows` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `timeperiodid` FROM `maintenances_windows` WHERE `timeperiodid` NOT IN (SELECT `timeperiodid` FROM `timeperiods`);
SELECT `userid` FROM `media` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `mediatypeid` FROM `media` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `mediatypeid` FROM `media_type_message` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `mediatypeid` FROM `media_type_param` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `operationid` FROM `opcommand` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opcommand_grp` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opcommand_hst` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opconditions` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `actionid` FROM `operations` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `operationid` FROM `opgroup` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opinventory` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage_grp` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage_usr` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `optemplate` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `eventid` FROM `problem` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `r_eventid` FROM `problem` WHERE `r_eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `eventid` FROM `problem_tag` WHERE `eventid` NOT IN (SELECT `eventid` FROM `problem`);
SELECT `userid` FROM `profiles` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `userid` FROM `report` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `dashboardid` FROM `report` WHERE `dashboardid` NOT IN (SELECT `dashboardid` FROM `dashboard`);
SELECT `reportid` FROM `report_param` WHERE `reportid` NOT IN (SELECT `reportid` FROM `report`);
SELECT `reportid` FROM `report_user` WHERE `reportid` NOT IN (SELECT `reportid` FROM `report`);
SELECT `userid` FROM `report_user` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `reportid` FROM `report_usrgrp` WHERE `reportid` NOT IN (SELECT `reportid` FROM `report`);
SELECT `usrgrpid` FROM `report_usrgrp` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `groupid` FROM `rights` WHERE `groupid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `id` FROM `rights` WHERE `id` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `roleid` FROM `role_rule` WHERE `roleid` NOT IN (SELECT `roleid` FROM `role`);
SELECT `value_moduleid` FROM `role_rule` WHERE `value_moduleid` NOT IN (SELECT `moduleid` FROM `module`);
SELECT `value_serviceid` FROM `role_rule` WHERE `value_serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `scriptid` FROM `script_param` WHERE `scriptid` NOT IN (SELECT `scriptid` FROM `scripts`);
SELECT `serviceid` FROM `service_alarms` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `eventid` FROM `service_problem` WHERE `eventid` NOT IN (SELECT `eventid` FROM `problem`);
SELECT `serviceid` FROM `service_problem` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `serviceid` FROM `service_problem_tag` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `serviceid` FROM `service_status_rule` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `serviceid` FROM `service_tag` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `serviceupid` FROM `services_links` WHERE `serviceupid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `servicedownid` FROM `services_links` WHERE `servicedownid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `userid` FROM `sessions` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `slaid` FROM `sla_excluded_downtime` WHERE `slaid` NOT IN (SELECT `slaid` FROM `sla`);
SELECT `slaid` FROM `sla_schedule` WHERE `slaid` NOT IN (SELECT `slaid` FROM `sla`);
SELECT `slaid` FROM `sla_service_tag` WHERE `slaid` NOT IN (SELECT `slaid` FROM `sla`);
SELECT `selementid` FROM `sysmap_element_trigger` WHERE `selementid` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `triggerid` FROM `sysmap_element_trigger` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `selementid` FROM `sysmap_element_url` WHERE `selementid` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `sysmapid` FROM `sysmap_shape` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `sysmapid` FROM `sysmap_url` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `sysmapid` FROM `sysmap_user` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `userid` FROM `sysmap_user` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `sysmapid` FROM `sysmap_usrgrp` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `usrgrpid` FROM `sysmap_usrgrp` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `selementid` FROM `sysmaps_element_tag` WHERE `selementid` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `sysmapid` FROM `sysmaps_elements` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `linkid` FROM `sysmaps_link_triggers` WHERE `linkid` NOT IN (SELECT `linkid` FROM `sysmaps_links`);
SELECT `triggerid` FROM `sysmaps_link_triggers` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `sysmapid` FROM `sysmaps_links` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `selementid1` FROM `sysmaps_links` WHERE `selementid1` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `selementid2` FROM `sysmaps_links` WHERE `selementid2` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `usrgrpid` FROM `tag_filter` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `groupid` FROM `tag_filter` WHERE `groupid` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `proxy_hostid` FROM `task` WHERE `proxy_hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `taskid` FROM `task_acknowledge` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_check_now` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_close_problem` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_data` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_remote_command` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_remote_command_result` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `taskid` FROM `task_result` WHERE `taskid` NOT IN (SELECT `taskid` FROM `task`);
SELECT `userid` FROM `token` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `triggerid_down` FROM `trigger_depends` WHERE `triggerid_down` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `triggerid_up` FROM `trigger_depends` WHERE `triggerid_up` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `triggerid` FROM `trigger_discovery` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `triggerid` FROM `trigger_tag` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `templateid` FROM `triggers` WHERE `templateid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `roleid` FROM `users` WHERE `roleid` NOT IN (SELECT `roleid` FROM `role`);
SELECT `usrgrpid` FROM `users_groups` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `userid` FROM `users_groups` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `hostid` FROM `valuemap` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `valuemapid` FROM `valuemap_mapping` WHERE `valuemapid` NOT IN (SELECT `valuemapid` FROM `valuemap`);
SELECT `dashboard_pageid` FROM `widget` WHERE `dashboard_pageid` NOT IN (SELECT `dashboard_pageid` FROM `dashboard_page`);
SELECT `widgetid` FROM `widget_field` WHERE `widgetid` NOT IN (SELECT `widgetid` FROM `widget`);
SELECT `value_groupid` FROM `widget_field` WHERE `value_groupid` NOT IN (SELECT `groupid` FROM `hstgrp`);
SELECT `value_hostid` FROM `widget_field` WHERE `value_hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `value_itemid` FROM `widget_field` WHERE `value_itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `value_graphid` FROM `widget_field` WHERE `value_graphid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `value_sysmapid` FROM `widget_field` WHERE `value_sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `value_serviceid` FROM `widget_field` WHERE `value_serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `value_slaid` FROM `widget_field` WHERE `value_slaid` NOT IN (SELECT `slaid` FROM `sla`);