New extract SQL from Media Monkey

OriNOVet

I have reworked my initial SQL to extract the data from Media Monkey database for importing to Strawberry a little bit:

This ne one, extracts also filesize (can be used to identify the song in strawberry), mtime and ctime, where the 2 additional date fields are used for date added to database and modified last time. You can use filesize to identify easier the song in Strawberry. Mostly this can be unique, but sometimes you will have multiple files with the same filesize. In this case, you should use additional conditions to find the right entries.

To find if filesize is unique across your database, you can use:

SELECT FileLength, Count(FileLength)
FROM Songs
GROUP BY FileLength
HAVING Count(FileLength) > 1;

If the result is empty, FileLength is unique across the database. If the result contains entries, you should use additionally markers to find the right song, but all you need is in the next SQL:

SELECT 
	Artist as artist, 
	Album as album, 
	AlbumArtist as albumartist, 
	TrackNumber as track, 
	DiscNumber as  disc, 
	SongTitle as title, 
	PlayCounter as playcount, 
	IIF(LastTimePlayed > 1, strftime('%s', datetime(LastTimePlayed + 2415019.0)), -1) as lastplayed,
	FileLength as filesize, 
	strftime('%s', datetime(FileModified + 2415019.0)) as mtime, 
	strftime('%s', datetime(DateAdded + 2415019.0)) as ctime
FROM Songs
;

This extracts the whole database, the last SQL extracted only songs with playcount > 0, because now i include also mtime and ctime.

Have fun with migrating.