View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010922 | MMW v4 | Synchronization | public | 2013-05-29 15:06 | 2013-10-01 12:50 |
| Reporter | Ludek | Assigned To | |||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1 | ||||
| Target Version | 4.1 | Fixed in Version | 4.1 | ||
| Summary | 0010922: WiFi sync fails for very large sync lists | ||||
| Description | It seems that WiFi sync always fails (because of MMA's 10s timeout) whenever there are thousands of tracks on the sync list. Steps to repro: 1. Select whole 'Accessible tracks' playlist on sync-list (9000 files in my case) 2. Initiate Wi-Fi sync => MMA shows "Synchronization failed" message | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=71748 BGH-889879 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1642 | ||||
| related to | 0010959 | closed | Ludek | MMW v4 | Browsing playlists on sync-list remotelly in MMA/MM8 can be slow |
| parent of | 0010954 | closed | Ludek | MMW v4 | WiFi sync is broken in build 1640 (regression) |
| related to | 0010850 | closed | marek | MMA | Playlists don't update on resync |
| related to | 0010764 | closed | peke | MMA | Some users can't sync with build 124 |
| related to | 0010969 | closed | marek | MMA | Wi-Fi Sync fails for complex auto-playlists |
| related to | 0011635 | closed | Ludek | MMW v4 | SQL error when working with Device Profile (overcomplex SQL issues) |
|
|
Fixed in build 1639. |
|
|
Verified 1640 |
|
|
I see this with 1641 and 139 when 2 Playlists are selected to be synced (400 and 300 tracks). |
|
|
Please attach debug log. Nevertheless I found a performance leak when MMA browses MMW playlists (fixed as 0010959 ), it will be probably the same problem (to be confirmed based on the log). I uploaded new MediaMonkey.exe to FTP/MMW/MediaMonkey.exe for testing and confirming the fixes |
|
|
Tested with MMW/Testexe/MediaMonkey.exe (there was no FTP/MMW/MediaMonkey.exe) and the sync did start with 2 Playlists, but it ended up failing to sync all files (according to MMA) and only 1 of 2 Playlists is on the device after sync. [debug.zip on FTP] |
|
|
I analyzed the log, MMA asked the sync list and downloaded whole the sync list correctly (about 700 tracks), then it downloaded the tracks (many of them needed auto-conversion), finally it browsed playlist \Playlists\Guest\ -no files, just a child playlist, right? \Playlists\Guest\Jerry Tine Warning\ -including tracks So I guess that the \Guest\Jerry Tine Warning\ is that one that was correctly created in MMA, right? Which was the other one? I don't see another playlist in the log. Are you sure that the other playlist was checked on sync-list of "Samsung GT-N7000 - Internal Storage"? Re the service: Starting from build 1641 MM stops the service on start so that there are not running two instances simultanously: 0010910:0036258 , but the service needs to be reinstalled (because of proper privileges settings) So could you try to re-install to service, run MM and ensure that only one MediaMonkey.exe instance is running? Then try to re-sync in order to eliminate that the failure could be caused by the service running simultaneously. Thx. EDIT: 1) I see that you have DB stored locally as D:\Data\MediaMonkey\MM.DB so I don't see a reason for the "SQLite logic error or missing database" in the ELF you sent. 2) I see SQL of both the playlists on the sync-list, they are both quite complicated auto-playlists producing quite complicated SQL, could you compress and send me your DB for analyze? 3) Do you see both the playlists in MMA->Options->WIFI sync-> Sync/location settings -> Internal Storage -> Auto-sync server content -> Playlists ... ? |
|
|
For syncing the following was selected: Internal 1A) Guest > Jerry & Tine Warning 1B) Sync > Samsung Note > Internal > Car External 2A) Sync > Samsung Note > Internal > Radio In all those only the last Playlist in the list has tracks. All Playlists are composite AutoPlaylists made up of multiple AutoPlaylist often related to other AutoPlaylists (no AND and OR requires this complicated setup). Playlists are nested logically on MMW to reduce Playlist clutter (unfortunately the hierarchy is annoying on MMA) On Playlist 1A showed on device after sync, external card never seemed to get synced at all. All 3 Playlists show as checked in the MMA sync options. I've disabled the service in MMW to isolate any issues with syncing to syncing itself and not the service. |
|
|
BTW: I see at the end of the log (when External Storage was synced) that there was a really complicated auto-playlist that has taken more than 20 seconds to process and thus MMA has timed out. This will be most problably the main problem. I am afraid that only chance is to simplify the auto-playlist (its SQL is really crazy) or increase the MMA's timeout. But please compress your DB so that I could analyze it further. |
|
|
DB added to FTP. Note that Car Playlist now also shows on device (no further syncing). So maybe MMA takes a bit to get Playlists worked out (there also seems to be slowness with editing Playlists on MMA vs. other Apps and seeing them updated vice versa). I like Peke's suggestion of sending stay alive messages from MMW to MMA while MMW calculates what needs to be synced. Although my Playlists are fairly complex and thus slower, other users will have slower machines and/or larger Playlists which will probably result in similar timeouts. |
|
|
Yes, I was thinking about the same (because users always can create a very complex AP), but it requires minor changes in MMA/MM8 too. |
|
|
Fixed in build 1642. If MMW cannot get requested amount of tracks (200 in case of MMA) in 15 seconds, it notifies MMA/MM8 that they should repeat the request. Small changes needs to be done also in MM8/MMA ( #10972 / 0010969 ). |
|
|
Verified 1642 and MMA 140 on multi crosslinked Auto-playlists (3 sub-levels) with filtering and random generation along with limitations. To show the list MMW takes at least 37 Sec. |
|
|
On 165 with 1658 I frequently see MMA have sync fail before MMW is done creating the sync list. MMW debug on FTP, MMA: ID3RJJCB2P. |
|
|
I analyzed the MMW log and I see that at 82 seconds MMW started to build the sync-list, at 97 seconds it replied to MMA that it is still loading, at 120 seconds it again replied "still loading" and MMA immediatelly sent "sync finished". So it seems that MMA re-sends the request only once? Marek, could you look at the MMA log? |
|
|
I restarted the sync myself after MMA showed it failed. In MMA (which may be in the MMA log) I actually tried a couple times, restarted the device (and MMW) and tried a couple more times before I got a successful sync. |
|
|
The loading of a complex AutoPlaylist (made one even more complex) can fail on both MMA (likely the same problem as wifi sync) with Connection Failed message, but it can also fail on MMW (MMW is server and client). The latter isn't consistent as I haven't been able to reproduce since restart of MMW (to capture a debug log). Watching the log it seemed that MMW never produced the track list (or perhaps I didn't wait long enough, but Reading files... had disappeared in MMW). MMA failure is first attempt to load Radio Playlist, log also shows successful MMW attempts after this (Browse UPnP Playlist.zip on FTP) |
|
|
Managed to get MMW to fail to load it's own UPnP Playlist (MMW load UPnP Playlist fail.zip on FTP) |
|
|
Lowlander, I see following in the log: SQL: SELECT Songs.* 00000789 3.90238285 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000790 3.90238285 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000791 3.90238285 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004))) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (101049,98,100234,100000,13,14))) ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000792 3.90238285 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000793 3.90238285 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000794 3.90238285 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19700101 and Songs.OrigYear<=19800101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000795 3.90238285 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000796 3.90238285 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHER 00000797 3.90246534 [4748] E Genres.IDGenre in (2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000798 3.90246534 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000799 3.90246534 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000800 3.90246534 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000801 3.90246534 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 300) OR Songs.Id IN (SELECT Songs.Id 00000802 3.90246534 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000803 3.90246534 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genre 00000804 3.90255260 [4748] s WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 250) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000805 3.90255260 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000806 3.90255260 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100025,100013))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000807 3.90255260 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000808 3.90255260 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=180000 AND (Songs.SongLength>=0 and Songs.SongLength<=420000) AND Songs.LastTimePlayed<41540.25 AND ( Songs.Id NOT IN (SELECT Songs.Id 00000809 3.90255260 [4748] FROM Songs WHERE Songs.ID IN (SELECT ListsSongs.IDSong FROM ListsSongs WHERE ListsSongs.IDListType = 3 AND ListsSongs.IDList in (118)) AND Songs.ID IN (SELECT ListsSongs.IDSong FROM ListsSongs WHERE ListsSongs.IDListType = 4 AND ListsSongs.IDList in (25,297)) ) ) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,11,12))) AND Songs.IdAlbum not in (68323,16836) AND NOT (Songs.Album like '%sounds of the eighties%') AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=100) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (98))) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM 00000810 3.90261316 [4748] Genres WHERE Genres.IDGenre in (1))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=19800101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000811 3.90261316 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000812 3.90261316 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000813 3.90261316 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (4))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19700101 and Songs.OrigYear<=19800101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 20) OR Songs.Id IN (SELECT Songs.Id 00000814 3.90261316 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000815 3.90261316 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (4))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 30) OR Songs.Id IN (SELECT Songs.Id 00000816 3.90261316 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000817 3.90261316 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres. 00000818 3.90267229 [4748] IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (35))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000819 3.90267229 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000820 3.90267229 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (3,35,31))) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000821 3.90267229 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000822 3.90267229 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (3,31))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like '%\\lowla 00000823 3.90273404 [4748] nder01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 20) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000824 3.90273404 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000825 3.90273404 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000826 3.90273404 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100000,100005,142))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000827 3.90273404 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000828 3.90273404 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000829 3.90273404 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000830 3.90273404 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM Artists 00000831 3.90281272 [4748] Songs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,100242,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 300) OR Songs.Id IN (SELECT Songs.Id 00000832 3.90281272 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000833 3.90281272 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,100242,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 250) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000834 3.90281272 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000835 3.90281272 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100780,100506,100047,100382,101249,88,100432,101353,101299,100854,48,101298,101260,100050,101293,100542,101454,101455,101457,101619,101011,101239,101010,101664,11,101459,16,101658,100227,100138,101300,100135,101050,100142,100906,100152,100136,100577,101295,100179,101387))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres. 00000836 3.90287495 [4748] IDGenre FROM Genres WHERE Genres.IDGenre in (100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101628,101614,100475,100073,101764,101,100129,100133))) ORDER BY random(*) LIMIT 25) OR Songs.Id IN (SELECT Songs.Id 00000837 3.90287495 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000838 3.90287495 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000839 3.90287495 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (13))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19700101 and Songs.OrigYear<=19800101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000840 3.90287495 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000841 3.90287495 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100137,13))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000842 3.90287495 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000843 3.90287495 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE Artists 00000844 3.90295076 [4748] Songs.PersonType = 1 AND ArtistsSongs. 00000845 3.90319800 [4748] OpenQuery - Preparing query SELECT Songs.* 00000846 3.90319800 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000847 3.90319800 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000848 3.90319800 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004))) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (101049,98,100234,100000,13,14))) ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000849 3.90319800 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000850 3.90319800 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000851 3.90319800 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19700101 and Songs.OrigYear<=19800101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000852 3.90319800 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000853 3.90319800 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM G 00000854 3.90326786 [4748] enres WHERE Genres.IDGenre in (2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000855 3.90326786 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000856 3.90326786 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000857 3.90326786 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000858 3.90326786 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 300) OR Songs.Id IN (SELECT Songs.Id 00000859 3.90326786 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000860 3.90326786 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre 00000861 3.90334630 [4748] FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (89,2))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 250) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000862 3.90334630 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000863 3.90334630 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100025,100013))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000864 3.90334630 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000865 3.90334630 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=180000 AND (Songs.SongLength>=0 and Songs.SongLength<=420000) AND Songs.LastTimePlayed<41540.25 AND ( Songs.Id NOT IN (SELECT Songs.Id 00000866 3.90334630 [4748] FROM Songs WHERE Songs.ID IN (SELECT ListsSongs.IDSong FROM ListsSongs WHERE ListsSongs.IDListType = 3 AND ListsSongs.IDList in (118)) AND Songs.ID IN (SELECT ListsSongs.IDSong FROM ListsSongs WHERE ListsSongs.IDListType = 4 AND ListsSongs.IDList in (25,297)) ) ) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,11,12))) AND Songs.IdAlbum not in (68323,16836) AND NOT (Songs.Album like '%sounds of the eighties%') AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=100) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (98))) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.ID 00000867 3.90341210 [4748] Genre FROM Genres WHERE Genres.IDGenre in (1))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=19800101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000868 3.90341210 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000869 3.90341210 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000870 3.90341210 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (4))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19700101 and Songs.OrigYear<=19800101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 20) OR Songs.Id IN (SELECT Songs.Id 00000871 3.90341210 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000872 3.90341210 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (4))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 30) OR Songs.Id IN (SELECT Songs.Id 00000873 3.90341210 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000874 3.90341210 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELE 00000875 3.90349126 [4748] CT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (35))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000876 3.90349126 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000877 3.90349126 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (3,35,31))) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 50) OR Songs.Id IN (SELECT Songs.Id 00000878 3.90349126 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000879 3.90349126 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (3,31))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like 00000880 3.90356064 [4748] '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 20) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000881 3.90356064 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000882 3.90356064 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000883 3.90356064 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100000,100005,142))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19800101 and Songs.OrigYear<=19900101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000884 3.90356064 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000885 3.90356064 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=19900101 and Songs.OrigYear<=20000101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 200) OR Songs.Id IN (SELECT Songs.Id 00000886 3.90356064 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000887 3.90356064 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FR 00000888 3.90364122 [4748] OM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,100242,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND (Songs.OrigYear>=20000101 and Songs.OrigYear<=20100101) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 300) OR Songs.Id IN (SELECT Songs.Id 00000889 3.90364122 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000890 3.90364122 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100378,100002,100011,86,100000,100124,100005,142,100242,114))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100130,100322,100537,61,141,100004,100252,98,38,101761,33,100693,101073,100465,101614,100475,100314,100073,11,101,100129,100133))) AND Songs.OrigYear>=20100101 AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 250) ) AND (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') ORDER BY random(*) LIMIT 100) OR Songs.Id IN (SELECT Songs.Id 00000891 3.90364122 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000892 3.90364122 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM ArtistsSongs WHERE ArtistsSongs.PersonType = 1 AND ArtistsSongs.IDArtist IN (SELECT Artists.ID FROM Artists WHERE Artists.ID in (8282))) AND (Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)>=0 and Songs.PlayCounter + (Songs.PlaybackPos * 1.0 / Songs.SongLength)<=25) ) ) AND Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100780,100506,100047,100382,101249,88,100432,101353,101299,100854,48,101298,101260,100050,101293,100542,101454,101455,101457,101619,101011,101239,101010,101664,11,101459,16,101658,100227,100138,101300,100135,101050,100142,100906,100152,100136,100577,101295,100179,101387))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELE 00000893 3.90370536 [4748] CT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100322,100537,61,141,100004,100252,101761,33,100693,101073,100465,101628,101614,100475,100073,101764,101,100129,100133))) ORDER BY random(*) LIMIT 25) OR Songs.Id IN (SELECT Songs.Id 00000894 3.90370536 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000895 3.90370536 [4748] FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id 00000896 3.90370536 [4748] FROM Songs WHERE (Songs.SongPath like '%\\lowlander01\Qmultimedia\Music\%') AND Songs.Rating>=96 AND Songs.Bitrate>=160000 AND (Quality = '' or Quality = null ) AND ( mediaaccessible( Songs.IdMedia) OR Songs.CacheStatus=1) AND Songs.SongLength>=150000 AND (Songs.SongLength>=0 and Songs.SongLength<=500000) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (100004,57,100252,100,100308,100693,101073,100465,101628,101614,100475,100314,100134,100073,12))) AND NOT Songs.ID IN (SELECT ArtistsSongs.IDSong FROM Art |
|
|
The auto-playlist is simply over-complex for MM, look at its SQL, next time it loaded the crazy SQL, but it took 70 seconds !!! Resolving as no change required, the solution is to simplify the auto-playlist. But could you upload your MM.DB and write down the name of the auto-playlist so that I could analyze it? It looks like the SQL is somehow cycled, but not exactly, looks like it references many other similar auto-playlists? |
|
|
The problem is that MediaMonkey doesn't allow this to be done in a simpler way, although requests for this are years old (like AND and OR, percentages for values of a criteria, all conditions like is not for all criteria). Also the fact that an AutoPlaylist is slow shouldn't be a problem as users with simpler AutoPlaylists on slow computers/DB on NAS would still run into this too. Question: Does setting an AutoPlaylist as a Collection vs. Entire Library add a level of complexity? DB added as MM2.zip to FTP Note, this complex AutoPlaylist wasn't part of the initial re-opening of the bug. It involves a simpler AutoPlaylist that used to work, but fails several times for each successful sync. |
|
|
LL, I see that the problematic auto-playlist is \Playlists\Sync\Samsung Note\Internal\Radio The Radio auto-playlists references 9 further auto-playlists, each of them references further playlists, e.g. 'Electronic' references 5 further auto-playlists, and e.g. Radio\Electronic\1970-1980\ references 'Mater Adult' auto-playlist + adds further criteria based on Genre etc. That said the whole hierarchy is really really complicated with many conditions resulting in the crazy SQL above. You wrote that the problem is that MediaMonkey doesn't allow this to be done in a simpler way, although requests for this are years old (like AND and OR, percentages for values of a criteria, all conditions like is not for all criteria). Can you eleborate? I think that the whole and crazy playlists hierarchy and criteria can be simplified a lot. I also don't understand what you mean by (like AND and OR, percentages for values of a criteria, all conditions like is not for all criteria), could you reference corresponding Mantis issues and examples? |
|
|
I'm looking for a Playlist that gets a certain percentage for each type of Genre (for example Rock would include several Rock type Genre's). Within each type of Genre I'm looking to get a certain percentage of songs per decennium. Another problem (although not in this playlist) is that I need to exclude files of a specific Occasion (not possible) thus need to work around this by creating a AutoPlaylist with this specific Occasion and then excluding the AutoPlaylist. I understand that the AutoPlaylist is really complicated due to the fine control I want, I understand that it will take longer to load due to its complexity, but this seems to be an issue of timeouts as there is no reason it wouldn't work over DLNA/sync (it would just take longer). I've been able to simplify the AutoPlaylist by taking out 2 AutoPlaylist levels and in doing so I managed a successful wifi sync. |
|
|
I've done a test while ago to verify MMA correctness, I put an infinite loop to the preparing sync-list thread and MMA has correctly waited forever by sending repeating requests for sync-list. I think that the failure might by caused by the overcomplex SQL that mostly halts DB completely even for minutes. Resolving, as the root of this issue was the overcomplex SQL above. |
