SELECT DISTINCT `a`.* FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` LEFT JOIN `galette_cotisations` AS `ct` ON `ct`.`id_adh`=`a`.`id_adh` WHERE LOWER(a.pref_lang) = 'en_us' ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0
SELECT DISTINCT `a`.* FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` LEFT JOIN `galette_cotisations` AS `ct` ON `ct`.`id_adh`=`a`.`id_adh` ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0
il manque WHERE LOWER(a.pref_lang) = 'en_us'
exemple 2
SELECT DISTINCT `a`.* FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` LEFT JOIN `galette_cotisations` AS `ct` ON `ct`.`id_adh`=`a`.`id_adh` WHERE activite_adh=true AND LOWER(a.id_statut) = '1' ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0
SELECT DISTINCT `a`.* FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` LEFT JOIN `galette_cotisations` AS `ct` ON `ct`.`id_adh`=`a`.`id_adh` WHERE activite_adh=true ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0