Advanced Hearing Center
609 North Church Street, Ste 1
Mt. Pleasant, Pennsylvania, US map
724-547-3445
Website www.advancedhearingctr.com
Query: SELECT `Zip`.`zip`, `Zip`.`lat`, `Zip`.`lon`, `Zip`.`city`, `Zip`.`state`, `Zip`.`county`, `Zip`.`is_primary`, `Zip`.`population`, `Zip`.`cityaliasname`, `Zip`.`areacode`, `Zip`.`has_location` FROM `zipcodes` AS `Zip` WHERE `Zip`.`lat` BETWEEN '38' AND '38' AND `Zip`.`lon` BETWEEN '-97' AND '-97' AND `Zip`.`state` LIKE LIMIT 1
( ! ) Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 in /var/www/websites-local/prod/wdp/cake/libs/model/datasources/dbo_source.php on line 439 Call Stack # Time Memory Function Location 1 0.0000 75280 {main}( ) ../index.php:0 2 0.0017 320840 Dispatcher->dispatch( ) ../index.php:82 3 0.1144 4837248 Dispatcher->_invoke( ) ../dispatcher.php:245 4 0.1253 5385160 call_user_func_array
( ) ../dispatcher.php:263 5 0.1253 5385456 FindaprofessionalController->index( ) ../dispatcher.php:0 6 0.1304 5426752 FindaprofessionalController->__office( ) ../findaprofessional_controller.php:104 7 0.5359 5915440 Controller->render( ) ../findaprofessional_controller.php:271 8 0.5359 5916008 AppController->beforeRender( ) ../controller.php:534 9 0.6204 6166784 Zip->getZipNear( ) ../app_controller.php:280 10 0.6205 6168184 Model->find( ) ../zip.php:25 11 0.6205 6168784 Model->findAll( ) ../model_php5.php:1146 12 0.6206 6171336 DboSource->read( ) ../model_php5.php:1199 13 0.6222 6176568 DboSource->fetchAll( ) ../dbo_source.php:564 14 0.6222 6176864 DboSource->execute( ) ../dbo_source.php:296 15 0.6233 6177152 DboSource->showQuery( ) ../dbo_source.php:165 16 0.6234 6177712 trigger_error
( ) ../dbo_source.php:439
Query: SELECT `Zip`.`zip`, `Zip`.`lat`, `Zip`.`lon`, `Zip`.`city`, `Zip`.`state`, `Zip`.`county`, `Zip`.`is_primary`, `Zip`.`population`, `Zip`.`cityaliasname`, `Zip`.`areacode`, `Zip`.`has_location` FROM `zipcodes` AS `Zip` WHERE `Zip`.`lat` BETWEEN '37' AND '39' AND `Zip`.`lon` BETWEEN '-98' AND '-96' AND `Zip`.`state` LIKE LIMIT 1
( ! ) Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 in /var/www/websites-local/prod/wdp/cake/libs/model/datasources/dbo_source.php on line 439 Call Stack # Time Memory Function Location 1 0.0000 75280 {main}( ) ../index.php:0 2 0.0017 320840 Dispatcher->dispatch( ) ../index.php:82 3 0.1144 4837248 Dispatcher->_invoke( ) ../dispatcher.php:245 4 0.1253 5385160 call_user_func_array
( ) ../dispatcher.php:263 5 0.1253 5385456 FindaprofessionalController->index( ) ../dispatcher.php:0 6 0.1304 5426752 FindaprofessionalController->__office( ) ../findaprofessional_controller.php:104 7 0.5359 5915440 Controller->render( ) ../findaprofessional_controller.php:271 8 0.5359 5916008 AppController->beforeRender( ) ../controller.php:534 9 0.6204 6166784 Zip->getZipNear( ) ../app_controller.php:280 10 0.6271 6114728 Model->find( ) ../zip.php:37 11 0.6271 6115328 Model->findAll( ) ../model_php5.php:1146 12 0.6272 6117736 DboSource->read( ) ../model_php5.php:1199 13 0.6288 6122968 DboSource->fetchAll( ) ../dbo_source.php:564 14 0.6288 6123264 DboSource->execute( ) ../dbo_source.php:296 15 0.6297 6123552 DboSource->showQuery( ) ../dbo_source.php:165 16 0.6298 6124112 trigger_error
( ) ../dbo_source.php:439
609 North Church Street, Ste 1
Mt. Pleasant, Pennsylvania, US map
724-547-3445
Website www.advancedhearingctr.com
