by ScottBolton » Thu Aug 13, 2015 5:05 am
Code: Select all
Tracks with same Name from different Artists|SQL Filter: Songs.SongTitle IN (SELECT SongTitle FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle HAVING Count(DISTINCT Artist) > 1)\<Title|Trim:1>\<Title|Sort by:Count(All)>\<Artist>
by SchulA » Thu Oct 15, 2009 9:07 am
by onenonymous » Sun Oct 04, 2009 10:18 am
Artists sorted by total play count|Child of:Library|Position:Before|Filter:<Played> > 0\<Artist|Sort by:Sum(Played) Desc>\<Title|Sort by:Sum(Played) Desc>
by nynaevelan » Sun Oct 04, 2009 8:50 am
by Prateek » Mon Aug 03, 2009 8:35 am
by ZvezdanD » Thu Jul 30, 2009 11:21 am
Prateek wrote:I'm looking for a mask that can return (any) one song from each artist in a directory. For example, if the path is D:\My Music\Rock and the folder has 3 subfolders: Metallica, Ironmaiden and Dreamtheater, which further have separate albums inside them, then I need any 3 tracks, one from each artist.
<Group|Name:Random|Show tracks:No>\One random Track from each Artist in My Music folder|Icon:Top level|Filter:Songs.ID IN (SELECT (SELECT A1.IDSong FROM ArtistsSongs AS A1 WHERE A1.IDArtist = ArtistsSongs.IDArtist ORDER BY Random() LIMIT 1) FROM ArtistsSongs WHERE (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY ArtistsSongs.IDArtist) AND <Folder> LIKE 'D:\My Music\Rock\%'\<Artist|Trim:1>\<Artist>
by Prateek » Thu Jul 30, 2009 5:13 am
by ZvezdanD » Fri May 29, 2009 12:20 pm
MosquitoLoco wrote:I updated to the current version (3.0.7.1191) Still no luck
by MosquitoLoco » Fri May 29, 2009 4:18 am
ZvezdanD wrote:You should try with MN 2.4.1 or newer. It has removed error with filters and Count(some_field) function. I also recommend using latest versions of MM, even it is still in beta.
by ZvezdanD » Tue May 26, 2009 12:37 pm
by MosquitoLoco » Tue May 26, 2009 12:18 pm
by MosquitoLoco » Tue May 26, 2009 12:11 pm
ZvezdanD wrote:Which MM version exactly? Which version of MN script? You could turn on the "Allow editing of SQL queries", "...when expand field nodes" and "...for the Unknown node" in the Options dialog box, copy the SQL query which you get before the error message and post it here.
SELECT Count(*) AS StatField0 FROM Songs , ArtistsSongs AS AArtistsSongs, Artists AS SongArtists LEFT JOIN ArtistsSongs AS AArtistsSongs ON Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) LEFT JOIN Artists AS SongArtists ON AArtistsSongs.IDArtist = SongArtists.ID WHERE (Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))) AND Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND NOT Songs.Custom5 <> ''
by ZvezdanD » Tue May 26, 2009 11:50 am
by MosquitoLoco » Tue May 26, 2009 11:20 am
ZvezdanD wrote: You could try this: Code: Select allCUS5xARTxALB|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))\<Custom 5|Sort by:Count(Artist) Desc|Statistic:Count(Tracks)>\<Artist|Sort order:Desc|Sort by:Count(Album) Desc|Statistic:Count(Tracks)>\<Album|Sort order:Desc|Sort by:Count(Tracks) Desc>
CUS5xARTxALB|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))\<Custom 5|Sort by:Count(Artist) Desc|Statistic:Count(Tracks)>\<Artist|Sort order:Desc|Sort by:Count(Album) Desc|Statistic:Count(Tracks)>\<Album|Sort order:Desc|Sort by:Count(Tracks) Desc>
ambiguous column name: SongArtists.ID (1, 1)
by ZvezdanD » Tue May 26, 2009 10:16 am
MosquitoLoco wrote:I am thinking of a mask that shows me only the nodes of artists that have 2 or more tracks, and at least one of the tracks is labeled "new" in the CUSTOM5 field
Top
Powered by phpBB® Forum Software © phpBB Limited
Theme based on Absolution by PlanetStyles