SELECT DISTINCT #getProjectActivityListQueryString()# LEFT JOIN employeeAccessProfile ON projectActivity.idProject=employeeAccessProfile.idProject WHERE employeeAccessProfile.idEmployee= AND ( (projectActivity.dateEnd < OR projectActivity.dateEnd IS NULL) AND (projectActivity.dateEndReal >= projectActivity.dateEnd+5 OR projectActivity.dateEndReal IS NULL) ) AND projectActivity.idProject= ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)# SELECT #getPaymentRequestQueryString()# LEFT JOIN employeeAccessProfile ON projectActivity.idProject=employeeAccessProfile.idProject WHERE employeeAccessProfile.idEmployee= AND paymentRequest.idProject= AND paymentRequest.idPaymentRequestState= AND paymentRequest.idCompany= GROUP BY paymentRequest.idPaymentRequest ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)#