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 count(username) As TotalRecords from users where username = '#client.username#' and logged = 1 Wishlist - Rareflix.com
UserName could not be found!!
If incorrect please try and log-in or create a new account.
UserName:
Password:
UserName:
Password:
select wishlist.line_number, wishlist.upc, dvd.synopsis, dvd.brief, dvd.title, dvd.srp, dvd.discount_rate, dvd.onhand, dvd.format, dvd.subtitles from wishlist, dvd where ((wishlist.upc = dvd.upc) and (username = '#client.username#')) select count(username) As TotalRecords from wishlist where username = '#client.username#'
Your wish list is empty!!
#title#

#brief#

#format# - #subtitles#

Availability: #onhand# on hand
Availability: out of stock

SRP: #DollarFormat(srp)#

SRP: #DollarFormat(srp)#
NOW #DollarFormat(srp * (1 - discount_rate))#
PREVIOUS PREVIOUS
NEXT NEXT
For any questions
contact by email at
support@rareflix.com
For any comments or
suggestions contact
by email at
support@rareflix.com