SELECT COUNT(artist) artist_count, artist, strftime('%Y', last_played_timestamp / 10000000 - 11644473600, 'unixepoch') year FROM medialibraryWHERE year = strftime('%Y','now')GROUP BY artistORDER BY artist_count DESC
Quote from: chiwou on 01 October, 2011, 08:42:54 AMbtw: it's the panel on the left side Did you remove the <Default> node? What happens, when you right click in the panel and choose "Create default nodes"?
btw: it's the panel on the left side
Quote from: fbuser on 01 October, 2011, 09:39:45 AMQuote from: chiwou on 01 October, 2011, 08:42:54 AMbtw: it's the panel on the left side Did you remove the <Default> node? What happens, when you right click in the panel and choose "Create default nodes"?yeah I tried that, I can see it on the redraw, so my guess is that everything is there, but it won't render correctly
oh right. it's just that no answer looks pretty unequivocal to me so i thought you must have missed it.
DROP TABLE IF EXISTS MediaLibrary_Snapshot;CREATE TABLE MediaLibrary_SnapshotAS SELECT * FROM MediaLibrary;
DROP VIEW IF EXISTS random_view4;CREATE TEMP VIEW random_view4 AS SELECT last_played, MetaDB_Handle FROM medialibrary WHERE rating = 4 AND last_played < '2011-09-09' AND ((julianday('now') - julianday(last_played)) > 42)ORDER BY random() LIMIT 40;DROP VIEW IF EXISTS random_view5;CREATE TEMP VIEW random_view5 AS SELECT last_played, MetaDB_Handle FROM medialibrary WHERE rating = 5 AND last_played < '2011-08-10' AND ((julianday('now') - julianday(last_played)) > 21)ORDER BY random() LIMIT 20;
SELECT * FROM random_view4UNIONSELECT * FROM random_view5;
My use-case is I like random plays of my higher-rated music without repeats.
AND (((last_played < '2011-09-09') AND ((julianday('now') - julianday(last_played)) > 42)) OR (last_played == ''))
Lost all my queries!I have just updated from 1.1.9 beta to 1.1.9 release and lost all my SQL tree queries.
The only way to be able to re-create any folders or queries is to remove the panel from the config and then add a new one.
I could live with it if we could export\import queries!
Just a small reminder. Any chance of a few common context menu items such as Properties?
Using SQL tree console, when I get a result from my queries that will consist of a short-list of tracks (Artist, Album, Title), is there a way to direct these track related results to the selection Playlist, a specified Playlist and/or the Playback Queue?
No, this is not the purpose of the SQL tree console, that's what the panel is for, although sending to the playback queue is not supported and won't be in the future. The result rows in the console might match tracks one by one by coincidence, but generally they don't.
There is no relation between the release update and the loss of your queries.
Well it happened the very next startup after installing 1.1.10 beta 1.
SELECT genre "Genre" FROM MediaLibraryWHERE genre LIKE 'soundtrack'
1) Context menu entry: Open containing folder2) Options to not display a node icon3) Ability to change vertical intra-node spacing (padding) and horizontal indentation4) Allow sub-item and leaf count to be placed on right of node text5) Provide additional double-click action configuration
Bug: The status of Start playback option for the middle click action isn't saved. If I check this and then restart it is back unchecked. I've not tested same for Click action.
. A standard foobar2000 context menu for node children with the sql_tree context menu available via a modifier.
. Double click, enter, space bar actions
. Hide node icons
. Hide horizontal/vertical scroll bar
. Option to hide +/- for the root node
. Option to make the scroll bars stick to the very edge of the panel
Also, the undo options seem to be unusable after a playlist has been modified by foo_sql_tree.
Hi how can I display all albums that have the genre tag soundtrackthis is what I've haveCode: [Select]SELECT genre "Genre" FROM MediaLibraryWHERE genre LIKE 'soundtrack'works great but only for albums which have the 'Soundtrack' as their ONLY tag not for all with multiple values
SELECT genre "Genre" FROM MediaLibraryWHERE genre LIKE '%soundtrack%'
SELECT genre_mv "Genre" FROM MediaLibraryWHERE genre_mv='soundtrack'