#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-2-bedrooms-for-rent-in-fully-furnished-suite--refH13082410336988.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
2-week minimum stay. 2 bedroom large, bright fully-furnished suite. By Northgate Mall, Argyle and Ring Road. Clean, quiet, safe neighbourhood, close to transportation and amenities. Two bedrooms---Each bedroom rents for $750 each per month or $200 each per week. . 2 tenants share rest of space. Each bedroom is fully furnished with high-quality queen sized bed, new linens, hi-def TV and high-speed internet. One has built-in gas fireplace. Shared use of sitting area with electric fireplace and leather sofa. Shared use of full 3-piece bathroom with shower. Shared use of fully equipped kitchen with fridge, microwave convection oven, toaster oven, hot plate, slow cooker, electric frying pan, toaster, coffeemaker, kettle, all dishes, cutlery, cooking utensils, kitchen linens, dishsoap, etc.. In-suite shared laundry facilities for use free of charge. Detergent provided. Full use of backyard, patio, patio set, gas barbeque. We supply propane. Driveway parking available with plug-in if required. House is fully air conditioned. Quiet couple lives upstairs. Each bedroom is suitable for one person occupancy, occasional overnight visitors okay. No pets. We pair up like minded people.....2 students, 2 tradesguys, whoever rents the first room....we will find you a suitable roommate for the second. Both available for Sept. 1. Short or long term stays. Call or text for immediate details or viewing.
Rooms information | |
---|---|
Bedrooms available | 2 |
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...