INSERT INTO site_visitors ( visit_timestamp, visit_page, visit_referer, visit_address, visit_user, visit_agent ) VALUES ( GETDATE(), '/music/review/reviews.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 review_id, genre_name, artist_name, album_name, release_date, label_name, copyright_text, image50_url, image100_url, feature_flag, new_flag, review_date, review_text, active_flag, album_link FROM album_reviews WHERE new_flag = 1 AND active_flag = 1 AND genre_name = '#url.genre#' ORDER BY feature_flag DESC, artist_name, album_name <cfoutput>The Tuesday Apple Record Review - #genre_title# Album Reviews</cfoutput> The Thirteenth Dimension
Criticizing Others For Free
The Tuesday Apple Record Review

   Alternative   Blues   Country   Dance   Electronic   Folk   Inspirational   Pop   Rock   Hip Hop   Soul   Jazz   Soundtrack     
  #genre_title# Reviews provided by
.
   New Releases   Album Reviews  
Today's Specials
 
#artist_name# - #album_name#
#copyright_text#
Read complete review
#artist_name#
#album_name#
#copyright_text#

#display_review#
Read complete review
Sorry, there are no reviews of #genre_title# albums at this time.