#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-looking-for-third-flatmate-in-new-3-bed-penthouse-refH130823123557997.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
Hi, I am a first year graduate entry medical student who is looking for a third flatmate for a 3 bedroom Penthouse on Hayfield Road. It's being newly built and is almost complete and will be ready for September. Suitable for young professionals or students being ideally located within walking/cycling distance from any college - especially St Hugh's, Wadham, Somerville, St Anne?s and Green Templeton. The kitchen is huge and has a glass wall with views of the stunning canal and boats floating upon it. There is also a bathroom with both bath and shower facilities. Each bedroom is spacious, full of light, and the whole property will be fully furnished. The room nearest to kitchen is taken. The rent on the property every month per individual is £469.00. Bills will be shared between the flatmates and cost £40 - 50.00 on top meaning a total £510 - 520.00 per calendar month. Deposit of 6 weeks rent (£648.00) is required. This is to cover against any damage and protects you from losing your deposit if another housemate is responsible for any damage. You will be able to get back the deposit at the end of the 12 month contract (52 weeks). Contract can be renewed and continued also. A U.K based guarantor is required. If you are an international student without a U.K based guarantor a deposit of 12 weeks rent is required. Tenancy starts on 15th of September. We are looking for a committed, easy going, sociable, open minded and tolerant house mate. If you are interested do get in touch telling us a bit about yourself, why you think you will be a good house mate and with some information so I can contact you. Attached are photos of the property taken during construction. I am happy to email further photos and a floor plan. I can also arrange House viewings if you would like to personally inspect it. Thanks, Siva
Rooms information | |
---|---|
Bedrooms available | 1 |
Bathrooms | 1 |
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...