$album_statement = "SELECT a.id, a.date, a.name, a.description, a.location, a.filepath ".
     		             "FROM gallery_album a ".
                        "WHERE a.active = 1 ".
                        "AND a.galleryid = $galleryid ".
                        "ORDER BY a.sort desc ".
                        "LIMIT $start,$perpage";

SELECT ...
FROM (
SELECT albumid FROM gallery_picture ORDER BY views DESC LIMIT 0, 1
) AS a INNER JOIN gallery_album b ON a.albumid=b.id

SELECT a.id, a.date, a.name, a.description, a.location, a.filepath, p.id AS pid
FROM wb_gallery_album a, wb_gallery_picture p
WHERE a.active = 1
AND p.active = 1
AND a.id = p.albumid
AND a.galleryid = 1
GROUP BY p.albumid
ORDER BY a.sort desc, p.views desc
LIMIT 0,10