"select distinct a.id_customer, a.firstname, a.lastname, a.address1, a.address2, a.postcode, a.city,ct.name from pre3305_address a, pre3305_country_lang ct where ct.id_country = a.id_country and a.id_customer not in ( select distinct g.id_customer from pre3305_customer_group g where g.id_group=10)"
