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=35954 OR p.agent2=35954 OR p.agent3=35954) ORDER BY FIELD(p.id, 1321629,1321629,1321629,235656,1339591,241883,1321296,1321296,1321296,242622,1316437,235335,152230,1330698,1330698,1319927,1335474,166782,1318140,1318140,1318140,1324551,1324551,1324551,710773,1317897,1317897,1317897,1322050,1317898,1015127,1141119,186996,1319638,1319638,1319638,212064,212064,1319529,1317559,1321692,1321692,1321692,1319090,1345873,1345873,1345873,1345873,1346790,1346790,1346790,1344380,1338388,1338415,1337959,1337959,1337776,1337768,1337768,1337767,1334970,1336261,1336261,1335540,1335540,1334141,1333324,1319750,1320674,1319849,1319564,1319434,1319022,1318212,1318156,1317678,1147947,1314124,1146063,1314125,1311902,1310683,1145363,1145363,1139354,1138928,1138928,900722,900538,808059,442289,442289,318270,242856,362280,319043,318297,318297,242117,242117,242316,1356425,1336557,1346958,1336818,1319990,1330700,1322727,1321663,1319597,1321246,1317971,1317169,1317046,1317045,1315596,1315273,1311379,1314999,1314999,1314999,1314842,1145989,1142998,1142990,1143654,234214,1017796,247377,1000423,1000423,733784,733784,570940,242491,584256,232031,537612,4648,599855,729719,725711,577583,702065,637983,599300,571465,571423,566016,556416,461244,461244,461244,479469,382404,478567,233003,240776,245468,314060,233176,233176,242134,242134,245851,235526,245530,245499,242227,236348,232437,234281,231455,236172)

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

Line Number: 720