SELECT album_label, album_photocnt, album_createdate, album_lastupdate, album_viewcnt, gallery_id, album_desc, album_id
FROM album_t
WHERE album_id = #Form.album_id#
SELECT photo_filename, photo_label, photo_thumb, photo_t.photo_id, photo_dateadded,
photo_viewcnt, (photo_rating_total/photo_rating_count) as rating
FROM photo_t
LEFT JOIN photo_rating_t ON photo_t.photo_id = photo_rating_t.photo_id
WHERE album_id = #Form.album_id#
ORDER BY #form.sort#
SELECT user_id, gallery_label
FROM gallery_t
WHERE gallery_id = '#getalbum.gallery_id#'
SELECT user_fname, user_lname, user_email, user_city, user_state, user_country, user_display
FROM user_t
WHERE user_id = '#getuser1.user_id#'
UPDATE album_t SET album_lastviewed = '#dateformat(now(),'yyyy-mm-dd')#' WHERE album_id = #Form.album_id#
Sorry, the album you requested is either not available or not publicly viewable.
UPDATE album_t SET album_viewcnt = album_viewcnt + 1 WHERE album_id = #Form.album_id#