top200artists.dqy

XLODBC
1
DSN=MediaMonkey;DBQ=\\somecomputer\c$\mediamonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT top 200 COUNT(1), artists.Artist  FROM `\\somecomputer\c$\mediamonkey`.Artists artists, `\\somecomputer\c$\mediamonkey`.Songs Songs  WHERE Songs.IDArtist = artists.ID  GROUP BY artists.Artist  ORDER BY count(1) desc


Expr1000	Artist

Here's a simple query that I defined in msqry32.exe that, when run, generates an excel spreadsheet with the 200 artists in my collection that have the most songs.

Your mileage is probably going to vary-- some of the stuff in there looks like magic numbers.

However, I thought this was an interesting way of probing the monkey database without having to do a whole lot of work. (I hacked together an asp.net webapp to view the database, but that was not as simple as this thing is for sure)


[code]top200artists.dqy[/code]
---------------------------------
[code]
XLODBC
1
DSN=MediaMonkey;DBQ=\\somecomputer\c$\mediamonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT top 200 COUNT(1), artists.Artist FROM `\\somecomputer\c$\mediamonkey`.Artists artists, `\\somecomputer\c$\mediamonkey`.Songs Songs WHERE Songs.IDArtist = artists.ID GROUP BY artists.Artist ORDER BY count(1) desc


Expr1000 Artist
[/code]