#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-double-furnished-rooms-refH120914151237762.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
In Ramsgate, on Crescent Road, close to Ellington Park in Kent we have two properties CT11 9RE which is a 5 minute walk to Ramsgate Station only 19 minutes by High Speed train to Canterbury West. We currently have the following rooms in two properties in Ramsgate. ? 1st Floor Middle large double room £79 pw £342 p.cm on a 6 month Tenancy or £385 if tenancy is less than 6 months. ? 1st Floor Rear double bedroom at £69 pw £299 p.cm on a 6 month tenancy or £342 p.cm if the tenancy is for less than 6 months. All prices above include all bills except telephone and are on a standard 6 month agreement. If wanting for less than 6 months the rent will be £ 5 per week more. The property in question has a cleaner who calls once a week. First of all let me introduce ourselves. We are local people who are members of the government regulated ?National Landlords Association? who are living & working in the County of Kent. We started this small accommodation business & now run 10 properties with just under 50 tenants the majority based in Kent. Telephone All we ask if you decide to move in is that you pay:- 2 months advance rent. This being your 1st month?s rent & your last month?s rent. We do not take a deposit. If you are 2 people we charge £1.61p per day for the 2nd person. This covers the use of showers/bath. If taking up a tenancy you will receive via e mail/post a copy of your tenancy agreement from the ?National Landlords Association? We do ask to save paper that you do not print. However on the day of moving you will receive the front and back pages of the tenancy agreement once signed for you to keep. For Tenancies of less than 6 months we charge a £49 administration fee. Charges 6-12 Months: - £19. 95 Contract Fee only. (£10. 00 Refunded at end of Tenancy if all rental payments rec?d on time) Renewal of 6 monthly contracts is £9. 95 Tenant Referencing Fee of £35 per applicant is only payable if you do not meet one of the two criteria options below:- Last 3 Months Pay Slips & Proof of Address (Tax code advice/Driving Licence/Utility Bill i. e. Council Tax, Water, Gas, Electricity) Or Contract of Employment if you are taking up a new position of employment & 2 months advance rent plus last month?s rent (3 Months in advance as opposed to 2) PLEASE NOTE: - We now charge a £99 Refundable Key Deposit. This is required so that if you lose your keys or do not hand them back then this will cover the cost of replacing your keys. If you lose your keys through your tenancy you will be required to pay for replacement front door lock, plus keys for yourself & any fellow tenants living in the property at the time of LOSS. Last of all we can spread the 2nd month, key deposit & contract & or referencing fee if applicable over the 1st three months. To do this you must be employed or have an offer of employment of which you will need to send us a copy of via e mail or post.
Rooms information | |
---|---|
Bedrooms available | 3 |
Bathrooms | 2 |
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...