SELECT g.`id_group` AS `ID`, g.`name` AS `group name`, g.`abbr`, 
g.`dangerous`, g.`status`, c.`name` AS `country name`, c.`iso`, 
r.`name` AS `religion name`, rg.`name` AS `religion group`,  i.`id_people` AS `ID people`, i.`name`, i.`surname`, i.`main`
	FROM `group` AS g 
		LEFT JOIN `country` AS c ON  g.country=c.id_country 
		LEFT JOIN religion AS r ON g.religion=r.id_religion 
		LEFT JOIN religion_group AS rg ON r.religion_group=rg.id_religion_group	
		LEFT JOIN `identity` AS i ON g.leader=i.id_people 
	GROUP BY `group name` ORDER BY ID ASC