120129 11:54:46 98 Connect xbmc@192.168.2.11 on
98 Query SET NAMES utf8
98 Query show databases like 'xbmc_video49'
98 Quit
120129 11:54:51 99 Connect xbmc@192.168.2.11 on
99 Query SET NAMES utf8
99 Query show databases like 'xbmc_video48'
99 Quit
120129 11:55:06 101 Connect xbmc@192.168.2.11 on
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 count(1) from movie
101 Quit
120129 11:55:11 102 Connect xbmc@192.168.2.11 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 count(1) from tvshow
102 Quit
120129 11:55:16 103 Connect xbmc@192.168.2.11 on
103 Query SET NAMES utf8
103 Query show databases like 'xbmc_music18'
103 Query show tables
103 Init DB xbmc_music18
103 Query show databases like 'xbmc_music18'
103 Query show tables
103 Query SELECT idVersion FROM version
103 Query select count(idSong) as NumSongs from songview
103 Quit
120129 11:55:21 104 Connect xbmc@192.168.2.11 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 count(1) from musicvideo
104 Quit
120129 11:55:26 105 Connect xbmc@192.168.2.11 on
105 Query SET NAMES utf8
105 Query show databases like 'xbmc_music18'
105 Query show tables
105 Init DB xbmc_music18
105 Query show databases like 'xbmc_music18'
105 Query show tables
105 Query SELECT idVersion FROM version
105 Query SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
105 Query select * from albumview order by idAlbum desc limit 10
105 Quit
120129 11:55:31 106 Connect xbmc@192.168.2.11 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 * from movieview order by idMovie desc limit 10
106 Query SELECT * FROM streamdetails WHERE idFile = 85
106 Query SELECT * FROM streamdetails WHERE idFile = 84
106 Query SELECT * FROM streamdetails WHERE idFile = 83
106 Query SELECT * FROM streamdetails WHERE idFile = 82
106 Query SELECT * FROM streamdetails WHERE idFile = 81
106 Query SELECT * FROM streamdetails WHERE idFile = 80
106 Query SELECT * FROM streamdetails WHERE idFile = 79
106 Query SELECT * FROM streamdetails WHERE idFile = 78
106 Query SELECT * FROM streamdetails WHERE idFile = 77
106 Query SELECT * FROM streamdetails WHERE idFile = 76