
var getCustomNodeDefinitions = function () {

        let defaultArray = [
        {
                type: 'tracks',
                name: 'Show 5 most played tracks',            
                sql: 'SELECT * FROM Songs WHERE Songs.PlayCounter > 0 ORDER BY Songs.PlayCounter DESC LIMIT 5'
        }, 
        {
                type: 'tracks',
                name: 'Tracks with Artist different from Album Artist',
                sql: 'SELECT * FROM Songs WHERE Songs.artist <> Songs.albumArtist'
        }, 
        {
                type: 'tracks',
                name: 'Tracks with unassigned artwork',
                sql: 'SELECT * FROM Songs WHERE Songs.ID NOT IN (SELECT Songs.ID FROM Songs, Covers WHERE Covers.IDSong = Songs.ID)'
        }, 
        {
                type: 'tracks',
                name: 'Tracks with artworks stored in tag',
                sql: 'SELECT * FROM Songs WHERE Songs.ID IN (SELECT IDSong FROM Covers WHERE Covers.CoverStorage = 0)'
        }, 
        {
                type: 'tracks',
                name: 'Tracks with artworks stored in files',
                sql: 'SELECT * FROM Songs WHERE Songs.ID IN (SELECT IDSong FROM Covers WHERE Covers.CoverStorage = 1)'
        },
        {
                type: 'albums',
                name: 'Albums with same name',
                sql: 'SELECT * FROM Albums WHERE ID IN (SELECT DISTINCT Albums.ID FROM Albums INNER JOIN Albums As Inline ON Albums.Album = Inline.Album AND Albums.ID <> Inline.ID)'
        }, 
        {
                type: 'albums',
                name: 'Compilations',
                sql: 'SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs WHERE IDAlbum > 0 GROUP BY IDAlbum HAVING Count(DISTINCT Artist) > 1)'
        }
        ];

        return app.getValue('customNodesDefinitions', defaultArray);
}
