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 'Kendal' OR village LIKE 'Kendal' OR ((lat-54.3271<0.05 && lat-54.3271>-0.05) AND (lon--2.74796<0.05 && lon--2.74796>-0.05))) UNION SELECT id FROM cottages WHERE approved = 1 AND `good_views` = 1 AND (town LIKE 'Kendal' OR ((lat-54.3271<0.05 && lat-54.3271>-0.05) AND (lon--2.74796<0.05 && lon--2.74796>-0.05))) UNION SELECT id FROM hotels WHERE approved = 1 AND `good_views` = 1 AND (town LIKE 'Kendal' OR ((lat-54.3271<0.05 && lat-54.3271>-0.05) AND (lon--2.74796<0.05 && lon--2.74796>-0.05)))