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