#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-laidback-roommate-asap-refH130821135056936.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
FINANCIAL AND LEASE INFO Before moving in, I ask that you to put down first month (850), last month (850), security (850). Finally, you must sign a ONE YEAR lease: September 1, 2013 to August 31, 2014. ABOUT YOUR ROOMMATE: I am a 25-year-old male graduate student in US political history. I am laid-back, relatively quiet, and am easy to talk to. While college-like partying no longer interests me, I am always up for grabbing drinks with friends at a nearby pub. Right now, work for school--primarily preparing for comprehensive exams--consumes most of my time, I have developed a mild addiction to pub trivia, corny jokes, and muppet videos on youtube. I am looking for a roommate who values good communication, clean common areas, and enjoys a quiet living space. My relations with past roommates (male and female) have been good ones. ABOUT YOUR NEW APARTMENT: The apartment is located in a quiet residential neighborhood about a five-minute walk from Cleveland Circle. The apartment has two private bedrooms (one available) with closets, and one shared bathroom. It has a kitchen with a dishwasher and a decently sized living room (see photo). It is on the garden level (basement, windows are normal sized), which is a plus in the summer since it stays cooler. There are laundry machines within the complex. The complex prohibits smoking within the building. YOUR TRANSPORTATION OPTIONS: For transportation, you have three options. A one to two minute walk to the Green B-Line (Chiswick Road). A six to eight minute walk to the Green C or D Lines (Cleveland Circle/Reservoir). One can also catch the 66 Bus to Harvard at the Reservoir T-Stop. And if you love coffee, there is a sweet independent coffee shop (not starbucks or dunkin) that is a four to six minute walk from the apartment.
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 | |
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...