Code: Select all
MonkeyRok 5.0 started...
Panel enabled...
[OnPlayChange()]
Showing statistics...
[OnPlayChange()]
Showing statistics...
***SELECT Count(Distinct ArtistsSongs.IDArtist) AS Nombre FROM Songs,ArtistsSongs WHERE Songs.ID=ArtistsSongs.IDSong AND ArtistsSongs.PersonType=1
***SELECT Count(Distinct Artists.ID) AS Nombre FROM Artists WHERE Artists.ID IN (SELECT ArtistsSongs.IDArtist FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.IDSong IN (SELECT Songs.ID FROM Songs WHERE PlayCounter>0))
***SELECT Count(Distinct Songs.IDAlbum) AS Nombre FROM Songs WHERE Songs.IDAlbum>0 AND Songs.Album!=''
***SELECT Count(Distinct Songs.IDAlbum) AS Nombre FROM Songs WHERE Songs.IDAlbum>0 AND Songs.Album!='' AND Songs.Playcounter>0
***SELECT Count(Distinct Genres.IDGenre) AS Nombre FROM Genres WHERE Genres.IDGenre IN (SELECT GenresSongs.IDGenre FROM Songs,GenresSongs WHERE Songs.ID=GenresSongs.IDSong)
***SELECT Count(Distinct Genres.IDGenre) AS Nombre FROM Genres WHERE Genres.IDGenre IN (SELECT GenresSongs.IDGenre FROM Songs,GenresSongs WHERE Songs.ID=GenresSongs.IDSong AND Songs.Playcounter>0)
***SELECT Count(Distinct CAST((Songs.Year/10000) AS INTEGER)) AS Nombre FROM Songs WHERE Songs.Year>0
***SELECT Count(Distinct CAST((Songs.Year/10000) AS INTEGER)) AS Nombre FROM Songs,Played WHERE Songs.ID=Played.IDSong AND Songs.Year>0
***SELECT Count(Distinct PlayLists.IDPlaylist) AS Nombre FROM PlayLists WHERE (PlayLists.IsAutoPlayList ISNULL or PlayLists.IsAutoPlaylist=0)
***SELECT Count(Distinct PlayLists.IDPlaylist) AS Nombre FROM PlayLists WHERE (PlayLists.IsAutoPlayList ISNULL or Playlists.IsAutoPlaylist=0) AND PlayLists.IDPlaylist IN (SELECT PlaylistSongs.IDPlaylist FROM Songs,PlaylistSongs WHERE Songs.ID=PlaylistSongs.IDSong AND Songs.Playcounter>0)
***SELECT Count(Distinct Songs.ID) AS Nombre FROM Songs WHERE Songs.Playcounter>0
***SELECT Count(Distinct Songs.ID) AS Nombre, Sum(Songs.SongLength) AS TotalLength, Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.ID>0
***SELECT Sum(Songs.SongLength) AS TotalLength, Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Playcounter>0
***SELECT Avg(Distinct CAST((Songs.Year/10000) AS INTEGER)) AS avgYear FROM Songs WHERE Songs.Year>0
***SELECT Avg(Distinct Cast((Songs.Year/10000) AS Integer)) AS avgYearPlayed FROM Songs WHERE Songs.Year>0 AND Songs.Playcounter>0
***SELECT Avg(Songs.SongLength) AS AvgLength, Avg(Songs.FileLength) AS AvgFileLength, Avg(Songs.Bitrate) AS AvgBitrate FROM Songs WHERE Songs.ID>0
***SELECT Avg(Songs.Rating) AS AvgRating FROM Songs WHERE Songs.Rating>-1
***SELECT Avg(Songs.SongLength) AS AvgLength, Avg(Songs.FileLength) AS AvgFileLength, Avg(Songs.Bitrate) AS AvgBitratePlayed FROM Songs WHERE Songs.Playcounter>0
***SELECT Avg(CountOfID) AS AVGTracks FROM (SELECT Count(*) AS CountOfID FROM Songs WHERE Album!='' GROUP BY IDAlbum)
***SELECT Count(Distinct Songs2.ID) AS CountOfID FROM Songs AS Songs2 WHERE Songs2.IDAlbum IN (SELECT Albums.ID FROM Albums WHERE Albums.Album!='' AND Albums.ID IN (SELECT Songs.IDAlbum FROM Songs WHERE Songs.Playcounter>0))
***SELECT Avg(CountOfID) AS AVGPlayed FROM (SELECT Count(Played.IdSong) AS CountOfID FROM Songs,Played WHERE Songs.ID=Played.IdSong GROUP BY Cast(Played.PlayDate AS Integer))
***SELECT Avg(Songs.Rating) AS AvgRatingPlayed FROM Songs,Played WHERE Songs.ID=Played.IdSong AND Songs.Rating>-1
***SELECT Avg(CountOfID) AS AVGGenre FROM (SELECT COUNT(*) AS CountOfID FROM Songs,GenresSongs WHERE Songs.ID=GenresSongs.IDSong GROUP BY GenresSongs.IDGenre)
***SELECT Count(Distinct GenresSongs.ID) AS CountOfID FROM GenresSongs WHERE GenresSongs.IdGenre IN (SELECT GenresSongs2.IDGenre FROM Songs,GenresSongs AS GenresSongs2 WHERE Songs.ID=GenresSongs2.IDSong AND Songs.Playcounter>0)
***SELECT Avg(CountOfID) AS AVGArtist FROM (SELECT COUNT(*) AS CountOfID FROM Songs,ArtistsSongs WHERE Songs.ID=ArtistsSongs.IDSong AND ArtistsSongs.PersonType=1 GROUP BY ArtistsSongs.IDArtist)
***SELECT Count(Distinct ArtistsSongs.ID) AS CountOfID FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.IdArtist IN (SELECT ArtistsSongs2.IdArtist FROM Songs,ArtistsSongs AS ArtistsSongs2 WHERE Songs.ID=ArtistsSongs2.IDSong AND Songs.Playcounter>0)
***SELECT Avg(CountOfID) AS AVGYear FROM (SELECT COUNT(*) AS CountOfID FROM Songs WHERE Songs.Year>-1 GROUP BY Songs.Year)
***SELECT Avg(CountOfID) AS AVGYearPlayed FROM (SELECT Count(Songs.ID) AS CountOfID FROM Songs WHERE Songs.Playcounter>0 AND Songs.Year>-1 GROUP BY Songs.Year)
***SELECT Artists.ID,Artists.Artist,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Artists,ArtistsSongs,Songs WHERE Artists.ID=ArtistsSongs.IDArtist AND ArtistsSongs.IDSong=Songs.ID AND ArtistsSongs.PersonType=1 GROUP BY ArtistsSongs.IDArtist ORDER BY Count(Songs.ID) DESC LIMIT 10
***SELECT Artists.ID,Artists.Artist,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Artists,ArtistsSongs,Songs WHERE Artists.ID=ArtistsSongs.IDArtist AND ArtistsSongs.IDSong=Songs.ID AND ArtistsSongs.PersonType=1 AND Songs.Playcounter>0 GROUP BY ArtistsSongs.IDArtist ORDER BY Count(Songs.ID) DESC LIMIT 10
***SELECT Songs.AlbumArtist AS Artist,Albums.Album AS Album,Avg(Songs.Rating) AS Rating,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs,Albums WHERE Albums.ID>0 AND Albums.Album!='' AND Albums.ID=Songs.IDAlbum GROUP BY Songs.IDAlbum, Albums.Album ORDER BY Rating Desc, TotalLength Desc LIMIT 10
***SELECT Songs.AlbumArtist AS Artist,Albums.Album AS Album,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs,Albums WHERE Albums.ID>0 AND Albums.Album!='' AND Albums.ID=Songs.IDAlbum AND Songs.Playcounter>0 GROUP BY Songs.IDAlbum, Albums.Album ORDER BY Sum(Songs.PlayCounter) Desc LIMIT 10
***SELECT Genres.IDGenre,Genres.GenreName,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs,GenresSongs,Genres WHERE Songs.ID=GenresSongs.IDSong AND Genres.IDGenre=GenresSongs.IDGenre GROUP BY Genres.IDGenre, Genres.GenreName ORDER BY Count(Songs.ID) Desc LIMIT 10
***SELECT Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength,Genres.GenreName FROM Songs,GenresSongs,Genres WHERE Songs.ID=GenresSongs.IDSong AND Genres.IDGenre=GenresSongs.IDGenre AND Songs.Playcounter>0 GROUP BY GenresSongs.IDGenre ORDER BY Count(Songs.ID) Desc LIMIT 10
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>95 AND Songs.Rating<101
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>85 AND Songs.Rating<96
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>75 AND Songs.Rating<86
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>65 AND Songs.Rating<76
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>55 AND Songs.Rating<66
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>45 AND Songs.Rating<56
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength, Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>35 AND Songs.Rating<46
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>25 AND Songs.Rating<36
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>15 AND Songs.Rating<26
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>5 AND Songs.Rating<26
***SELECT Songs.Rating,Count(Songs.ID) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>-1 AND Songs.Rating<6
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>95 AND Songs.Rating<101 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>85 AND Songs.Rating<96 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>75 AND Songs.Rating<86 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>65 AND Songs.Rating<76 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>55 AND Songs.Rating<66 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>45 AND Songs.Rating<56 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>35 AND Songs.Rating<46 AND Songs.Playcounter>0
***SELECT Songs.Rating,Sum(Songs.PlayCounter) AS CountOfID,Sum(Songs.SongLength) AS TotalLength,Sum(Songs.FileLength) AS TotalFileLength FROM Songs WHERE Songs.Rating>25 AND Songs.Rating<36 AND Songs.Playcounter>0
[OnPlayChange()]
[13] Type mismatch: 'CLng' (Microsoft VBScript runtime error)
Showing statistics...
OnPlay event triggered...
[OnPlayChange()]
...
1)Re-tested later, log froze at same point (rating>25 & <36). CPU basically idle at that point for > 15 seconds.
2)Tested Stats(Filtered) report. No problems.