select
    id,
    base_info,
    technical_content,
    reference_document_file_url,
    generated_doc_type,
    generated_status,
    error_mess,
    CREATED_TIME
from
    biz_software_copyright
where
is_deleted = 'N'
<< and LOCATE(:query,JSON_EXTRACT(base_info, '$.softwareFullName'))>>
<< and generated_status = :generatedStatus >>
<< and generated_status in (:generatedStatusList) >>
order by CREATED_TIME desc