120129 11:50:24 94 Connect xbmc@Apple-TV.local on 94 Query SET NAMES utf8 94 Query show databases like 'xbmc_video58' 94 Query show tables 94 Init DB xbmc_video58 94 Query show databases like 'xbmc_video58' 94 Query show tables 94 Query SELECT idVersion FROM version 94 Query select count(1) from movie 94 Quit 95 Connect xbmc@Apple-TV.local on 95 Query SET NAMES utf8 95 Query show databases like 'xbmc_video58' 95 Query show tables 95 Init DB xbmc_video58 95 Query show databases like 'xbmc_video58' 95 Query show tables 95 Query SELECT idVersion FROM version 95 Query select count(1) from tvshow 95 Quit 96 Connect xbmc@Apple-TV.local on 96 Query SET NAMES utf8 96 Query show databases like 'xbmc_music18' 96 Query show tables 96 Init DB xbmc_music18 96 Query show databases like 'xbmc_music18' 96 Query show tables 96 Query SELECT idVersion FROM version 96 Query select count(idSong) as NumSongs from songview 96 Quit 120129 11:50:26 97 Connect xbmc@Apple-TV.local on 97 Query SET NAMES utf8 97 Query show databases like 'xbmc_video58' 97 Query show tables 97 Init DB xbmc_video58 97 Query show databases like 'xbmc_video58' 97 Query show tables 97 Query SELECT idVersion FROM version 97 Query select count(1) from musicvideo 97 Quit 98 Connect xbmc@Apple-TV.local on 98 Query SET NAMES utf8 98 Query show databases like 'xbmc_music18' 98 Query show tables 98 Init DB xbmc_music18 98 Query show databases like 'xbmc_music18' 98 Query show tables 98 Query SELECT idVersion FROM version 98 Query SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum 98 Query select * from albumview order by idAlbum desc limit 10 98 Quit 99 Connect xbmc@Apple-TV.local on 99 Query SET NAMES utf8 99 Query show databases like 'xbmc_video58' 99 Query show tables 99 Init DB xbmc_video58 99 Query show databases like 'xbmc_video58' 99 Query show tables 99 Query SELECT idVersion FROM version 99 Query select * from movieview order by idMovie desc limit 10 99 Query SELECT * FROM streamdetails WHERE idFile = 85 99 Query SELECT * FROM streamdetails WHERE idFile = 84 99 Query SELECT * FROM streamdetails WHERE idFile = 83 99 Query SELECT * FROM streamdetails WHERE idFile = 82 99 Query SELECT * FROM streamdetails WHERE idFile = 81 99 Query SELECT * FROM streamdetails WHERE idFile = 80 99 Query SELECT * FROM streamdetails WHERE idFile = 79 99 Query SELECT * FROM streamdetails WHERE idFile = 78 99 Query SELECT * FROM streamdetails WHERE idFile = 77 99 Query SELECT * FROM streamdetails WHERE idFile = 76 100 Connect xbmc@Apple-TV.local on 100 Query SET NAMES utf8 100 Query show databases like 'xbmc_video58' 100 Query show tables 100 Init DB xbmc_video58 100 Query show databases like 'xbmc_video58' 100 Query show tables 100 Query SELECT idVersion FROM version 100 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=85 and type=1 order by timeInSeconds 100 Quit 101 Connect xbmc@Apple-TV.local on 120129 11:50:27 101 Query SET NAMES utf8 101 Query show databases like 'xbmc_video58' 101 Query show tables 101 Init DB xbmc_video58 101 Query show databases like 'xbmc_video58' 101 Query show tables 101 Query SELECT idVersion FROM version 101 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=84 and type=1 order by timeInSeconds 101 Quit 102 Connect xbmc@Apple-TV.local on 102 Query SET NAMES utf8 102 Query show databases like 'xbmc_video58' 102 Query show tables 102 Init DB xbmc_video58 102 Query show databases like 'xbmc_video58' 102 Query show tables 102 Query SELECT idVersion FROM version 102 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=83 and type=1 order by timeInSeconds 102 Quit 103 Connect xbmc@Apple-TV.local on 103 Query SET NAMES utf8 103 Query show databases like 'xbmc_video58' 103 Query show tables 103 Init DB xbmc_video58 103 Query show databases like 'xbmc_video58' 103 Query show tables 103 Query SELECT idVersion FROM version 103 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=82 and type=1 order by timeInSeconds 103 Quit 104 Connect xbmc@Apple-TV.local on 104 Query SET NAMES utf8 104 Query show databases like 'xbmc_video58' 104 Query show tables 104 Init DB xbmc_video58 104 Query show databases like 'xbmc_video58' 104 Query show tables 104 Query SELECT idVersion FROM version 104 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=81 and type=1 order by timeInSeconds 104 Quit 105 Connect xbmc@Apple-TV.local on 105 Query SET NAMES utf8 105 Query show databases like 'xbmc_video58' 105 Query show tables 105 Init DB xbmc_video58 105 Query show databases like 'xbmc_video58' 105 Query show tables 105 Query SELECT idVersion FROM version 105 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=80 and type=1 order by timeInSeconds 105 Quit 106 Connect xbmc@Apple-TV.local on 106 Query SET NAMES utf8 106 Query show databases like 'xbmc_video58' 106 Query show tables 106 Init DB xbmc_video58 106 Query show databases like 'xbmc_video58' 106 Query show tables 106 Query SELECT idVersion FROM version 106 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=79 and type=1 order by timeInSeconds 106 Quit 107 Connect xbmc@Apple-TV.local on 107 Query SET NAMES utf8 107 Query show databases like 'xbmc_video58' 107 Query show tables 107 Init DB xbmc_video58 107 Query show databases like 'xbmc_video58' 107 Query show tables 107 Query SELECT idVersion FROM version 107 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=78 and type=1 order by timeInSeconds 107 Quit 108 Connect xbmc@Apple-TV.local on 108 Query SET NAMES utf8 108 Query show databases like 'xbmc_video58' 108 Query show tables 108 Init DB xbmc_video58 108 Query show databases like 'xbmc_video58' 108 Query show tables 108 Query SELECT idVersion FROM version 108 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=77 and type=1 order by timeInSeconds 108 Quit 109 Connect xbmc@Apple-TV.local on 109 Query SET NAMES utf8 109 Query show databases like 'xbmc_video58' 109 Query show tables 109 Init DB xbmc_video58 109 Query show databases like 'xbmc_video58' 109 Query show tables 109 Query SELECT idVersion FROM version 109 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=76 and type=1 order by timeInSeconds 109 Quit 99 Query select * from episodeview order by idEpisode desc limit 10 99 Query SELECT * FROM streamdetails WHERE idFile = 15 99 Query SELECT * FROM streamdetails WHERE idFile = 14 99 Query SELECT * FROM streamdetails WHERE idFile = 13 99 Query SELECT * FROM streamdetails WHERE idFile = 12 99 Query SELECT * FROM streamdetails WHERE idFile = 11 99 Query SELECT * FROM streamdetails WHERE idFile = 10 120129 11:50:28 110 Connect xbmc@Apple-TV.local on 110 Query SET NAMES utf8 110 Query show databases like 'xbmc_video58' 110 Query show tables 110 Init DB xbmc_video58 110 Query show databases like 'xbmc_video58' 110 Query show tables 110 Query SELECT idVersion FROM version 110 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=15 and type=1 order by timeInSeconds 110 Quit 111 Connect xbmc@Apple-TV.local on 111 Query SET NAMES utf8 111 Query show databases like 'xbmc_video58' 111 Query show tables 111 Init DB xbmc_video58 111 Query show databases like 'xbmc_video58' 111 Query show tables 111 Query SELECT idVersion FROM version 111 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=14 and type=1 order by timeInSeconds 111 Quit 112 Connect xbmc@Apple-TV.local on 112 Query SET NAMES utf8 112 Query show databases like 'xbmc_video58' 112 Query show tables 112 Init DB xbmc_video58 112 Query show databases like 'xbmc_video58' 112 Query show tables 112 Query SELECT idVersion FROM version 112 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=13 and type=1 order by timeInSeconds 112 Quit 113 Connect xbmc@Apple-TV.local on 113 Query SET NAMES utf8 113 Query show databases like 'xbmc_video58' 113 Query show tables 113 Init DB xbmc_video58 113 Query show databases like 'xbmc_video58' 113 Query show tables 113 Query SELECT idVersion FROM version 113 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=12 and type=1 order by timeInSeconds 113 Quit 114 Connect xbmc@Apple-TV.local on 114 Query SET NAMES utf8 114 Query show databases like 'xbmc_video58' 114 Query show tables 114 Init DB xbmc_video58 114 Query show databases like 'xbmc_video58' 114 Query show tables 114 Query SELECT idVersion FROM version 114 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=11 and type=1 order by timeInSeconds 114 Quit 115 Connect xbmc@Apple-TV.local on 115 Query SET NAMES utf8 115 Query show databases like 'xbmc_video58' 115 Query show tables 115 Init DB xbmc_video58 115 Query show databases like 'xbmc_video58' 115 Query show tables 115 Query SELECT idVersion FROM version 115 Query select timeInSeconds, totalTimeInSeconds from bookmark where idFile=10 and type=1 order by timeInSeconds 115 Quit 120129 11:50:29 99 Query select * from musicvideoview order by idMVideo desc limit 10 99 Quit 116 Connect xbmc@Apple-TV.local on 116 Query SET NAMES utf8 116 Query show databases like 'xbmc_music18' 116 Query show tables 116 Init DB xbmc_music18 116 Query show databases like 'xbmc_music18' 116 Query show tables 116 Query SELECT idVersion FROM version 116 Query SELECT count(1) FROM songview LIMIT 1 116 Query SELECT count(distinct strAlbum) FROM songview LIMIT 1 116 Query SELECT count(distinct strArtist) FROM songview LIMIT 1 116 Quit 117 Connect xbmc@Apple-TV.local on 117 Query SET NAMES utf8 117 Query show databases like 'xbmc_video58' 117 Query show tables 117 Init DB xbmc_video58 117 Query show databases like 'xbmc_video58' 117 Query show tables 117 Query SELECT idVersion FROM version 117 Query SELECT count(1) FROM tvshowview LIMIT 1 117 Query SELECT count(1) FROM movieview LIMIT 1 117 Query SELECT count(playCount) FROM movieview LIMIT 1 117 Query SELECT count(1) FROM musicvideoview LIMIT 1 117 Query SELECT count(playCount) FROM musicvideoview LIMIT 1 117 Query SELECT sum(watchedcount) FROM tvshowview LIMIT 1 117 Query SELECT sum(totalcount) FROM tvshowview LIMIT 1 117 Query SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1 117 Quit