Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '270')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '270') ORDER BY distance ASC LIMIT 1
MySQL Error: 1030 (Got error 28 from storage engine)
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 670 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/estatebl/public_html/libs/mysql5i.php [line] => 514 [function] => halt [class] => DB_Sql [type] => -> [args] => Array ( [0] => Invalid SQL: (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '270')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '270') ORDER BY distance ASC LIMIT 1 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/Demographic.php [line] => 509 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '270')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '270') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 812 [function] => getNeighborhoodUniData [class] => Demographic [type] => -> [args] => Array ( [0] => Array ( [main_category] => Education [sub_category] => % with univ. certificate/degree [rel_field_name] => with_univ_certificate_degree [cartodb_id] => 270 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2347886 [MLSP_ID] => 1 [listing_key] => R2347886-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V15422 [agent_key] => V15422-1 [agent_name] => Gordon Carter [office_code] => V002901 [office_key] => V002901-1 [office_name] => Sutton Group-West Coast Realty [ListingKey] => 0 [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 3 Storey [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 5 [BathsHalf] => 1 [Baths] => 6 [Beds] => 5 [TotalAcreage] => 0.44 [ListPrice] => 7980000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => -19.95 [OriginalListPrice] => 7980000 [SQFT] => 19364 [FloorArea] => 6071 [YearBuilt] => 1996 [TotalPhotos] => 19 [Main_Photo] => 1 [Description] => BEST PRICE OCEANFRONT HOME in all of WEST VANCOUVER !!! FEATURING: 100 Ft. PRIME OCEANFRONT and over 6,000 Sq. Ft. of LUXURY LIVING with PRIVACY, 180 DEGREE STUNNING VIEWS, OUTDOOR POOL, JACUZZI, over 2500 Sq. Ft. of DECKING and PATIO space for your ENTERTAINING & BBQ's. This Amazing Residence is Situated on a 19,364 Sq. Ft. LOT that was built by Bradner Homes and Architecture by Poskitt Design Ltd. This LOVELY HOME includes: 5 BEDROOMS, 6 BATHROOMS, SENSATIONAL MASTER BEDROOM with HIS and HER FULL BATHROOMS, Office, Den, Family Room, 20 Foot Ceiling in Dining-Living Room, Custom Double Staircases, Maple Hardwood Flooring throughout main, Wine Cellar, Custom Bar, Theatre Room with Custom Millwork, Triple Car Garage, Doggie Wash, Heated Driveway & More. This is a MUST SEE !!! [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 18712.66 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-11 [LastUpdateDate] => 2019-05-15T22:21:00.3 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 68 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 0000-00-00 00:00:00 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 217 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 51 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 20 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 270 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 127 [cartodb_id_demographic2_process] => Yes [cartodb_id_flood] => 0 [cartodb_id_flood_process] => Yes [cartodb_id_roads2_bound] => No [cartodb_id_roads2_process] => Yes [cartodb_id_rail_skytrain_bound] => No [cartodb_id_rail_skytrain_process] => Yes [cartodb_id_airports_ports_bound] => No [cartodb_id_airports_ports_process] => Yes [cartodb_id_power_bound] => No [cartodb_id_power_process] => Yes [cartodb_id_alr] => 0 [cartodb_id_alr_process] => Yes [cartodb_id_cemeteries] => 0 [cartodb_id_cemeteries_process] => Yes [cartodb_id_city] => 11 [cartodb_id_city_process] => Yes [cartodb_id_area] => 11 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1029 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369513 [display_on_website] => Yes [display_on_website_datetime] => 1552416062 [created_datetime] => 2019-03-12 11:20:05 [updated_datetime] => 2019-05-15 15:40:16 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-15 15:44:21 [is_hotdeal] => No [hotdeal_tag] => [hotdeal_description] => null [BasementArea] => [Features] => [Amenities] => [SiteInfluences] => [View] => [Frontage] => [mls_market_sef_url] => lower-mainland [mls_is_pic_url_supported] => No [ListingID_MLS] => R2347886-1 [Area] => West Vancouver [StreetName] => BONNIE BAY [StreetNumber] => 6101 [StreetType] => PLACE [UnitNo] => [StreetDirection] => [ZipCode] => V7W 2V8 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Gleneagles [Latitude] => 49.360259000000000 [Longitude] => -123.282953000000000 [DayOnMarket] => 69 [Pic_Path] => https://static.estateblock.com/pictures/property/R2347886-1/0 [mls_disclaimer_big] => The data relating to real estate on this website comes in part from the MLS® Reciprocity program of either the Real Estate Board of Greater Vancouver (REBGV), the Fraser Valley Real Estate Board (FVREB) or the Chilliwack and District Real Estate Board (CADREB). Real estate listings held by participating real estate firms are marked with the MLS® logo and detailed information about the listing includes the name of the listing agent. This representation is based in whole or part on data generated by either the REBGV, the FVREB or the CADREB which assumes no responsibility for its accuracy. The materials contained on this page may not be reproduced without the express written consent of either the REBGV, the FVREB or the CADREB. [PictureArr] => Array ( [0] => https://static.estateblock.com/pictures/property/default/0 ) [L_Zip] => V7W 2V8 [L_UpdateDate] => 2019-05-15T22:21:00.3 [L_StreetDesignationId] => PLACE [L_ListingID] => 262369513 [L_ListOffice2] => 4200 [L_Status] => Active [L_State] => BC [L_ListingDate] => 2019-03-11 [LFD_Amenities_25] => Air Cond./Central,Pool; Outdoor,Sauna/Steam Room,Swirlpool/Hot Tub [L_ListAgent2] => 42740 [L_ListAgent1] => 19558 [L_DisplayId] => R2347886 [L_City] => West Vancouver [L_AskingPrice] => 7980000 [L_Area] => West Vancouver [L_AddressStreet] => BONNIE BAY [L_AddressNumber] => 6101 [L_Address] => 6101 BONNIE BAY PLACE [LV_vow_include] => Yes [LV_vow_address] => Yes [LO2_PhoneNumber1] => 604-416-8888 [LO2_OrganizationName] => Royal Pacific Lions Gate Realty Ltd. [LR_remarks22] => BEST PRICE OCEANFRONT HOME in all of WEST VANCOUVER !!! FEATURING: 100 Ft. PRIME OCEANFRONT and over 6,000 Sq. Ft. of LUXURY LIVING with PRIVACY, 180 DEGREE STUNNING VIEWS, OUTDOOR POOL, JACUZZI, over 2500 Sq. Ft. of DECKING and PATIO space for your ENTERTAINING & BBQ's. This Amazing Residence is Situated on a 19,364 Sq. Ft. LOT that was built by Bradner Homes and Architecture by Poskitt Design Ltd. This LOVELY HOME includes: 5 BEDROOMS, 6 BATHROOMS, SENSATIONAL MASTER BEDROOM with HIS and HER FULL BATHROOMS, Office, Den, Family Room, 20 Foot Ceiling in Dining-Living Room, Custom Double Staircases, Maple Hardwood Flooring throughout main, Wine Cellar, Custom Bar, Theatre Room with Custom Millwork, Triple Car Garage, Doggie Wash, Heated Driveway & More. This is a MUST SEE !!! [LO2_ShortName] => V005090 [LO1_OrganizationName] => Sutton Group-West Coast Realty [L_ListOffice1] => 2967 [LO1_ShortName] => V002901 [LO1_PhoneNumber1] => 604-714-1700 [LM_char1_36] => Residential Detached [LM_char100_3] => . [LM_Int2_3] => 23 [LM_Int2_5] => 2018 [LM_Int2_2] => 1996 [LM_Int1_4] => 5 [LM_Int1_2] => 3 [LM_Int1_19] => 6 [LM_Int1_18] => 5 [LM_Int1_17] => 1 [LM_Int1_1] => 3 [LM_Dec_9] => 30.48 [LM_Dec_8] => 100 [LM_Dec_7] => 6071 [LM_Dec_16] => 18712.66 [LM_Dec_14] => 0.18 [LM_Dec_12] => 0.44 [LM_Dec_13] => 1798.97 [LM_Dec_11] => 19364 [LM_Dec_1] => 2082 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Gleneagles [LM_Char10_23] => Yes [LM_Char10_11] => House/Single Family [LFD_StyleofHome_1] => 3 Storey [LFD_SiteInfluences_15] => Central Location,Golf Course Nearby,Marina Nearby,Private Setting,Recreation Nearby,Waterfront Property [LFD_FeaturesIncluded_24] => Air Conditioning,ClthWsh/Dryr/Frdg/Stve/DW,Disposal - Waste,Drapes/Window Coverings,Hot Water Dispenser,Microwave,Security System,Sprinkler - Inground,Vacuum - Built In [LFD_BasementArea_6] => Full [LA2_WebPage] => http://www.clarencedebelle.com [LA2_PhoneNumber1] => 604-726-5780 [LA2_LoginName] => V53726 [LA2_Char100_1] => Clarence Debelle PREC* [LA1_WebPage] => http://www.gordoncartermarketing.com [LA1_PhoneNumber1] => 604-728-0996 [LA1_LoginName] => V15422 [LA1_Char100_1] => Gordon Carter [L_PictureCount] => 19 [L_Last_Photo_updt] => 2019-03-25T23:56:14.8 [VT_VTourURL] => https://www.youtube.com/watch?v=y46By-sYkNM&authuser=0 [LM_Char10_12] => Freehold NonStrata [Section] => mls ) ) ) ) [previous:Exception:private] => )