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 count(username) As TotalRecords
from users
where username = '#client.username#' and logged = 1
My Account - Rareflix.com