Вот:

select * from kc_content where  ka_parent_doc = '080000018d4cf387'

and ka_is_deleted = 1

order by 2 desc