select * from mixes where isActive = 'y' order by mixUploaded Desc
select * from mixes where mixID = '#mixRef#'
update mixes set downloads = '#newCount#' where mixID = '#mixRef#'
select * from mixes where isActive = 'y' order by mixUploaded Desc
select * from events where eventTypeID = '3' and eventDate >= #fortnight#
select * from mixes where mixUploaded >= #fortnight# and isActive = 'y'
select * from tracks where mixID = #mixID# order by trackNo