SQLSTATE[42000]: Syntax error or access violation: 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 ') ) GROUP BY product.category_three_id ORDER BY category_three.name_it ASC' at line 14 (SQL: SELECT product.category_three_id as id FROM product LEFT JOIN category_three ON product.category_three_id = category_three.id WHERE product.id IN (SELECT product.id FROM product LEFT JOIN category_three ON product.category_three_id = category_three.id LEFT JOIN company ON product.company_id = company.id WHERE `company`.`status_pool` = 'approved' and `company`.`is_real` = 1 and `product`.`status` = 'approved' AND `category_three`.`id` IN () ) GROUP BY product.category_three_id ORDER BY category_three.name_it ASC)

(2/2) QueryException

SQLSTATE[42000]: Syntax error or access violation: 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 ')

) GROUP BY product.category_three_id ORDER BY category_three.name_it ASC' at line 14 (SQL: SELECT product.category_three_id as id FROM product LEFT JOIN category_three ON product.category_three_id = category_three.id WHERE product.id IN (SELECT product.id
FROM product
LEFT JOIN category_three
ON
product.category_three_id = category_three.id
LEFT JOIN company ON product.company_id = company.id


WHERE
`company`.`status_pool` =
'approved' and
`company`.`is_real` = 1 and
`product`.`status` = 'approved'
AND `category_three`.`id` IN ()

) GROUP BY product.category_three_id ORDER BY category_three.name_it ASC)

in Connection.php line 669
at Connection->runQueryCallback()in Connection.php line 629
at Connection->run()in Connection.php line 338
at Connection->select()in DatabaseManager.php line 349
at DatabaseManager->__call()in Facade.php line 261
at Facade::__callStatic()in Controller.php line 666
at Controller->getQueryToShow()in Controller.php line 396
at Controller->rankingSearch()in CategoryController.php line 121
at CategoryController->show()in Controller.php line 54
at Controller->callAction()in ControllerDispatcher.php line 45
at ControllerDispatcher->dispatch()in Route.php line 219
at Route->runController()in Route.php line 176
at Route->run()in Router.php line 681
at Router->Illuminate\Routing\{closure}()in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline\{closure}()in Notification.php line 145
at Notification->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in MetaInfos.php line 29
at MetaInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in FilterList.php line 41
at FilterList->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in SubstituteBindings.php line 41
at SubstituteBindings->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in VerifyCsrfToken.php line 78
at VerifyCsrfToken->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in StartSession.php line 56
at StartSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in EncryptCookies.php line 67
at EncryptCookies->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Pipeline.php line 105
at Pipeline->then()in Router.php line 683
at Router->runRouteWithinStack()in Router.php line 658
at Router->runRoute()in Router.php line 624
at Router->dispatchToRoute()in Router.php line 613
at Router->dispatch()in Kernel.php line 170
at Kernel->Illuminate\Foundation\Http\{closure}()in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline\{closure}()in OwnNavigationInfos.php line 33
at OwnNavigationInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in MetaInfos.php line 29
at MetaInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Notification.php line 145
at Notification->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in FilterList.php line 41
at FilterList->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in VerifyCsrfToken.php line 78
at VerifyCsrfToken->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in StartSession.php line 56
at StartSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in CheckForMaintenanceMode.php line 63
at CheckForMaintenanceMode->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Language.php line 28
at Language->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Pipeline.php line 105
at Pipeline->then()in Kernel.php line 145
at Kernel->sendRequestThroughRouter()in Kernel.php line 110
at Kernel->handle()in index.php line 53

(1/2) PDOException

SQLSTATE[42000]: Syntax error or access violation: 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 ')

) GROUP BY product.category_three_id ORDER BY category_three.name_it ASC' at line 14

in Connection.php line 331
at PDO->prepare()in Connection.php line 331
at Connection->Illuminate\Database\{closure}()in Connection.php line 662
at Connection->runQueryCallback()in Connection.php line 629
at Connection->run()in Connection.php line 338
at Connection->select()in DatabaseManager.php line 349
at DatabaseManager->__call()in Facade.php line 261
at Facade::__callStatic()in Controller.php line 666
at Controller->getQueryToShow()in Controller.php line 396
at Controller->rankingSearch()in CategoryController.php line 121
at CategoryController->show()in Controller.php line 54
at Controller->callAction()in ControllerDispatcher.php line 45
at ControllerDispatcher->dispatch()in Route.php line 219
at Route->runController()in Route.php line 176
at Route->run()in Router.php line 681
at Router->Illuminate\Routing\{closure}()in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline\{closure}()in Notification.php line 145
at Notification->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in MetaInfos.php line 29
at MetaInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in FilterList.php line 41
at FilterList->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in SubstituteBindings.php line 41
at SubstituteBindings->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in VerifyCsrfToken.php line 78
at VerifyCsrfToken->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in StartSession.php line 56
at StartSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in EncryptCookies.php line 67
at EncryptCookies->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Pipeline.php line 105
at Pipeline->then()in Router.php line 683
at Router->runRouteWithinStack()in Router.php line 658
at Router->runRoute()in Router.php line 624
at Router->dispatchToRoute()in Router.php line 613
at Router->dispatch()in Kernel.php line 170
at Kernel->Illuminate\Foundation\Http\{closure}()in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline\{closure}()in OwnNavigationInfos.php line 33
at OwnNavigationInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in MetaInfos.php line 29
at MetaInfos->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Notification.php line 145
at Notification->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in FilterList.php line 41
at FilterList->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in VerifyCsrfToken.php line 78
at VerifyCsrfToken->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in StartSession.php line 56
at StartSession->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in CheckForMaintenanceMode.php line 63
at CheckForMaintenanceMode->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Language.php line 28
at Language->handle()in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline\{closure}()in Pipeline.php line 105
at Pipeline->then()in Kernel.php line 145
at Kernel->sendRequestThroughRouter()in Kernel.php line 110
at Kernel->handle()in index.php line 53