Songs.SongTitle || '@#$' || Songs.Artist IN (SELECT SongTitle || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle, Artist HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1)
What does || '@#$ || mean?
Boys Don't Cry 3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
RobertSmith wrote:Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters (where is no instr only substr in SQLite, or maybe I have missed it)?
My Tracks with same Title (...) from same Artists|Icon:Top level|Statistic:Count(Tracks)|Filter:CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END || '@#$' || Songs.Artist IN (SELECT CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1)\<Artist|Statistic:Count(Tracks)>\<Title|Statistic:Count(Tracks)|Left of: (>\<Album artist with album>
is '@#$' used to "ensure" a unique combination of title & artist?
Edit: Added CASE WHEN... to mask
Boys Don't Cry 3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
RobertSmith wrote:Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters
No, it isn't.
RobertSmith wrote:What I try to do is a MN for what include all variants of tracks xxx, xxx (demo), xxx (radio edit) etc.
Well, with your formulas you would include titles which have parentheses as well, like Don't You (Forget About Me). This is a reason why I prefer brackets for variants like demo, live, remixes...
RobertSmith wrote:What does || '@#$ || mean?
RobertSmith wrote:is '@#$' used to "ensure" a unique combination of title & artist?
Yes, it is.
●Magic Nodes 4.3.3 / 5.2●RegExp Find & Replace 4.4.9 / 5.2●Invert Selection/Select None 1.5.1 ●Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1●Expand Child Nodes/Expand All 1.1.2 ●Event Logger 2.7 ●Filtered Statistics Report 1.6 ●Track Redirection & Synchronization 3.4.2 ●Restore/Synchronize Database 3.1.8 / 4.0.1●Find Currently Playing Track 1.3.2 ●Queue List 1.2.1 ●Add to Library on Play 1.0.1 ●Tree Report for Child Nodes 1.1.1 ●Update Location of Files in Database 1.4.5 / 2.3●Inherit Child Playlists 1.0.3 ●Add Currently Playing/Selected Track(s) to Playlist 1.2
ZvezdanD wrote:Well, with your formulas you would include titles which have parentheses as well, like Don't You (Forget About Me). This is a reason why I prefer brackets for variants like demo, live, remixes...
As long as it's the same artist (Simple minds?). However the formula works of course if you substitute " (" with " [". But you gave me an idea to write a similarly MN for tagging Inconsistencies (find titles without subtitles).
Title (subtitle) [variant] is not so bad I will think about it (easy to change with RegExp).
Boys Don't Cry 3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Statistic:Count(Artist)|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
●Magic Nodes 4.3.3 / 5.2●RegExp Find & Replace 4.4.9 / 5.2●Invert Selection/Select None 1.5.1 ●Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1●Expand Child Nodes/Expand All 1.1.2 ●Event Logger 2.7 ●Filtered Statistics Report 1.6 ●Track Redirection & Synchronization 3.4.2 ●Restore/Synchronize Database 3.1.8 / 4.0.1●Find Currently Playing Track 1.3.2 ●Queue List 1.2.1 ●Add to Library on Play 1.0.1 ●Tree Report for Child Nodes 1.1.1 ●Update Location of Files in Database 1.4.5 / 2.3●Inherit Child Playlists 1.0.3 ●Add Currently Playing/Selected Track(s) to Playlist 1.2
<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Statistic:Count(Artist)|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
When I edit the node, and paste the code above in the "Mask:" section I get the following error.
51graphix wrote:Doing so allowed me to save the node, but then got the following errors:
Sorry, I tried the mask with my working version of the script which has removed that bug. You could try with removed Statistic qualifier from the global node:
<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
●Magic Nodes 4.3.3 / 5.2●RegExp Find & Replace 4.4.9 / 5.2●Invert Selection/Select None 1.5.1 ●Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1●Expand Child Nodes/Expand All 1.1.2 ●Event Logger 2.7 ●Filtered Statistics Report 1.6 ●Track Redirection & Synchronization 3.4.2 ●Restore/Synchronize Database 3.1.8 / 4.0.1●Find Currently Playing Track 1.3.2 ●Queue List 1.2.1 ●Add to Library on Play 1.0.1 ●Tree Report for Child Nodes 1.1.1 ●Update Location of Files in Database 1.4.5 / 2.3●Inherit Child Playlists 1.0.3 ●Add Currently Playing/Selected Track(s) to Playlist 1.2
Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170. I would like to look at the "Multi" nodes, since I don't understand how you can have two Genre's when there
is only one field. But that might be another message.
tableguy wrote:Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170. I would like to look at the "Multi" nodes, since I don't understand how you can have two Genre's when there
is only one field. But that might be another message.
tableguy wrote:Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170.
This question was asked several times before, so it is a time to put it in the FAQ section, but I doubt that anybody read it. The answer:
By default, the Magic Nodes script installs only initial 83 masks. If you want to add 90 additional masks, you should open the Edit /Magic Nodes Export/Import dialog box, choose File, specify c:\Program Files\MediaMonkey\Scripts\Auto\MN-Onenonymous.ini file and click on the Import button.
●Magic Nodes 4.3.3 / 5.2●RegExp Find & Replace 4.4.9 / 5.2●Invert Selection/Select None 1.5.1 ●Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1●Expand Child Nodes/Expand All 1.1.2 ●Event Logger 2.7 ●Filtered Statistics Report 1.6 ●Track Redirection & Synchronization 3.4.2 ●Restore/Synchronize Database 3.1.8 / 4.0.1●Find Currently Playing Track 1.3.2 ●Queue List 1.2.1 ●Add to Library on Play 1.0.1 ●Tree Report for Child Nodes 1.1.1 ●Update Location of Files in Database 1.4.5 / 2.3●Inherit Child Playlists 1.0.3 ●Add Currently Playing/Selected Track(s) to Playlist 1.2
Can someone help please?
I'm trying to make a node to list all where the genre doesnt match the tags on Custom 4 (its a backup tag coz I usually mess up the genre by dragging it somewhere.. )
I tried basing it off the included node "artist does not match original artist" but it gives me an error everytime.. I tried different things I just cant find the right way to script it.. (no programming background at all)