SELECT
            
                  count( DISTINCT `competitions_membership`.`id` ) as `count` 
		
            FROM
                `competitions_membership`
                 JOIN `competitions_cats` ON  `competitions_cats`.`id` = `competitions_membership`.`id_category`
		 JOIN `disciplines` ON  `disciplines`.`id` = `competitions_cats`.`id_discipline`
		 JOIN `sportsmen_competition` s ON  s.`id` = `competitions_membership`.`id_sportsmen` 
		 LEFT JOIN `geo_countries` ON  `geo_countries`.`id` = s.`id_country`
		 LEFT JOIN `geo_provinces` ON  `geo_provinces`.`id` = s.`id_province`
		
            
            WHERE
                 `competitions_membership`.`id_trainer` =