Whoops, looks like something went wrong.

(2/2) QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'new_recomend_product.product_no' in 'on clause' (SQL: select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = P001 inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = 1 where `sale_start_yyyymmdd` <= 2024-03-28 00:00:00 and `sale_start_yyyymmdd` <= 2024-03-28 00:00:00 and `sale_end_yyyymmdd` >= 2024-03-28 00:00:00 and `del_chk` = 1)

in Connection.php line 647
at Connection->runQueryCallback('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), object(Closure))in Connection.php line 607
at Connection->run('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), object(Closure))in Connection.php line 326
at Connection->select('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), true)in Builder.php line 1705
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 2025
at Builder->aggregate('count', array('*'))in Builder.php line 1953
at Builder->count()in ProductController.php line 430
at ProductController->recomendList('29', object(Request))
at call_user_func_array(array(object(ProductController), 'recomendList'), array('category' => '29', object(Request)))in Controller.php line 55
at Controller->callAction('recomendList', array('category' => '29', object(Request)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(ProductController), 'recomendList')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AuthenticateSession.php line 39
at AuthenticateSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 53

(1/2) PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'new_recomend_product.product_no' in 'on clause'

in Connection.php line 319
at PDO->prepare('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?')in Connection.php line 319
at Connection->Illuminate\Database\{closure}('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'))in Connection.php line 640
at Connection->runQueryCallback('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), object(Closure))in Connection.php line 607
at Connection->run('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), object(Closure))in Connection.php line 326
at Connection->select('select count(*) as aggregate from `product` inner join `categories` on `product`.`category` = `categories`.`cateId` and `categories`.`type` = ? inner join `new_recomend_product` on `product`.`product_no` = `new_recomend_product`.`product_no` and `new_recomend_product`.`del_yn` = ? where `sale_start_yyyymmdd` <= ? and `sale_start_yyyymmdd` <= ? and `sale_end_yyyymmdd` >= ? and `del_chk` = ?', array('P001', '1', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '1'), true)in Builder.php line 1705
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 2025
at Builder->aggregate('count', array('*'))in Builder.php line 1953
at Builder->count()in ProductController.php line 430
at ProductController->recomendList('29', object(Request))
at call_user_func_array(array(object(ProductController), 'recomendList'), array('category' => '29', object(Request)))in Controller.php line 55
at Controller->callAction('recomendList', array('category' => '29', object(Request)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(ProductController), 'recomendList')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AuthenticateSession.php line 39
at AuthenticateSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 53