SELECT SQL_CALC_FOUND_ROWS p.*, (SELECT image_path FROM property_image WHERE fk_property_id=p.property_id AND property_image.image_order=10) AS image_path, FORMAT(p.realnz_list_price,0) AS price, FORMAT(p.realnz_min_price,0) AS min_price, FORMAT(p.realnz_max_price,0) AS max_price, FORMAT(p.realnz_status_price,0) AS status_price, ws.website_suburb_name,wd.website_district_name ,(SELECT GROUP_CONCAT( open_home_id,'/', open_home_date,'/', TIME_FORMAT(start_time,'%l.%i'),'/', TIME_FORMAT(end_time,'%l.%i %p') ) FROM open_home_new WHERE fk_property_id=property_id AND DATE(open_home_date)>=DATE(NOW()) ORDER BY open_home_date) AS open_homes FROM property p LEFT JOIN website_suburb ws ON p.fk_website_suburb_id = ws.website_suburb_id LEFT JOIN website_district wd ON p.fk_website_district_id = wd.website_district_id WHERE is_real_publish=TRUE AND LENGTH(realnz_marketing_text)>8 AND LENGTH(realnz_marketing_heading)>8 AND p.fk_property_type_id=1 AND p.realnz_sold_status NOT IN ('D','W','U') AND p.fk_website_region_id = '1' AND p.is_eves = 1 AND DATE(oh.open_home_date_time) = '2018-01-18' HAVING NOT ISNULL(open_homes) ORDER BY p.realnz_list_price DESC LIMIT 0,60 gave Unknown column 'oh.open_home_date_time' in 'where clause'

Fatal error: Call to a member function fetch_object() on boolean in /usr/local/www/apache22/data/webarts.co.nz/propdata/eves2015/eves_property/includes/Property.php on line 1238