select distinct genre from dvd where format <> 'MERC' order by genre select distinct collection from dvd where featured = 4 and format <> 'MERC' order by collection select distinct subgenre from dvd where format = 'MERC' order by subgenre select * from dvd where label <> 'RF' and label <> 'Media Blasters' and (create_date between '#today_7#' and '#tod_date#') order by title select count(upc) as TotalSearch from dvd where label <> 'RF' and label <> 'Media Blasters' and (create_date between '#today_7#' and '#tod_date#') select count(username) As TotalRecords from users where username = '#client.username#' and logged = 1 Latest Additions - Rareflix.com
Welcome to the newly redesigned"rareFLIX.com". We are currently going through and updating the look and feel of our entire site. This will be an on going process that should be completed in a few days. In the mean time we will be actively bug checking to ensure everything works as it should. If you find any errors please forward them, preferably with URL and screen shot, to support@rareflix.com.
No New Additions in the last week.
Latest Additions during the Last Week
#title#
#brief#
#format# - #subtitles#
j
Availability: #onhand# on hand Availability: out of stock #discount_word#% Off!!
Retail Price: #DollarFormat(srp)# NOW -> #DollarFormat(srp * (1 - discount_rate))# Retail Price: #DollarFormat(srp)#
Previous #DisplayRows# Records Previous Records | Next #Evaluate((get_titles.RecordCount - Next)+1)# #DisplayRows# Records Next Records