Database error

Error Number: 1054

Unknown column 'battersea' in 'where clause'

SELECT room_beds_st.id AS room_beds_st_id, room_beds_st.bed_number AS room_beds_st_bed_number, room_beds_st.room_letter AS room_beds_st_room_letter, room_beds_st.destination_id AS room_beds_st_destination_id, room_beds_st.accommodation_id AS room_beds_st_accommodation_id, room_beds_st.type_of_bed AS room_beds_st_type_of_bed, room_beds_st.room_bed_together_id AS room_beds_st_room_bed_together_id, room_beds_st.ideal_rent_amount AS room_beds_st_ideal_rent_amount, room_beds_st.private_bathroom AS room_beds_st_private_bathroom, room_beds_st.television AS room_beds_st_television, room_beds_st.available AS room_beds_st_available, room_beds_st.notes AS room_beds_st_notes, room_beds_st.dt_available_from AS room_beds_st_dt_available_from, room_beds_st.locker_room AS room_beds_st_locker_room, room_beds_st.locker_code AS room_beds_st_locker_code, room_beds_st.wardrobe AS room_beds_st_wardrobe, room_beds_st.chestrobe AS room_beds_st_chestrobe, room_beds_st.private_kitchen AS room_beds_st_private_kitchen, room_beds_st.fridge AS room_beds_st_fridge, room_beds_st.floor AS room_beds_st_floor, room_beds_st.sex AS room_beds_st_sex, room_beds_st.video AS room_beds_st_video, room_beds_st.desk AS room_beds_st_desk, room_beds_st.inserted_on AS room_beds_st_inserted_on, room_beds_st.inserted_by AS room_beds_st_inserted_by, room_beds_st.updated_on AS room_beds_st_updated_on, room_beds_st.updated_by AS room_beds_st_updated_by, destinations.id AS destinations_id, destinations.name AS destinations_name, destinations.available AS destinations_available, destinations.office_address AS destinations_office_address, destinations.office_tube_station AS destinations_office_tube_station, destinations.manager_name AS destinations_manager_name, destinations.manager_phone AS destinations_manager_phone, destinations.manager_email AS destinations_manager_email, destinations.maintenance_man_name AS destinations_maintenance_man_name, destinations.maintenance_man_phone AS destinations_maintenance_man_phone, destinations.maintenance_man_email AS destinations_maintenance_man_email, destinations.notice_type AS destinations_notice_type, destinations.contract_address AS destinations_contract_address, destinations.contract_tube_station AS destinations_contract_tube_station, destinations.notice_url AS destinations_notice_url, destinations.notice_email AS destinations_notice_email, destinations.payment_day AS destinations_payment_day, destinations.bank_account AS destinations_bank_account, destinations.contract AS destinations_contract, destinations.rent_payment_letter AS destinations_rent_payment_letter, destinations.house_owner AS destinations_house_owner, destinations.clients_web_site_url AS destinations_clients_web_site_url, destinations.arrivals_email AS destinations_arrivals_email, destinations.email_sent_on AS destinations_email_sent_on, destinations.autorenew AS destinations_autorenew, destinations.n_day_notice AS destinations_n_day_notice, destinations.maintenance_fee AS destinations_maintenance_fee, destinations.room_management AS destinations_room_management, destinations.manager_id AS destinations_manager_id, destinations.property_details AS destinations_property_details, destinations.property_post_code AS destinations_property_post_code, destinations.property_street_view AS destinations_property_street_view, destinations.property_google_map AS destinations_property_google_map, destinations.property_address_print AS destinations_property_address_print, destinations.property_zone AS destinations_property_zone, destinations.property_area AS destinations_property_area, destinations.property_floor AS destinations_property_floor, destinations.property_additional_note AS destinations_property_additional_note, destinations.property_communal_bathroom AS destinations_property_communal_bathroom, destinations.property_kitchen AS destinations_property_kitchen, destinations.property_living_room AS destinations_property_living_room, destinations.property_washing_machine AS destinations_property_washing_machine, destinations.property_dishwasher AS destinations_property_dishwasher, destinations.property_internet_wifi AS destinations_property_internet_wifi, destinations.property_video AS destinations_property_video, destinations.property_private_considerations AS destinations_property_private_considerations, destinations.landlord_week_rent AS destinations_landlord_week_rent, destinations.landlord_deposit AS destinations_landlord_deposit, destinations.landlord_dt_st_ct AS destinations_landlord_dt_st_ct, destinations.property_paypal AS destinations_property_paypal, destinations.rent_email AS destinations_rent_email, destinations.minimum_stay AS destinations_minimum_stay, destinations.show_l2l AS destinations_show_l2l, destinations.bills AS destinations_bills, destinations.deposit_required AS destinations_deposit_required, destinations.rent_required AS destinations_rent_required, tube_stations.id AS tube_stations_id, tube_stations.latitude AS tube_stations_latitude, tube_stations.longitude AS tube_stations_longitude, tube_stations.name AS tube_stations_name, tube_stations.zone AS tube_stations_zone, tube_stations.total_lines AS tube_stations_total_lines, tube_stations.rail AS tube_stations_rail, accommodations.id AS accommodations_id, accommodations.name AS accommodations_name, accommodations.zone AS accommodations_zone, accommodations.type AS accommodations_type, accommodations.maximum_guests AS accommodations_maximum_guests, accommodations.rent_per AS accommodations_rent_per, accommodations.weeks_in_advance AS accommodations_weeks_in_advance, accommodations.available AS accommodations_available, accommodations.archived AS accommodations_archived FROM destinations JOIN room_beds_st ON destinations.id = room_beds_st.destination_id LEFT JOIN `tube_stations` ON `destinations`.`contract_tube_station` = `tube_stations`.id JOIN `accommodations` ON accommodations.id = room_beds_st.accommodation_id WHERE room_beds_st.id = battersea-park