select s.site_id from site_types s, e_site e where s.s=1 AND s.site_id=e.id AND e.for_sale='Y'