MariaDB [mythconverg]> select hostname,value,data from (select s.hostname,s.value,s.data from settings s union all select o.hostname,o.value,o.data from settings_old o) t where hostname is null or hostname='mypvr' group by hostname,value having count(*)=1 order by hostname,value; +----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | hostname | value | data | +----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | NULL | BrowserDBSchemaVer | 1002 | | NULL | Country | NZ | | NULL | Language | en_GB | | NULL | MovieGrabber | metadata/Movie/tmdb3.py | | NULL | MusicStreamListModified | 2016-02-10T13:20:13Z | | NULL | recommend_enabled | | | NULL | recommend_key | REQUIRED | | NULL | recommend_server | http://myth-recommendations.aws.af.cm/ | | NULL | TelevisionGrabber | metadata/Television/ttvdb.py | | mypvr | AllowLinkLocal | 1 | | mypvr | AllowTagWriting | 1 | | mypvr | DailyArtworkUpdates | 0 | | mypvr | EventCmdLivetvStarted | /usr/local/bin/mythsgu event LivetvStarted | | mypvr | EventCmdMasterShutdown | /usr/local/bin/mythsgu event MasterShutdown | | mypvr | EventCmdMasterStarted | /usr/local/bin/mythsgu event MasterStarted | | mypvr | EventCmdPlayPaused | /usr/local/bin/mythsgu event PlayPaused | | mypvr | EventCmdPlayStarted | /usr/local/bin/mythsgu event PlayStarted | | mypvr | EventCmdPlayStopped | /usr/local/bin/mythsgu event PlayStopped | | mypvr | EventCmdPlayUnpaused | /usr/local/bin/mythsgu event PlayUnpaused | | mypvr | EventCmdRecDeleted | /usr/local/bin/event_test.sh %HOSTNAME% %CHANID% %DIR% %FILE% %PROGSTARTISOUTC% %PROGENDISOUTC% %STARTTIMEISOUTC% %ENDTIMEISOUTC% %RECGROUP% %TITLE% | | mypvr | EventCmdRecExpired | /usr/local/bin/mythsgu event RecExpired %FILE% | | mypvr | EventCmdRecFinished | /usr/local/bin/mythsgu event RecFinished | | mypvr | EventCmdRecPending | /usr/local/bin/mythsgu event RecPending | | mypvr | EventCmdRecStarted | /usr/local/bin/mythsgu event RecStarted | | mypvr | EventCmdSchedulerRan | /usr/local/bin/mythsgu event SchedulerRan | | mypvr | GalleryDirCaption | 1 | | mypvr | GalleryImageCaption | 1 | | mypvr | JobAllowMetadata | 1 | | mypvr | MusicJumpPointAction | stop | | mypvr | MusicScannerLastRunEnd | 2016-07-24T14:24:01Z | | mypvr | MusicScannerLastRunStart | 2016-07-24T14:24:01Z | | mypvr | MusicScannerLastRunStatus | success - total tracks found: 118 (unchanged: 108, added: 10, removed: 0, updated 0) - total coverart found: 9 (unchanged: 1, added: 8, removed: 0, updated 0) | | mypvr | mythgame.MetadataGrabber | | | mypvr | mythvideo.folder_view_1 | 0 | | mypvr | mythvideoDefaultBrowse | -1 | | mypvr | mythvideoDefaultCast | -1 | | mypvr | mythvideoDefaultCategory | -1 | | mypvr | mythvideoDefaultCountry | -1 | | mypvr | mythvideoDefaultCoverFile | -1 | | mypvr | mythvideoDefaultFilter | ty9 - | | mypvr | mythvideoDefaultGenre | -1 | | mypvr | mythvideoDefaultInetRef | -1 | | mypvr | mythvideoDefaultOrderby | 0 | | mypvr | mythvideoDefaultRuntime | -2 | | mypvr | mythvideoDefaultUserrating | -1 | | mypvr | mythvideoDefaultWatched | -1 | | mypvr | mythvideoDefaultYear | -1 | | mypvr | ResumeModeEditor | 0 | | mypvr | ResumeModePlayback | 3 | | mypvr | ResumeModeRadio | 2 | +----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+ 50 rows in set (0.04 sec)