#ERROR RECU:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT
Error number: HY000
Error message SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT
Error SQL SELECT DISTINCT bdd_country.cny_idt, bdd_country.cny_lib_fr as cny_nam,
bdd_country.cny_lib_fr as loc_name, bdd_country.cny_lib_simple
FROM bdd_country INNER JOIN flatshare ON flatshare.cny_idt = bdd_country.cny_idt
ORDER BY cny_lib_seo ASC
Error URL /immobilier/collocation-rooms-to-let-in-large-detached-house-with-garden-refH13081881517998.html
0:HY000
1:3065
2:Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT
Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409
Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380
Warning: Cannot use a scalar value as an array in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380
Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409
Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380
We have 3 bedrooms to let, prices are reduced at the moment because some redecoration and minor building work is currently being carried out in other parts of the house. This work will be completed by the end of September but the prices will be held for 3 months. 1) Large double 5.5m by 3.8m with en-suite bathroom, currently £500.00 normally £650.00. 2) Double 3.70m by 3.35m (use main bathroom) currently £400.00, normally £500.00 3) Largish Single 3.9m by 2.9m (use main bathroom) currently £400.00 normally £450.00 All rooms have built in wardrobes which are in addition to the areas specified. There is a kitchen/diner with larder. utility room with shower. sitting room with open fireplace. dining room. TV room on the ground floor. We, when we are here* will occupy a bedroom at the rear of the house which has its own en-suite. There is a secluded garden of over one acre (.5 hectares). The garden may be used for: e.g. Badminton/Croquet. we have played cricket but balls get lost. or just loafing about. There is plenty of parking space. * We are normally resident in Devon and once the refurbishment is completed (latest end September) our visits will be reduced and we will be landscaping and gardening when we do come. The costs are inclusive of bills and sharers will have unlimited access to the ground floor rooms listed above. A small second study at the rear of the house is retained for our use. We haven't included many interior pics. because work is still underway and things are a bit messy. but we'd be happy for anyone interested to visit.
Rooms information | |
---|---|
Bedrooms available | 3 |
Bathrooms | 4 |
Flatmate information | Flatmate preferences information | ||
---|---|---|---|
Gender | DoesntMatter | Gender | DoesntMatter |
Age | N/A | Age | N/A - N/A |
Smoker | DoesntMatter | Smoker | DoesntMatter |
Occupation | N/A | Occupation | DoesntMatter |
Pets | N/A | Couples | NotDisclosed |
ACS, spécialiste de la protection sociale pour expatriés avec plus de 20 ans d'expérience. Demandez un devis dès maintenant!
Pour aider les individus et les familles à vivre une vie plus longue, plus saine et plus heureuse.
Sélection de prestataires, produits et services relatifs à votre déménagement et votre vie à l’étranger... Logement, Finance, Assurance…
Comparez les offres. En tant qu'expatrié bénéficiez de l’exonération de droit de succession meme apres retour en France!
Transferez et changez votre argent au meilleur taux. Paiements Internationaux Importants, Transfert réguliers, Couverture Taux. Devis & Conseils Gratuits!
Faites appel à des experts spécialisés en audit et bilan retraite: Calcul, Rachats de trimestres, Age de départ, interventions auprès des caisses de retraite...