SELECT #getQueryString()# WHERE salesClientUnitPaymentSchema.idSalesClientUnit= SELECT #getQueryString()# WHERE 1=1 AND salesClientUnit.idProject= AND salesClientUnit.idSalesClientState IN (,,) AND ( salesClient.nameFirst LIKE OR salesClient.nameFirst1 LIKE ) AND ( salesClient.nameLast LIKE OR salesClient.nameLast1 LIKE ) AND salesClientUnit.idEmployee= ORDER BY #arguments.orderBy##module.list.orderBy# DELETE FROM salesPayment WHERE idSalesClientUnit= AND amount=0 INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , , ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT INTO salesClientUnitPaymentSchema ( idSalesClientUnit, booking, dateBooking, hook, dateHook, monthly, monthes, dateMonthlyPaymentStart, lastMonthlyPaymentDay, final1, final2, dateFinal1, dateFinal2, penalty, dateDelivery ) VALUES ( , , NULL, , NULL, , , , , , , NULL, NULL, , NULL ) ON DUPLICATE KEY UPDATE booking=, dateBooking=NULL, hook=, dateHook=NULL, monthly=, monthes=, dateMonthlyPaymentStart=, lastMonthlyPaymentDay=, final1=, final2=, dateFinal1=NULL, dateFinal2=NULL, penalty=, dateDelivery=NULL Details: " & cfcatch.Detail> DELETE FROM salesClientUnitPaymentSchema WHERE salesClientUnitPaymentSchema.idSalesClientUnit= DELETE FROM salesPayment WHERE salesPayment.idSalesClientUnit= Details: " & cfcatch.Detail> #_idx#