maintenance MM.DB

[Milagro]

I would like to maintain my Media Monkey database.
I have tried SQLite and FireFox SQLite manager to run the following queries.


Empty albums with less then 4 song:
SELECT album, COUNT (album) FROM album GROUP BY test.songs

Empty genres with less then 50 song:
SELECT genre, COUNT (genre) FROM songs GROUP BY Genre

Delete double songs
SELECT album, artist, track title, COUNT (title song) FROM test.songs GROUP BY title song

Determine is the artist has the corrected genre
SELECT album, artist, genre FROM songs GROUP BY albumartist

Is there a tool to run these query's or some plugins to get the same result?

[Lowlander]

Check out:
SQL Viewer script: http://mediamonkey.com/forum/viewtopic. ... sql+viewer
MM DB Cleanup: http://mediamonkey.com/forum/viewtopic. ... up#p232491

[Milagro]

That is exactly what i need,

Only it seem that this query don't work

Displaying double songs:
SELECT songtitle,albumartist,
ROUND(songlength *1.66666666666667E-05,2) AS minutes,extension,
COUNT(songtitle) AS doubleSongs
FROM songs
GROUP BY minutes
HAVING doubleSongs >1
ORDER BY doubleSongs desc