"SELECT album.album_id, album.title, image.preview_path FROM `album` INNER JOIN
                            (SELECT album_id, MAX(image_id) AS max_image_id FROM image GROUP BY album_id)
                             max_images ON album.album_id = max_images.album_id JOIN image ON                    image.image_id=max_images.max_image_id"