SELECT
    lawyer_writing_template_id, 
    lawyer_writing_template_type, 
    lawyer_writing_template_name, 
    lawyer_writing_template_classification
FROM
    biz_ai_lawyer_writing_template_type template_type
WHERE
1=1
    << AND template_type.lawyer_writing_template_type in (:lawyerWritingTemplateTypeList)  >>
    << AND template_type.lawyer_writing_template_classification in (:lawyerWritingTemplateClassificationList) >>  
    << AND template_type.lawyer_writing_template_name LIKE CONCAT('',:lawyerWritingTemplateName,'%')  >>