A Database Error Occurred

Error Number: 1054

Unknown column 'rides_cities.city_id' in 'where clause'

SELECT `reviews`.`review_id`, `reviews`.`created`, `reviews`.`item_id`, `reviews`.`type`, `reviews`.`rating_score`, `reviews`.`review_text`, `reviews`.`user_id`, `ibf_core_members`.`name`, `reviews`.`status`, `reviews`.`votes`, `reviews`.`hitcounter`, `ibf_core_members`.`pp_thumb_photo`, `attraction`.`title`, `attraction`.`subtitle`, `attraction`.`slug`, `attraction`.`image`, `attraction`.`parent_id`, `attraction`.`parent_type`, `attraction`.`type` as `attraction_type`, `attraction`.`rating`, `park`.`title` as `parent_title`, `park`.`slug` as `parent_slug`, `park`.`image` as `parent_image`, cities.location_country, cities.location_state, cities.location_city, country.country_name, CONCAT(cities.location_city, ', ', country.country_name) AS parent_location FROM `reviews` LEFT JOIN `parkz_ipb4`.`ibf_core_members` ON `reviews`.`user_id` = `ibf_core_members`.`member_id` JOIN `attraction` AS `attr_parent` ON `reviews`.`attraction_id` = `attr_parent`.`id` JOIN `attraction` ON `reviews`.`attraction_id` = `attraction`.`id` LEFT JOIN `attraction` as `park` ON `attraction`.`parent_id` = `park`.`id` AND `attraction`.`parent_type` = `park`.`type` LEFT JOIN `cities` ON `attraction`.`parent_id` = `cities`.`city_id` AND `attraction`.`parent_type` = 'city' LEFT JOIN `country` ON `cities`.`location_country` = `country`.`location_country` WHERE `attr_parent`.`parent_id` IN('5049', '5052', '5065', '5079', '5120', '5233', '5299') AND `rides_cities`.`city_id` = '14' AND `reviews`.`status` = 'publish' ORDER BY `reviews`.`created` DESC LIMIT 12

Filename: models/Reviewmodel.php

Line Number: 245