SELECT DISTINCT salesClientUnit.idEmployee, COUNT(salesClientUnit.idSalesUnit) AS numberOfUnits, CONCAT(TRIM(CONCAT(employee.nameFirst, ' ', employee.nameFirst1)), ' ', TRIM(CONCAT(employee.nameLast, ' ', employee.nameLast1))) AS employee FROM salesClientUnit LEFT JOIN employee ON salesClientUnit.idEmployee=employee.idEmployee WHERE ( salesClientUnit.idSalesClientState=30 OR salesClientUnit.idSalesClientState=40 ) AND salesClientUnit.idProject= GROUP BY salesClientUnit.idEmployee ORDER BY employee SELECT DISTINCT salesClientUnit.idSalesClientUnit, salesClientUnit.idSalesClient, CONCAT(TRIM(CONCAT(salesClient.nameFirst, ' ', salesClient.nameFirst1)), ' ', TRIM(CONCAT(salesClient.nameLast, ' ', salesClient.nameLast1))) as salesClient, salesClientUnit.idSalesUnit, salesUnit.number as salesUnit, salesClientUnit.idProject, project.name AS project, salesClientUnit.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, ' ', employee.nameFirst1)), ' ', TRIM(CONCAT(employee.nameLast, ' ', employee.nameLast1))) AS employee, salesClientUnit.idSalesPaymentPlan, salesPaymentPlan.name as salesPaymentPlan, salesClientUnit.idSalesClientState, salesClientState.name as salesClientState, salesClientUnit.idSalesContact, salesContact.name as salesContact, salesClientUnit.idSalesContactMedia, salesContactMedia.name as salesContactMedia, salesClientUnit.dateRegistration, salesClientUnit.sellPrice, salesClientUnit.price, salesClientUnit.idCurrency, currency.name AS currency FROM salesClientUnit LEFT JOIN salesClient ON salesClientUnit.idSalesClient=salesClient.idSalesClient LEFT JOIN salesUnit ON salesClientUnit.idSalesUnit=salesUnit.idSalesUnit LEFT JOIN project ON salesClientUnit.idProject=project.idProject LEFT JOIN employee ON salesClientUnit.idEmployee=employee.idEmployee LEFT JOIN salesPaymentPlan ON salesClientUnit.idSalesPaymentPlan=salesPaymentPlan.idSalesPaymentPlan LEFT JOIN salesClientState ON salesClientUnit.idSalesClientState=salesClientState.idSalesClientState LEFT JOIN salesContact ON salesClientUnit.idSalesContact=salesContact.idSalesContact LEFT JOIN salesContactMedia ON salesClientUnit.idSalesContactMedia=salesContactMedia.idSalesContactMedia LEFT JOIN currency ON salesClientUnit.idCurrency=currency.idCurrency WHERE ( salesClientUnit.idSalesClientState=30 OR salesClientUnit.idSalesClientState=40 ) AND salesClientUnit.idProject= ORDER BY #module.list.orderBy# selected>#idx# SELECT idProject FROM project WHERE name= AND idProject !=