A Database Error Occurred

Error Number: 1054

Unknown column 'good_views' in 'where clause'

SELECT id FROM accommodation WHERE approved = 1 AND `good_views` = 1 AND (town LIKE 'Cartmel' OR village LIKE 'Cartmel' OR ((lat-54.2003<0.05 && lat-54.2003>-0.05) AND (lon--2.95245<0.05 && lon--2.95245>-0.05))) UNION SELECT id FROM cottages WHERE approved = 1 AND `good_views` = 1 AND (town LIKE 'Cartmel' OR ((lat-54.2003<0.05 && lat-54.2003>-0.05) AND (lon--2.95245<0.05 && lon--2.95245>-0.05))) UNION SELECT id FROM hotels WHERE approved = 1 AND `good_views` = 1 AND (town LIKE 'Cartmel' OR ((lat-54.2003<0.05 && lat-54.2003>-0.05) AND (lon--2.95245<0.05 && lon--2.95245>-0.05)))