$sql = 'select '. 'embbi.*, '. 'count(id_branche_industrielle) as count_bi, '. 'count(id_emballage_primaire) as count_primaire, '. 'count(id_emballage_secondaire) as count_secondaire '. 'from '. 'emballages as embbi left join emballages_assoc_bi on ( id_emballage = id ), '. 'emballages as embep left join emballages_assoc_primaire on ( id_emballage = id ), '. 'emballages as embes left join emballages_assoc_secondaire on ( id_emballage = id ) '. 'where '. 'embbi.id = embep.id and embbi.id = embes.id '. 'group by '. 'embbi.id '. 'order by '. 'embbi.libelle_fr asc';