Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 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 ') GROUP BY PR.id ...' at line 11 (SQL: SELECT SZ.size, COUNT(PRZS.item_id) as number FROM sizes SZ LEFT JOIN ( SELECT PRZS.item_id, PRD.stock_text, PR.frametype, PRZS.size FROM products PR LEFT JOIN product_sizes PRZS ON PR.id = PRZS.item_id LEFT JOIN products_domain PRD ON PRD.id = PRZS.item_id AND PR.brand IN () GROUP BY PR.id ) as PRZS ON SZ.size = PRZS.size AND SZ.categoryid = 3 GROUP BY SZ.size) in file /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669 #0 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run() #2 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(349): Illuminate\Database\Connection->select() #3 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\DatabaseManager->__call() #4 /var/www/vhosts/ochelarii.ro/httpdocs/app/Http/Controllers/ProductController.php(2827): Illuminate\Support\Facades\Facade::__callStatic() #5 /var/www/vhosts/ochelarii.ro/httpdocs/app/Http/Controllers/ProductController.php(1845): App\Http\Controllers\ProductController->getAllSizes() #6 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ProductController->index() #7 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #8 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch() #9 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #10 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #11 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #12 /var/www/vhosts/ochelarii.ro/httpdocs/app/Http/Middleware/Localization.php(28): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #13 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\Localization->handle() #14 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #15 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle() #16 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #18 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #20 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #21 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle() #22 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #24 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle() #26 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then() #28 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack() #29 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute() #30 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute() #31 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch() #32 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #33 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #34 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #35 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #37 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #39 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() #41 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle() #43 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then() #45 /var/www/vhosts/ochelarii.ro/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #46 /var/www/vhosts/ochelarii.ro/httpdocs/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle() #47 {main}