$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';