How to choose between classic SQL query and Drupal 8 technic?
Finally, this worked:

$database = \Drupal::database();
$query = $database-&gt;select('amap_distributions_dates', 'amdd');
$query-&gt;leftJoin('amap_distributions_inscriptions', 'amdi', 'amdi.datedistributionid = amdd.id');
$query-&gt;leftJoin('association_personne', 'ap', 'ap.id = amdi.amapienid');
$query-&gt;fields('amdd', ['id', 'datedistribution', 'nombreproduits'])
    -&gt;fields('amdi', ['id', 'datedistributionid', 'amapienid', 'role'])
    -&gt;fields('ap', ['id', 'nom', 'prenom'])
    -&gt;condition('nombreproduits', 0, '&gt;')
    -&gt;orderBy('datedistribution', 'ASC')
    -&gt;orderBy('role', 'ASC')
    -&gt;orderBy('nom', 'ASC')
    -&gt;orderBy('prenom', 'ASC');
$results = $query-&gt;execute()-&gt;fetchAllAssoc('id');
foreach ($results as $row) { some code here }