Unknown column 'new_city_carrental_text.carrental_text' in 'field list'
SELECT DISTINCT trans_languages.lang_code AS lang_code, translated_continent_names.seo_name AS continent_seo_name, translated_country_names.name AS country_name, translated_country_names.seo_name AS country_seo_name, new_city_carrental_text.carrental_text AS carrental_text FROM new_country_names INNER JOIN languages ON new_country_names.language_id = languages.id INNER JOIN new_continent_names ON new_continent_names.seo_name = 'afrique' AND new_continent_names.language_id = languages.id INNER JOIN new_continent_names AS translated_continent_names ON new_continent_names.continent_id = translated_continent_names.continent_id INNER JOIN new_country_names AS translated_country_names ON new_country_names.country_id = translated_country_names.country_id AND translated_country_names.language_id = translated_continent_names.language_id INNER JOIN languages AS trans_languages ON translated_country_names.language_id = trans_languages.id WHERE new_country_names.seo_name = 'kenya' AND new_city_carrental_text.carrental_text != ''