select `a`.`companyID` AS `companyID`,`a`.`ID` AS `customerID`,`a`.`customerName` AS `customerName`,`a`.`phoneNumber1` AS `phoneNumber1`,`a`.`email` AS `email`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 0) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 0) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 0) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `current`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 1) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 1) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 1) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month1`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 2) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 2) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 2) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month2`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 3) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 3) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 3) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month3`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 4) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 4) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 4) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month4`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 5) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 5) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 5) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month5`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 6) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 6) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 6) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month6`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 7) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 7) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 7) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month7`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 8) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 8) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 8) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month8`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 9) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 9) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 9) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month9`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) = 10) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) = 10) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) = 10) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month10`,((ifnull((select sum(`sps1401`.`comp_sales_invoice`.`totalReceivable`) from `sps1401`.`comp_sales_invoice` where ((`sps1401`.`comp_sales_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_invoice`.`salesInvoiceDate`,now()) > 10) and (`sps1401`.`comp_sales_invoice`.`updateAble` = 0) and (`sps1401`.`comp_sales_invoice`.`is_delete` = 0))),0) + ifnull((select sum(`sps1401`.`comp_sales_debitnote`.`total`) from `sps1401`.`comp_sales_debitnote` where ((`sps1401`.`comp_sales_debitnote`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_sales_debitnote`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_sales_debitnote`.`debitNoteDate`,now()) > 10) and (`sps1401`.`comp_sales_debitnote`.`updateAble` = 0) and (`sps1401`.`comp_sales_debitnote`.`is_delete` = 0))),0)) + ifnull((select sum(`sps1401`.`comp_historical_customer_invoice`.`totalReceivable`) from `sps1401`.`comp_historical_customer_invoice` where ((`sps1401`.`comp_historical_customer_invoice`.`companyID` = `a`.`companyID`) and (`sps1401`.`comp_historical_customer_invoice`.`customerID` = `a`.`ID`) and (timestampdiff(MONTH,`sps1401`.`comp_historical_customer_invoice`.`salesInvoiceDate`,now()) > 10) and (`sps1401`.`comp_historical_customer_invoice`.`updateAble` = 0) and (`sps1401`.`comp_historical_customer_invoice`.`is_delete` = 0))),0)) AS `month11` from `sps1401`.`customer` `a`