SELECT salesContactMedia.name, COUNT(salesClientData.idSalesClient) AS numberOfClients FROM salesContactMedia LEFT JOIN salesClientData ON salesContactMedia.idSalesContactMedia=salesClientData.idSalesContactMedia LEFT JOIN salesClient ON salesClientData.idSalesClient=salesClient.idSalesClient LEFT JOIN sellerClientProject ON salesClientData.idSalesClient=sellerClientProject.idSalesClient WHERE 1=1 AND CAST(salesClient.dateRegistration AS DATE) >= AND CAST(salesClient.dateRegistration AS DATE) >= AND sellerClientProject.idProject= GROUP BY salesContactMedia.idSalesContactMedia ORDER BY salesContactMedia.name selected>#idx#