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