ZpmdItemAuditController#find

select zpmditempr0_.id as id1_12_, zpmditempr0_.begin_date as begin_da2_12_, zpmditempr0_.date_create as date_cre3_12_, zpmditempr0_.date_born as date_bor4_12_, zpmditempr0_.end_date as end_date5_12_, zpmditempr0_.family as family6_12_, zpmditempr0_.first_name as first_na7_12_, zpmditempr0_.date_receive as date_rec8_12_, zpmditempr0_.zpmd_item_number as zpmd_ite9_12_, zpmditempr0_.status as status10_12_, zpmditempr0_.main_diagnosis as main_di11_12_, zpmditempr0_.mcode as mcode12_12_, zpmditempr0_.med_history_number as med_his13_12_, zpmditempr0_.not_provided_reason_comment as not_pro14_12_, zpmditempr0_.not_provided_reason_id as not_pro15_12_, zpmditempr0_.npolis as npolis16_12_, zpmditempr0_.patronymic as patrony17_12_, zpmditempr0_.region as region18_12_, zpmditempr0_.request_number as request19_12_, zpmditempr0_.repeated_count as repeate20_12_, zpmditempr0_.spolis as spolis21_12_, zpmditempr0_.theme_category_id as theme_c22_12_, zpmditempr0_.zpmd_id as zpmd_id23_12_, zpmditempr0_.zpmd_status as zpmd_st24_12_, zpmditempr0_.zsl_id as zsl_id25_12_ from zpmd.zpmd_item_view zpmditempr0_ where lower(zpmditempr0_.region)=? and lower(zpmditempr0_.npolis)=? order by zpmditempr0_.date_create desc limit ?