Image 17 of 57
Date: 2/20/07 8:58 PM
*îîSELECT Media.Label, Media.MediaID, Albums.Folder, Albums.Name, Albums.AlbumID FROM Media INNER JOIN Albums ON Media.MediaID = Albums.MediaID WHERE Media.MediaID <> -1 AND Media.MediaType <> 4 ORDER BY Media.MediaID ASC, Albums.Folder ASC