SELECT COUNT(idSalesUnit) AS numberOfUnits FROM salesUnit WHERE idProject= AND salesUnit.idSalesUnitState= SELECT SUM(salesUnit.price) AS valueOfUnits FROM salesUnit WHERE idProject= AND salesUnit.idSalesUnitState= SELECT SUM(salesClientUnit.sellPrice) AS valueOfUnits FROM salesUnit LEFT JOIN salesClientUnit ON salesUnit.idSalesUnit=salesClientUnit.idSalesUnit AND salesClientUnit.idSalesClientState= AND ( salesClientUnit.idSalesClientState= OR salesClientUnit.idSalesClientState= ) WHERE salesUnit.idProject= AND salesUnit.idSalesUnitState= SELECT projectTask.idProjectTask, projectTask.idParent, parent.name AS parent, projectTask.idProjectActivity, projectActivity.name AS projectActivity, projectTask.idProject, project.name AS project, projectTask.idCurrency, currency.name AS currency, projectTask.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, ' ', employee.nameFirst1)), ' ', TRIM(CONCAT(employee.nameLast, ' ', employee.nameLast1))) AS employee, projectTask.name, projectTask.amountAuthorized, projectTask.amountUsed, (projectTask.amountAuthorized-projectTask.amountUsed) AS amountAvailable, projectTask.dateStart, projectTask.dateEnd, projectTask.dateEndReal FROM projectTask LEFT JOIN projectTask AS parent ON projectTask.idParent=parent.idProjectTask LEFT JOIN projectActivity ON projectTask.idProjectActivity=projectActivity.idProjectActivity LEFT JOIN project ON projectTask.idProject=project.idProject LEFT JOIN currency ON projectTask.idCurrency=currency.idCurrency LEFT JOIN employee ON projectTask.idEmployee=employee.idEmployee WHERE projectTask.idProject= AND projectActivity.name LIKE "%construccion%" ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)# SELECT projectActivity.idProjectActivity, projectActivity.idParent, parent.name AS parent, projectActivity.idProject, project.name AS project, projectActivity.idCurrency, currency.name AS currency, projectActivity.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, ' ', employee.nameFirst1)), ' ', TRIM(CONCAT(employee.nameLast, ' ', employee.nameLast1))) AS employee, projectActivity.name, projectActivity.amountAuthorized, projectActivity.amountUsed, (projectActivity.amountAuthorized-projectActivity.amountUsed) AS amountAvailable, projectActivity.dateStart, projectActivity.dateEnd, projectActivity.dateEndReal FROM projectActivity LEFT JOIN projectActivity AS parent ON projectActivity.idParent=parent.idProjectActivity LEFT JOIN project ON projectActivity.idProject=project.idProject LEFT JOIN currency ON projectActivity.idCurrency=currency.idCurrency LEFT JOIN employee ON projectActivity.idEmployee=employee.idEmployee WHERE projectActivity.idProject= ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)#