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.StreetNumber = '7622' AND A.StreetName LIKE '%SEVEN O'CLOCK%' AND A.StreetType = 'DRIVE' AND A.State = 'BC' AND A.CityName = 'Pemberton' AND M.MLSP_ID IN (1) 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 'CLOCK%' AND A.StreetType = 'DRIVE' AND A.State = 'BC' AND A.CityName = 'Pember' 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.StreetNumber = '7622' AND A.StreetName LIKE '%SEVEN O'CLOCK%' AND A.StreetType = 'DRIVE' AND A.State = 'BC' AND A.CityName = 'Pemberton' AND M.MLSP_ID IN (1) 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.StreetNumber = '7622' AND A.StreetName LIKE '%SEVEN O'CLOCK%' AND A.StreetType = 'DRIVE' AND A.State = 'BC' AND A.CityName = 'Pemberton' AND M.MLSP_ID IN (1) 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] => 1 [slugLocation] => c2-7622-seven-o-clock-drive,pemberton,bc [slugProvider] => lower-mainland [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 123257844 [keyword] => C2 7622 SEVEN O'CLOCK DRIVE, Pemberton, BC [type] => street [sef_url] => c2-7622-seven-o-clock-drive,pemberton,bc [mls_board_name] => Real Estate Board of Greater Vancouver [UnitNo] => C2 [StreetNumber] => 7622 [StreetName] => SEVEN O'CLOCK [StreetType] => DRIVE [CityName] => Pemberton [State] => BC [display_order] => 4 [is_active] => Yes [length] => 42 [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] => 1 [slugLocation] => c2-7622-seven-o-clock-drive,pemberton,bc [slugProvider] => lower-mainland [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 123257844 [keyword] => C2 7622 SEVEN O'CLOCK DRIVE, Pemberton, BC [type] => street [sef_url] => c2-7622-seven-o-clock-drive,pemberton,bc [mls_board_name] => Real Estate Board of Greater Vancouver [UnitNo] => C2 [StreetNumber] => 7622 [StreetName] => SEVEN O'CLOCK [StreetType] => DRIVE [CityName] => Pemberton [State] => BC [display_order] => 4 [is_active] => Yes [length] => 42 [AllPhoto] => 1 [sort_by] => display_on_website_datetime|desc ) ) ) ) [previous:Exception:private] => )