select cat.id, listing.id as listing_id, listing.sitename,listing.sitedescribe,listing.siteurl,listing.rating,cat.category from abclistings as listing, abccat as cat where listing.cat1 = #cat# and cat.id = #cat# and listing.status = 1 and (listing.end_date is null OR listing.end_date >= getdate()) order by newid()