INSERT INTO `netiscrm_tfbsdb02`.`policy_payments_last_pay_date` (`policynumber`,`policypk`,`holderpk`,`billpk`,`holderidnumber`,`region`,`country`,`province`,`branchid`,`chargedate`,`billdate`,`collectiondate`,`pay_number`,`numberofpayments`,`openbill`, `totalbill`,`premium`,`externded_premium`,`premiumpaid`,`premiumoutstaning`,`arrearscount`,`collection_change_amount`,`memberbranchid`,`payed_in_branchid`,`paymentmethodid`,`pay_bulk`, `pay_bulkfilename`,`pay_postofficecode`,`pay_postofficereceiptnr`,`createdby`,`createdon`,`modifiedby`,`modifiedon`,`status`,`statecode`,`charge_month`,`charge_day`,`recordstate`) SELECT `policynumber`,`policypk`,`holderpk`,`billpk`,`holderidnumber`,`region`,`country`,`province`,`branchid`,`chargedate`,`billdate`,`collectiondate`,`pay_number`,`numberofpayments`,`openbill`, `totalbill`,`premium`,`externded_premium`,`premiumpaid`,`premiumoutstaning`,`arrearscount`,`collection_change_amount`,`memberbranchid`,`payed_in_branchid`,`paymentmethodid`,`pay_bulk`, `pay_bulkfilename`,`pay_postofficecode`,`pay_postofficereceiptnr`,`createdby`,`createdon`,`modifiedby`,`modifiedon`,`status`,`statecode`,`charge_month`,`charge_day`,`recordstate` FROM `netiscrm_tfbsdb02`.policy_payments WHERE `policynumber` = 'Ork720110' ORDER BY pk DESC;