select
			a.*
		from
			article_sale_ja a
		where
			(a.sale = 'その他') and 
			a.view = '0' and 
			a.ddate is null
		group by
			a.article_sale_ja_id