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 GENRE
FROM dvd
WHERE (genre IS NOT NULL) AND (genre <> '')
ORDER BY GENRE
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
