Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT NHD.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '4') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '4') ORDER BY distance ASC LIMIT 1
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bf_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"))
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 665 [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.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '4') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '4') ORDER BY distance ASC LIMIT 1 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/DemographicCrime.php [line] => 212 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT NHD.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '4') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '4') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 475 [function] => getNeighborhoodCrimeData [class] => DemographicCrime [type] => -> [args] => Array ( [0] => Array ( [main_category] => Violent Crime Rate [cartodb_id] => 4 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => C8027530 [MLSP_ID] => 4 [listing_key] => C8027530-4 [resource] => Property [class] => CM_1 [mls_board_name] => [agent_code] => V70731 [agent_key] => V70731-4 [agent_name] => Max Chiu PREC* [office_code] => V002288 [office_key] => V002288-4 [office_name] => Sutton Group-West Coast Realty [ListingKey] => [PropertyType] => Business [PropertyTypeNew] => Business [PropertyStyle] => [ListingStatus] => ACTIVE [SubType] => [OwnershipType] => [OwnershipTypeNew] => [Zoning] => BUSINESS [BathsFull] => 0 [BathsHalf] => 0 [Baths] => 0 [Beds] => 0 [TotalAcreage] => 0 [ListPrice] => 138000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 26.98 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 500 [YearBuilt] => [TotalPhotos] => 2 [Main_Photo] => 1 [Description] => Turn-key business! Located in the prime location in Crystal Mall in Burnaby, guaranteed high traffic. 10 years in operation, with stable clientele and good reputation. 500 SF, $2,100 rent per month plus $550 management fee. 3 years lease expiring 2021. 3 staffs in total, with 2 full time and 1 part time. Ample mall parkings. Do not disturb staff. Showing by appointment only. [Description2] => [Stories] => [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 0.00 [TaxYear] => 0 [Region] => [ListingDate] => 2019-08-23 [LastUpdateDate] => 2019-08-26T16:08:00.3 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => General Retail [business_type_minor] => GR - Misc Retail [dom] => 0 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2019-08-23 18:00:03 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 98 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 64 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 4 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 432 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 397 [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] => 41 [cartodb_id_city_process] => Yes [cartodb_id_area] => 16 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1607 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 224932599 [display_on_website] => Yes [display_on_website_datetime] => 1566610742 [created_datetime] => 2019-08-23 18:00:03 [updated_datetime] => 2019-08-26 10:00:04 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-08-26 10:05:08 [is_hotdeal] => No [hotdeal_tag] => [hotdeal_description] => null [BasementArea] => [Features] => [Amenities] => [SiteInfluences] => [View] => [Frontage] => [mls_market_sef_url] => lower-mainland-commercial [mls_is_pic_url_supported] => No [ListingID_MLS] => C8027530-4 [Area] => Burnaby South [StreetName] => KINGSWAY [StreetNumber] => 4500 [StreetType] => [UnitNo] => 1327 [StreetDirection] => [ZipCode] => V5H 2A9 [CityName] => Burnaby [County] => [State] => BC [Subdivision] => Metrotown [Latitude] => 49.229008500000000 [Longitude] => -123.005049800000000 [DayOnMarket] => 316 [Pic_Path] => https://static.estateblock.com/pictures/property/C8027530-4/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 ) [LA1_Char100_3] => Max Chiu PREC* [LA1_Email] => maxc@sutton.com [LA1_LoginName] => V70731 [LA1_PhoneNumber1] => 604-649-3188 [LA1_WebPage] => http://www.bc1800.com [LFD_PropertyType_1] => Business [LM_char100_1] => 800-132-629 [LM_Char10_14] => GR - Misc Retail [LM_Char10_4] => Greater Vancouver [LM_Char25_15] => BUSINESS [LM_Char50_1] => Metrotown [LM_char5_11] => Vancouver [LM_char5_8] => General Retail [LM_Int4_3] => 500 [LO1_EMail] => killarney.admin@suttonwestcoast.com [LO1_OrganizationName] => Sutton Group-West Coast Realty [LO1_PhoneNumber1] => 604-257-8888 [LO1_ShortName] => V002288 [LO1_WebPage] => http://www.suttonwestcoast.com [LR_remarks66] => Turn-key business! Located in the prime location in Crystal Mall in Burnaby, guaranteed high traffic. 10 years in operation, with stable clientele and good reputation. 500 SF, $2,100 rent per month plus $550 management fee. 3 years lease expiring 2021. 3 staffs in total, with 2 full time and 1 part time. Ample mall parkings. Do not disturb staff. Showing by appointment only. [LV_vow_address] => Yes [L_Address] => 1327 4500 KINGSWAY [L_AddressNumber] => 4500 [L_AddressSearchNumber] => 4500 [L_AddressStreet] => KINGSWAY [L_AddressUnit] => 1327 [L_Area] => Burnaby South [L_AskingPrice] => 138000 [L_City] => Burnaby [L_DisplayId] => C8027530 [L_IdxInclude] => Yes [L_Last_Photo_updt] => 2019-08-26T16:08:00.4 [L_ListingDate] => 2019-08-23 [L_ListingID] => 224932599 [L_PictureCount] => 2 [L_SaleRent] => For Sale [L_State] => BC [L_Status] => ACTIVE [L_Type_] => Business [L_UpdateDate] => 2019-08-26T16:08:00.3 [L_Zip] => V5H 2A9 [Section] => mls ) ) ) ) [previous:Exception:private] => )