thats great thanks.
now the AND download.Live = 1 will only allow the product to show if the download is set to Live otherwise the product would show as no results.
how would I modify the rs to allow the product detail to show even if the download(s) were not live?