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 label from dvd where label <> '' and label <> 'RF' and label <> 'Media Blasters' order by label select count(username) As TotalRecords from users where username = '#client.username#' and logged = 1 Studios - 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.
Studios
#label#
Previous #DisplayRows# Records Previous Records | Next #Evaluate((get_labels.RecordCount - Next)+1)# #DisplayRows# Records Next Records