SELECT paymentRequest.idPaymentRequest, paymentRequest.dateRegistered AS PRDate, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= AND paymentRequestStateHistory.idPaymentRequestState= ORDER BY paymentRequestStateHistory.idPaymentRequestState, paymentRequest.idPaymentRequest Direccion: Sending mail to

ID	Fecha	Creador	Proyecto	Proveedor	N° de factura	Concepto	Fecha de factura	Monto	Estado
#listPR_DR.idPaymentRequest#	#LSDateFormat(listPR_DR.PRDate, "dd/mm/yyyy")#	#listPR_DR.employee#	#listPR_DR.project#	#listPR_DR.provider#	#listPR_DR.billNumber#	#listPR_DR.billConcept#	#LSDateFormat(listPR_DR.billDate, "dd/mm/yyyy")#	#LSCurrencyFormat(listPR_DR.amount)# #listPR_DR.currency#	#listPR_DR.paymentRequestState# #LSDateFormat(listPR_DR.dateRegistered)# #LSTimeFormat(listPR_DR.dateRegistered, "HH:mm")#