MySQL [MyMusic32]> explain select `album`.`idAlbum` AS `idAlbum`,`album`.`strAlbum` AS `strAlbum`,`album`.`strArtists` AS `strArtists`,`album`.`strGenres` AS `strGenres`,`album`.`iYear` AS `iYear`,`albuminfo`.`idAlbumInfo` AS `idAlbumInfo`,`albuminfo`.`strMoods` AS `strMoods`,`albuminfo`.`strStyles` AS `strStyles`,`albuminfo`.`strThemes` AS `strThemes`,`albuminfo`.`strReview` AS `strReview`,`albuminfo`.`strLabel` AS `strLabel`,`albuminfo`.`strType` AS `strType`,`albuminfo`.`strImage` AS `strImage`,`albuminfo`.`iRating` AS `iRating`,`album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed` from ((`album` left join `albuminfo` on((`album`.`idAlbum` = `albuminfo`.`idAlbum`)) ) left join `song` on((`album`.`idAlbum` = `song`.`idAlbum`)))  group by `album`.`idAlbum`;
+----+-------------+-----------+-------+---------------+--------------+---------+-------------------------+------+-------+
| id | select_type | table     | type  | possible_keys | key          | key_len | ref                     | rows | Extra |
+----+-------------+-----------+-------+---------------+--------------+---------+-------------------------+------+-------+
|  1 | SIMPLE      | album     | index | NULL          | PRIMARY      | 4       | NULL                    |   90 |       |
|  1 | SIMPLE      | albuminfo | ref   | idxAlbumInfo  | idxAlbumInfo | 5       | MyMusic32.album.idAlbum |    1 |       |
|  1 | SIMPLE      | song      | ref   | idxSong3      | idxSong3     | 5       | MyMusic32.album.idAlbum |   11 |       |
+----+-------------+-----------+-------+---------------+--------------+---------+-------------------------+------+-------+
3 rows in set (0.01 sec)