INSERT INTO site_visitors ( visit_timestamp, visit_page, visit_referer, visit_address, visit_user, visit_agent ) VALUES ( GETDATE(), '/music/review/recordsbasic.cfm?genre=#url.genre#', '#cgi.http_referer#', 'N/A', '#cgi.remote_addr#', 'N/A', '#cgi.remote_user#', 'N/A', '#cgi.http_user_agent#' 'N/A' ) SELECT album_id, album_title, album_date, album_rating, album_desc FROM album_notes ORDER BY album_title SELECT review_id, artist_name, album_name, release_date, copyright_text, image50_url, review_text, album_link FROM album_reviews WHERE feature_flag = 1 AND active_flag = 1 AND genre_name = '#url.genre#' ORDER BY artist_name, album_name <cfoutput>The Tuesday Apple Record Review - #genre_title# New Releases Summary</cfoutput> The Thirteenth Dimension
Delighting the masses
The Tuesday Apple Record Review

   Alternative   Blues   Country   Dance   Electronic   Folk   Inspirational   Pop   Rock   Hip Hop   Soul   Jazz   Soundtrack     |   View #genre_title# releases in scroller (IE only)
  #genre_title# Featured
Reviews
#artist_name#
#album_name#
   New Releases   Album Reviews  
#title# (#categoryLabel#)