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=2649 OR p.agent2=2649 OR p.agent3=2649) ORDER BY FIELD(p.id, 1339591,571688,349718,1315006,1319281,1014830,1014830,242698,242698,1035476,1035476,726549,673343,1319407,1319407,1319407,1321245,1315100,1316454,1315101,1315099,1142228,1144224,1311835,1311835,1147934,1140109,1140364,1220004,1139923,1140183,1148195,1142804,1142804,1145846,1147020,1147020,1147020,1144889,1144889,1145360,1143003,1144214,1144223,1138925,1142621,1142621,1142567,1142568,1139508,1000235,1000235,1140365,1142082,1142082,1137668,1137668,1137668,1137354,1137797,1140110,1139357,1139355,1139356,1138926,1059611,1138761,1138760,1138762,1138172,1053184,1138759,1138173,1138174,1137669,1137359,1137360,1137911,1055801,1137910,1057295,1015366,898551,898551,1059462,1055802,1052153,1052153,1038337,1016258,1000239,1000240,883348,1000238,790540,790540,887201,887200,887196,887196,883349,754569,745871,754554,670949,750277,768309,732898,732898,727315,745794,723259,673024,673024,715472,624612,642547,673705,685766,587633,604537,654565,651318,556421,556421,607201,607201,619493,642546,579774,579774,627764,606324,604351,619559,616785,589036,606317,583629,599276,601951,601951,599274,578849,582213,577582,577582,571043,556423,556423,571534,556422,556422,571743,571631,556420,565592,556418,479358,479358,556419,478929,478929,569614,557024,541948,540091,478074,478074,556424,548544,535569,479128,530642,530642,535519,545711,548483,548483,525651,430621,430621,542068,541955,541955,478930,478930,535542,538257,523441,478275,470556,479127,393524,393524,430619,430619,473163,328438,328438,449942,363022,363022,380533,380533,458905,450158,367660,393884,393522,393522,430086,430086,247659,247659,400572,385361,385361,393880,417192,393881,367657,382287,354307,382288,354872,356672,381063,344157,344165,344165,350693,350693,350690,350690,353272,344337,353273,246447,246447,315218,318596,331625,344336,344156,319190,318598,297980,278278,278278,303877,314052,314052,315594,285528,245446,245446,285527,315605,283170,299704,299704,299725,304539,297210,283171,296992,298285,279954,272279,278252,247412,247412,247415,247415,277731,260609,260609,273046,261635,274957,246848,275768,275768,261400,265340,264326,247411,247411,263321,263712,246850,245445,245445,228110,245460,246611,246517,245912,260354,247378,247196,251785,232219,232219,242091,247709,247159,247159,246849,247303,242088,246262,247013,241573,241573,246350,242084,245882,242080,246157,246157,242081,242085,242083,246450,246450,242079,242086,242082,245913,246846,246845,246844,246843,246842,246840,246841,246838,246839,246837,246836,246835,246834,246043,246045,246360,246449,246449,246233,245501,246261,245875,241914,245617,242815,242205,242440,242242,240841,240841,242655,242655,241469,241469,242442,241643,241859,241014,236490,241015,241013,241915,241860,234026,240842,241147,241220,235222,235222,241146,1377217,1377217,1374625,1345492,1335595,1334991,1322725,1322204,1318233,1318113,1310785,1316878,1316878,1316878,1317141,1317133,1317133,1317133,566015,1310966,240436,1149629,1147931,1147931,1147931,1147932,1147932,729106,898658,898658,898658,571412,723778,723778,714300,714300,714300,708533,564053,575622,575622,548804,571026,235809,566014,556416,543877,325724,325724,318004,315608,335685,235440,258816,258816,251422,275766,251423,261401,235394,235394)
Filename: /var/www/ipg/data/www/idealpropertiesgroup.com/modules/property/models/property_frontend_model.php
Line Number: 720