Exception Object ( [message:protected] => Database error: Invalid SQL: SELECT count(M.MLS_NUM) as cnt,MIN(ListPrice) as Min_price ,MAX(ListPrice) as Max_price FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID WHERE 1 AND A.StreetName LIKE '%23KM PRINCETON/S'LAND ROAD%' AND A.State = 'BC' AND A.CityName = 'Princeton' AND M.MLSP_ID IN (3) AND ( 6378.7 * ACOS( SIN( A.Latitude / 57.2958 ) * SIN( 0.000000000000000 / 57.2958 ) + COS( A.Latitude / 57.2958 ) * COS( 0.000000000000000 / 57.2958 ) * COS( 0.000000000000000 / 57.2958 - ( A.Longitude ) / 57.2958 ) ) ) <= 10 AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891' )
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LAND ROAD%' AND A.State = 'BC' AND A.CityName = 'Princeton' AND M.MLSP_ID IN (3' at line 1)
[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 count(M.MLS_NUM) as cnt,MIN(ListPrice) as Min_price ,MAX(ListPrice) as Max_price FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID WHERE 1 AND A.StreetName LIKE '%23KM PRINCETON/S'LAND ROAD%' AND A.State = 'BC' AND A.CityName = 'Princeton' AND M.MLSP_ID IN (3) AND ( 6378.7 * ACOS( SIN( A.Latitude / 57.2958 ) * SIN( 0.000000000000000 / 57.2958 ) + COS( A.Latitude / 57.2958 ) * COS( 0.000000000000000 / 57.2958 ) * COS( 0.000000000000000 / 57.2958 - ( A.Longitude ) / 57.2958 ) ) ) <= 10 AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891' ) ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/IDXListing.php [line] => 2013 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => SELECT count(M.MLS_NUM) as cnt,MIN(ListPrice) as Min_price ,MAX(ListPrice) as Max_price FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID WHERE 1 AND A.StreetName LIKE '%23KM PRINCETON/S'LAND ROAD%' AND A.State = 'BC' AND A.CityName = 'Princeton' AND M.MLSP_ID IN (3) AND ( 6378.7 * ACOS( SIN( A.Latitude / 57.2958 ) * SIN( 0.000000000000000 / 57.2958 ) + COS( A.Latitude / 57.2958 ) * COS( 0.000000000000000 / 57.2958 ) * COS( 0.000000000000000 / 57.2958 - ( A.Longitude ) / 57.2958 ) ) ) <= 10 AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891' ) ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 249 [function] => getListingByParam [class] => IDXListing [type] => -> [args] => Array ( [0] => Array ( [MLSP_ID] => 3 [slugLocation] => 23km-princeton~s-land-road,princeton,bc [slugProvider] => british-columbia [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 18489 [keyword] => 23KM PRINCETON/S'LAND ROAD , Princeton, BC [type] => street [sef_url] => 23km-princeton-s-land-road,princeton,bc [mls_board_name] => South Okanagan Real Estate Board [StreetName] => 23KM PRINCETON/S'LAND ROAD [CityName] => Princeton [State] => BC [display_order] => 4 [is_active] => Yes [length] => 42 [city_latitude] => 0.000000000000000 [city_longitude] => 0.000000000000000 [AllPhoto] => 1 [sort_by] => display_on_website_datetime|desc [viewType] => ListingView ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/search.php [line] => 186 [function] => getSearchData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLSP_ID] => 3 [slugLocation] => 23km-princeton~s-land-road,princeton,bc [slugProvider] => british-columbia [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 18489 [keyword] => 23KM PRINCETON/S'LAND ROAD , Princeton, BC [type] => street [sef_url] => 23km-princeton-s-land-road,princeton,bc [mls_board_name] => South Okanagan Real Estate Board [StreetName] => 23KM PRINCETON/S'LAND ROAD [CityName] => Princeton [State] => BC [display_order] => 4 [is_active] => Yes [length] => 42 [city_latitude] => 0.000000000000000 [city_longitude] => 0.000000000000000 [AllPhoto] => 1 [sort_by] => display_on_website_datetime|desc ) ) ) ) [previous:Exception:private] => )