#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-room-for-rent-in-4-bedroom-house-refH120810125658139.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 guys, My name is Ben and I'm here to let you know about a room that my 2 house mates and I have for rent in a spacious terraced house in Heaton. For those of you that don't know Heaton is a student area about 15 minutes away from the Newcastle city centre. There are bus and metro options but it's 15 mins walk into town from our door. The rent works out at 50 quid a week (paid monthly) and the bills don't come to more than 40 quid a month. Council tax is £29 for the property split between the 4 of us. We have been in the house for a year but it's still in good condition, we will be doing an industrial clean before anyone new comes in (for cleanliness and not just deposit purposes) We're easy-going and very easy to get along with. We've lived with new people before in other countries and at uni so we know that everyone is different, whether you want to sit in your room or hang out with us it's no problem at all. It'll be your house too. Ideally you'll be working full time. Nothing against students but we're looking for a professional house mate. We're looking for someone who knows what it's like to live away from home and who can get along with new people. Only criteria is that you're nice to be around haha. Hope to hear from you soon, Ben ******************************************************************** Just to let you all know, the room is listed as a single room, we have had some viewings and people seem disillusioned with the size of it so please be aware when you come see it. It's a single room. Cheers, ********************************************************************
Rooms information | |
---|---|
Bedrooms available | 1 |
Bathrooms | 2 |
Flatmate information | Flatmate preferences information | ||
---|---|---|---|
Gender | DoesntMatter | Gender | Male |
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...