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 COLLECTION
FROM dvd
WHERE (collection IS NOT NULL) AND (collection <> '')
ORDER BY COLLECTION
select count(username) As TotalRecords
from users
where username = '#client.username#' and logged = 1
select distinct subgenre
from dvd
where format = 'MERC'
order by subgenre
All Collections - Rareflix.com
