select SQL_CALC_FOUND_ROWS OUTPUT.* from
 (select  loan.id as loanId , mc.office_id as officeId,
 loan.loan_status_id as loanStatusId, loan.accrued_till as accruedTill,
  loan.repayment_period_frequency_enum as frequencyEnum,
   loan.interest_calculated_from_date as interestCalculatedFrom,
     loan.repay_every as repayEvery,loan.is_npa as npa,ls.installment as installmentNumber,
      ls.duedate AS duedate,ls.fromdate AS fromdate,ls.id AS scheduleId,
     loan.product_id AS productId,ls.interest_amount AS interest,
     ls.interest_waived_derived AS interestWaived,ls.penalty_charges_amount AS penalty,
         ls.fee_charges_amount AS charges, ls.accrual_interest_derived AS accinterest,
         ls.accrual_fee_charges_derived AS accfeecharege,ls.accrual_penalty_charges_derived AS accpenalty,
         loan.currency_code AS currencyCode,loan.currency_digits AS currencyDigits,
         loan.currency_multiplesof AS inMultiplesOf
FROM m_loan_repayment_schedule ls
INNER JOIN
            (
SELECT l.id, l.client_id, l.product_id, l.accrued_till,
            l.repayment_period_frequency_enum,l.interest_calculated_from_date,
             l.repay_every, l.is_npa, l.currency_code, l.currency_digits,
             l.currency_multiplesof, l.loan_status_id
FROM m_loan
             l
INNER JOIN m_client mc ON mc.id = l.client_id
INNER JOIN m_office o ON mc.office_id = o.id
WHERE l.loan_status_id= 300 AND l.is_npa=0 AND
                 l.maturedon_date >= CURDATE() AND l.accrued_till < 2018-07-14 AND o.hierarchy LIKE '.%' AND l.id >= 0
LIMIT 1000) loan ON loan.id=ls.loan_id
INNER JOIN m_product_loan mpl ON mpl.id = loan.product_id
INNER JOIN m_client mc ON mc.id = loan.client_id
INNER JOIN m_office o ON mc.office_id = o.id
WHERE loan.accrued_till < ls.duedate AND mpl.accounting_type=3 AND ls.completed_derived = 0 and ls.fromdate < 2018-07-14
order by loan.id, ls.duedate)OUTPUT;