A Database Error Occurred

Error Number: 1054

Unknown column 'nbl.location' in 'field list'

SELECT p.*,btd.type_id as building_type, c.counter AS cl_clicks, u.id as agent, u.name, u.surname, u.email, u.craiglist_phone as cell_phone, u.address as phone, u.id as agent_id, u.office_id as office_id, u2.id as agent2, u2.name AS sec_agent_name, u2.surname AS sec_agent_surname, u2.address AS sec_agent_phone, u2.email AS sec_agent_email, u2.office_id AS sec_agent_office_id, u3.id as agent3, u3.name AS thr_agent_name, u3.surname AS thr_agent_surname, u3.address AS thr_agent_phone, u3.email AS thr_agent_email, u3.office_id AS thr_agent_office_id, npu.url_path , btd.type_id, nba.address, nba.house, b.cross_streets AS cstreet, nbl.location, nbad.trains, b.zip, nbad.ps, IF(npp.price != 0, npp.price, npp.oprice) AS price FROM node_properties as p LEFT JOIN node_buildings AS b ON b.id = p.building_id LEFT JOIN node_buildings_addresses AS nba ON nba.building_id = b.id and nba.type = 1 LEFT JOIN building_types_data as btd ON btd.building_id = b.id LEFT JOIN craigslist_statistics AS c ON c.property_id=p.id LEFT JOIN node_properties_urls AS npu ON npu.prop_id=p.id LEFT JOIN users as u ON u.id = p.agent LEFT JOIN users as u2 ON u2.id = p.agent2 LEFT JOIN users as u3 ON u3.id = p.agent3 LEFT JOIN node_properties_prices AS npp ON npp.prop_id = p.id WHERE (1=1) AND p.status=4 AND (p.agent=32987 OR p.agent2=32987 OR p.agent3=32987) ORDER BY p.dt_switch_to_available DESC

Filename: /var/www/ipg/data/www/idealpropertiesgroup.com/modules/property/models/property_frontend_model.php

Line Number: 720