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 = '304')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 = '304') 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 = '304')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 = '304') 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 = '304')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 = '304') 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] => 304 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2348973 [MLSP_ID] => 1 [listing_key] => R2348973-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V83463 [agent_key] => V83463-1 [agent_name] => Shirley Wu PREC* [office_code] => V004812 [office_key] => V004812-1 [office_name] => Luxmore Realty [ListingKey] => 0 [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 0 [BathsHalf] => 2 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 753000 [ListMarketPercentage] => -21.18 [ListMarketPercentageCity] => -3.19 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 900 [YearBuilt] => 2019 [TotalPhotos] => 11 [Main_Photo] => 1 [Description] => Sub-Penthouse South Facing!! 1013 Sqf of balcony makes the feeling of living in a single house! Must see to appreciate! Welcome to Richmond's most desirable waterfront community.MONACO at PARC RIVIERA. A master-planned neighbourhood by Dava Developments, one of Richmond's most premium home builders. This well appointed residence features:9 foot ceilings,open gourmet chef's kitchen with 36"Fisher Paykel Stainless Steel Refrigerator, Bosch 5 Burner Gas Stove,Air Conditioning,Undermount kitchen sink, Soft-Close Cabinets, large patio and 2 parking spots.The Clubhouse has lap pool, hot tub, gym and lounge. This area has 5 acres of parks and is closest entry to Vancouver,steps to the riverfront dyke, shopping and schools. [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 360.00 [Tax] => 0.00 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-05-03T22:13:36 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 67 [tag] => open_house [is_openhouse] => Yes [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] => 251 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 83 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 28 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 304 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 419 [cartodb_id_demographic2_process] => Yes [cartodb_id_flood] => 0 [cartodb_id_flood_process] => Yes [cartodb_id_roads2_bound] => Yes [cartodb_id_roads2_process] => Yes [cartodb_id_rail_skytrain_bound] => No [cartodb_id_rail_skytrain_process] => Yes [cartodb_id_airports_ports_bound] => Yes [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] => 2 [cartodb_id_city_process] => Yes [cartodb_id_area] => 2 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 100 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262370600 [display_on_website] => Yes [display_on_website_datetime] => 1552652282 [created_datetime] => 2019-03-14 16:20:04 [updated_datetime] => 2019-05-03 15:40:11 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-03 15:44:30 [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] => R2348973-1 [Area] => Richmond [StreetName] => RIVER [StreetNumber] => 10177 [StreetType] => DRIVE [UnitNo] => 504 [StreetDirection] => [ZipCode] => V6X 1Z3 [CityName] => Richmond [County] => [State] => BC [Subdivision] => Bridgeport RI [Latitude] => 49.198534700000000 [Longitude] => -123.110983700000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348973-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_Last_Photo_updt] => 2019-03-15T18:47:57 [L_UpdateDate] => 2019-05-03T22:13:36 [L_Zip] => V6X 1Z3 [L_StreetDesignationId] => DRIVE [L_State] => BC [L_Status] => Active [L_ListingID] => 262370600 [L_PictureCount] => 11 [L_ListingDate] => 2019-03-12 [L_ListOffice1] => 2878 [L_ListAgent1] => 60109 [L_DisplayId] => R2348973 [L_City] => Richmond [L_AskingPrice] => 753000 [L_Area] => Richmond [L_AddressUnit] => 504 [L_AddressNumber] => 10177 [L_AddressStreet] => RIVER [LV_vow_include] => Yes [L_Address] => 504 10177 RIVER DRIVE [LV_vow_address] => Yes [LR_remarks22] => Sub-Penthouse South Facing!! 1013 Sqf of balcony makes the feeling of living in a single house! Must see to appreciate! Welcome to Richmond's most desirable waterfront community.MONACO at PARC RIVIERA. A master-planned neighbourhood by Dava Developments, one of Richmond's most premium home builders. This well appointed residence features:9 foot ceilings,open gourmet chef's kitchen with 36"Fisher Paykel Stainless Steel Refrigerator, Bosch 5 Burner Gas Stove,Air Conditioning,Undermount kitchen sink, Soft-Close Cabinets, large patio and 2 parking spots.The Clubhouse has lap pool, hot tub, gym and lounge. This area has 5 acres of parks and is closest entry to Vancouver,steps to the riverfront dyke, shopping and schools. [LO1_ShortName] => V004812 [LO1_PhoneNumber1] => 604-790-1111 [LO1_OrganizationName] => Luxmore Realty [LM_char1_36] => Residential Attached [LM_char100_3] => River View from Balcony [LM_Int2_5] => 2018 [LM_Int2_2] => 2019 [LM_Int1_4] => 2 [LM_Int1_19] => 2 [LM_Int1_1] => 1 [LM_Int1_17] => 2 [LM_Dec_22] => 360.00 [LM_Dec_7] => 900 [LM_Dec_1] => 900 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Bridgeport RI [LM_Char10_23] => Yes [LM_Char10_11] => Apartment/Condo [LFD_SiteInfluences_46] => Central Location,Shopping Nearby [LFD_StyleofHome_32] => Inside Unit [LFD_FeaturesIncluded_55] => Air Conditioning,ClthWsh/Dryr/Frdg/Stve/DW,Dishwasher,Drapes/Window Coverings,Microwave,Oven - Built In,Range Top,Refrigerator,Sprinkler - Fire [LFD_Amenities_56] => Club House,Exercise Centre,Playground,Pool; Indoor,Recreation Center,Swirlpool/Hot Tub [LA1_LoginName] => V83463 [LA1_PhoneNumber1] => 778-288-2118 [LA1_Char100_1] => Shirley Wu PREC* [LM_Char10_12] => Freehold Strata [Section] => mls ) ) ) ) [previous:Exception:private] => )