SELECT b.num_client, b.adresse, c.ville_codepostaux, c.code_codepostaux FROM client b, codepostaux c, client_geo d WHERE b.num_codepostaux = c.num_codepostaux AND d.num_client = b.num_client AND d.latitude = '0.00000000' ORDER BY b.num_client DESC LIMIT 50 0