INSERT INTO site_visitors
(
visit_timestamp,
visit_page,
visit_referer,
visit_address,
visit_user,
visit_agent
)
VALUES
(
GETDATE(),
'/music/review/records.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 n.album_id,
n.album_title,
n.album_date,
n.album_rating,
n.album_desc,
r.review_id
FROM album_notes n
LEFT JOIN album_reviews r
ON r.review_id = n.review_id
AND r.active_flag = 1
WHERE n.album_date > DATEADD(day, -90, GETDATE())
ORDER BY n.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
The Tuesday Apple Record Review - #genre_title# New Releases