JSON Request (movies: title, art, file, cast), limits: 0:35 00:24:36 25316.820312 T:2845832272 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "params": {"sort": {"order": "ascending", "method": "title"}, "properties": ["title", "art", "file", "cast"], "limits": {"start": 0, "end": 35}}, "method": "VideoLibrary.GetMovies", "id": "libMovies"} MySQL Queries: 140224 0:24:36 92876 Connect xbmc@192.168.0.8 on 92876 Query SET NAMES utf8 92876 Query show databases like 'MyVideos78' 92876 Query show tables 92876 Init DB MyVideos78 92876 Query show databases like 'MyVideos78' 92876 Query show tables 92876 Query select * from movieview 140224 0:24:37 92876 Query select * from movieview where idMovie=1 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=1 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 1 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=1 92876 Query SELECT * FROM streamdetails WHERE idFile = 1 92876 Query select * from movieview where idMovie=358 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=358 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 358 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=358 92876 Query SELECT * FROM streamdetails WHERE idFile = 358 92876 Query select * from movieview where idMovie=295 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=295 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 295 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=295 92876 Query SELECT * FROM streamdetails WHERE idFile = 295 92876 Query select * from movieview where idMovie=635 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=635 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 635 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=635 92876 Query SELECT * FROM streamdetails WHERE idFile = 3172 92876 Query select * from movieview where idMovie=2 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=2 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 2 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=2 92876 Query SELECT * FROM streamdetails WHERE idFile = 2 92876 Query select * from movieview where idMovie=3 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=3 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 3 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=3 92876 Query SELECT * FROM streamdetails WHERE idFile = 3 92876 Query select * from movieview where idMovie=428 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=428 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 428 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=428 92876 Query SELECT * FROM streamdetails WHERE idFile = 428 92876 Query select * from movieview where idMovie=4 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=4 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 4 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=4 92876 Query SELECT * FROM streamdetails WHERE idFile = 4 92876 Query select * from movieview where idMovie=5 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=5 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 5 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=5 92876 Query SELECT * FROM streamdetails WHERE idFile = 5 92876 Query select * from movieview where idMovie=6 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=6 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 6 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=6 92876 Query SELECT * FROM streamdetails WHERE idFile = 6 92876 Query select * from movieview where idMovie=7 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=7 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 7 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=7 92876 Query SELECT * FROM streamdetails WHERE idFile = 7 92876 Query select * from movieview where idMovie=8 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=8 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 8 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=8 92876 Query SELECT * FROM streamdetails WHERE idFile = 8 92876 Query select * from movieview where idMovie=9 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=9 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 9 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=9 92876 Query SELECT * FROM streamdetails WHERE idFile = 9 92876 Query select * from movieview where idMovie=10 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=10 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 10 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=10 92876 Query SELECT * FROM streamdetails WHERE idFile = 10 92876 Query select * from movieview where idMovie=636 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=636 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 636 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=636 92876 Query SELECT * FROM streamdetails WHERE idFile = 3173 92876 Query select * from movieview where idMovie=637 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=637 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 637 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=637 92876 Query SELECT * FROM streamdetails WHERE idFile = 3174 92876 Query select * from movieview where idMovie=725 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=725 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 725 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=725 92876 Query SELECT * FROM streamdetails WHERE idFile = 3535 92876 Query select * from movieview where idMovie=611 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=611 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 611 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=611 92876 Query SELECT * FROM streamdetails WHERE idFile = 2983 92876 Query select * from movieview where idMovie=12 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=12 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 12 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=12 92876 Query SELECT * FROM streamdetails WHERE idFile = 12 92876 Query select * from movieview where idMovie=413 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=413 ORDER BY actorlinkmovie.iOrder 140224 0:24:38 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 413 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=413 92876 Query SELECT * FROM streamdetails WHERE idFile = 413 92876 Query select * from movieview where idMovie=621 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=621 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 621 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=621 92876 Query SELECT * FROM streamdetails WHERE idFile = 387 92876 Query select * from movieview where idMovie=467 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=467 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 467 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=467 92876 Query SELECT * FROM streamdetails WHERE idFile = 467 92876 Query select * from movieview where idMovie=638 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=638 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 638 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=638 92876 Query SELECT * FROM streamdetails WHERE idFile = 3175 92876 Query select * from movieview where idMovie=622 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=622 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 622 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=622 92876 Query SELECT * FROM streamdetails WHERE idFile = 388 92876 Query select * from movieview where idMovie=671 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=671 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 671 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=671 92876 Query SELECT * FROM streamdetails WHERE idFile = 3339 92876 Query select * from movieview where idMovie=721 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=721 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 721 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=721 92876 Query SELECT * FROM streamdetails WHERE idFile = 3518 92876 Query select * from movieview where idMovie=13 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=13 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 13 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=13 92876 Query SELECT * FROM streamdetails WHERE idFile = 13 92876 Query select * from movieview where idMovie=313 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=313 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 313 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=313 92876 Query SELECT * FROM streamdetails WHERE idFile = 313 92876 Query select * from movieview where idMovie=315 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=315 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 315 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=315 92876 Query SELECT * FROM streamdetails WHERE idFile = 315 92876 Query select * from movieview where idMovie=316 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=316 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 316 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=316 92876 Query SELECT * FROM streamdetails WHERE idFile = 316 92876 Query select * from movieview where idMovie=314 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=314 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 314 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=314 92876 Query SELECT * FROM streamdetails WHERE idFile = 314 92876 Query select * from movieview where idMovie=341 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=341 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 341 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=341 92876 Query SELECT * FROM streamdetails WHERE idFile = 341 92876 Query select * from movieview where idMovie=429 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=429 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 429 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=429 92876 Query SELECT * FROM streamdetails WHERE idFile = 429 92876 Query select * from movieview where idMovie=332 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=332 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 332 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=332 92876 Query SELECT * FROM streamdetails WHERE idFile = 332 92876 Query select * from movieview where idMovie=14 92876 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=14 ORDER BY actorlinkmovie.iOrder 92876 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 14 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92876 Query select * from movielinktvshow where idMovie=14 92876 Query SELECT * FROM streamdetails WHERE idFile = 14 92877 Connect xbmc@192.168.0.8 on 92877 Query SET NAMES utf8 92877 Query show databases like 'MyVideos78' 92877 Query show tables 92877 Init DB MyVideos78 92877 Query show databases like 'MyVideos78' 92877 Query show tables 92877 Query SELECT type,url FROM art WHERE media_id=1 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=358 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=295 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=635 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=2 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=3 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=428 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=4 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=5 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=6 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=7 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=8 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=9 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=10 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=636 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=637 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=725 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=611 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=12 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=413 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=621 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=467 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=638 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=622 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=671 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=721 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=13 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=313 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=315 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=316 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=314 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=341 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=429 AND media_type='movie' 140224 0:24:39 92877 Query SELECT type,url FROM art WHERE media_id=332 AND media_type='movie' 92877 Query SELECT type,url FROM art WHERE media_id=14 AND media_type='movie' 92877 Quit 92876 Quit JSON Request (movies: title, art, file, cast), limits: 35:70 00:24:39 25319.796875 T:2845832272 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "params": {"sort": {"order": "ascending", "method": "title"}, "properties": ["title", "art", "file", "cast"], "limits": {"start": 35, "end": 70}}, "method": "VideoLibrary.GetMovies", "id": "libMovies"} MySQL Queries: 92878 Connect xbmc@192.168.0.8 on 92878 Query SET NAMES utf8 92878 Query show databases like 'MyVideos78' 92878 Query show tables 92878 Init DB MyVideos78 92878 Query show databases like 'MyVideos78' 92878 Query show tables 92878 Query select * from movieview 140224 0:24:40 92878 Query select * from movieview where idMovie=15 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=15 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 15 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=15 92878 Query SELECT * FROM streamdetails WHERE idFile = 15 92878 Query select * from movieview where idMovie=16 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=16 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 16 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=16 92878 Query SELECT * FROM streamdetails WHERE idFile = 16 92878 Query select * from movieview where idMovie=639 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=639 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 639 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=639 92878 Query SELECT * FROM streamdetails WHERE idFile = 3176 92878 Query select * from movieview where idMovie=17 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=17 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 17 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=17 92878 Query SELECT * FROM streamdetails WHERE idFile = 17 92878 Query select * from movieview where idMovie=18 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=18 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 18 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=18 92878 Query SELECT * FROM streamdetails WHERE idFile = 18 92878 Query select * from movieview where idMovie=19 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=19 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 19 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=19 92878 Query SELECT * FROM streamdetails WHERE idFile = 19 92878 Query select * from movieview where idMovie=20 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=20 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 20 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=20 92878 Query SELECT * FROM streamdetails WHERE idFile = 20 92878 Query select * from movieview where idMovie=21 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=21 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 21 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=21 92878 Query SELECT * FROM streamdetails WHERE idFile = 21 92878 Query select * from movieview where idMovie=741 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=741 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 741 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=741 92878 Query SELECT * FROM streamdetails WHERE idFile = 3536 92878 Query select * from movieview where idMovie=23 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=23 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 23 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=23 92878 Query SELECT * FROM streamdetails WHERE idFile = 23 92878 Query select * from movieview where idMovie=526 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=526 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 526 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=526 92878 Query SELECT * FROM streamdetails WHERE idFile = 526 92878 Query select * from movieview where idMovie=527 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=527 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 527 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=527 92878 Query SELECT * FROM streamdetails WHERE idFile = 527 92878 Query select * from movieview where idMovie=318 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=318 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 318 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=318 92878 Query SELECT * FROM streamdetails WHERE idFile = 318 92878 Query select * from movieview where idMovie=319 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=319 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 319 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=319 92878 Query SELECT * FROM streamdetails WHERE idFile = 319 92878 Query select * from movieview where idMovie=320 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=320 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 320 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=320 92878 Query SELECT * FROM streamdetails WHERE idFile = 320 92878 Query select * from movieview where idMovie=24 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=24 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 24 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=24 92878 Query SELECT * FROM streamdetails WHERE idFile = 24 92878 Query select * from movieview where idMovie=414 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=414 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 414 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=414 92878 Query SELECT * FROM streamdetails WHERE idFile = 414 92878 Query select * from movieview where idMovie=322 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=322 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 322 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=322 92878 Query SELECT * FROM streamdetails WHERE idFile = 322 92878 Query select * from movieview where idMovie=321 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=321 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 321 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=321 92878 Query SELECT * FROM streamdetails WHERE idFile = 321 92878 Query select * from movieview where idMovie=323 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=323 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 323 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=323 92878 Query SELECT * FROM streamdetails WHERE idFile = 323 92878 Query select * from movieview where idMovie=324 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=324 ORDER BY actorlinkmovie.iOrder 140224 0:24:41 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 324 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=324 92878 Query SELECT * FROM streamdetails WHERE idFile = 324 92878 Query select * from movieview where idMovie=325 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=325 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 325 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=325 92878 Query SELECT * FROM streamdetails WHERE idFile = 325 92878 Query select * from movieview where idMovie=519 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=519 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 519 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=519 92878 Query SELECT * FROM streamdetails WHERE idFile = 519 92878 Query select * from movieview where idMovie=25 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=25 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 25 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=25 92878 Query SELECT * FROM streamdetails WHERE idFile = 25 92878 Query select * from movieview where idMovie=26 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=26 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 26 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=26 92878 Query SELECT * FROM streamdetails WHERE idFile = 26 92878 Query select * from movieview where idMovie=633 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=633 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 633 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=633 92878 Query SELECT * FROM streamdetails WHERE idFile = 3141 92878 Query select * from movieview where idMovie=640 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=640 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 640 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=640 92878 Query SELECT * FROM streamdetails WHERE idFile = 3177 92878 Query select * from movieview where idMovie=663 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=663 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 663 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=663 92878 Query SELECT * FROM streamdetails WHERE idFile = 3276 92878 Query select * from movieview where idMovie=520 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=520 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 520 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=520 92878 Query SELECT * FROM streamdetails WHERE idFile = 520 92878 Query select * from movieview where idMovie=28 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=28 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 28 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=28 92878 Query SELECT * FROM streamdetails WHERE idFile = 28 92878 Query select * from movieview where idMovie=328 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=328 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 328 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=328 92878 Query SELECT * FROM streamdetails WHERE idFile = 328 92878 Query select * from movieview where idMovie=329 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=329 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 329 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=329 92878 Query SELECT * FROM streamdetails WHERE idFile = 329 92878 Query select * from movieview where idMovie=330 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=330 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 330 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=330 92878 Query SELECT * FROM streamdetails WHERE idFile = 330 92878 Query select * from movieview where idMovie=331 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=331 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 331 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=331 92878 Query SELECT * FROM streamdetails WHERE idFile = 331 92878 Query select * from movieview where idMovie=333 92878 Query SELECT actors.strActor, actorlinkmovie.strRole, actorlinkmovie.iOrder, actors.strThumb, art.url FROM actorlinkmovie JOIN actors ON actorlinkmovie.idActor=actors.idActor LEFT JOIN art ON art.media_id=actors.idActor AND art.media_type='actor' AND art.type='thumb' WHERE actorlinkmovie.idMovie=333 ORDER BY actorlinkmovie.iOrder 92878 Query SELECT tag.strTag FROM tag, taglinks WHERE taglinks.idMedia = 333 AND taglinks.media_type = 'movie' AND taglinks.idTag = tag.idTag ORDER BY tag.idTag 92878 Query select * from movielinktvshow where idMovie=333 92878 Query SELECT * FROM streamdetails WHERE idFile = 333 92879 Connect xbmc@192.168.0.8 on 92879 Query SET NAMES utf8 92879 Query show databases like 'MyVideos78' 92879 Query show tables 92879 Init DB MyVideos78 92879 Query show databases like 'MyVideos78' 92879 Query show tables 92879 Query SELECT type,url FROM art WHERE media_id=15 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=16 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=639 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=17 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=18 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=19 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=20 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=21 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=741 AND media_type='movie' 140224 0:24:42 92879 Query SELECT type,url FROM art WHERE media_id=23 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=526 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=527 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=318 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=319 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=320 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=24 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=414 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=322 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=321 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=323 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=324 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=325 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=519 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=25 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=26 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=633 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=640 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=663 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=520 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=28 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=328 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=329 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=330 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=331 AND media_type='movie' 92879 Query SELECT type,url FROM art WHERE media_id=333 AND media_type='movie' 92879 Quit 92878 Quit