select distinct "customers".country AS "customers_country", "customers".city AS "customers_city", "customers".customername AS "nom_client", 'XXXXXX' AS "customers_phone", "customers".customernumber AS "customers_number" from PUBLIC.customers "customers", PUBLIC.timeline "timeline", PUBLIC.orderfact "orderfact" where "orderfact".customernumber="customers".customernumber AND "orderfact".time_id="timeline".id AND  ("timeline".id <= NOW()) AND "customers".country in ('France')  order by "customers_country", "customers_city", "nom_client", "customers_phone", "customers_number"