I use a series of autoplaylists to track my music. Custom field 2 is Year.Week (ie this week would be 16.05). The autoplaylists are structured as so: Year\Quarter\Week. For year, the autoplaylist just find all tracks where Custom 2 starts with eg 15. For week, the autoplaylist just find all tracks with eg 15.05 in Custom 2. The quarter however is more tricky and so it simply finds all tracks in playlists 15.01, 15.02, 15.03... 15.13.
However I have noticed that the quarter autoplaylists are omitting some tracks and duplicating others: So for this year there is an album in week 16.04 but it is not appearing in Q1 even though it appears in the 16.04 playlist and the Q1 playlist has 16.04 selected. It also is for some reason duplicating tracks, as below:
http://i.imgur.com/zLCKg0d.png
Any ideas? I have tried optimizing the database etc.
Thanks
Ed